Skip to main content
hectoro98972169
Participant
August 1, 2020
Question

validar consulta sql

  • August 1, 2020
  • 2 replies
  • 220 views

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?

    This topic has been closed for replies.

    2 replies

    Legend
    August 2, 2020

    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

    }

    Nancy OShea
    Community Expert
    Community Expert
    August 1, 2020

    Don't blame the software.  Answers are contained in your code.

     

    Nancy O'Shea— Product User & Community Expert