On Friday, August 24, 2012 08:53:40 PM Bastien Koert wrote:
> On Fri, Aug 24, 2012 at 8:34 PM, Gary Chambers <[email protected]> wrote:
> > David,
> >
> >> The database gets updated with a record, but all the fields end up being
> >> empty in the db. Can anyone see what's out of whack here? I'd appreciate
> >> the help. http://pastebin.com/y8kcymnN
> >
> > There isn't much context to your request and I don't see how your table is
> > defined. How are you assigning the values to the variables that you are
> > trying to insert into the database? Do you have register_globals
> > enabled?
> >
> > --
> > Gary
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> I think you might have had register_globals turned on in the past.
> Current versions of PHP have that disabled as its a huge security
> hole.
>
> If your page is structured like the code you pasted, you would never
> have access to the values since there is no access to the post array
> to get the values sent from the form.
>
> on your insert page, do you have code like
>
> $image = $_POST['image'];
> $year = $_POST['year'];
> ...
Just did that like Richard had suggested also and I do get the expected
results. I suspect I need to put the same thing in my query correct? like
this:
mysql_query ("INSERT INTO inventory(image, year, make, model,
milage, price)VALUES($_POST['image'], $_POST['year'], $_POST['make'],
$_POST['model'], $_POST['milage'] , $_POST['price'])");
