[PHP] Sample code : Berkeley DB , bdb , dba_open , db4 , key-value database ,

$id = dba_open(“bdb4_tsid.db”, “w”, “db4”); if (!$id) { echo “dba_open failed\n”; exit; } dba_replace(“key”, “This is an example!”, $id); if (dba_exists(“key”, $id)) { echo dba_fetch(“key”, $id); dba_delete(“key”, $id); } dba_close($id);       This is an example! exist: This is an example! —> This is an example!

[php] array_key_exists vs isset 那一個比較快?

這些微差異要在大量的 loop 中才會有一些差別, 不過還是寫 code 時一次寫好吧 —> 給我自己的提醒! 答案是 isset 比較快! ref. URL: http://www.alternateinterior.com/2006/11/comparing-array_key_exists-with-isset.html 相關資訊: A HOWTO on Optimizing PHP http://phplens.com/lens/php-book/optimizing-debugging-php.php Tuning Apache and PHP for Speed on Unix http://phplens.com/phpeverywhere/tuning-apache-php

[php] regular expression match

preg_match( ‘/c=([0-9]+)/’ , $t->log[‘dest_query’] , $data); 這樣可以取出 c=xxxx 抓 user agent 版本 preg_match( ‘/MSIE ([0-9]+.[0-9])/’ , $_SERVER[‘HTTP_USER_AGENT’] , $data_msie_ver); preg_match( ‘/Windows NT ([0-9]+.[0-9])/’ , $_SERVER[‘HTTP_USER_AGENT’] , $data_nt_ver); if ( !( (float)$data_msie_ver[1]>=6 && (float)$data_msie_ver[1]

USE Oracle / oci8 with PHP / test sample code

前提環境要先裝好 Oracle instant client , 然後 PHP 要把 instantclient 編譯進去 –with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client/lib 這是 sample code $conn = OCILogon(‘scott’, ‘scott’, ‘//172.30.0.176/DB1’); $query = ‘select * from dept’; $stid = OCIParse($conn, $query); OCIExecute($stid, OCI_DEFAULT); while ($succ = OCIFetchInto($stid, $row)) { foreach ($row as $item) { echo $item.” “; } echo “\n”; } OCILogoff($conn); … 1. 建 oracle table […]

範例程式 jQuery /JSON / PHP /json_encode / json_decode sample code

jQuery : 請參考這篇 : http://jsgears.com/thread-63-1-1.html Microsoft 也提供 video 教學: http://msdn.microsoft.com/zh-tw/asp.net/dd310332.aspx#jQuery $(document).ready( function(){ var data = new Object(); data.hello = “Hello”; data.world = ‘World’; data.worked = ” it worked “; data.somebool = true; data.array = new Array(“he\”ll\”o”, ‘”World”‘); var dataString = $.toJSON(data); $.post(‘phpfile.php’, {data: dataString}, function(res){ var obj = $.evalJSON(res); if(obj.somebool === true) $(“#result”).html(obj.hello + ‘ […]