|
|
Posted by VitaminB on 10/31/06 21:47
Thx for all these tips. I will try this tomorrow evening. The "currious
syntax" is from another forum (o.
strawberry wrote:
> 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]
|