1, in PHP using the mysqli extension library to the MySQL DQL operation
| The code is as follows |
Copy Code |
|
<?php
Header ("Content-type:text/html;charset=utf-8");
MYSQLI operating the MySQL database (object-oriented mode) 1. Create Mysqli objects $mysqli =new mysqli ("localhost", "root", "root", "test");
if ($mysqli->connect_error) {
Die ("Connection failed". $mysqli->connect_error);
} 2. Operation database (send SQL)
$sql = "Select *from user1"; 3, processing results
$res = $mysqli->query ($sql);
Var_dump ($res);
FETCH_ASSOC Fetch_array Fetch_object
while ($row = $res->fetch_row ()) { Var_dump ($row); /* foreach ($row as $val) {
Echo '--'. $val;
}
Echo ' <br/> ';
}
4. Close Resources
$res->free ();
$mysqli->close ();
?> |
The following is a process-oriented
| The code is as follows |
Copy Code |
| <?php Header ("Content-type:text/html;charset=utf-8");
$mysqli =mysqli_connect ("localhost", "root", "root", "test");
if (! $mysqli) {
Die ("Connection Failed". Mysqli_connect_error ());
} $sql = "Select *from user1"; $res =mysqli_query ($mysqli, $sql);
Var_dump ($res); while ($row =mysqli_fetch_row ($res)) {
foreach ($row as $val) {
Echo '-'. $val;
}
Echo ' <br/> ';
} Free memory
Mysqli_free_result ($res);
Mysqli_close ($MYSQLI);
?> |
2, in PHP using the mysqli extension library for MySQL DML operation
| The code is as follows |
Copy Code |
|
<?php
CRUD operations on MySQL using the mysqli extension library
Header ("Content-type:text/html;charset=utf-8");
$mysqli = new Mysqli ("localhost", "root", "root", "test");
if ($mysqli->connect_error) {
Die ("Connection failed". $mysql->connect_error);
} Add a record
$sql = "INSERT INTO User1 (name,password,email,age) VALUES (' Lucy ', MD5 (' Lucy '), ' lucy@163.com ', 17)";
Delete a record
$sql = "Delete from User1 where id = 80";
Update a record
$sql = "Update user1 set age=20 where id=7"; $res = $mysqli->query ($sql);
if (! $res) {
Echo "Operation failed". $mysqli->error;
}else{
if ($mysqli->affected_rows>0) {
echo "Success";
}else{
echo "No rows affected";
}
} Close Resource
$mysqli->close ();
?> |
3, carry out the encapsulation
| The code is as follows |
Copy Code |
| ? class sqlhelper{
private $mysqli;
//Here first write dead, later write dead things in a file to configure
private static $host = "localhost";
private static $user = "root";
private static $pwd = "root";
private static $db = "Test"; Public Function __construct () {
$ This->mysqli=new mysqli (self:: $host, Self:: $user, Self:: $pwd, Self:: $DB);
if ($this->mysqli->connect_error) {
die (Connection failed). $ THIS->MYSQLI->CONNECT_ERROR);
}
/Setting character set
$this->mysqli->query ("Set names UTF8");
} DQL operate
function Execute_dql ($sql) { $res = $this->mysqli->query ($sql) or Die ($this->mysqli->error);
return $res;
} DML operate
function Execute_dml ($sql) { $res = $this->mysqli->query ($sql) or Die ($this->mysqli->error);
if (! $res) {
Return 0;//failed
}else{
if ($this->mysqli->affected_rows>0) {
Return 1;//Successful
}else{
Return 2;//no line to impact
}
}
}
}
?> |
