|
|
Posted by strawberry on 10/31/06 10:15
Petr Vileta wrote:
> "VitaminB" <hetmar@web.de> píse v diskusním príspevku
> news:1162232099.474267.67990@e3g2000cwe.googlegroups.com...
> > Hi Guys,
> >
> > I try to insert data from a form into a mysql database, but it did not
> > work...
> >
> >
> > <?php
> > print_r($_POST);
> >
> >
> > $link = mysql_connect("aaa", "aaa", "aaa")
> > or die("Could not connect: " . mysql_error());
> > mysql_selectdb("db182527668",$link) or die ("Can\'t use
> > dbserver : " . mysql_error());
> >
> >
> > $Lat = $_POST['Lat'];
> > $Lon = $_POST['Lon'];
> > $Name = $_POST['Name'];
> > $Owner = $_POST['Owner'];
> > $City = $_POST['City'];
> > $Street = $_POST['Street'];
> > $ZIP = $_POST['ZIP'];
> > $Country = $_POST['Country'];
> >
> >
> > $result = mysql_query("INSERT INTO wholocations('id', 'lat',
> > 'lon','description', 'owner', 'city', 'street', 'zip', 'country')
> > VALUES('0',
> > '".$Lat."','".$Lon."','".$Name."' , '".$Owner."' ,'".$City."'
> > ,'".$Street."' ,'".$ZIP."' ,'".$Country."')");
>
> It is curious syntax :-) Try this:
>
> $query = "INSERT INTO wholocations('id', 'lat',
> 'lon','description', 'owner', 'city', 'street', 'zip', 'country')
> VALUES('0', $Lat, $Lon, $Name, $Owner , $City, $Street, $ZIP,
> $Country)";
> $result = mysql_query($query) or die(mysql_error());
>
>
> --
>
> Petr Vileta, Czech republic
> (My server rejects all messages from Yahoo and Hotmail. Send me your mail
> from another non-spammer site please.)
Also, take a look at php's extract() function
Navigation:
[Reply to this message]
|