PHP Classes

File: sample_logfile.txt

Recommend this page to a friend!
  Classes of Carlos Falo Hervás   mysql_db   sample_logfile.txt   Download  
File: sample_logfile.txt
Role: Sample output
Content type: text/plain
Description: An example of log data generated by the classes
Class: mysql_db
MySQL Database access & control classes
Author: By
Last change:
Date: 23 years ago
Size: 5,455 bytes
 

Contents

Class file image Download
EXAMPLE LOG INFORMATION FROM A REAL WEB APPLICATION USING adv. mysql_db ---------------------- SAMPLE LOGFILE STARTS HERE ------------------------------------- 13/01/2001 - 18:24:51 ===== SESSION STARTED BY /portada.php3 ===== 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_active_sessions got 1 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_active_sessions,tbl_monedas WHERE tbl_active_sessions.moneda=tbl_monedas.id AND sessionID = '3a60d2c0c545a' got 1 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_monedas order by moneda_e got 14 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=2 got 1 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=3 got 1 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=4 got 1 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=5 got 1 rows 13/01/2001 - 17:24:51 - OPERATION O.K.: Database vinost released 15/01/2001 - 05:48:35 ===== SESSION STARTED BY /portada.php3 ===== 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_active_sessions got 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed DELETE FROM tbl_active_sessions WHERE sessionid = '3a60d2c0c545a' affected 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_active_sessions,tbl_monedas WHERE tbl_active_sessions.moneda=tbl_monedas.id AND sessionID = '3a5b4515224bf' got 0 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed INSERT INTO tbl_active_sessions (sessionid,start,userid) VALUES ('3a5b4515224bf',979552115,'') affected 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_monedas order by moneda_e got 14 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=2 got 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=3 got 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=4 got 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Executed SELECT * FROM tbl_vinos where id=5 got 1 rows 15/01/2001 - 04:48:35 - OPERATION O.K.: Database vinost released 15/01/2001 - 05:48:48 ===== SESSION STARTED BY /vinos/fichavino.php3 ===== 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed SELECT * FROM tbl_active_sessions got 1 rows 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed SELECT * FROM tbl_active_sessions,tbl_monedas WHERE tbl_active_sessions.moneda=tbl_monedas.id AND sessionID = '3a5b4515224bf' got 1 rows 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed SELECT * FROM tbl_monedas order by moneda_e got 14 rows 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed SELECT tbl_vinos.*,tbl_tipos.tipo_e, tbl_denorigen.nombre AS do,tbl_bodegas.nombre as bod,tbl_bodegas.localidad_e,tbl_bodegas.zona_e FROM tbl_denorigen,tbl_tipos,tbl_vinos LEFT JOIN tbl_bodegas ON tbl_vinos.bodega=tbl_bodegas.id WHERE tbl_vinos.tipo=tbl_tipos.id and tbl_denorigen.id=tbl_vinos.denorigen and tbl_vinos.id=3 got 1 rows 15/01/2001 - 04:48:48 - OPERATION FAILED: Executed SELECT anyada from tbl_anyada where id= got 1064 You have an error in your SQL syntax near '' at line 1 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed select tbl_composicion.varuva, tbl_variedades.nombre_e,tbl_composicion.cantidad from tbl_composicion,tbl_variedades where tbl_variedades.id=tbl_composicion.varuva AND vinoid=3 order by cantidad desc got 4 rows 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed SELECT capacidad_e from tbl_capacidades where id=7 got 1 rows 15/01/2001 - 04:48:48 - OPERATION O.K.: Executed SELECT botella_e from tbl_botellas where id=15 got 1 rows 15/01/2001 - 04:48:49 - OPERATION O.K.: Database vinost released 15/01/2001 - 05:49:43 ===== SESSION STARTED BY /variedades/ficha_uva.php3 ===== 15/01/2001 - 04:49:43 - OPERATION O.K.: Executed SELECT * FROM tbl_monedas order by moneda_e got 14 rows 15/01/2001 - 04:49:43 - OPERATION O.K.: Executed SELECT * FROM tbl_variedades WHERE id=47 got 1 rows 15/01/2001 - 04:49:43 - OPERATION O.K.: Database vinost released ---------------------- SAMPLE LOGFILE ENDS HERE ------------------------------------- [ logfile generated by http://www.vinostrum.com web-store ] As you can see this is a heavy db driven website and logfile info is quite useful to find out where your SQL statements fail due to malformed syntax and give you (through log analysis) enough data to build i.e. a search engine most used words, the most viewed database info and so on Each line in the logfile shows the moment of the log operation, the result of the operation, the command executed, the rows affected or number of rows retrieved and in case of error the error number and error description (in the sample logfile lines are wraped for reading improvement) For comodity and page-hit count initialization of mysql_conn->init() states an info line displaying ===== SESSION STARTED BY [name of the page starting the log] ===== and mysql_conn->destroy() function states a "Database [database name] released" info line Carlos Falo Hervás carles@bisinteractive.net http://www.bisinteractive.net C/Manila 62-64 Esc. E Ent. 3ª 08034 Barcelona Spain Phone: +34 9 3 2063652 Fax: +34 9 3 2063689