Re: foreach
Al <[email protected]>
| Newsgroups | gmane.comp.php.database,gmane.comp.php.general |
|---|---|
| Message-ID | <[email protected]> |
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