MySQL 是跟 PHP 配套使用的最流行的開源數據庫系統。

首先，我們可以在瀏覽器輸入localhost打開phpMyAdmin，可以直觀的看到我們對數據庫操作后的結果

以下，我將全部以 ?面向過程? 的方式來像大家講解PHP操作SQL的過程：

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "myOneDB"; ?/* 這個是在創建之后才能查詢連接成功的 */

// 創建連接

$conn = mysqli_connect($servername, $username, $password,$dbname);

if (!$conn)

{

die("連接失敗: " . mysqli_connect_error($conn));

}

else

{

echo "鏈接成功";

}

// 創建數據庫

$sql_create = "CREATE DATABASE myOneDB";

mysqli_query($conn, $sql_create);

//創建表

$createTable = "CREATE TABLE TableOne?(

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(30) NOT NULL,

phone INT(11) UNSIGNED NOT NULL,

regist_time TIMESTAMP

)";

mysqli_query($conn,$createTable);

//插入數據

$sql_insert = "INSERT INTO

TableOne(id,name,phone)

VALUES(1,'zhangsan',13088888888)";

mysqli_query($conn,$sql_insert);

//插入多條數據

$sql_insert? = "INSERT INTO TableOne(id,name,phone)

VALUES (2,'lisi',15738298760);";

$sql_insert .= "INSERT INTO TableOne(id,name,phone)

VALUES (3,'wangwu',13083458800);";

$sql_insert .= "INSERT INTO TableOne(id,name,phone)

VALUES (4,'zhaoliu',17798209357);";

mysqli_multi_query($conn,$sql_insert);

//刪除

$sql_deleteTable? = "DELETE FROM TableOne WHERE id=3;";

$sql_deleteTable .= "DELETE FROM TableOne WHERE id=4;";

$sql_deleteTable .= "DELETE FROM TableOne WHERE id=5;";

mysqli_multi_query($conn,$sql_deleteTable);

//查詢數據

$sql_read = "SELECT id,name,phone,regist_time FROM TableOne";

$result = mysqli_query($conn,$sql_read);

if ($result -> num_rows > 0)

{

echo "查詢成功";

while ($row = $result -> fetch_assoc())

{

echo "id = ".$row["id"]."name = ".$row["name"]."phone = ".$row["phone"]."注冊時間 = ".$row["regist_time"];

}

}

//where查詢

$sql_where = "SELECT * FROM TableOne WHERE id='2'";

$result = mysqli_query($conn,$sql_where);

if ($result)

{

while ($row = mysqli_fetch_array($result))

{

echo "查詢結果: id = ".$row["id"]."name = ".$row["name"];

}

}

//更新數據

$sql_update = "UPDATE TableOne SET name='ys' WHERE id=4";

mysqli_query($conn,$sql_update);

//關鍵詞操作? ? DESC降序? ? ASC升序

$sql_orderby = "SELECT * FROM TableOne ORDER BY id DESC";

$result = mysqli_query($conn,$sql_orderby);

if ($result)

{

while ($row = mysqli_fetch_array($result))

{

echo "id = ".$row["id"]." name = ".$row["name"];

}

}

mysqli_close($conn); ?//關閉數據庫！

總結

以上是生活随笔為你收集整理的php mysql unsigned,PHP MySQL 核心的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。