how to compare data from mysql database with inline if statement to return true or false

Question

This is my code, the first function. fun.php

function post_exists($post_id){
    global $con;
    $post_id = (int)$post_id;
    return (mysqli_fetch_array(mysqli_query($con, "SELECT COUNT(post_id) FROM home_post WHERE  post_id='$post_id'"), MYSQLI_NUM) != 0) ? true : false;
}

This is the function call in index.php

if(post_exists(23) === true){
    echo "<script>alert('working oo')</script>";
}

function usually return true when the argument is false. what i want is, if the argument is true(which means if the data exist in my database)return true if is false return false .

junkfoodjunkie · Accepted Answer · 2016-10-26 04:07:27Z

1

What you are doing is checking if the array is not equal to 0 - not the actual result inside the array. Change the true/false ternary to this:

return (mysqli_fetch_array(mysqli_query($con, "SELECT COUNT(post_id) FROM home_post WHERE post_id='$post_id'"), MYSQLI_NUM)[0] != 0) ? true : false;

as you can see, we check the first value in the array (using the [0] key after the array is assigned). This kind of syntax, however, is only available in newer versions of PHP, but should be useable in 5.1 and up.

edited Oct 26, 2016 at 4:07

answered Oct 26, 2016 at 3:56

junkfoodjunkie

3,1861 gold badge22 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

how to compare data from mysql database with inline if statement to return true or false

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related