php sqlite_create_function函數的例子

/** * sqlite_create_function函數樣本 * edit: bbs.it-home.org */ define("PPO",400); function my($salary){ return $salary / PPO; } $sqldb = sqlite_open("mydatabase.db"); sqlite_create_function($sqldb,"myFunction", "my", 1); $query = "select myFunction(salary) FROM employee WHERE empid=1"; $result = sqlite_query($sqldb, $query); list($myFunction) = sqlite_fetch_array($result); echo "The employee can purchase: ".$myFunction." ounces."; sqlite_close($sqldb); ?> 複製代碼

