how to use conditional operator in php

Question

$sql  = "INSERT INTO `employee_master` ( em_first_name, em_middle_name, em_last_name, em_gender, em_DOB, em_DOJ, em_mobile_no, em_alternate_mobile_no, em_landline_no, em_permanent_address, em_corresponding_address, em_email_id ) VALUES(

        '" . $params["txtFirstName"] . "',
        '" . $params["txtMiddleName"] . "', 
        '" . $params["txtLastName"] . "',

        '" . $params["selGender"] . "',
        '" . $params["txtDOB"] . "',
        '" . $params["txtDOJ"] . "',
        '" . $params["txtMobileNo"] . "',
        '" . $params["txtAlternateMobileNo"] . "',
        '" . $params["txtLandlineNo"] . "',
        '" . $params["txtPermanentAddressTextarea"] . "',
        '" . $params["txtCorrespondingAddressTextarea"] . "',
        '" . $params["txtEmailID"] . "');  ";
    //echo $sql;
    echo $result = mysqli_query($this->conn, $sql) or die("Error to insert User.");

}

($('#selReligion').val() == -1 ) ? " " : $('#selReligion').val(),

Here I want to use Conditional operator. Right Now..if selGender is null that It inserts -1 but i want to insert 0 or null

You code is at risk of [SQL Injection](https://stackoverflow.com/questions/601300/what-is-sql-injection). You should use prepared statements with parameters. — litelite, Sep 01 '17 at 12:20
You're already using an API that supports **prepared statements** with bounded variable input, you should utilize parameterized queries with placeholders (prepared statements) to protect your database against [SQL-injection](http://stackoverflow.com/q/60174/)! Get started with [`mysqli::prepare()`](http://php.net/mysqli.prepare) and [`mysqli_stmt::bind_param()`](http://php.net/mysqli-stmt.bind-param). — Qirel, Sep 01 '17 at 12:21
It's not clear exactly what you're asking. Do you want to insert `-1`, `0` or `null`? — Qirel, Sep 01 '17 at 12:23
And what have you tried? Have you looked up what the conditional operator is? When you actually use it, what doesn't work? — David, Sep 01 '17 at 12:25
If the option is not selected -1 will be inserted but I don't want to insert -1. I want to insert null — J doe, Sep 01 '17 at 12:27
@Karthik: Then why not just make that value empty in the HTML? — David, Sep 01 '17 at 12:28
But I am Validating selGender If it is -1 that should alert. — J doe, Sep 01 '17 at 12:30
Please do not dump code in comments. Modify your original post to add any new information. — Jay Blanchard, Sep 01 '17 at 12:34
@Karthik: The conditional operator you've edited into the question is JavaScript, not PHP. It's not clear at all what the actual problem is here or what specifically you're trying to accomplish. — David, Sep 01 '17 at 12:50

Code Lღver · Answer 1 · 2017-09-01T12:41:21.537

0

Use the ternary operator. It will insert the 0 instead of -1, as you require. if $params["selGender"] will not be null then it will insert the value otherwise 0. and you can change the condition in that according to your need.

'" . (!empty($params["selGender"])) ? $params["selGender"] : 0 . "',

EDITED:

Other way to achieve this is:

Take a variable:

$selGender = '0';
if(!empty($params["selGender"]))
   $selGender = $params["selGender"];

And then use this variable:

'" . $selGender . "',

edited Sep 01 '17 at 12:41

answered Sep 01 '17 at 12:22

Code Lღver

15,573
16
56
75

5

"Try this" does not make for good answers. You should explain *how* and *why* this solves their problem. I recommend reading, "[How do I write a good answer?"](http://stackoverflow.com/help/how-to-answer) – John Conde Sep 01 '17 at 12:24
The above code is working. any other thing Code Lover – J doe Sep 01 '17 at 12:31
@Karthik What other thing do you want to know?? – Code Lღver Sep 01 '17 at 12:33
any other options – J doe Sep 01 '17 at 12:34
($('#selReligion').val() == -1 ) ? " " : $('#selReligion').val(), this is my javascript conditional operator. – J doe Sep 01 '17 at 12:48

how to use conditional operator in php

1 Answers1