[Frens]

Ok Now working fine… there was a error somewhere…..

[Frens]

Hi

sample

[code]

$week_nummer 1= 1;
$week_nummer2= 2;

$query .= "test = " . $week_nummer1." - " .$week_nummer2. ",";
[/code]

In record test -2
must 1-2

Regards

[Frens]

Hi

samole

[code]

$week_nummer = 1;
$week_nummer2= 2;

$query .= "test = " . $week_nummer1." - " .$week_nummer2. ",";
[/code]

In record test -2
must 1-2

Regards

[Frens]

Thanks Ally ,solved it all at this way

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

• This reply was modified 10 years, 7 months ago by Frens.

[Frens]

You can try this one , with explanation:

http://stefangabos.ro/jquery/zebra-datepicker/

normally the datatype is date (only date) or datetime

and read this:

var from select

[Frens]

Find out. must a comma after $longitude})

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

[Frens]

It must like:

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

or

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

But got error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax

I dont now how to make a better syntax for the $query ??

• This reply was modified 10 years, 7 months ago by Frens.

[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 10 years, 7 months ago by Frens.

[Frens]

Thank Ally,,works fine now !

[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;………….

[Frens]

Thanks!

[Frens]

Hi

For the database dateformat must only yyyy-mm-dd format if i am right

sample

<select class=”quform-tooltip” id=”date” name=”date” >
<option value=””>choose</option>
<option value=” 2014-11-11″> 2014-11-11</option>
<option value=” 2014-11-14″> 2014-11-14</option>
</select>

In the email template i wil the european dateformaat dd-mm-yyyy

<?php
$date = $form->getValue(‘date’);
if ($date != ”) {
$date = date(‘d-F-Y’, strtotime($date));
}
echo $date;
?>
So i put the code above in the top of the email template (first table row)

But now in the email template got 2 dates of course ;
01-November-2014 (make with the function above
and;
2014-11-01 (from the form)

Is there a solution for this? only need the format 01-November-2014

Regards and thanks

[Frens]

Thanks Ally ,,,works fine !

[Frens]

Thanks Ally

For me not working e-mail is ok , but in the database record is empthy

Can you give me the exxact place where to ad the code in the process.php

[Frens]

Hi Thanks for comment, but is not wath i mean )sorry for my poor English’

I want a conditional comment from the input in the form, as a new result to the
MAIL TEMPLATE and the DATABASE

form weeknumber sample;

<select class=”quform-tooltip” id=”date” name=”date” >
<option value=””>choose</option>
<option value=” 2014-11-11″> 2014-11-11</option>
<option value=” 2014-11-14″> 2014-11-14</option>
</select>

sample ;
$date = $date ) (input from the form above)

<?php if date = { 2014-10-07
$week_num = date(‘W’, strtotime($a));
}
result is 41
?>

i wanth the result (41) as a new line in the email template (as Name, email eg) and to the database as a new record weeknumber
The conditional comment and date-weeknumber is just a sample not my problem. only dont now where to place it…in the process.php and how?

regards

[Author]

Posts