標籤:
1. 添加首頁index.php,最終郊果 :
1.1 編輯首頁內容
<!DOCTYPE html><html><head><meta charset="UTF-8"><title>Joke Management System</title></head><body> <h1>Joke Management System</h1> <ul> <li><a href="jokes/">Manage Jokes</a></li> <li><a href="authors/">Manage Authors</a></li> <li><a href="categories/">Manage Joke Categories</a></li> </ul></body></html>
2. 搭建總體架構
3. 架構的前期準備
3.1 定義訪問資料庫操作
網站中經常訪問資料庫,我們可以把此段代碼封裝起來.
include_once $_SERVER[‘DOCUMENT_ROOT‘].‘/PHP_MySQL_Web/includes/db.inc.php‘;
db.inc.php檔案實現,其中ijdb_user1是訪問資料庫的使用者名稱,123456是密碼.
<?php try { $dsn = ‘mysql:host=localhost;dbname=ijdb;‘; $username = ‘ijdb_user1‘; $passwd = ‘123456‘; $pdo = new PDO($dsn, $username, $passwd); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $statement = ‘SET NAMES "utf8"‘; $pdo->exec($statement); } catch (PDOException $e) { $error = ‘connect to database failed...‘ .$e->getMessage(); include ‘error.html.php‘; }
PHP和MySQL Web開發從新手到高手,第4天-搭建基本架構