The simplest way for mysqli to operate mysql database
This article mainly introduces the simplest way for mysqli to operate mysql database, the contents of the article are carefully selected and edited by the author, with a certain pertinence, and is of great significance to everyone's reference, the following is to understand the simplest way for mysqli to operate mysql database with the author.
/ / 1. Create a MySQLi object
Echo ""
$mysqli=new MySQLi ("localhost", "root", "root", "test")
If ($mysqli- > connect_error) {
Die ("connection failed". $mysqli- > connect_error)
}
/ / 2. Manipulate the database (send sql)
$sql= "select * from user1"
$res=$mysqli- > query ($sql)
/ / 3. Processing result
While ($row=$res- > fetch_row ()) {
Foreach ($row as $key= > $val) {
Echo "--$val"
}
Echo ""
}
/ / 4. Close resources, connect
$res- > free ()
$mysqli- > close ()
After reading the simplest way for mysqli to operate mysql database, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.
