mysql_num_rows(）期望参数1是count行的资源 - mysql_num_rows() expects parameter 1 to be resource for count row

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

我得到一个错误mysql_num_rows（）期望参数1是资源

这是我的代码

$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;

我也尝试了mysqli编号，但出现了相同的错误

试试这个：

$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;

使用mysqli，参数应该是查询

$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;

编辑：更多详细信息

$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';
}

以下是的正确答案

$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;

mysqli_num_row参数必须是mysqli查询变量，而不是fetch