How to create if statement on query data in mysqli

Question

i create displaydata but i want condition like below

function display(){
    $get_data   = "SELECT * FROM table";
    $run_data   = mysqli_query($connect, $get_data);
    $check_data = mysqli_fetch_array($run_data);

                if($check_data == 0){
                    echo "No post yet";
                }
                else
                {
                    echo "Display post";
                }
}

the data did not display "no post yet" when the query is none.

did i do wrong ?

thanks in advance.

ignore global $connect , just try mysqli_affected_rows . did not work :( . . — Rzj Hayabusa, Oct 13 '16 at 07:50
try this way `$run_data = mysqli_query($connect,$get_data ); if(mysqli_num_rows($run_data ) >1){ $row = mysqli_fetch_array($result, MYSQLI_BOTH); echo $row['data'];` — Karthi, Oct 13 '16 at 07:53
if its not variable scope issue than chk `echo count($check_data);` — devpro, Oct 13 '16 at 07:55

score 2 · Accepted Answer · answered Oct 13 '16 at 08:02

You could likely use mysqli_num_rows and process accordingly like:

function display(){
    global $connect;

    $sql = "SELECT * FROM table";

    $result = mysqli_query( $connect, $sql );

    if( $result && mysqli_num_rows( $result ) > 0 ){

        while( $rs = mysqli_fetch_array( $result ) ){
            echo $rs['id'],$rs['title'];/*etc*/
        }
        mysqli_free_result( $result );

    } else {
        echo 'No post yet';
    }
}

thanks . it's work :) ... – Rzj Hayabusa Oct 13 '16 at 08:19 — Rzj Hayabusa, Oct 13 '16 at 08:19

score -1 · Answer 2 · answered Oct 13 '16 at 07:59

you can use :-

function display(){
$get_data   = "SELECT * FROM table";
$run_data   = mysqli_query($connect, $get_data);
$check_data = mysqli_fetch_array($run_data);
$count=count($check_data);
            if($count == 0){
                echo "No post yet";
            }
            else
            {
                echo "Display post";
            }

}

or you can use :-

function display(){
$get_data   = "SELECT * FROM table";
$run_data   = mysqli_query($connect, $get_data);
if(mysqli_num_rows($run_data))
{
 while($check_data = mysqli_fetch_array($run_data))
 {
     print_r($check_data);
 }
}
else
{
    echo "No post yet";
}

}

How to create if statement on query data in mysqli

2 Answers2