function do_cryptdb_sql($cdbh, $q) { global $last_sth, $last_sql, $reccount, $out_message, $SQLq, $SHOW_T; $SQLq = $q; if (!do_multi_sql($q)) { $out_message = "Error: " . $cdbh->error; } else { if ($last_sth && $last_sql) { $SQLq = $last_sql; if (preg_match("/^select|show|explain|desc/i", $last_sql)) { if ($q != $last_sql) { $out_message = "Results of the last select displayed:"; } display_select($last_sth, $last_sql); } else { $reccount = mysql_affected_rows($cryptdbh); $out_message = "Done."; if (preg_match("/^insert|replace/i", $last_sql)) { $out_message .= " Last inserted id=" . get_identity(); } if (preg_match("/^drop|truncate/i", $last_sql)) { do_sql($SHOW_T); } } } } }
function do_sql($q) { global $dbh, $last_sth, $last_sql, $reccount, $out_message, $SQLq; $SQLq = $q; if (!do_multi_sql($q, '', 1)) { $out_message = "Error: " . mysql_error($dbh); } else { if ($last_sth && $last_sql) { $SQLq = $last_sql; if (preg_match("/^select|show|explain/i", $last_sql)) { if ($q != $last_sql) { $out_message = "Results of the last select displayed:"; } display_select($last_sth, $last_sql); } else { $reccount = mysql_affected_rows($dbh); $out_message = "Done."; if (preg_match("/^insert|replace/i", $last_sql)) { $out_message .= " Last inserted id=" . get_identity(); } if (preg_match("/^drop|truncate/i", $last_sql)) { do_sql("show tables"); } } } } }