|
|
|
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 | | | A template script to provide the ability to get the next or previous n records from a MySQL database. Categories : Databases, PHP, MySQL | | | Password reminder Categories : PHP, PHP Classes, Databases, MySQL, Mail | | | BBS system for easy customization. Utilizes mySQL. Categories : Complete Programs, MySQL, PHP, Databases | | | Broadcast HTML Email Categories : PHP, Email, MySQL, Databases | | | Returns the last row from a select where multiple rows have been selected.
In this case it is used to determine the last number in an AUTO_INCREMENT column. I use it to create "ticket numbers" or anything that needs a unique ID in sequence. Categories : mSQL, MySQL, Databases, PHP | | | MySQL Connection/Query Class Categories : Databases, MySQL, PHP, PHP Classes | | | Phorum, MySQL, Language, UK date format, MySQL UK Date format Categories : PHP, Date Time, Strings, MySQL, Databases | | | How to load a query result into a PHP Array Categories : PHP, Databases, Arrays, MySQL | | | Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.
Categories : PHP, Arrays, Date Time, Databases, MySQL | | | Functions for loading images into a MySQL database and displaying them. Categories : Graphics, HTML and PHP, MySQL, PHP, Databases | | | for each record, do this to the first record, and do that to any subsequent record Categories : PHP, Databases, MySQL, Beginner Guides | | | PHP4 AND MySQL Authentication Categories : PHP, MySQL, Authentication, Databases | |
|
|