Re: [PHP-DB] Re: foreach

Send the code around line 198, say 170 to 210.

On Apr 5, 2012, at 8:42 PM, Al wrote:

> 
> 
> On 4/5/2012 4:15 PM, Ethan Rosenberg wrote:
>> Dear Lists -
>> 
>> I know I am missing something fundamental - but I have no idea where to start to
>> look.
>> 
>> Here are code snippets:
>> 
>> I have truncated the allowed_fields to make it easier to debug.
>> 
>> $allowed_fields = array( 'Site' =>'POST[Site]', 'MedRec' => '$_POST[MedRec]',
>> 'Fname' => '$_POST[Fname]' );
>> echo "post #1\n";
>> print_r($_POST);
>> 
>> RESPONSE:
>> 
>> post #1
>> Array
>> (
>> [Site] => AA
>> [MedRec] => 10002
>> [Fname] =>
>> [Lname] =>
>> [Phone] =>
>> [Height] =>
>> [welcome_already_seen] => already_seen
>> [next_step] => step10
>> )
>> 
>> 
>> 
>> // $allowed_fields = array("Site", "MedRec", "Fname", "Lname", // previous
>> statement of $allowed_fields
>> // "Phone", "Sex", "Height");
>> 
>> 
>> 
>> Key Site, Value POST[Site]
>> Key MedRec, Value $_POST[MedRec]
>> Key Fname, Value $_POST[Fname]
>> 
>> 
>> 
>> foreach ($allowed_fields as $key => $val) {
>> print "Key $key, Value $val\n";
>> }
>> 
>> 
>> if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
>> {
>> if ($_REQUEST['Sex'] === "0")
>> {
>> $sex = 'Male';
>> }
>> else
>> {
>> $sex = 'Female';
>> }
>> }
>> }
>> echo "Post#2";
>> print_r($_POST);
>> if(empty($allowed_fields))
>> //RESPONSE
>> 
>> Post#2Array
>> (
>> [Site] => AA
>> [MedRec] => 10002
>> [Fname] =>
>> [Lname] =>
>> [Phone] =>
>> [Height] =>
>> [welcome_already_seen] => already_seen
>> [next_step] => step10
>> )
>> 
>> 
>> 
>> {
>> echo "ouch";
>> }
>> 
>> foreach ( $allowed_fields as $key => $val ) //This is line 198
>> {
>> if ( ! empty( $_POST['val'] ) )
>> {
>> print "Key $key, Value $val\n";
>> $cxn = mysqli_connect($host,$user,$password,$db);
>> $value = mysql_real_escape_string( $_POST[$fld] );
>> $query .= " AND $fld = '$_POST[value]' ";
>> echo "#1 $query"; //never echos the query
>> }
>> }
>> 
>> These are the messages I receive on execution of the script:
>> 
>> Notice: Undefined variable: allowed_fields in /var/www/srchrhsptl5.php on line 198
>> Warning: Invalid argument supplied for foreach() in /var/www/srchrhsptl5.php on
>> line 198
>> 
>> Advice and help, please.
>> 
>> Thank you.
>> 
>> Ethan Rosenberg
>> 
> 
> Break down you code into workable segments and test each one individually. If you have a problem with a small segment, ask for help about it specifically.
> 
> Folks don't have time to digest and critique your whole code.
> 
> 
> -- 
> PHP Database 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