List/Grid

原創 Subscribe to 原創

Gatorhost pdo don’t support sqlite3

Gatorhost pdo don’t support sqlite3

May 23, 2011 | 0 Comment

Greetings,
The sqlite PDO extension appears to be loaded properly. However, it appears that the extension supports sqlite2, but not sqlite3. Currently, I see the use of sqlite3 in your scripts. You will need to use sqlite2 instead in order for them to work properly. I apologize for the inconvenience.

Please feel free to ask if you need anything else at all.

use curl to got Content-Disposition filename

use curl to got Content-Disposition filename

January 10, 2011 | Comments Off

curl CURLOPT_BINARYTRANSFER can’t not got Content-Disposition filename for u

[php-editor] USE PHP_Beautifier in Notepad++

[php-editor] USE PHP_Beautifier in Notepad++

August 18, 2010 | 0 Comment

This is the way to use PHP_Beautifier to formate php in notepad++ and output to clipboard Install PHP_Beautifier via http://pear.php.net/package/PHP_Beautifier Make sure your notepad++ have NPPExec Add Execute like this… Read more »

[PHP::PDO]SQLITE Drop Columns function

[PHP::PDO]SQLITE Drop Columns function

August 17, 2010 | 3 Comments

//CODE DEMO $dbh = new PDO(‘sqlite:ClientFB.sqlite3′); $st = $dbh->query(“PRAGMA table_info(ap_form_elements)”); var_dump($st->fetchAll(PDO::FETCH_COLUMN,1)); sqlite_drop_table_columns(‘ap_form_elements’,array(‘element_position’,'element_default_value’),$dbh); $st = $dbh->query(“PRAGMA table_info(ap_form_elements)”); var_dump($st->fetchAll(PDO::FETCH_COLUMN,1)); /** * 實做一個刪除資料表欄位 function * @prama $table STRING * @prama $columns ARRAY */… Read more »

NotePad++ 5.7 in windows7 support php function list

NotePad++ 5.7 in windows7 support php function list

August 11, 2010 | 0 Comment

This case spend me so much time . Step 1. Download this file FunctionList.zip Step 2. Install notepad++ 5.7 and don’t install with %APPDATA% Step 3. unzip the FunctionList.zip and… Read more »

[xampp+komodo] php code beautifier

[xampp+komodo] php code beautifier

July 20, 2010 | 0 Comment

That’s very simple and easy. c:\xampp\php>PEAR install PHP_Beautifier-beta After install PHP_Beautifier,you will find the c:\xampp\php\php_beautifier.bat And just Do as below pictures

WordPress admin side query debug

WordPress admin side query debug

July 7, 2010 | Comments Off

Sometime I really hat wordpress query module.
For debug ,it is too many package!!

Now I show the way to sql debug

phpquery edit meta(case-insense)

phpquery edit meta(case-insense)

May 26, 2010 | 0 Comment

Sometime the html meta like: or or If you just use “meta[name='keywords']” to find the node,you will get nothing. Because what the phpquery do is expand css selector to xpath… Read more »