在php编程中,有关sqlite_create_function函数的小例子

<?php
/**
 * sqlite_create_function函数示例
 * edit: www.junphp.com
 */
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);
?>


相关评论(0)
您是不是忘了说点什么?

友情提示:垃圾评论一律封号...

还没有评论,快来抢沙发吧!