RE: [PHP] RE: R: [PHP] Get nice variables from POST
Try to use $query = SELECT * FROM user WHERE user_id = $_POST['user_id']; -Original Message- From: Mike Mapsnac [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:40 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] RE: R: [PHP] Get nice variables from POST I try to use quotes in the query and this doesn't work. $query = SELECT * FROM user WHERE user_id = '$_POST['user_id']}'; But you use brackets and it works.. Why do you use brackets ? $query = SELECT * FROM user WHERE user_id = ${_POST['user_id']}; From: Alessandro Vitale [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: R: [PHP] Get nice variables from POST Date: Thu, 11 Mar 2004 17:30:57 +0100 hi, why don't you simple use the $_POST vars? they are already available to you, so why you should copy them? example: function show_function() { $query = SELECT * FROM user WHERE user_id = ${_POST['user_id']}; } at the same time: - you save a lot of time ( you don't need to write code for copying vars ) - you can always identify in your script the variable you are using is the one that comes from POST cheers, alessandro -Messaggio originale- Da: Mike Mapsnac [mailto:[EMAIL PROTECTED] Inviato: gioved 11 marzo 2004 15.51 A: [EMAIL PROTECTED] Oggetto: [PHP] Get nice variables from POST I have about 10 fields in the form. And I get the fields through POST: //Get Variable from the form $username = $_POST['username']; $password = $_POST['password']; $password2 = $_POST['password2']; $email = $_POST['email']; $email2 = $_POST['email2']; $nickname = $_POST['name']; $city = $POST['city']; $state = $_POST['state']; $country = $_POST['country']; $misc = $_POST['misc']; $country = $_POST['country']; It works but it looks ugly. For each variable I have statemet. Is there a way to get the variables in the loop? I'm looking for nice way to get variables from POST? Thanks _ Frustrated with dial-up? Lightning-fast Internet access for as low as $29.95/month. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Get a FREE online computer virus scan from McAfee when you click here. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- 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
Re: [PHP] RE: R: [PHP] Get nice variables from POST
oops. It's much better to use single quotes and entire variable in {} eg .. where user_id = '{$_POST['user_id']}' ... realize - POST variable user_id has no value, so in your code it will be as select * from users where user_id =; as a result - you have wrong sql query. /tom On Fri, 12 Mar 2004 13:40:12 + Mike Mapsnac [EMAIL PROTECTED] wrote: I try to use quotes in the query and this doesn't work. $query = SELECT * FROM user WHERE user_id = '$_POST['user_id']}'; But you use brackets and it works.. Why do you use brackets ? $query = SELECT * FROM user WHERE user_id = ${_POST['user_id']}; From: Alessandro Vitale [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: R: [PHP] Get nice variables from POST Date: Thu, 11 Mar 2004 17:30:57 +0100 hi, why don't you simple use the $_POST vars? they are already available to you, so why you should copy them? example: function show_function() { $query = SELECT * FROM user WHERE user_id = ${_POST['user_id']}; } at the same time: - you save a lot of time ( you don't need to write code for copying vars ) - you can always identify in your script the variable you are using is the one that comes from POST cheers, alessandro -Messaggio originale- Da: Mike Mapsnac [mailto:[EMAIL PROTECTED] Inviato: gioved 11 marzo 2004 15.51 A: [EMAIL PROTECTED] Oggetto: [PHP] Get nice variables from POST I have about 10 fields in the form. And I get the fields through POST: //Get Variable from the form $username = $_POST['username']; $password = $_POST['password']; $password2 = $_POST['password2']; $email = $_POST['email']; $email2 = $_POST['email2']; $nickname = $_POST['name']; $city = $POST['city']; $state = $_POST['state']; $country = $_POST['country']; $misc = $_POST['misc']; $country = $_POST['country']; It works but it looks ugly. For each variable I have statemet. Is there a way to get the variables in the loop? I'm looking for nice way to get variables from POST? Thanks _ Frustrated with dial-up? Lightning-fast Internet access for as low as $29.95/month. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Get a FREE online computer virus scan from McAfee when you click here. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --