mysqli tutorial

moving from procedural coding style to OOP this article telling basic information and maybe helpfull

http://www.willfitch.com/mysqli-tutorial.html

Getting some info on the result from the mysql database:

 $mysqli = new mysqli('localhost','db_user','my_password','mysql'); // Get all the MySQL users and their hosts $sql = "SELECT user, host FROM user"; // If the query goes through if ($result = $mysqli->query($sql)) { // If there are some results if ($result->num_rows > 0) { // Let's show some info echo 'There were '.$result->num_rows.' rows returned. '; echo 'We selected '.$result->field_count.' fields in our query. '; echo 'Our thread ID is '.$mysqli->thread_id.' '; // Ok, let's show the data while ($row = $result->fetch_object()) { echo 'Username: '.$row->user.' :: Host: '.$row->host.' '; } // end while loop } else { echo 'There are no results to display. Odd how we connected to this database and there are no users.'; } // end else } else { // Notice the error would be within the mysqli class, rather than mysql_result printf("There has been an error from MySQL: %s",$mysqli->error); } // end else // Close the DB connection $mysqli->close(); ?>

also read mysql performance

http://chrisjohnson.blogsite.org/php-and-mysql-data-import-performance/