MySQL ???????

MySQL ????

1. ?????

?? mysqli() ????????????

// ?????$mysql = new mysqli("localhost", "root", "root");if ($mysql->connect_error) {    die("????: " . $mysql->connect_error);}echo "?????";

2. ?????

???????????????????????

// ?????$sql = "CREATE DATABASE php";if ($mysql->query($sql) == true) {    echo "????????";} else {    echo "???????: " . $mysql->error;}

?????????

3. ?????

???????????

// ????$mysql = new mysqli("localhost", "root", "root", "php");if ($mysql->connect_error) {    die("????: " . $mysql->connect_error);}echo "?????";// ?????$sql1 = "CREATE TABLE user (    id INT unsigned AUTO_INCREMENT PRIMARY KEY,    pwd VARCHAR(20) NOT NULL)";if ($mysql->query($sql1) == true) {    echo "????????";} else {    echo "???????: " . $mysql->error;}// ????$sql2 = "INSERT INTO user VALUES('201801', '123456')";if ($mysql->query($sql2) == true) {    echo "???????";} else {    echo "??????: " . $mysql->error;}// ??????$sql3 = "INSERT INTO user VALUES('201802', '123456');";$sql3 .= "INSERT INTO user VALUES('201803', '123456');";if ($mysql->multi_query($sql3) == true) {    echo "?????????";} else {    echo "????????: " . $mysql->error;}

4. ?????

???????????????

// ?????$sql = $mysql->prepare("INSERT INTO user VALUES(?, ?)");$sql->bind_param("is", $id, $pwd);// ????$id = 201804;$pwd = "123456";if ($sql->execute()) {    echo "?????????";} else {    echo "????????";}

5. ????

?????????

// ????$sql = "SELECT * FROM user";$result = $mysql->query($sql);if ($result->num_rows > 0) {    while ($row = $result->fetch_assoc()) {        echo "????: id=" . $row["id"] . ", ??: " . $row["pwd"] . "
";    }}