Silent Dismissal

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====SQL=====
Create the SQL as a text variable, using in-line variable where required:
  $sql = 'SELECT field FROM table WHERE 1';
=====DELETE or UPDATE===== 
<code php>
if ($mysqli->query($sql) === false) {
	$log = $_SERVER['PHP_SELF'].' SQL ERROR: '.$mysqli->error.'  ** SQL: '.$sql;
	f_log($log);
} else {
	$rows = $mysqli->affected_rows;
}
</code>
=====INSERT=====
<code php>
if ($mysqli->query($sql) === false) {
	$log = $_SERVER['PHP_SELF'].' SQL ERROR: '.$mysqli->error.'  ** SQL: '.$sql;
	f_log($log);
} else {
	$newkey=$mysqli->insert_id;
}
</code>
=====SELECT=====
<code php>
if (($result = $mysqli->query($sql)) === false) {
	$errmsg .= '<p class=err><b>TRX DESC:</b> ' . $mysqli->error . '</p><p>' . $sql . '</p>';
	echo $errmsg;
} elseif (!$result->num_rows) {
	//no records
} else {
	$row = $result->fetch_assoc();
	while ($row = $result->fetch_assoc()) {
		
	}
}
</code>
Bootstrap Version
<code php>
if (($result = $mysqli->query($sql)) === false) {
	$log = $_SERVER['PHP_SELF'].' SQL ERROR: '.$mysqli->error.'  ** SQL: '.$sql;
	f_log($log);
} elseif (!$result->num_rows) {
	//no records
} else {
	$row = $result->fetch_assoc();
	while ($row = $result->fetch_assoc()) {
		
	}
}
</code>

OLD Version
<code php>
if (($result = mysql_query($sql)) == FALSE) {	
	$error = mysql_error();
} elseif (!mysql_num_rows($result)) {
			
} else {
	//$id = mysql_insert_id();
	while ($row = mysql_fetch_assoc($result)) {
	}
}
</code>
=====TRANSACTION=====
<code php>
try {
	$mysqli->autocommit(false); //start the transaction
	
	//first SQL 		
	$sql = 'UPDATE tablename SET ' .
	'field=1 ' .
	'WHERE field=' . $target;
	
	if ($mysqli->query($sql) === false) {
		throw new Exception($mysqli->error);
	}
	
	//second SQL 		
	$sql = 'UPDATE tablename SET ' .
	'field=2 ' .
	'WHERE field=' . $target;
	
	if ($mysqli->query($sql) === false) {
		throw new Exception($mysqli->error);
	}
	
	//catch any errors
} catch (Exception $e) {
	//roll back the changes thus far
	$mysqli->rollback();
	//optionally terminate the page
	die($e);
}
//no errors found, so turn on autocommit which will also process all of the pending transactions
$mysqli->autocommit(TRUE);
</code>

=====TRANSACTION (Alternate)=====
<code php>
//first SQL 		
$sql1 = 'UPDATE tablename SET ' .
'field=4 ' .
'WHERE field=' . $target;

$sql2 = 'UPDATE tablename SET ' .
'field=5 ' .
'WHERE field=' . $target;

try {
      $mysqli->autocommit(false); //start the transaction
  
      if ($mysqli->query($sql1) === false) {
           throw new Exception('<p class=err>TRX1: ' . $mysqli->error . '</p><p>' . $sql . '</p>');
      }
      
      //a select transaction
      if (($result = $mysqli->query($sql)) === false) {
           throw new Exception('<p class=err>TRX2: ' . $mysqli->error . '</p><p>' . $sql . '</p>');
      }

//catch any errors
} catch (Exception $e) {
     //roll back the changes thus far
     $mysqli->rollback();
     //optionally terminate the page
     die($e);
}
//no errors found, so turn on autocommit which will also process all of the pending transactions
$mysqli->autocommit(TRUE);
</code>
=====Copy Record=====
newtable also has an idfield that is auto-increment, primary key but different from the idfield of the original table
<code php>
//copy the record to the deleted load table
$sql = 'INSERT INTO newtable (`idfield`, `field2`, `field3`) '.
'SELECT `idfield`, `field2`, `field3` FROM originaltable WHERE idfield = '.$target;
</code>
===== Table Format =====
<code php>
$page = '<div class="row">'.chr(13).
'<div class="col-sm-9 col-sm-offset-1"></div>'.chr(13).
'<div class="col-sm-2"><a href="admin_account_edit.php?id=0"><button class="btn btn-success btn-block">New</button></a></div>'.chr(13).
'</div>'.chr(13).
'<br />';

$page .= '<table name="A" id="A" class="table table-striped table-bordered table-hover table-responsive sortable" style="width: 100%">'.chr(13).
	'<thead>'.chr(13).
	'<tr>'.chr(13).
	'<th class="sorttable_nosort"></th>'.chr(13).
	'<th></th>'.chr(13).
	'<th></th>'.chr(13).
	'</tr>'.chr(13).
	'</thead>'.chr(13).
	'<tbody>'.chr(13);
	while ($row = $result->fetch_assoc()) {
		$page .= '<tr>'.chr(13).
		'<td sorttable_customkey="2">'.$row[''].'</td>' . chr(13) .
		'<td>'.$row[''].'</td>' . chr(13) .
		'<td>'.$row[''].'</td>' . chr(13) .
		'</tr>' . chr(13) . chr(13);
	}
$page .= '</tbody>' . chr(13) .
'</table>' . chr(13) . chr(13);
</code>