WHERE clause of MySQL in PHP

WHERE clause of MySQL in PHP

The WHERE clause is used to filter records.

WHERE clause
The WHERE clause is used to extract only those records and complete the specified criteria.

Syntax

SELECT column_name (s) FROM table_nameWHERE column_name operator value

For more information about SQL, see our SQL tutorial.

To allow PHP to execute the preceding Declaration, we must use the mysql_query () function. This function is a MySQL connection used to send queries or commands.

For example
In the following example, select all rows from the "persons" table, where "name =" Peter ':
 
$ Con = mysql_connect ("localhost", "peter", "abc123"); if (! $ Con) {die ('could not connect :'. mysql_error ();} mysql_select_db ("my_db", $ con); $ result = mysql_query ("SELECT * FROM PersonsWHERE FirstName = 'peter '"); while ($ row = mysql_fetch_array ($ result) {echo $ row ['firstname']. "". $ row ['lastname']; echo "<br/>" ;}?>
 
Output.
Peter Griffin