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
wiki:sql [2017/07/06 08:27] – [INSERT] gregorwiki:sql [2024/03/05 13:13] (current) – external edit 127.0.0.1
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>';+ $log $_SERVER['PHP_SELF'].' SQL ERROR: '.$mysqli->error.'  ** SQL: '.$sql
 + f_log($log);
 } else { } else {
  $rows = $mysqli->affected_rows;  $rows = $mysqli->affected_rows;
Line 13: Line 14:
 <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 {
  $newkey=$mysqli->insert_id;  $newkey=$mysqli->insert_id;
Line 35: Line 37:
 <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.1499344053.txt.gz · Last modified: 2024/03/05 12:58 (external edit)