php sqlite_create_function函数的例子

3. /**

4. * sqlite_create_function函数示例
5. * edit: bbs.it-home.org
6. */
7. define("PPO",400);
8. function my($salary){
9. return $salary / PPO;
10. }
11. $sqldb = sqlite_open("mydatabase.db");
12. sqlite_create_function($sqldb,"myFunction", "my", 1);
13. $query = "select myFunction(salary) FROM employee WHERE empid=1";
14. $result = sqlite_query($sqldb, $query);
15. list($myFunction) = sqlite_fetch_array($result);

16. echo "The employee can purchase: ".$myFunction." ounces.";

17. sqlite_close($sqldb);

18. ?>

复制代码