A simple question I hope. In using the OOPs mysqli protocol how do I get the number of rows returned in a select query such as:
$queryStr = ("SELECT * FROM entry where username='$userin' AND password='$passwordin'");Thanks!
WBR
rouse
0
Junior Poster
Recommended Answers
Jump to Postthis doesn't have error handling, but here is how you do it following your line
$result = $mysqli->query($queryStr); $row_count = $result->num_rows; $result->close();
All 2 Replies
dickersonka
104
Veteran Poster
this doesn't have error handling, but here is how you do it following your line
$result = $mysqli->query($queryStr);
$row_count = $result->num_rows;
$result->close();
rouse
0
Junior Poster
Thanks!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.