Querying and formatting

resource mysqli_query ( resource link_identifier, string query [, int mode = MYSQLI_STORE_RESULT])

int mysqli_num_rows ( [resource result])

The majority of your interaction with MySQL in PHP will be done using the mysqli_query() function, which takes at least two parameters: the database connection you want to query, and the SQL query you want to perform. It will then perform that query and return a special resource known as a MySQL result index, which contains all the rows that matched your query.

This result index resource is the return value of mysqli_query(), and you should save it in a variable for later use - whenever you want to extract rows from the results, count the number of rows, etc, you need to use this value.

One other key function is mysqli_num_rows(), which takes a MySQL result index as its parameter, and returns the number of rows inside that result - this is the number of rows that matched the query you sent in mysqli_query(). With the two together we can write our first database enabled script:

<?php
    $db = mysqli_connect("localhost", "phpuser", "alm65z", "phpdb");
    $result = mysqli_query($db, "SELECT * FROM usertable");
    $numrows = mysqli_num_rows($result);
    print "There are $numrows people in usertable\n";
?>

As you can see, we capture the return value of mysqli_query() inside $result, then use on the very next line - this MySQL result index is used quite heavily, so it is important to keep track of it. The exception to this is when you are executing a write query in MySQL - you might not want to know the result.

One helpful feature of mysqli_query() is that it will return false if the query is syntactically invalid - that is, if you have used a bad query. This means that very often it is helpful to check the return value even if you are writing data - if the data was not written successfully, mysqli_query() will tell you so with the return value.

 

Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: Disconnecting from a MySQL database >>

Previous chapter: Connecting to a MySQL database

Jump to:

 

Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.