Re: Stuffing those damn values into their fields...!
| From: | Jason Davidson | Date: | Mon, 19 Jul 2004 16:36:57 +0000 |
| Subject: | Re: Stuffing those damn values into their fields...! | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-191033@lists.php.net to get a copy of this message | ||
php will evaluate vars in single quotes provided they are double
quoted outside them. The quoting in the query appears valid, i would
suggest debugging the sql firstly. (which i beleive was mentioned
already)
Jason
On Mon, 19 Jul 2004 12:20:33 -0400, Brent Baisley <brent@landover.com> wrote:
> I would try echoing out the $UserDataDump variable to see what your
> query text is. PHP does not parse what's in single quotes, so your
> variables may not be getting substituted with values. Try something
> like this:
>
> $UserDataDump = 'UPDATE MembersData SET Title="'.$Title.'")
> WHERE UserID="'.$_POST[Hidden].'"';
>
> ...or escaping the quotes...
>
> $UserDataDump = "UPDATE MembersData SET Title=\'$Title\')
> WHERE UserID=\'$_POST[Hidden]\'";
>
>
>
> On Jul 19, 2004, at 11:54 AM, Justin Patrin wrote:
>
> > On Mon, 19 Jul 2004 13:22:45 +0100, Harlequin
> > <michael.mason@arraspeople.co.uk> wrote:
> >> OK. So here we have on the submission form:
> >>
> >> <input type="hidden" value="$_SESSION['logname']"
> >> name="Hidden">
> >>
> >
> > Your problem is likely here. What exactly are you doing with this
> > string? echo? print? ?> <? It is surrounded by single or double
> > quotes?
> >
> > Try this:
> > echo '<input type="hidden"
> > value="'.htmlentities($_SESSION['logname']).'"
> > name="Hidden">';
> >
> >> It echoes fine, so I know it's there.
> >>
> >> When I go to the target page it echoes fine there also and doesn't
> >> return an
> >> error. But more strangely, it doesn't perform the update I request:
> >>
> >> $UserDataDump = "UPDATE MembersData SET Title='$Title'...)
> >> WHERE UserID='$_POST[Hidden]'";
> >>
> >> What's missing...? No error, no update...? No caffiene...! Help...!
> >>
> >> Oh - is OK, I have my Nicotine :)
> >>
> >
> >
> > --
> > DB_DataObject_FormBuilder - The database at your fingertips
> > http://pear.php.net/package/DB_DataObject_FormBuilder
> >
> > paperCrane --Justin Patrin--
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> --
> Brent Baisley
> Systems Architect
> Landover Associates, Inc.
> Search & Advisory Services for Advanced Technology Environments
> p: 212.759.6400/800.759.0577
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>