SQL Select | Tutorial

Course Title: Web Development Masterclass
Course Link: http://youaccel.com/admin/cdisplay.php?cid=11

Facebook: https://www.facebook.com/youaccel
Twitter: https://twitter.com/YouAccel
Website: http://youaccel.com

Tutorial Content:

With our data imported into the database, we can start exploring some of the SQL statements we can integrate with MySQLi to perform different tasks.

We will start off with the SELECT Statement. We have worked with this before, in PhpMyAdmin. The SELECT statement will retrieve data from the database.

First create and save a new PHP file in your text editor. We have named it select.php.

Establish a connection to the mywebsite database, as we did in the last lesson.

Next, we need to create our SQL statement.

Here we have set the SQL statement to select the id, firstname, lastname and email columns from the users table.

We then execute the SQL query and put the resulting data into a variable called result.

The following if statements checks to make sure there is at least one row. If there are no rows, it means there is no data relevant to our query. In which case the words "0 results" will be outputted.

If there is at least one row, the function fetch_assoc() will put all the results into an associative array that we can loop through. The while() loop loops through the result set and outputs the data from the columns we specified in the SELECT statement. The output is done through a basic echo statement.

We can see the results by loading this page in our web browser.