網路程式設計

105期中考解答

資料庫連線檔 db.inc.php

<?php
require 'lib/medoo.php';

$database = new medoo([
	// required
	'database_type' => 'mysql',
	'database_name' => 'student',
	'server' => 'localhost',
	'username' => 'student',
	'password' => '1234',
	'charset' => 'utf8',
]);

註：PHP版本為 5.6，若為5.3必須改為 ==>

<?php
$database = new medoo(array(
	// required
	//...
));

如何查看php版本

輸入表單

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <form action="add.php" method="POST">
            <p>
            <label>學號： </label>
                <input type="text" name="sid" placeholder="學號8碼，例如：AA123456">
            </p> 
            <p>
            <label>姓名：</label>
                <input type="text" name="name" placeholder="輸入姓名">
             </p> 
            <p>
            <label>成績：</label>
                <input type="number" name="score" placeholder="輸入成績0~100">
            </p>
            <input type="submit" value="送出">
        </form>
    </body>
</html>

<input placeholder='提示文字'....

處理程式add.php

<?php
require 'db.inc.php';

$back = false;
if (empty($_POST['sid'])) {
    echo '學號未填<br>';
    $back = true;
}
if (empty($_POST['name'])) {
    echo '姓名未填<br>';
    $back = true;
}
if (empty($_POST['score'])) {
    echo '分數未填<br>';
    $back = true;
}

if (!$back) {
    $sid = $_POST['sid'];
    $name = $_POST['name'];
    $score = $_POST['score'];
    $database->insert('student', [
        'sid' => $sid,
        'name' => $name,
        'score' => $score
    ]);
}
// 查詢
$data = $database->select('student', '*');
if (count($data)) {
    foreach ($data as $row) {
        ?>
        <?= $row['sid'] ?>
        <?= $row['name'] ?>
        <?= $row['score'] ?>
        <br>
        <?php
    }
}
?>
<p><a href="index.php">新增另一筆</a></p>