|
|
|
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 | | | 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 | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | 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 | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | 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 | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | color codes for positive and negative numbers
Categories : PHP, MySQL, Databases, HTML | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Tropicalm Genetree Family (MySQL based family tree)
Categories : PHP, Interfaces, Databases, MySQL, Complete Programs | | | mysql_escape_string
Categories : PHP, MySQL, Databases, Strings | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | Email a user with out exposing email address
Categories : PHP, Databases, MySQL, Email | |
|
|
|
