Querying MySQL database using PHP (if statement)

Question

I need your help.

I have a PHP code that I use to query a MySQL database after selecting a certain operator. The operators that I have from the dropdown list are "LESS THAN, GREATER THAN, and EQUALS". The problem I have is; whichever operator I select, the result that I get from the database is always for the "LESS THAN" operator. That is, it give me the same result whether I select "LESS THAN", "GREATER THAN" or "EQUALS". I tried to locate the problem but failed. Here is the code that I use:

            if ($op='LESS THAN') {
        $query = "SELECT * FROM tbl_reservoir WHERE res_vol < '$vol'";
    } elseif ($op='GREATER THAN') {
            $query = "SELECT * FROM tbl_reservoir WHERE res_vol > '$vol'";
    } elseif ($op='EQUAL') {
         $query = "SELECT * FROM tbl_reservoir WHERE res_vol = '$vol'";
    }

$op is a variable that holds the operator, and "res_vol" is a field that I compare with from the database table.

In addition to the answers - if you have just three options, you don't need a final if ($op == 'EQUAL') line. You know if you reach that, then neither of the previous two options was chosen. I tend to make that option an else - I think it makes the code a little more readable. — andrewsi
– andrewsi, Commented Sep 17, 2012 at 0:56
The way you're building your queries leaves you open to a SQL injection attack. Please take a look at bobby-tables.com/php.html to find out about how to use parametrized queries. — Andy Lester
– Andy Lester, Commented Sep 17, 2012 at 2:07

John Woo · Accepted Answer · 2012-09-17 00:45:29Z

1

You have to use == or === in your if condition

if ($op == 'LESS THAN')
{
  // code here
}
elseif ($op == 'GREATER THAN')
{
  // code here
}
// .......

answered Sep 17, 2012 at 0:45

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kriz Over a year ago

Hahahaa...., Finding a small problem can sometimes be difficult. Thank you very much John Woo. I felt like a fool after seeing your response. Is not like I don't know anything about the operator. I don't know what was happening to me. Thank you once again

John Woo Over a year ago

@Kriz don't call yourself a fool, human as we are, we do always made mistakes :)

Ross Smith II · Accepted Answer · 2012-09-17 00:46:19Z

1

You're using an assignment operator (=) where you want the equality operator (==), so your code should read:

        if ($op=='LESS THAN') {
    $query = "SELECT * FROM tbl_reservoir WHERE res_vol < '$vol'";
} elseif ($op=='GREATER THAN') {
        $query = "SELECT * FROM tbl_reservoir WHERE res_vol > '$vol'";
} elseif ($op=='EQUAL') {
     $query = "SELECT * FROM tbl_reservoir WHERE res_vol = '$vol'";
}

but, you could simplify this to:

static $map = array('LESS THAN' => '<', 'GREATER THAN' => '>', 'EQUAL' => '=');
if (!isset($map[$op])) {
    throw new Exception(sprintf("Unexpected operator '%s', $op));
}
$query = sprintf("SELECT * FROM tbl_reservoir WHERE res_vol %s '$vol'", $map[$op]);

answered Sep 17, 2012 at 0:46

Ross Smith II

12.2k1 gold badge41 silver badges46 bronze badges

1 Comment

Kriz Over a year ago

I have really been a fool Ross. Thank you very much

Collectives™ on Stack Overflow

Querying MySQL database using PHP (if statement)

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related