Web項目開發(fā)圖書管理系統(tǒng)源代碼

隨著互聯(lián)網(wǎng)的發(fā)展，圖書管理系統(tǒng)的需求也越來越強烈。一個理想的圖書管理系統(tǒng)應該能夠方便地管理圖書館中的圖書，提供用戶方便訪問的界面，并且能夠集成其他圖書館服務和工具，如借還書、讀者檔案、目錄查詢等。

下面是一個基于PHP和MySQL開發(fā)的圖書管理系統(tǒng)的源代碼。該系統(tǒng)包括用戶登錄、圖書管理、借還書、讀者檔案、目錄查詢等功能。

用戶登錄功能

用戶登錄功能是系統(tǒng)的核心功能之一，用于驗證用戶憑據(jù)并授權(quán)用戶訪問系統(tǒng)。以下是一個簡單的用戶登錄模塊的代碼：

“`php
array(
\’username\’ => \’user1\’,
\’password\’ => \’password1\’,
\’email\’ => \’user1@example.com\’,
\’role\’ =>\’reader\’
),
\’user2\’ => array(
\’username\’ => \’user2\’,
\’password\’ => \’password2\’,
\’email\’ => \’user2@example.com\’,
\’role\’ => \’書友\’
)
);

// 定義管理員表
$admins = array(
\’admin1\’ => array(
\’username\’ => \’admin1\’,
\’password\’ => \’password1\’,
\’email\’ => \’admin1@example.com\’,
\’role\’ => \’admin\’
)
);

// 判斷用戶是否為管理員
function isAdmin($user) {
return in_array($user[\’username\’], $admins);
}

// 判斷用戶是否登錄
function isLoggedIn($user) {
return isset($users[$user[\’username\’]][\’password\’]) && strcmp($user[\’username\’], $users[$user[\’username\’]][\’password\’]) === 0;
}

// 判斷用戶是否匿名
function isAnonymous($user) {
return!isLoggedIn($user);
}

// 用戶登錄
function login($username, $password) {
$query = \”SELECT * FROM users WHERE username = $username AND password = $password\”;
$result = mysql_query($query);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
$user = $result->fetch_assoc();
return $user;
}

// 用戶注冊
function register($username, $password, $email, $role) {
$query = \”INSERT INTO users (username, password, email, role) VALUES (\’$username\’, \’$password\’, \’$email\’, \’$role\’)\”;
$result = mysql_query($query);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
$user = $result->fetch_assoc();
return $user;
}

// 用戶注銷
function logout() {
$query = \”SELECT * FROM users WHERE username = $username\”;
$result = mysql_query($query);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
$user = $result->fetch_assoc();
mysql_close();
return $user;
}

// 用戶借書
function bookBorrow($user, $book, $期限， $returnUrl) {
$query = \”SELECT * FROM books WHERE id = $book\”;
$result = mysql_query($query);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
$user = $result->fetch_assoc();
$returnUrl = $returnUrl. \’?return_type=book&return_date=\’. strftime(\’%Y-%m-%d\’, time() );
$returnUrl = rtrim($returnUrl, \’&\’);
$user[\’return_url\’] = $returnUrl;
$user[\’return_date\’] = date(\’Y-m-d H:i:s\’);
$result = mysql_query(\”INSERT INTO users (email, role, return_url) VALUES (\’$user[\’email\’], \’$user[\’role\’], $user[\’return_url\’]\’)\”);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
return $user;
}

// 用戶還書
function bookReturn($user, $bookId, $returnUrl) {
$query = \”SELECT * FROM books WHERE id = $bookId\”;
$result = mysql_query($query);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
$user = $result->fetch_assoc();
$returnUrl = $returnUrl. \’?return_type=book&return_date=\’. strftime(\’%Y-%m-%d\’, time() );
$returnUrl = rtrim($returnUrl, \’&\’);
$user[\’return_url\’] = $returnUrl;
$user[\’return_date\’] = date(\’Y-m-d H:i:s\’);
$result = mysql_query(\”INSERT INTO users (email, role, return_url) VALUES (\’$user[\’email\’], \’$user[\’role\’], $user[\’return_url\’]\’)\”);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
return $user;
}

// 用戶借還書信息
$user = array(
\’user1\’ => array(
\’username\’ => \’user1\’,
\’password\’ => \’password1\’,
\’email\’ => \’user1@example.com\’,
\’role\’ =>\’reader\’
),
\’user2\’ => array(
\’username\’ => \’user2\’,
\’password\’ => \’password2\’,
\’email\’ => \’user2@example.com\’,
\’role\’ => \’書友\’
)
);

// 借書信息
$books = array(
array(
\’id\’ => 1,
\’title\’ => \’哈利波特與魔法石\’,
\’author\’ => \’J.K.羅琳\’,
\’rating\’ => 4
),
array(
\’id\’ => 2,
\’title\’ => \’悲慘世界\’,
\’author\’ => \’雨果\’,
\’rating\’ => 4
)
);

// 還書信息
$returnBook = array(
array(
\’id\’ => 1,
\’title\’ => \’哈利波特與魔法石\’,
\’author\’ => \’J.K.羅琳\’,
\’rating\’ => 4
),
array(
\’id\’ => 2,
\’title\’ => \’悲慘世界\’,
\’author\’ => \’雨果\’,
\’rating\’ => 4
)
);

// 借還書信息
$returnBook = array();

// 借書
function bookBorrow($user, $book, $期限， $returnUrl) {
$query = \”SELECT * FROM books WHERE id = $book\”;
$result = mysql_query($query);
if ($result === false) {
die(\”數(shù)據(jù)庫連接失敗\”);
}
$user = $result->fetch_assoc();
$returnUrl = $returnUrl. \’?return_type=book&return_date=\’. strftime(\’%Y-%m-%d\’, time() );
$returnUrl = rtrim($returnUrl, \’&\’);
$user[\’return_url\’] = $returnUrl;
$user[\’return_date\’] = date(\’Y-m-d H:i:s\’);
$returnBook = array();
$result = mysql_query(\”INSERT INTO return_book (id, title, author, rating) VALUES (\’$returnBook[0][\’id\’], \’$returnBook[0][\’title\’], \’$$returnBook[