function get_person_list()
{
//Build the JSON array from the database
global $conf, $conn;
makeConn();
$stmt;
$person_list = array();
try {
$sql = "SELECT actor_id, first_name, last_name, last_update\n FROM actor";
$stmt = $conn->prepare($sql);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$person_list[] = array('actor_id' => $row['actor_id'], 'first_name' => $row['first_name'], 'last_name' => $row['last_name']);
}
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
umakeConn();
return $person_list;
}
define("DB_NAME", "../../jxc.db");
define("IS_SQLITE3", class_exists("SQLite3"));
//创建数据库文件,文件内容为空
$justCeate = false;
$initArray = array("CREATE TABLE 'UsersTb' (\r\n\t\t\t'id' VARCHAR(200) UNIQUE NOT NULL PRIMARY KEY,\r\n\t\t\t'pwd' VARCHAR(200) NOT NULL, \r\n\t\t\t'type' int, \r\n\t\t\tcreator VARCHAR(200)\r\n\t\t\t);", "insert into UsersTb (id, pwd, type, creator) values ('admin', '21232f297a57a5a743894a0e4a801fc3', 1, '');", "CREATE TABLE [Commodity] (\r\n\t\t\t[id] INTEGER PRIMARY KEY,\r\n\t\t\t[name] VARCHAR(200) NOT NULL,\r\n\t\t\t[description] VARCHAR(200) NULL,\r\n\t\t\t[weight] FLOAT DEFAULT '''''''0''''''' NULL,\r\n\t\t\t[SBNId] VARCHAR(200) NOT NULL,\r\n\t\t\t[type] VARCHAR(200) NOT NULL\r\n\t\t\t)", "CREATE TABLE [PurchaseLog] (\r\n\t\t\t[id] INTEGER PRIMARY KEY,\r\n\t\t\t[logTime] NUMERIC NULL,\r\n\t\t\t[commonditySBN] VARCHAR(200) NULL,\r\n\t\t\t[commondityName] VARCHAR(200) NULL,\r\n\t\t\t[num] INTEGER NULL,\r\n\t\t\t[realRetailPrice] FLOAT NULL,\r\n\t\t\t[madeTime] NUMERIC NULL,\r\n\t\t\t[operator] VARCHAR(200) NULL\r\n\t\t\t)", "CREATE TABLE [Store] (\r\n\t\t\t[id] INTEGER PRIMARY KEY,\r\n\t\t\t[SBN] VARCHAR(200) NULL,\r\n\t\t\t[name] VARCHAR(200) NULL,\r\n\t\t\t[num] INTEGER NULL,\r\n\t\t\t[madeTime] NUMERIC NULL,\r\n\t\t\t[operator] VARCHAR(200) NULL,\r\n\t\t\t[storeTime] NUMERIC NULL,\r\n\t\t\t[retailPrice] FLOAT NULL\r\n\t\t\t)", "CREATE TABLE [SoldLog] (\r\n\t\t\t[id] INTEGER PRIMARY KEY,\r\n\t\t\t[soldTime] NUMERIC NULL,\r\n\t\t\t[clientName] VARCHAR(200) NULL,\r\n\t\t\t[SBN] VARCHAR(400) NULL,\r\n\t\t\t[name] VARCHAR(400) NULL,\r\n\t\t\t[num] VARCHAR(200) NULL,\r\n\t\t\t[totalWeight] VARCHAR(200) NULL,\r\n\t\t\t[soldAddress] VARCHAR(200) NULL,\r\n\t\t\t[senderCompany] VARCHAR(200) NULL,\r\n\t\t\t[sendId] VARCHAR(200) NULL,\r\n\t\t\t[sendPrice] FLOAT NULL,\r\n\t\t\t[clientPay] FLOAT NULL,\r\n\t\t\t[profit] FLOAT NULL\r\n\t\t\t)", "CREATE TABLE [SendCompany] (\r\n\t\t\t[id] INTEGER PRIMARY KEY,\r\n\t\t\t[name] VARCHAR(200) NULL\r\n\t\t\t)");
//检查数据是否存在
if (!file_exists(DB_NAME)) {
if (!($fp = fopen(DB_NAME, "w+"))) {
exit("创建数据库失败");
}
$justCeate = true;
fclose($fp);
}
//打开数据库文件
$db = makeConn();
//设置初始数据
if ($justCeate) {
for ($i = 0; $i < count($initArray); $i++) {
execute($db, $initArray[$i]);
}
}
//建立数据库连接
function makeConn()
{
if (IS_SQLITE3) {
return new SQLite3(DB_NAME);
} else {
return sqlite_open(DB_NAME);
}
}
