validar consulta sql

Forum|Forum|5 years ago
August 1, 2020
返信数 2.
223 ビュー

al intenta validar una consulta con por ejemplo if (!Datos) no detecta cuando no se encontro un registro,

probe con empty . count mysqli_num _rows y tampoco me resolvieron el problema.

puede ser un problema de configuracion del php o dreamweaver?

このトピックへの返信は締め切られました。

O

osgood_

Legend

What exactly are you trying to do? Are you trying to find out IF any records exist when querying your database and IF they don't return a message or do something else?

Something like below where the number of rows are returned from the database query into a variable - $numRows

$conn = new mysqli('localhost' , 'username' , 'password' , 'databaseName');

$sqlQuery = $conn->query("SELECT * FROM tableName WHERE id= '3'") or die($conn->error);
$sqlQuery = $sqlQuery->fetch_assoc();
$numRows = $sqlQuery->num_rows;

If no results are found:

if($numRows == 0) {

Do Something

}

else {

Do Something Else

}