Ip adres to database

[Frens]

Hi ,

How to store the ip adres in the database…………

$config[‘extra’][‘IP address’] = Quform::getIPAddress();

Thanks for comment

[Frens]

make record in the database

In the process.php

$ip = $_SERVER[‘REMOTE_ADDR’];

and as query
$query .= “ip = ” . $ip . “,”;

but got message

You have an error in your SQL syntax;………….

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[Frens]

Thank Ally,,works fine now !

[Frens]

Hi,

I try the lat and longitude to store in the table

$user_ip = getenv(‘REMOTE_ADDR’);
$geo = unserialize(file_get_contents(“http://www.geoplugin.net/php.gp?ip=$user_ip”));
$latitude = $geo[“geoplugin_latitude”];
$longitude = $geo[“geoplugin_longitude”];
$coords = $geo[‘geoplugin_latitude’] .’, ‘. $geo[‘geoplugin_longitude’];

$query .= “point = ‘” . $coords . “‘,”;

But got this error , someone an idea?
Cannot get geometry object from data you send to the GEOMETRY field

• This reply was modified 9 years, 11 months ago by Frens.

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[Frens]

Thanks Ally ,solved it all at this way

$query.=” point = POINT({$latitude},{$longitude}), “;

• This reply was modified 9 years, 11 months ago by Frens.

[Author]

Posts