mysqli prepared statements select *
- by Victor Dallecio
I've spent this sunday trying to find what is wrong to the following code as it is not counting the rows. Could somebody help me with it? Thanks!
/*check if same IP has visited today*/
if ($stmt = $mysqli->query('SELECT * FROM table WHERE colum1 = ? AND colum2 > DATE_SUB(NOW(), INTERVAL 1 DAY)')) {
$stmt->bind_param('s', $ip);
/* execute query */
$stmt->execute();
/*number of rows */
/*store result when using prepared statements*/
$stmt->store_result();
$row_cnt = $stmt->num_rows;
printf("Result set has %d rows.\n", $row_cnt);
$stmt->close();
}
