"Steve Staples" <[email protected]> wrote in message
news:1298492194.14826.2425.camel@webdev01...
> On Wed, 2011-02-23 at 14:56 -0500, Gary wrote:
>> "Steve Staples" <[email protected]> wrote in message
>> news:1298490417.14826.2418.camel@webdev01...
>> > On Wed, 2011-02-23 at 14:17 -0500, Gary wrote:
>> >> "Jim Lucas" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > On 2/23/2011 4:35 AM, Gary wrote:
>> >> >> "Pete Ford" <[email protected]> wrote in message
>> >> >> news:[email protected]...
>> >> >>> This bit?
>> >> >>>
>> >> >>> On 22/02/11 22:06, Gary wrote:
>> >> >>>> for($i=1; $i<=$_POST['counties']; $i++) {
>> >> >>>> if ( isset($_POST["county{$i}"] ) ) {
>> >> >>>
>> >> >>> You loop over $_POST['counties'] and look for $_POST["county$i"]
>> >> >>>
>> >> >>> I suspect that there is no field 'counties' in your form, so the
>> >> >>> server
>> >> >>> is
>> >> >>> complaining about the missing index - seems likely that the
>> >> >>> production
>> >> >>> server
>> >> >>> is not showing the error, but instead just giving up on the page.
>> >> >>>
>> >> >>> I think the IE7/Firefox browser difference is a red herring: it
>> >> >>> wasn't
>> >> >>> actually working in any browser, or the code changed between
>> >> >>> tests.
>> >> >>> Remember, PHP is server side and generates HTML (or whatever).
>> >> >>> Unless
>> >> >>> you
>> >> >>> tell the PHP what browser you are using and write PHP code to take
>> >> >>> account
>> >> >>> of that (not generally recommended) then the server output is the
>> >> >>> same
>> >> >>> regardless of browser.
>> >> >>>
>> >> >>> --
>> >> >>> Peter Ford, Developer phone: 01580 893333 fax:
>> >> >>> 01580
>> >> >>> 893399
>> >> >>> Justcroft International Ltd.
>> >> >>> www.justcroft.com
>> >> >>> Justcroft House, High Street, Staplehurst, Kent TN12 0AH
>> >> >>> United
>> >> >>> Kingdom
>> >> >>> Registered in England and Wales: 2297906
>> >> >>> Registered office: Stag Gates House, 63/64 The Avenue, Southampton
>> >> >>> SO17
>> >> >>> 1XS
>> >> >>
>> >> >>
>> >> >> Pete
>> >> >>
>> >> >> Once again, thank you for your help.
>> >> >>
>> >> >> I was able to get it to work, I did not understand the browser
>> >> >> differences
>> >> >> either, but on my testing server on IE, it worked as I wanted but
>> >> >> not
>> >> >> on
>> >> >> anything else. I chopped out most of the code and ended up with
>> >> >> this:
>> >> >>
>> >> >> if ( isset($_POST['submit']) ) {} else {
>> >> >> print "<form action=\"phpForm3.php\" method=\"POST\">\n";
>> >> >> if ($Recordset1) {
>> >> >> print "<table width=200 border=1>\n";
>> >> >> print "<th> </th>\n";
>> >> >> print "<th> State </th>\n"; //2 fields in Counties table, State and
>> >> >> County
>> >> >> print "<th> County </th>\n";
>> >> >> print "</tr>\n";
>> >> >> //create table
>> >> >> $i = 0;
>> >> >> while ( $row = mysql_fetch_array($Recordset1) ) {
>> >> >> $i++;
>> >> >> print "<tr>\n";
>> >> >> print "<td><input type=\"checkbox\" name=\"county$i\"
>> >> >> value=\"$row[name]\"></td>\n";
>> >> >> echo "<td>{$row['state_id']}</td>\n";
>> >> >> echo "<td>{$row['name']}</td>\n";
>> >> >> echo "</tr>\n";
>> >> >> }//end while
>> >> >> print "</table>\n";
>> >> >> } else {
>> >> >> echo("<P>Error performing query: " .
>> >> >> mysql_error() . "</P>");
>> >> >> }
>> >> >> print "<input type=\"hidden\" name=\"counties\" value=\"$i\"/>\n";
>> >> >> print "<input type=\"submit\" name=\"submit\" value=\"Go\"/>\n";
>> >> >> }
>> >> >> ?>
>> >> >>
>> >> >> Again, thank you.
>> >> >>
>> >> >> Gary
>> >> >>
>> >> >> __________ Information from ESET Smart Security, version of virus
>> >> >> signature database 5899 (20110223) __________
>> >> >>
>> >> >> The message was checked by ESET Smart Security.
>> >> >>
>> >> >> http://www.eset.com
>> >> >>
>> >> >
>> >> > If you would allow me to show you a little easier way of doing this.
>> >> >
>> >> > if ( !isset($_POST['submit']) ) {
>> >> > echo '<form action="phpForm3.php" method="POST">';
>> >> > if ($Recordset1) {
>> >> > echo <<<HEADER
>> >> > <table width=200 border=1>
>> >> > <tr><th> </th><th> State </th><th> County </th></tr>
>> >> > HEADER;
>> >> > while ( $row = mysql_fetch_array($Recordset1) ) {
>> >> > echo <<<ROW
>> >> > <tr>
>> >> > <td><input type="checkbox" name="county[]"
>> >> > value="{$row['name']}"></td>
>> >> > <td>{$row['state_id']}</td>
>> >> > <td>{$row['name']}</td>
>> >> > </tr>
>> >> > ROW;
>> >> > }//end while
>> >> > echo '</table>';
>> >> > } else {
>> >> > echo '<p>Error performing query: '.mysql_error().'</p>';
>> >> > }
>> >> > echo '<input type="submit" name="submit" value="Go" />';
>> >> > }
>> >> >
>> >> > Now, the main thing I want you to see is the line for the country
>> >> > checkbox'es
>> >> >
>> >> > The county[] turns the submitted values into an array. So, in the
>> >> > processing
>> >> > script, you would do this.
>> >> >
>> >> > <?php
>> >> >
>> >> > ...
>> >> >
>> >> > if ( !empty($_POST['county'])
>> >> > foreach ( $_POST['county'] AS $id => $name )
>> >> > echo "{$id} {$name}\n";
>> >> >
>> >> > ...
>> >> > ?>
>> >> >
>> >> > Hope this clears things up for you a little.
>> >> >
>> >> > Enjoy.
>> >> >
>> >> > Jim
>> >>
>> >> In a weird twist, I have/had the script working, but again it is not
>> >> working in FF or Chrome. This is a link to the first page which runs
>> >> you
>> >> through the pages.
>> >>
>> >> I have the submit to trigger upon change so there is no submit button.
>> >> This
>> >> works in IE7. If I add a submit button, it does not work in any of
>> >> them.
>> >>
>> >> I am wondering if this is more a problem with the html.
>> >>
>> >>
>> >> http://www.assessmentappeallawyer.com/forum_state.php
>> >>
>> >> This is the code for the first processing page
>> >>
>> >> if ( !isset($_POST['submit']) ) {
>> >> echo '<form action="forum_delete.php" method="POST">';
>> >> if ($Recordset1) {
>> >> echo <<<HEADER
>> >> <table width=200 border=0>
>> >> <tr><th> </th><th> State </th><th> County </th></tr>
>> >> HEADER;
>> >> while ( $row = mysql_fetch_array($Recordset1) ) {
>> >> echo <<<ROW
>> >> <tr>
>> >> <td><input type="checkbox" name="county[]"
>> >> value="{$row['name']}"></td>
>> >> <td>{$row['state_id']}</td>
>> >> <td>{$row['name']}</td>
>> >> </tr>
>> >> ROW;
>> >> }//end while
>> >> echo '</table>';
>> >> } else {
>> >> echo '<p>Error performing query: '.mysql_error().'</p>';
>> >> }
>> >> echo '<input type="submit" name="submit" value="Select" />';
>> >> }
>> >>
>> >> ?>
>> >>
>> >> ****This is the code for the second processing page.
>> >>
>> >>
>> >> <?php
>> >>
>> >>
>> >> if ( !empty($_POST['county']))
>> >> foreach ( $_POST['county'] AS $id => $name )
>> >> echo 'You have selected '. " {$name}".'<br />';
>> >>
>> >>
>> >>
>> >> $totalRows_county_result_net= "($totalRows_county_result) + (1)";
>> >> echo "[$totalRows_county_result_net]";
>> >> echo "$totalRows_county_result";
>> >> ?>
>> >> </div>
>> >> <!--eo center-->
>> >>
>> >>
>> >> <?php
>> >> $name=$_POST['name'];
>> >> echo 'You have selected'."$name";
>> >>
>> >> ?>
>> >> <?php
>> >> mysql_free_result($county_result);
>> >> ?>
>> >>
>> >> Again, thank you for any input.
>> >>
>> >> Gary
>> >
>> > I think it may have to do with HTML, or the fact that IE is "helping"
>> > you with your coding... where FF and Chrome are usually more
>> > "literal" (yet better IMO). Also, the fact that "submit" has not been
>> > defined.
>> >
>> > try adding:
>> > <input type="submit" name="submit" value="submit" style="display:
>> > none;" />
>> >
>> > This *SHOULD* give you the submit button, but the style is "hidden"
>> > now,
>> > so it shouldn't show, but it will fire off the "submit" action... make
>> > sure it is in between the <form></form> tags though.
>> >
>> > Steve
>> >
>> Steve
>>
>> Thank you for your reply, I had inserted a submit button prior, but it
>> did
>> not work. I tried your suggestions and got the same result. I am not
>> seeing anything in the html that should be causing the hick-up, but given
>> the php is run on the server as Peter pointed out, browser issues with
>> php I
>> have not really encountered before.
>>
>> I can live with a submit button, but living with one that does not
>> work...
>>
>> Thank you for your input, if you see anything else that seems amiss,
>> please
>> let me know.
>>
>> Gary
>>
>
> the <form onchange="submit"> as far as I know, isn't a standard/valid
> html attribute... so I would remove it altogether.
> http://www.w3schools.com/tags/tag_form.asp
>
>
> and try on the <select ... onchange=""> to be
> <select .... onchange="document.forms["Form1"].submit();">
> where Form1 is the id of the form (so add that to the <form...>
> <form id="Form1" ... >
>
> try that... (i haven't been testing... my fault... but I am in the midst
> of work right now to really test it out)
>
> good luck!
>
> Steve
Thank you to everybody that has helped. As it is now, I have the checkboxes
appearing in all browers, but I am unable to pass the "checked" values to
the next page which echo's the choices.
The page that produces the checkboxes is here: (and this works fine)
if ( isset($_POST['submit']) ) { // if form is submitted, process it
print "<form action=\"phpForm3.php\" method=\"POST\">\n";
if ($Recordset1) {
print "<table width=200 border=0>\n";
print "<th> </th>\n";
print "</tr>\n";
//create table
$i = 0;
while ( $row = mysql_fetch_array($Recordset1) ) {
$i++;
print "<tr>\n";
print "<td><input type=\"checkbox\" name=\"county$i\"
value=\"$row[name]\"></td>\n";
/*echo "<td>{$row['state_id']}</td>\n";*/
echo "<td>{$row['name']}</td>\n";
echo "</tr>\n";
}//end while
print "</table>\n";
} else {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
}
print "<input type=\"hidden\" name=\"counties\" value=\"$i\"/>\n";
print "<input type=\"submit\" name=\"submit\" value=\"Go\"/>\n";
}?>
***************
My query on phpForm3.php is
$query_county_result = "SELECT * FROM counties WHERE name = 'checked' ";
Which is to be displayed by
if ( !empty($_POST['county']))
foreach ( $_POST['county'] AS $id => $name )
echo 'You have selected '. " {$name}".'<br />';
I get a blank page and mysql_num_row returns 0
Again, sorry I am not getting this and thank you for all your help.
Gary
__________ Information from ESET Smart Security, version of virus signature
database 5904 (20110224) __________
The message was checked by ESET Smart Security.
http://www.eset.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
