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?

sounds good. that's what I figured. I know these engines are already suited for this purpose, but doesn't hurt to ask! thanks!

Hi all, Yet another question for the experts here. As in the subject to this thread, I'm interested in finding out how PHP handles concurrent database connections when the script has a write operation in it. like for instance, this code: $sql = "UPDATE table1 field = 'new value' WHERE field = 'old value'"; mysql_query($sql) or die('Update Failed!'); if I have 10 people loading one of my pages at the same time and I'm updating the same database table (with different records for each user) with an update statement, am I risking errors or even corruption because of the write-conflict issue?? It seems to me that PHP would act somewhat like an operating system here and sequence the requests so that doesn't happen. True? thanks so much!

hi xyph, Hey I got it to work. that will be fine for what we're doing. Do you perhaps know if there is a cap on the concurrent connections to a mysql database when using PHP? as in, if the page is loaded 10 times by 10 different people at the same moment, will PHP simply execute the connection requests concurrently and the subsequent queries as well?? Or will it act kind of like threading in an operating system where memory processes changes statuses to "wait" and "execute" depending on their place in line (as the processor sees it)?? thanks so much!!

yes of course. the only 2 issues I see here is the fact that I don't know how to extract the query string out of the URL with PHP in order to use that and make the comparison. that, and of course getting the user (clicker) to the appropriate page so it doesn't error out. wouldn't it? I would think so, as the URL would not be the same at all. actually, the URL minus the query string would be the target page. thanks!

Hi all, I have a unique request from someone that uses unorthodox methods for emailing campaigns in his business. Currently he is using the SendGrid service to send unlimited relays throughout the country. What he's not capable of though is being able to script some PHP such that he can use an identifier (either incrementally or from an algorithmic digest from PHP) in the actual URL to send the user to the page.... (e.g. => mysite.com/brochurepage.php?u=384954) but before rendering the information on the page, redirect the user again to the proper page such as.... (e.g. => mysite.com/brochurepage.php) The desire here is to have PHP read a MYSQL database and compare the q string identifier with the proper record to get the name and phone number of the user that is already stored in the same database. I realize this is odd and certainly not the easiest way to do something like this. Does anyone have any hints for me on how to make this easy? The only thing I can think of that compares to this effort is when forums send algorithmic digests to the email that was registered by the user. And I'm guessing at that point the PHP script verifies the human authenticity of the email click due to the digest match that is found in the database. Am I correct here? Looking for the PHP experts here to guide me in the right direction. thanks so much guys!