cvs: docweb /www admin.php

From: Date: Fri, 29 Jul 2005 17:06:13 +0000
Subject: cvs: docweb /www admin.php
Groups: php.doc.web 
Request: Send a blank email to doc-web+get-699@lists.php.net to get a copy of this message
nlopess Fri Jul 29 13:06:13 2005 EDT Modified files: /docweb/www admin.php Log: show the warnings when executing the query to workaround a stupid libsqlite bug http://cvs.php.net/diff.php/docweb/www/admin.php?r1=1.2&r2=1.3&ty=u Index: docweb/www/admin.php diff -u docweb/www/admin.php:1.2 docweb/www/admin.php:1.3 --- docweb/www/admin.php:1.2 Fri Jul 29 08:30:38 2005 +++ docweb/www/admin.php Fri Jul 29 13:06:11 2005 @@ -1,5 +1,5 @@ <?php -/* $Id: admin.php,v 1.2 2005/07/29 12:30:38 nlopess Exp $ */ +/* $Id: admin.php,v 1.3 2005/07/29 17:06:11 nlopess Exp $ */ include '../include/init.inc.php'; require_once '../include/lib_auth.inc.php'; @@ -50,23 +50,27 @@ // execute the sql } else { - $idx = sqlite_open(dirname(__FILE__) . '/../sqlite/' . $_POST['file'], 0666, $error); + $file = dirname(__FILE__) . '/../sqlite/' . $_POST['file']; + $idx = sqlite_open($file, 0666, $error); if (!$idx) { echo "<p>$error</p>"; sql_print_textarea($_POST['command'], $_POST['file']); return; } - $result = @sqlite_query($idx, $_POST['command']); + $result = sqlite_query($idx, $_POST['command']); +echo sqlite_last_error($idx); if (!$result) { echo '<p><strong>There was an error in the query:</strong> ' . sqlite_error_string(sqlite_last_error($idx)) . '</p><p>&nbsp;</p>'; sql_print_textarea($_POST['command'], $_POST['file']); return; } + echo '<p>File size: ' . filesize($file) / 1024 . ' KB</p>'; echo '<p>Affected rows: ' . sqlite_changes($idx) , '</p>'; echo '<pre>' . htmlspecialchars(print_r(sqlite_fetch_all($result), true)) . '</pre>'; sqlite_close($idx); + sql_print_textarea($_POST['command'], $_POST['file']); } }

« previous php.doc.web (#699) next »