mysql_num_rows() expects parameter 1 to be resource for count row

Question

i got an error mysql_num_rows() expects parameter 1 to be resource

here's my code

$carikomoditas = $_POST['cari'];
$cariquery=mysqli_query($connect,"
    SELECT * 
    FROM komoditassample
    WHERE id='$carikomoditas'
") or die('Error');

$data = mysqli_fetch_array($cariquery);
$res = mysql_num_rows($data);
echo $res;

I tried the mysqli num too but same error

Answer 1

Try this :

$carikomoditas=$_POST['cari'];
$cariquery=mysqli_query($connect,"select*from komoditassample where id='$carikomoditas'") or die('Error');
$res=mysqli_num_rows($cariquery); // result set

$data=mysqli_fetch_array($cariquery);

echo $res;

Answer 2

use mysqli and the parameter should be the query

$carikomoditas = $_POST['cari'];
$cariquery = mysqli_query($connect, "select * from komoditassample where id='$carikomoditas'") or die('Error');

$data = mysqli_fetch_array($cariquery);
$res  = mysqli_num_rows($cariquery);
echo $res;

Edited: In more detail

$carikomoditas = isset($_POST['cari']) ? $_POST['cari'] : 0;

if (!empty($carikomoditas))
{
    $cariquery  = mysqli_query($connect, "select * from komoditassample where id='$carikomoditas'") or die('Error');

    $total_rows = mysqli_num_rows($cariquery);

    if ($total_rows > 0)
    {
        $data = mysqli_fetch_array($cariquery);
        /*
        Display the retrieved database content here
        */
    }
    else
    {
    echo 'No record found';
    }

}
else
{
echo 'Error: carikomoditas not valid';
}

Answer 3

Here's the right answer

$carikomoditas=$_POST['cari'];
    //echo$carikomoditas;
    $cariquery=mysqli_query($connect,"select*from komoditassample where id='$carikomoditas'") or die('Errorororor');
    $res=mysqli_num_rows($cariquery);
    echo $res;

the mysqli_num_row parameter must be the mysqli query variable not the fetch