NotePad++ 5.7 in windows7 support php function list
August 11, 2010 – 9:08 pm | No 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 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 …

Read the full story »
Featured

Some article you should watch….

Google Reader

some article I share in google reader. they are very important to me.

Headline

Most important article~

Normal

原創

通常 原創都是短短的 因為站長很忙.

Home » Archive by Category

Articles in 原創

[php-editor] USE PHP_Beautifier in Notepad++
August 18, 2010 – 4:18 pm | No 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
<%php_beautifier path%>\php_beautifier.bat  $(FULL_CURRENT_PATH) | clip
the formate output will save …

[PHP::PDO]SQLITE Drop Columns function
August 17, 2010 – 2:57 pm | No Comment

//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 = …

NotePad++ 5.7 in windows7 support php function list
August 11, 2010 – 9:08 pm | No Comment
NotePad++ 5.7 in windows7 support php function list

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 …

[xampp+komodo] php code beautifier
July 20, 2010 – 11:48 am | No 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
July 7, 2010 – 7:39 pm | 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)
May 26, 2010 – 1:13 am | No 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 query.
Xpath  require attribut value is case-sensitive. So where is …