php pdo [轉]Useful database helper class to generate CRUD statements using PHP and MySQL

http://www.angularcode.com/useful-database-helper-class-to-generate-crud-statements-using-php-and-mysql/

這個看起來更好，滿足我的問題，不用再進crud class中，一個一個改欄位，直接帶什麼改什麼，這樣更快。

roxyfileman ckeditor 看來是比較好的方式，連file broswer都有了

http://www.roxyfileman.com/CKEditor-file-browser


檔案下載 filedownload

Integration blueimp fileupload in ckeditor 實例範例

Integration blueimp fileupload in ckeditor

http://stackoverflow.com/questions/14013418/integration-blueimp-fileupload-in-ckeditor

https://github.com/blueimp/jQuery-File-Upload

------

檔案下載 file download


1、index.php 是 建立ckeditor，主要是多一個function triggerUploadImages(url){
2、在ckeditor目錄下的config.js，補上網頁上的程式碼，要注意html : ' <iframe src=  需要給正確

2.1、index.html 是非常基本的，basic-plus.html是取jquery file uploder的範例來用，上傳完後，點選該圖或文字，就能會回傳

2.2、index.html 和 basic-plus.html兩支程式都有呼叫 parent.triggerUploadImages，把url傳回ckeditor

2.3、注意index.html的data-url="server/php/" 路徑是否正確；basic-plus.html 這段

var url = window.location.hostname === 'blueimp.github.io' ?
                '//jquery-file-upload.appspot.com/' : 'server/php/'

路徑是否正確


基本上較麻煩的是，上傳完畢後，會回傳url，再送到CKEitor裡面。


圖片上傳在server/php/files  ，會自動做縮圖

[轉]HOW TO MAKE UPLOAD IMAGE IN CKEDITOR.

http://www.dukaweb.net/2014/01/how-to-make-upload-image-in-ckeditor.html


In script tag, which we call CKEditor put one more code:

CKEDITOR.replace( 'editor1', {
  filebrowserUploadUrl: "upload/upload.php"
} );


In upload.php

if (file_exists("img/"; . $_FILES["upload"]["name"]))
{
echo $_FILES["upload"]["name"] . " already exists please choose another image.";
}
else
{
move_uploaded_file($_FILES["upload"]["tmp_name"],
"img/" . $_FILES["upload"]["name"]);
echo "Stored in: " . "img/" . $_FILES["upload"]["name"];
}

If you get an error “image source url is missing“, that means the url of the image doesn’t pass to the image info tab, you can fix this error by adding the php code to pass the image url.

In upload.php file

Add the following code in the else function

// Required: anonymous function reference number as explained above.
$funcNum = $_GET['CKEditorFuncNum'] ;
// Optional: instance name (might be used to load a specific configuration file or anything else).
$CKEditor = $_GET['CKEditor'] ;
// Optional: might be used to provide localized messages.
$langCode = $_GET['langCode'] ;

// Check the $_FILES array and save the file. Assign the correct path to a variable ($url).
$url = "img/" . $_FILES["upload"]["name"];
// Usually you will only assign something here if the file could not be uploaded.
$message = '';

echo "<script type='text/javascript'> window.parent.CKEDITOR.tools.callFunction($funcNum, '$url', '$message');</script>";

http://www.paulfp.net/blog/2010/10/how-to-add-and-upload-an-image-using-ckeditor/

----------

http://bittyferrari.blogspot.tw/2015/03/ckeditor-image-upload.html

做法就是用個jquery的ajax檔案upload功能

我是包了這個 jquery-fileupload.min.js

function addImg(v) {

CKEDITOR.instances.content.insertHtml('<img src="' + baseUrl + '/upload/news/' + v + '" />');

}

==========

Integration blueimp fileupload in ckeditor

http://stackoverflow.com/questions/14013418/integration-blueimp-fileupload-in-ckeditor

https://github.com/blueimp/jQuery-File-Upload


jquery file upload 后台收到的文件名中文乱码， filename中文乱码

http://blog.csdn.net/zhouyingge1104/article/details/38322403

CRUD jquery free datatable jtable

以前開發的經驗，用過兩個算是功能最多最好用的

https://datatables.net/    MIT license
在六七年前有回覆過bug，在某間公司開發網頁時，有套用，前台顯示+後台MSSQL Storeprocess，在search按下任何一個字元，直接在後台的DB抓資料出來，速度非常的快，幾萬幾都沒問題。

https://editor.datatables.net/ 要付費，但付一次，無限站台，無限使用者
三、四年前有套過一次，上馬很快，但15天後到期，沒付費，轉找別的…

http://www.jtable.org/ MIT license
三、四年最後用這套，很快就套起來，CRUD全有了

以上很快的意思是，網站的demo含php，基本上，table column設好，就新、修、刪全有了，而且可以設定顯不顯示等等。

這些套件只有一個問題，就是css在修改上需要蠻多時間熟悉，不過有的是套jquery ui，可以用jquery ui產生器，也許會更快套色。


======

Evolutility 1.1.2  AGPL v3http://evoluteur.github.io/evolutility/


jsGrid   MIThttp://js-grid.com/


X-editable  MIT

https://vitalets.github.io/x-editable/


=====
手寫
https://github.com/sitepoint-editors/SCRUD   修改、刪除是在server輸出

php pdo

https://www.codeofaninja.com/2013/05/crud-with-php-jquery.html


while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
// extract row
// this will make $row['name'] to
// just $name only
  extract($row);

這樣就能直接引用

例： 原本是用$row['id']，現在直接$id

如果有重覆變數，請看

http://pydoing.blogspot.tw/2013/03/PHP-extract.html

[轉]Top 12 Best PHP RESTful Micro Frameworks (Pro/Con)

http://www.gajotres.net/best-available-php-restful-micro-frameworks/




I will recommend these 4 frameworks:

Silex
**Slim
Lumen
Phalcon