PHP MySQL OR Operator Example

If you want to filter data(records) in the record set based on two or more conditions then use OR operator that filter result.

PHP MySQL OR Operator Example:

If you want to filter data(records) in the record set based on two or more conditions then use OR operator that filter result, only those records contain by the record set that full fill any one condition in the given conditions.

Example:

<?php
$connection = mysql_connect("localhost","root","root");

if (!$connection) {
die('PHP Mysql database connection could not connect : ' . mysql_error());
}
else{ 
$db_name = "php_mysql";

mysql_select_db($db_name, $connection);
$sql = "select * from user where user_name='Brijesh'
or user_email='brijesh@gmail.com';";
$records = mysql_query($sql, $connection); 
while($rows = mysql_fetch_array($records)){
echo "User Id : " . $rows['user_id'] . "<br />";
echo "User Name : " . $rows['user_name'] . "<br />";
echo "User Email : " . $rows['user_email'] . "<br />";
echo "User Address : " . $rows['user_address'] . "<br /><br /><br />";
}
}
mysql_close($connection); 
?> 

The database user table records is:

In this example the executed mysql query fetch those record that fulfill any one conditions in the given conditions.

Output:

User Id : 2
User Name : Brijesh
User Email : brijesh@gmail.com
User Address : Delhi


User Id : 3
User Name : Brijesh
User Email : brijeshkumar@gmail.com
User Address : Delhi

Download Example Code