Re: PHP/MySQL Reading Database Field Help!
Peter Brawley Wrote:
-------------------------------------------------------
> DId you add a line to see if the query returns any
> rows? What's the result of mysqli_num_rows($conn)
> ?
>
> Check the PHP manual ... mysqli_fetch_field()
> fetches column info, not data---which needs
> mysqli_fetch_row().
I have this:
$sql = "SELECT streamID FROM broadcast WHERE id=1";
if ($result = mysqli_query($conn, $sql)) {
$row = $result->fetch_assoc();
echo "row = ", $row;
37: $row = $result->mysqli_num_rows($conn);
echo "row2 = ", $row;
// $sql = 'SELECT id FROM broadcast WHERE streamID = E0ArubgkL9q2SCrXL';
// $stream = mysqli_query($conn,$sql);
if( !$row) {
$err = mysqli_error( $conn );
logerr( $err );
if( $debug ) echo "Error: $err<br>" };
}
Which returns this:
Connected Successfully
row = Array /usr/local/antmedia/webapps/php/getstreamID.php:37: Fatal Error: Call to undefined function mysqli_num_rows (I show line 37)
Perhaps I should have mentioned I am not a mysql or php programmer. I am a learn as I go kinda guy. I'd much rather struggle a little and if I can't fix my problem, seek help.
Subject
Written By
Posted
Re: PHP/MySQL Reading Database Field Help!
July 23, 2019 12:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.