How do I display a MySQL error in PHP for a long query that depends on the user input

Question

In PHP  I am trying to execute a long MySQL query that depends on the user input  However  my query fails with the following message    Query Failed     Actually I have printed this message whenever the query fails  but I am having hard time looking for the reason behind this failure  Unfortunately  I couldn t find it because the error is not specified on the web page  Is there a way to display the error message that caused the failure on the web page   Here s my code    from    Findings    where        if   service    null         from    from      ServiceType Lookup        where   Findings ServiceType ID  ServiceType Lookup ServiceType ID AND ServiceType Name      service       if   keyword    null           where   where     AND       if   keyword    null         where   where    Finding ID LIKE    keyword   OR                      ServiceType ID LIKE    keyword   OR                      Title LIKE    keyword   OR                      RootCause ID LIKE    keyword   OR                      RiskRating ID LIKE    keyword   OR                      Impact ID LIKE    keyword   OR                      Efforts ID LIKE    keyword   OR                      Likelihood ID LIKE    keyword   OR                      Finding LIKE    keyword   OR                      Implication LIKE    keyword   OR                      Recommendation LIKE    keyword   OR                      Report ID LIKE    keyword         query    SELECT Finding ID                   ServiceType ID                   Title                   RootCause ID                   RiskRating ID                   Impact ID                   Efforts ID                   Likelihood ID                   Finding                   Implication                   Recommendation                   Report ID  FROM    from     WHERE      where   echo  wala 2eshiq     this- gt result    this- gt db link- gt query  query   if    this- gt result        printf  Query failed   s n   mysqli connect error         exit      r   mysqli query  this- gt db link   query   if   r    false      printf  error   s n   mysqli errno  this- gt db link

User · Answer

Use below code to print the error code   echo mysqli errno  this- gt db link   Error code will give you better idea about the error  More info can be found at https   www techqura com techqura php post How-to-display-MySQL-error-in-PHP amp pid 8 amp website techqura com

User · Answer

Try something like this    link    new mysqli  this- gt host   this- gt user   this- gt pass   statement    link- gt prepare  sqlStatement                   if   statement                                         this- gt debug mode  query    error     Query Failed lt br  gt      link- gt error                       return false

User · Answer

The suggestions don t work because they are for the standard MySQL driver  not for mysqli    this- gt db link- gt error contains the error if one did occur  Or  mysqli error  this- gt db link    will work

User · Answer

One useful line of code for you would be    sql    Your SQL statement here    result   mysqli query  this- gt db link   sql  or trigger error  Query Failed  SQL   sql - Error    mysqli error  this- gt db link   E USER ERROR     This method is better than die  because you can use it for development AND production  It s the permanent solution

User · Answer

I use the following to turn all error reporting on for MySQLi  mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT      NOTE  don t use this in a production environment

User · Answer

Use function die     or die mysql error

User · Answer

Use this    mysqli query  this- gt db link   query  or die mysqli error  this- gt db link       mysqli query  link  query  returns 0 if there s an error    mysqli error  link  returns a string with the last error message   You can also use this to print the error code   echo mysqli errno  this- gt db link     Take a look here and here

[php] How do I display a MySQL error in PHP for a long query that depends on the user input?

Examples related to php

Examples related to mysql