I can read real internet-pages on my Smartphone, I am now creating a website especially for my Smartphone, because the screensize differs a lot from the PPC or PC,
I am curious if there are people with a SMartphone are visiting my site, so I create a simple function for that which stores visit-information in a MySQL database,
you can use code below as structure for the MySQL log-file
CREATE TABLE `log` (
`log_id` int NOT NULL auto_increment primary key,
`log_lang` varchar(10) NOT NULL default '',
`log_ip` varchar(20) NOT NULL default '',
`log_sessionid` varchar(32) NOT NULL default '',
`log_browser` varchar(100) NOT NULL default '',
`log_userid` int NOT NULL default 0,
`log_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`log_url` varchar(255) NOT NULL default '')
you can use this function in every page, especially when you include it in a global functions file, I use the userid for connection to my usertable,
If you have tips, do not hesitate to respond,
success,
waiting for response . . .
<?
function logPage ()
{
$logDb = mysql_connect ( "localhost" , "" , "" ) or die( "LOG Error : Database connection failed." );
mysql_select_db ( "gsnwb" , $logDb ) or die( "LOG Error : Open database failed." );
$logQry = "INSERT INTO log (log_lang, log_ip, log_sessionid, log_url, log_browser, log_userid, log_datetime) " ;
$logQry .= "VALUES ('" ;
$logQry .= $_SERVER [ "HTTP_ACCEPT_LANGUAGE" ] . "', '" ;
$logQry .= $_SERVER [ "REMOTE_ADDR" ] . "', '" ;
$logQry .= session_id () . "', '" ;
$logQry .= $_SERVER [ "REQUEST_URI" ] . "', '" ;
$logQry .= $_SERVER [ "HTTP_USER_AGENT" ] . "', " ;
if( $_SESSION [ "userid" ] == "" ) $logQry .= 0 . ", '" ; else $logQry .= $_SESSION [ "userid" ] . ", '" ;
$logQry .= date ( "Y" ) . "-" . date ( "m" ) . "-" . date ( "d" ) . " " . date ( "H" ) . ":" . date ( "i" ) . ":" . date ( "s" ) . "')" ;
$result = mysql_query ( $logQry ) or die ( "LOG Error : " . mysql_error () . "<br>" . $logQry );
mysql_close ( $logDb );
}
?>
DB Connection Function with error handling and email failure notices Categories : PHP , MySQL , Errors and Logging , Databases , Errors and Logging bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL , PHP , MySQL , Complete Programs , Databases This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases , MySQL , Complete Programs , PHP , Databases Required form fields that pull from MySQL database Categories : PHP , HTML and PHP , Databases , MySQL GroupIT Engine v1.00rc1
Categories : PHP , Content Management , MySQL , Databases mySQL/PHP/search with multientry
form and table output with colored rows Categories : PHP , Beginner Guides , MySQL , HTML and PHP , Databases Simple function to return the number of days in a time span between 2 given dates. Categories : PHP , Date Time , MySQL , Databases phpAds, a complete banner and ad management system with detailled tracking and stats. Categories : MySQL , Complete Programs , Ecommerce , PHP , Databases Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL , Complete Programs , General SQL , PHP , Databases Invision Forums Latest Threads list Categories : PHP , Miscellaneous , Databases , MySQL [PHP5] aDB PDO LIKE Database Abstraction. Switch easily from one db server to another, strong errors management, manage transactions, queries preparation and more. Categories : PHP , PHP Classes , Databases , MS SQL Server , MySQL free, search engine, indexing, system, information, web,
ftp, http, free, software, cgi, php, MySQL, database, php3,
FreeBSD, Linux, Unix, UdmSearch Categories : MySQL , Complete Programs , PHP , Databases , Search Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases , PHP , MySQL , Complete Programs Full membership authentication system. Categories : Authentication , MySQL , PHP , Databases Example voting script. Lets people enter suggestions and vote for existing ones. Categories : MySQL , PHP , Cookies , Complete Programs , Databases