$sqlday = "select user_max from userinfo ;";
$result = $db->query($sqlday);
$row = $result->fetch_array();
$usermaxday = $row[0];
$sql = "select start_time ,end_time from stateinfo where book_id={$id}";
$result = $db->query($sql);
$row = $result->fetch_array();
$start = strtotime($row[0]);
$end = strtotime($row[1]);
$day = ($end - $start) / (24 * 3600);
if ($day > $usermaxday + 20) {
echo 0;
return;
}
$time = $end + 10 * 24 * 3600;
$finaltime = date('Y-m-d', $time);
$sql = "update stateinfo set end_time='{$finaltime}' where book_id={$id} ";
$db->query($sql);
echo 1;
}
$action = $_POST['action'];
$id = $_POST['book_id'];
$userid = $_POST['userid'];
$db = new mysqli("localhost", "root", "qwedd80", "library");
if ($action == "borrow") {
borrow($id, $userid, $db);
} elseif ($action == "return") {
ret($id, $db);
} elseif ($action == "next") {
nextday($id, $userid, $db);
}
}
$time = $end + 10 * 24 * 3600;
$finaltime = date('Y-m-d', $time);
$sql = "update stateinfo set end_time='{$finaltime}' where book_id={$id} ";
$db->query($sql);
echo 1;
}
function getallinfo($db)
{
$sql = "select * from stateinfo";
$result = $db->query($sql);
$results = array();
while ($row = $result->fetch_array()) {
$results[] = $row;
}
echo json_encode($results);
$result->free();
$db->close();
}
$action = $_POST["action"];
$db = new mysqli("localhost", "root", "qwedd80", "library");
$db->query("SET NAMES 'UTF8'");
if ($action == "getall") {
getallinfo($db);
} elseif ($action == "returnthis") {
$id = $_POST['book_id'];
returnbook($id, $db);
} elseif ($action == "next") {
$id = $_POST['book_id'];
nextday($id, $db);
}
