php - Codeigniter如何在函数内部的模型页面中回显获取的值

我正在使用codeigniter，我想使用从mysql表获取的信息来测试模型页面中的条件。

我的问题是，如何回显从“ reviews” mysql表获取的值的总数。结果为3-在

这是我在模型页面中的代码

$query = "
    SELECT 3 - COUNT(*) AS value FROM `reviews`
    INNER JOIN users ON user_id = users.uid

    WHERE value = 1 AND user_id = '" . $logged_in_user_via_session . "'
";


$query = $this->db->query($query);

// how to I echo the total number of values fetched from the "reviews" mysql table.
// so I basically want to know if the result is 0 or 1 or 2 so i can continue with additional conditions

提前致谢

最终清洁答案

勾选的答案以及所有其他答案都很好。但是，codeigniter确实允许您将CI_DB_mysqli_result类的Object添加到数字中，如$ records-> num_rows（）-3;中所示。建议将其添加到记录后的变量中，如下所示

$query = "
                    SELECT COUNT(*) AS value FROM `reviews`
                    INNER JOIN users ON user_id = users.uid

                    WHERE value = 1 AND user_id = '" . $logged_in_user_via_session . "'
                    ";

                    $records = $this->db->query($query);

                    $countedRows=$records->num_rows();
                    $countedRows;
                    // subtracting three (3)
                    $total_minus_three = $countedRows - 3;

                    echo $total_minus_three;

最佳答案

$query = "
    SELECT COUNT(*) AS value FROM `reviews`
    INNER JOIN users ON user_id = users.uid

    WHERE value = 1 AND user_id = '" . $logged_in_user_via_session . "'
";

$records = $this->db->query($query);

echo "Total Records ->".$records->num_rows();

to print all records use print_r($records->row_array());

编辑

当我看到您的评论时，您想从结果中减去3。

echo '-3 result is ->'. $records->num_rows() -3 ;

关于php - Codeigniter如何在函数内部的模型页面中回显获取的值，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/46047796/