PHP SQL Rows is used to fetch the select the row value based on the condition specified in where clause and display it on the browser.
Understand with Example
The Tutorial illustrate an example from 'PHP SQL Rows'. To understand the example we create a table 'users'. The select query is used to returns the records from table 'users'.
Source Code of sql_rows.php :
The sql_rows.php is a server side begins with <?php and end with ?>. This include a connection variable which is initialized with mysql_connect function. The mysql_connect ( ) accept the parameter like local host, user and password to authenticate the connection between the PHP and MySQL. Incase, there is connection failure between the PHP and MySQL, the die part will be executed shows you the error message specifying the 'Could not connect'. To execute MySQL query in PHP, we make use of mysql_function ( ) that run the sql command. In this example we create a SQL query result which returns the set of records from table 'users' based on the condition specified in where Clause. The row variable assigned the value of mysql_fetch_row ( ) function which accept the parameter result. Finally the echo print the row values on the browser.
Posted on: April 3, 2006 If you enjoyed this post then why not add us on Google+? Add us to your Circles