Articles in 原創
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
<%php_beautifier path%>\php_beautifier.bat $(FULL_CURRENT_PATH) | clip
the formate output will save …
//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
*/
function sqlite_drop_table_columns($table,$columns,$dbh){
//取得所有欄位
$st = $dbh->query("PRAGMA table_info(ap_form_elements)");
if($st){
$fields = $st->fetchAll(PDO::FETCH_COLUMN,1);
//去除不要的欄位
$fls = array();
foreach($fields as $f){
if(!in_array($f,$columns)){
$fls[] = $f;
}
}
}else{
return FALSE;
}
unset($st);
//組合SQL語法
$field_list = implode(',',$fls);
$SQL = …
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 copy all file to /plugins
This Article is from
http://www.danielkassner.com/2010/01/22/using-notepads-function-list-plugin-for-php-development
http://sourceforge.net/projects/npp-plugins/forums/forum/670934/topic/3568427
(This has been corrected with …
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
Sometime I really hat wordpress query module.
For debug ,it is too many package!!
Now I show the way to sql debug
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 query.
Xpath require attribut value is case-sensitive. So where is …

