Hello.
Are there any GOOD tutorials about MYSQLI Object orientated coding, and procedural.
IE - ONE PAGE that has procedural instructions and DOESNT EVEN BREATHE a sign of object-orientated, and the swapped version.
I prefer Procedural.
I've found tutorials that have both codes in one page - very confusing.. You use 1 line of procedural, and another line of object orientated & of course its causes errors. I want seperate pages/information.
I've been coding for years and now want a new thing added to my site. So I COPY the exact WORKING code i have on a separate script to this new script, and now that same code doesn't work.
my current code is here:-
$link = mysqli_connect('SITE.com', 'blah', 'Blahpasswrd', 'moreblah');
if ($link->connect_errno) {
$GLOBALS["jobs"].="Failed to connect to MySQL: " . $link=>connect_error;
save_logs("XXXXXXXXXV06_JOBSCHECK",$GLOBALS["jobs"]);
exit();
}
$sql = "SELECT * FROM `jobs` WHERE `ID` LIKE '$job%';";
$GLOBALS["jobs"].="\n$sql\n\n";$result = $link->query($sql);
$result = $link->query($sql);
while($row = mysqli_fetch_assoc($result)) {
$text.=print_r($row,true)."\n";
}
the error message im getting is:-
[10-Jun-2023 23:30:43 Pacific/Auckland] PHP Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in PATH.php on line 72
[10-Jun-2023 23:35:03 Pacific/Auckland] PHP Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in PATH.php on line 72
all i want is a list of each line/row of the database that matches.