Mega Code Archive
I can read real internet-pages on my Smartphone, I am now creating
<![CDATA[
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
// $query = "CREATE TABLE `log` (";
// $query .= "`log_id` int NOT NULL auto_increment primary key,";
// $query .= "`log_lang` varchar(10) NOT NULL default '',";
// $query .= "`log_ip` varchar(20) NOT NULL default '',";
// $query .= "`log_sessionid` varchar(32) NOT NULL default '',";
// $query .= "`log_browser` varchar(100) NOT NULL default '',";
// $query .= "`log_userid` int NOT NULL default 0,";
// $query .= "`log_datetime` datetime NOT NULL default '0000-00-00 00:00:00', ";
// $query .= "`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);
}
?>
]]>