ajetrumpet

no no, I'm not interested in capturing THEIR time, I want to store my own! central daylight time, Chicago IL time Berand, the time is stored in the DB the same way it is listed on the report.

looks like I'm dealing with a paranoid business owner. he changed the password on his hosting acct. I'll get back to you guys when I can get into phpMyAdmin.

I have this: $sql = mysqli_query($conn, "SELECT ip , page , CASE WHEN referrer = '' THEN 'N/A' ELSE referrer END as referrer , DATE_FORMAT(date, '%m/%d/%y') as date , TIME_FORMAT(time, '%T') as time FROM tblTraffic ORDER BY date DESC, time DESC"); most of my traffic report contains the correct times, my time, which is CST in the USA. but some records are off by a lot. Does the time() function capture the time of the actual location from which the visitor is coming from? if so, what could I do to return my timezone for any visitor? w3 schools and php.net don't mention this.

actually no i didn't. i wasn't hired for PHP. nor was i hired for web application work. but microsoft technologies suck, so he asked me what was available in the open source world. small business people don't have a ton of money to spend while they are in the early stages of business, thus he asked if I would learn it to produce some small projects. and now I will develop a mobile app for the same guy. that will be a huge undertaking. i'm really not looking forward to it.

oh and I just read in the news that some of the programming experts out there consider PHP to be a dying language, along with mainframers like cobol and fortran. I seriously doubt that though.

lack of knowledge in PHP only, buddy boy. i never said i did contracts in PHP.

lol, nice! you have yet to attract ONE customer!? you've never sold anything? i don't even have a website and i've done plenty of individual contracts! and you mite as well contact them. they have records for just about everything imaginable.

are you still running this consultancy? http://www.barringtondrew.co.uk/

he's not doing it for that purpose Barand. you should know, u gave me the correct script! he wants to know where his visitors are coming from. i regularly check that report and there are plenty of visits from google's cloud, google's bots, ms's bots and us cellular's company as well, which is our cell phone carrier.

??? why do you say that? my words indicate nothing of the sort. they want it as easy as possible. don't most small business people? they don't have time to figure that crap out, nor do they care to.

this is interesting...facebook shows that my geo location is 2 hours away from me! i'm on a wifi hotspot on my phone and my carrier is us cellular, so this too proves that this whole geo thing is not at all reliable.

the way i have it now, the president of this org. doesn't have to do anything but click on the link in the traffic report to see the ip geolocation information so it is fine the way it is.

good to know. thanks brother. i will stick with the ip lookup website then.

if that is the case, how would one capture the actual user's info? is this even possible?

i found the following code here: https://stackoverflow.com/questions/409999/getting-the-location-from-an-ip-address <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script> contry_code = google.loader.ClientLocation.address.country_code city = google.loader.ClientLocation.address.city region = google.loader.ClientLocation.address.region </script> will this work to get location info?