i have a code that is supposed to get the number of rows in a database that contains the ip address of the current user, so i wrote a mysqli statement that gets every row that contains that ip address and stored it in a variable. When i printed out the variable it printed this:
JavaScript
x
mysqli_result Object
(
[current_field] => 0
[field_count] => 7
[lengths] =>
[num_rows] => 2
[type] => 0
)
how can i access the num_rows
in the object.
here is my code:
JavaScript
<?php
include("../functions/functions.php");
include("./db.php");
global $conn;
$ip = get_ip();
$select = "SELECT * FROM `cart` WHERE `ip_address`= '$ip' ";
$run_check_prod = mysqli_query($conn,$select);
if(mysqli_num_rows($run_check_prod) > 0) {
print_r($run_check_prod);
}
?>
Advertisement
Answer
You can use the below code for getting the value num_rows
in an object with PHP. I implemented the code used in the above code for getting value in the object.
JavaScript
<?php
include("../functions/functions.php");
include("./db.php");
global $conn;
$ip = get_ip();
$select = "SELECT * FROM `cart` WHERE `ip_address`= '$ip' ";
$run_check_prod = mysqli_query($conn,$select);
if(mysqli_num_rows($run_check_prod) > 0) {
//the $run_check_prod is object and num_rows is key
echo $run_check_prod->num_rows;
}
?>