Re: [PHP] Displaying MySQL results on runtime



On Wed, September 27, 2006 11:25 am, Mário Gamito wrote:
I have this code to create a database and a few tables.

Is there a way to display the MySQL actions at runtime, i. e., display
the MySQL commands while they are being executed ?

If you happened to have each SQL statement in an array, you could just
echo them as you go...

Another option would be to use backticks and cat the file into a mysql
monitor shell, I guess, and then you'd see the stuff it prints out.

If the commands are static, and don't contain ';' in the data, you
could read in the file, $statements = explode(';', $sql); and then
you'd have the aforementioned array.

--
Like Music?
http://l-i-e.com/artists.htm
.



Relevant Pages

  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: [PHP] Passwords suddenly not working
    ... Dave M G wrote: ... You may also want to see if any MySQL errors are being generated. ... You also may want to display $query before you execute it to see what, exactly, is being executed. ... If I run the SQL code by itself at an SQL command prompt, I get results back, so I don't think the SQL is failing. ...
    (php.general)
  • Re: How to upload form data containing special characters correctly?
    ... See the MySQL doc and comp.databases.mysql newsgroup for more info on mysql topics. ... Well, I've been hearing for a while UTF-8 is the best for all that stuff, so tables and DB's are all in utf8_general_ci ... addslashesis a PHP construct which escapes certain characters. ... I'll rather use OpenOffice with MyODBC to edit the data when needed and use a report to display it. ...
    (comp.lang.php)
  • Re: Converting from MySQL commands to Oracle: HELP!
    ... > It's a relatively simple app, with a restricted set of mysql commands ... The MySQL DB is being replaced with an Oracle DB ... Most of the database code out there is for the ...
    (comp.lang.php)
  • Re: Converting from MySQL commands to Oracle: HELP!
    ... with a restricted set of mysql commands ... The MySQL DB is being replaced with an Oracle DB ...
    (comp.lang.php)