PHP Newbie Here

[timlab55]

Before PHP 8 my website was working as expected. After PHP 8 my website had a few minor bugs in it. And since I"m new, I'm wondering if someone from here can help me out. I have the database open 🙂. Now what I would like to do is going into a table and check if the table has any information in it. If it doesn't have any information, to print "No Information Found" and move on to the next coding. If there is information there, please print it in a while loop.

The coding I have is following:

$Query = "Select id from ticketinfo where box1 = '' ";
if($result = mysql_query($Query)) {
if ( mysql_num_rows($result) == 0 ) {
    echo "No Information Found";
}
if($stmt = $mysqli->query("SELECT box1, FROM ticketinfo WHERE username = '$username' ORDER BY drawingdate")){ 
 echo "<table border='1'>
     <tr>
    <th>Box #1</th>
   
     </tr>";

    while ($row = $stmt->fetch_assoc()) {
    echo "<tr>";
    echo '<td align="center">' . $row['box1'] . "</td>";
   
    echo "</tr>";
    }
 }

Thank you for your help in advance.

 

[OldMan]

Do you have control over the PHP ver you are using? If yes I'd just go back to the old version. If you want the upgrade you need to turn error reporting on to see the errors. Here is what to place in your code to do that:
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
Then troubleshoot.

 

[rene7705]

in addition, as your application grows, you might like the flexibility (when it comes to which database server you're using) of ADOdb - Database Abstraction Layer for PHP [ADOdb]

and you'll also need a more robust error routing method than mere output (of HTML!) to your browser.
i know this from time-consuming personal experience.

boot.php / startup.php :

//...

$naDebugAll = true;
global $naDebugAll;
if ($naDebugAll) {
    ini_set('display_errors', 1); // 0 == false, 1 == true
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);

    global $naBypassMainErrorHandler;
    if (!isset($naBypassMainErrorHandler) || $naBypassMainErrorHandler)
        $old_error_handler = set_error_handler ('mainErrorHandler');

    /*
    global $mainErrorLogFilepath; global $mainErrorLogLastWriteFilepath;
    $mainErrorLogFilepath = realpath(dirname(__FILE__)).'/siteLogs/error.'.date('Y-m-d_H.i.s').'.html.log';
    $mainErrorLogLastWriteFilepath = realpath(dirname(__FILE__)).'/siteLogs/error.'.date('Y-m-d_H.i.s').'.lastModified.txt';
    */
}
ini_set ('log_errors', true);
//...

mainErrorHandler() :

NicerApp-WebOS/NicerAppWebOS/functions.php at 07c9b07eb12c9ccea7b6e81cd947d9f2c346cef7 · NicerEnterprises/NicerApp-WebOS

Contribute to NicerEnterprises/NicerApp-WebOS development by creating an account on GitHub.

github.com

also, you might want to take a look at my freely usable (even commercially, MIT-licensed) universal database PHP drivers and logging facilities at :

NicerApp-WebOS/NicerAppWebOS/logic.business at main · NicerEnterprises/NicerApp-WebOS

Contribute to NicerEnterprises/NicerApp-WebOS development by creating an account on GitHub.

github.com

and

NicerApp-WebOS/NicerAppWebOS/logic.databases/generalizedDatabasesAPI-1.0.0 at main · NicerEnterprises/NicerApp-WebOS

Contribute to NicerEnterprises/NicerApp-WebOS development by creating an account on GitHub.

github.com

adodb support will be added in version 6 of my software; (all versions are entirely free to use and modify)

GitHub - NicerEnterprises/NicerApp-WebOS-v6.y.z

Contribute to NicerEnterprises/NicerApp-WebOS-v6.y.z development by creating an account on GitHub.

github.com

and finally, you'll need a different logging mechanism for PHP and JS.
trust only the results that JS sends you and which don't have a useragent that matches the regex /.bot./
but do occasionally view the PHP log as well. it'll tell you what the hackers are up to 😉