User Tools

Site Tools


wiki:sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
wiki:sql [2017/07/06 08:27] – [DELETE or UPDATE] gregorwiki:sql [2020/01/06 16:52] – [DELETE or UPDATE] gregor
Line 5: Line 5:
 <code php> <code php>
 if ($mysqli->query($sql) === false) { if ($mysqli->query($sql) === false) {
- $errmsg .= '<p class="bg-danger">TRX DESC: ' . $mysqli->error . '</p><p>' . $sql . '</p>';+ $log $_SERVER['PHP_SELF'].' SQL ERROR: '.$mysqli->error.'  ** SQL: '.$sql
 + f_log($log);
 } else { } else {
  $rows = $mysqli->affected_rows;  $rows = $mysqli->affected_rows;
Line 35: Line 36:
 <code php> <code php>
 if (($result = $mysqli->query($sql)) === false) { if (($result = $mysqli->query($sql)) === false) {
- $msg .= '<p class="bg-danger"><strong>TRXDESC:</strong> ' . $mysqli->error . '<br /><br />' . $sql . '</p>';+ $log $_SERVER['PHP_SELF'].' SQL ERROR: '.$mysqli->error.'  ** SQL: '.$sql
 + f_log($log);
 } elseif (!$result->num_rows) { } elseif (!$result->num_rows) {
  //no records  //no records
wiki/sql.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1