Use MySQL IF in PHP

In this article I explain MySQL if, function in PHP
  • 2116

MySQL IF Function

The MySQL IF function is used to test a condition and return a value if the condition is true or another value if the condition is false. In other words, the if function takes three arguments and if the first expression of the given condition is TRUE then it returns the second expression (the true expression) and if the given condition is FALSE then it returns the third expression (the false expression).

Syntax

IF (condition (means expression), if_true_expression, if_false_expression );


Parameters in IF function

It takes three parameters; they are:
 

Parameter Description
condition It specifies a expression.
if_true_expression, Return, when condition is true.
if_false_expression, Return, when condition is false.

Example of MySQL If function in PHP

 

<?php

$con=mysql_connect("localhost","root","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("mysql", $con);

print "<h2>MySQL: Use of IF function</h2>";

$result = mysql_query("SELECT monger_name, IF(monger_country='france','Available','Notavailable') AS isCity_France FROM vendordtl");

 

echo "<table border='1'>

<tr>

<th>VendorName</th>

<th>IsCityFrance</th>

</tr>";

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['monger_name'] . "</td>";

  echo "<td>" . $row['isCity_France'] . "</td>";

  echo "</tr>";

  }

  echo "</table>";

?>

Output 

mysql-if-function-in-php.jpg

© 2019 DotNetHeaven. All rights reserved.