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] – [INSERT] gregorwiki:sql [2020/01/06 14:34] – [SELECT] gregor
Line 5: Line 5:
 <code php> <code php>
 if ($mysqli->query($sql) === false) { if ($mysqli->query($sql) === false) {
- $errmsg .= '<p class=err>TRX DESC: ' . $mysqli->error . '</p><p>' . $sql . '</p>';+ $errmsg .= '<p class="bg-danger">TRX DESC: ' . $mysqli->error . '</p><p>' . $sql . '</p>';
 } else { } else {
  $rows = $mysqli->affected_rows;  $rows = $mysqli->affected_rows;
Line 35: Line 35:
 <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