PHP MySQL Where clause

PHP MySQLWhere clause

The WHERE clause is used to filter records.

WHERE clause

The WHERE clause is used to extract records that meet the specified criteria.

Grammar

SELECT column_name (s)  from table_name WHERE column_name operator value

To learn more about SQL, please visit our SQL Tutorial.

In order for PHP to execute the above statement, we must use the Mysqli_query () function. This function is used to send a query or command to a MySQL connection.

Instance

The following example selects all rows of Firstname= ' Peter ' from the "Persons" table:

<?PHP$con=Mysqli_connect("localhost", "username", "password", "Database");//Detecting Connectionsif(Mysqli_connect_errno()){    Echo"Connection failed:".Mysqli_connect_error();}$result=Mysqli_query($con,"SELECT * from Personswhere firstname= ' Peter '"); while($row=Mysqli_fetch_array($result)){    Echo $row[' FirstName ']. " " .$row[' LastName ']; Echo"<br>";}?>

The above code will output:

Peter Griffin

PHP MySQL Where clause