NEWS: Total Picture Views: 155282 | Total Article Views: 165614 | Top 5 Most Popular Article: 1. Am I Stuck Algorithm with Becker Robot | 2. PickUpThings with Becker Robot | 3. How to read a JSON and work with it | 4. Encrypted Data GUI (Download .Zip) | 5. Create Wall and Things with Becker

Connect to a database and make query using MySQLi PHP/MySQL

Description:

In this example I will be showing how to connect to a database and make query to it (Object oriented style). 

Code:

/* Database Connection Information */
$mysqli = new mysqli("localhost", "my_user", "my_password", "db_name");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s", $mysqli->connect_error);
    exit();
}

/* Select queries return a resultset */
if ($result = $mysqli->query("SELECT * FROM Sheridan")) {
    printf("Select returned %d rows.", $result->num_rows);

    /* free result set */
    $result->close();
}
/* Close Connection */
$mysqli->close();
Attachments: None

Tags: MySQLi Query Connect

Total Views: 1178

My name is Jean-Mathieu

I created this website so other people could enjoy finding useful stuff easier. If you have any question do not hesitate to contact me.

jean8mathieuCreated on 01/13/15 and updated on 01/15/15


affiliate_link

Disclosure: We are a website that needs compensation to operate like any other website on the internet.
We may receive consideration for our reviews but we are totally unbiased and do not accept paid reviews or fake reviews claiming to be something they are not.