[time() capturing wrong time]

6 hours ago, requinix said:

You have to know something about where your user lives. With only PHP you can use geolocation on their IP address to get a good approximation. With Javascript you can get their "timezone" (UTC offset) with the Date object, which does not tell you their location.

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.

[time() capturing wrong time]

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.

[time() capturing wrong time]

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.

[Google geolocation]

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.

[Google geolocation]

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.

[Google geolocation]

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

[Google geolocation]

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.

[Google geolocation]

are you still running this consultancy?

 

http://www.barringtondrew.co.uk/

[Google geolocation]

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.

[Google geolocation]

???  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.

[Google geolocation]

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.

 

 

[Google geolocation]

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.

[Google geolocation]

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

[Google geolocation]

6 minutes ago, gw1500se said:

IP address locations are based on the ISP location not the assigned user location.

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

[populate textbox after clicking href URL]

FORGET THAT POST.  i'm getting my threads confused here.

[populate textbox after clicking href URL]

this code is from this page:  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 capture geo data?

[Google geolocation]

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?

[populate textbox after clicking href URL]

is this:

Quote

"https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"

this geolocation library that google offers?  it doesn't look like it.  when godaddy failed me on the geolocation extension implementation I google the issue and found some HTML code that uses the free google apis for that purpose.

[populate textbox after clicking href URL]

hey wonderful!  thanks!  for a guy desperately in need in petrol, you are certainly knowledgeable enough!

[populate textbox after clicking href URL]

what i want is:  https://whatismyipaddress.com/ip

and then of course $col concatenated on the end.  without $col on the end of the URL, the link takes me to:  https://whatismyipaddress.com/ip-lookup

and yes i've tested them.  what i said above happens the same way in the browser too.  e.g. - without $col on the end of the first link, it redirects to the second link.

[populate textbox after clicking href URL]

i don't think i follow you my friend.  the link i'm trying to specify in the <href is not where i'm being sent, like i said before.

[populate textbox after clicking href URL]

what's the purpose of this:

<a href="#nowhere"

am I supposed to copy that into my code literally?

I tried:

<a href="#nowhere" id="anchor">"https://whatismyipaddress.com/ip/" . $col </a>

but i'm getting an -unexpected "- and -unexpected "<" error in eclipse.

[populate textbox after clicking href URL]

another option I supposed is to do:

echo "<td><a href = 'https://whatismyipaddress.com/ip/' . $col target = '_blank'>$col</a></td>";

i tried this and also tried putting $col in '  ' quotes, but i'm sent to the page:  https://whatismyipaddress.com/ip-lookup

[populate textbox after clicking href URL]

I have this code:

echo "<td><a href = 'https://whatismyipaddress.com/ip-lookup' target = '_blank'>$col</a></td>";

the textbox I want to populate on the page has name attribute "LOOKUPADDRESS".  it has no id attribute.  after clicking on the link, is it possible  to fill the textbox with $col?

[for each loop for echoing column data]

no I'm not doing this, but I rarely work with other people.  I am the sole developer for this small business.  but i will keep that in mind.  when you work for entrepreneurs a lot of times the "traditionality" and coding standards sometimes get missed cuz the business owners don't really understand the tech that their using.