本人是一位學生，正在學習當中，可能BUG眾多，請見諒並指正，謝謝！！！ 學生列表實現 HTML: PHP: 添加學生實現 HTML: PHP: ...
本人是一位學生，正在學習當中，可能BUG眾多，請見諒並指正，謝謝！！！
學生列表實現
HTML:
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>學生信息</title> <link rel="stylesheet" type="text/css" href="css/Bootstrap.css"> </head> <body> <div class="container mt-5"> <h1 class="display-4 text-center">學生信息管理中心</h1> <div class="row mt-3"> <a class="btn btn-info col-sm-2" style="margin-right: 88px; margin-left: 15px;" href="add_student.php">添加學生</a> <input type="text" class="form-control col-sm-6 ml-5" placeholder="請輸入關鍵詞"> <button type="submit" class="btn btn-info col-sm-2 ml-4">點擊搜索</button> </div> <table class="table table-hover table-bordered mt-3"> <thead class="thead-inverse"> <tr> <th class="text-center align-middle">學號</th> <th class="text-center align-middle">學院/系</th> <th class="text-center align-middle">班級</th> <th class="text-center align-middle">姓名</th> <th class="text-center align-middle">性別</th> <th class="text-center align-middle">年齡</th> <th class="text-center align-middle">照片</th> <th class="text-center align-middle">操作</th> </tr> </thead> <tbody class="text-center"> <?php while ($student = mysqli_fetch_assoc($query)): ?> <tr> <td class="align-middle"><?php echo $student['num']; ?></td> <td class="align-middle"><?php echo $student['system']; ?></td> <td class="align-middle"><?php echo $student['class']; ?></td> <td class="align-middle"><?php echo $student['name']; ?></td> <td class="align-middle"><?php echo $student['gender'] === 1 ? '♂' : '♀'; ?></td> <td class="align-middle"><?php echo date('Y') - substr($student['birthday'], 0, 4); ?></td> <td class="align-middle"><img src="<?php echo $student['photo']; ?>" width="100" height="70"></td> <td class="align-middle"><a class="btn btn-info mr-2" href="edit.php?num=<?php echo $student['num']; ?>">編輯</a><a class="btn btn-danger ml-2" href="delete.php?num=<?php echo $student['num']; ?>">刪除</a></td> </tr> <?php endwhile ?> </tbody> </table> </div> </body> </html>
PHP:
// 這裡：
// 第一個參數：本地網路地址
// 第二個參數：資料庫賬號
// 第三個參數：資料庫密碼
// 第四個參數：資料庫名稱
$connection = mysqli_connect('localhost', 'root', '密碼', 'students_info_system'); if (!$connection) { exit('<h1>連接資料庫失敗</h1>'); } $query = mysqli_query($connection, 'select * from students'); if (!$query) { exit('<h1>學生數據查詢失敗</h1>'); } $administrator_query = mysqli_query($connection, 'select * from students');
添加學生實現
HTML:
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>添加學生</title> <link rel="stylesheet" type="text/css" href="css/Bootstrap.css"> </head> <body> <div class="container mt-3"> <h1 class="display-4 text-center">添加學生</h1> <?php if (isset($error_msg)): ?> <div class="alert alert-danger"><?php echo $error_msg; ?></div> <?php endif ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data" autocomplete="off"> <div class="form-group"> <input type="number" name="num" class="form-control" placeholder="學號" value="<?php echo isset($_POST['num']) ? $_POST['num']: ''; ?>"> </div> <div class="form-group"> <select class="form-control" name="system"> <option>請選擇學院/系</option> <option>電氣工程學院</option> <option>信息工程與藝術學院</option> <option>國際教育學院</option> <option>水利水電工程學院</option> <option>測繪與市政工程學院</option> <option>馬克思主義學院</option> <option>建築工程學院</option> <option>經濟與管理學院</option> </select> </div> <div class="form-group"> <input type="text" name="class" class="form-control" placeholder="班級" value="<?php echo isset($_POST['class']) ? $_POST['class'] : ''; ?>"> </div> <div class="form-group"> <input type="text" name="name" class="form-control" placeholder="姓名" value="<?php echo isset($_POST['name']) ? $_POST['name'] : ''; ?>"> </div> <div class="form-group"> <select class="form-control" name="gender"> <option value="-1">請選擇性別</option> <option <?php echo isset($_POST['gender']) && $_POST['gender'] === '1' ? 'selected' : ''; ?> value="1">男</option> <option <?php echo isset($_POST['gender']) && $_POST['gender'] === '0' ? 'selected' : ''; ?> value="0">女</option> </select> </div> <div class="form-group"> <label for="birthday">出生日期</label> <input type="date" name="birthday" class="form-control" id="birthday" value="<?php echo isset($_POST['birthday']) ? $_POST['birthday'] : ''; ?>"> </div> <div class="form-group"> <label for="photo">照片</label> <input type="file" name="photo" class="form-control"> </div> <button class="btn btn-info btn-block">確認添加</button> </form> </div> </body> </html>
PHP:
function add_student () {
$connection = mysqli_connect('localhost', 'root', '密碼', 'students_info_system'); if (!$connection) { $GLOBALS['error_msg'] = '連接資料庫失敗'; return; } $query = mysqli_query($connection, 'select * from students'); if (!$query) { $GLOBALS['error_msg'] = '數據查詢失敗'; return; } // 查詢已有學生 while ($student = mysqli_fetch_assoc($query)) { // var_dump($student); $students_num[] = $student['num']; } // var_dump($_FILES['photo']); // var_dump($_POST['gender']); if (empty($_POST['num'])) { $GLOBALS['error_msg'] = '請輸入學號'; return; } // 判斷該學號是否已經被添加(即列表中已存在該學生)========= if (in_array($_POST['num'], $students_num)) { $GLOBALS['error_msg'] = '該學生已存在'; return; } if (empty($_POST['system']) || $_POST['system'] === '請選擇學院/系') { $GLOBALS['error_msg'] = '請選擇學院/系'; return; } if (empty($_POST['class'])) { $GLOBALS['error_msg'] = '請輸入班級'; return; } if (empty($_POST['name'])) { $GLOBALS['error_msg'] = '請輸入姓名'; return; } if (!(isset($_POST['gender']) && $_POST['gender'] !== '-1')) { $GLOBALS['error_msg'] = '請選擇性別'; return; } if (empty($_POST['birthday'])) { $GLOBALS['error_msg'] = '請輸入出生日期'; return; } // 以下處理文件域======================================================= if (empty($_FILES['photo'])) { $GLOBALS['error_msg'] = '請上傳照片'; return; } if ($_FILES['photo']['error'] !== UPLOAD_ERR_OK) { $GLOBALS['error_msg'] = '上傳照片失敗'; return; } // 驗證上傳文件的類型(只允許圖片) if (strpos($_FILES['photo']['type'], 'image/') !== 0) { $GLOBALS['error_msg'] = '這不是支持的文件格式類型，請重新上傳'; return; } // 文件上傳到了服務端開闢的一個臨時地址，需要轉移到本地 $image_target = 'images/' . $_FILES['photo']['name']; if (!move_uploaded_file($_FILES['photo']['tmp_name'], $image_target)) { $GLOBALS['error_msg'] = '圖片上傳失敗'; return; } // 接收學生信息 $num = (string)$_POST['num']; $system = (string)$_POST['system']; $class = (string)$_POST['class']; $name = (string)$_POST['name']; $gender = (int)$_POST['gender']; $birthday = (string)$_POST['birthday']; $photo = (string)$image_target; // 將數據存放到資料庫 $insert_query = mysqli_query($connection, "insert into students values ('{$num}', '{$system}', '{$class}', '{$name}', {$gender}, '{$birthday}', '{$photo}')"); if (!$insert_query) { $GLOBALS['error_msg'] = '數據查詢失敗'; return; } $affected_rows = mysqli_affected_rows($connection); if ($affected_rows !== 1) { $GLOBALS['error_msg'] = '添加失敗'; return; } // 延遲2秒 time_sleep_until(time() + 2);
// 跳回到學生信息頁面 header("Location: student_info.php"); } if ($_SERVER['REQUEST_METHOD'] === 'POST') { add_student(); }
