• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

validar consulta sql

New Here ,
Jul 31, 2020 Jul 31, 2020

Copy link to clipboard

Copied

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?

Views

156

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 01, 2020 Aug 01, 2020

Copy link to clipboard

Copied

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

 

Nancy O'Shea— Product User, Community Expert & Moderator

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 02, 2020 Aug 02, 2020

Copy link to clipboard

Copied

LATEST

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

}

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines