well this sql :
select * from database where this='$foo' and that='$bar';
should become :
select * from database where this='' and that='';
after you substitute the variables in.
This looks like a valid sql to me, unless the database is set up to
_dis_allow zero length strings... I'd suggest looking at the two database
schemas to see if they're exactly to same
-----Original Message-----
From: Gerard Samuel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 11:30 AM
To: PHP
Subject: Re: [PHP] PHP new super globals or something else??
Actually, no. $foo and $bar are controls to let the script know which
threads (its a forum script) to follow.
This merely an example.
Im not really looking for a fix for the script, thats a no brainer, but
an explanation as to why the script is not behaving as it is supposed to be
with register_globals set to off.
If its going to run on my box, it would be nice if it ran on everyone
elses to.
Lars Torben Wilson wrote:
>On Tue, 2002-05-28 at 18:05, Gerard Samuel wrote:
>
>
>>Its a fairly long script but this is a basic rundown of the mechanics.
>>
>>some_page.php
>>-----------------------------
>><?php
>>/* user is sent here from another page, grab foo and bar from the url */
>>$foo = $_GET['foo'];
>>$bar = $_GET['bar'];
>>
>>select * from database where this='$foo' and that='$bar';
>>$result = mysql_query(....);
>>if ($result === false)
>>{
>> trigger_error(...); // <- this is where it breaks for the other guy
>>but not for me...
>>}
>>
>>if (isset($_POST['submit']))
>>{
>> insert into database (col1, col2) values ('$foo', '$bar');
>>}
>>else
>>{
>> echo '<form action="some_page.php" method="post">';
>>
>>
> ^^^^
>
>You're POSTing the variables back to the form. Change your method
>to get and you should be fine.
>
>
>
>> echo '<input type="hidden" name="foo" value="' . $foo . '">';
>> echo '<input type="hidden" name="bar" value="' . $bar . '">';
>> echo '<input type="submit" name="submit" value="Submit">';
>>}
>>?>
>>
>>Now as it stands, initially it would work fine, but when the form is
>>submitted, it would break, because 'foo' and 'bar' are in $_POST.
>>For some reason, this is working on my boxes with register_globals set
>>to off.
>>
>>Martin Towell wrote:
>>
>>
>>
>>>code snippets would be good, if possible
>>>
>>>-----Original Message-----
>>>From: Gerard Samuel [mailto:[EMAIL PROTECTED]]
>>>Sent: Wednesday, May 29, 2002 10:46 AM
>>>To: PHP
>>>Subject: [PHP] PHP new super globals or something else??
>>>
>>>
>>>I hope this makes sense to someone....
>>>
>>>Im converting a script over to work with 4.1.x +.
>>>Im running php 4.1.2 on FreeBSD/Apache and I have 4.2.0 on
w2k/IIS/Apache.
>>>I sent the script to a friend of mine who is running w2k/Apache with
4.2.0.
>>>He told me that the script isn't working for him but it was for me.
>>>Upon closer inspection, I found out why it wasn't working for him, but
>>>Im wondering why it is for me.
>>>I have register global turned off on both machines.
>>>In the initial load of the page, I used $_GET to grab some variables
>>>
>>>
>>>from the url and pass it to hidden fields in the form.
>>
>>
>>>$_GET['foo']
>>>$_GET['bar']
>>>Then the form is submitted to itself to insert into the database. When
>>>its submitted, the script is looking for 'foo' and 'bar', but
>>>they are now in the $_POST, and this is where it breaks for the other
>>>guy, because the script is still looking for 'foo' and 'bar' in
>>>the $_GET array. So in my case, it seems as if php is not behaving as
>>>it should.
>>>So, my question is, are there any other php options that I should be
>>>looking for/using, to use the new variables in its strictest form.
>>>
>>>If you need more info, dont hesitate to ask.
>>>Thanks
>>>
>>>
>>>
>>>
>>>
>>>
>>--
>>Gerard Samuel
>>http://www.trini0.org:81/
>>http://dev.trini0.org:81/
>>http://www.myphpnuke.com
>>
>>
>>
>>
>>--
>>PHP General Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>>
--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/
http://www.myphpnuke.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
