Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.