<?php
$dsn = 'mysql:host=localhost;dbname=test;charset=utf8mb4';
$user = 'root';
$pass = '';
try {
$pdo = new PDO($dsn, $user, $pass, [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
]);
// 建立資料表
$sql = "CREATE TABLE IF NOT EXISTS `test` (
`id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(150) DEFAULT NULL,
`content` TEXT,
`addNewColumn` VARCHAR(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
$pdo->exec($sql);
echo '資料表 test 建立成功';
} catch (PDOException $e) {
echo '錯誤:' . $e->getMessage();
}
$mysqli = new mysqli('localhost', 'root', '', 'test');
if ($mysqli->connect_errno) {
die('連線失敗:' . $mysqli->connect_error);
}
$mysqli->set_charset('utf8mb4');
$sql = "CREATE TABLE IF NOT EXISTS `test` (
`id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(150) DEFAULT NULL,
`content` TEXT,
`addNewColumn` VARCHAR(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
if ($mysqli->query($sql)) {
echo '資料表建立成功';
} else {
echo '建立失敗:' . $mysqli->error;
}
$mysqli->close();
utf8 僅支援 BMP// 新增
$stmt = $pdo->prepare("INSERT INTO test (title, content, addNewColumn) VALUES (?, ?, ?)");
$stmt->execute(['標題', '內容', 'extra']);
// 查詢
$stmt = $pdo->query("SELECT * FROM test");
while ($row = $stmt->fetch()) {
echo $row['title'] . '<br>';
}
// 更新
$stmt = $pdo->prepare("UPDATE test SET content = ? WHERE id = ?");
$stmt->execute(['新內容', 1]);
// 刪除
$stmt = $pdo->prepare("DELETE FROM test WHERE id = ?");
$stmt->execute([1]);
原範例使用的 mysql_connect()、mysql_query() 等函式自 PHP 5.5 棄用、PHP 7.0 移除,**請勿在新專案使用**,改用 PDO 或 mysqli。
原始來源:www.111cn.net