MySQLi OR condition is used to filter records if any one of the conditions is TRUE.
if any of the conditions separated by OR is TRUE then it will displays a records
Below the syntax of OR condition
WHERE condition1
OR condition2
...
OR condition_n;<?php
$conn = mysqli_connect('localhost:3306', 'user_name', 'password', 'db_nexladder');
if(! $conn) {
die('Could not connect: ' . mysqli_error());
}
$sql = "SELECT * FROM `tbl_customers` WHERE `first_name` = 'Ajay' OR `id` > 15";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_object($result)) {
echo "Name: " . $row->first_name. "<br />";
}
} else {
echo "0 rows";
}
mysqli_close($conn);
?>Below it'll look like:
