"Steve Staples" <sstaples@xxxxxxxx> wrote in message news:1298570683.14826.2438.camel@xxxxxxxxxxx > On Thu, 2011-02-24 at 12:52 -0500, Gary wrote: >> "Steve Staples" <sstaples@xxxxxxxx> wrote in message >> news:1298568238.14826.2431.camel@xxxxxxxxxxx >> > On Thu, 2011-02-24 at 11:42 -0500, Gary wrote: >> >> "Steve Staples" <sstaples@xxxxxxxx> wrote in message >> >> news:1298492194.14826.2425.camel@xxxxxxxxxxx >> >> > On Wed, 2011-02-23 at 14:56 -0500, Gary wrote: >> >> >> "Steve Staples" <sstaples@xxxxxxxx> wrote in message >> >> >> news:1298490417.14826.2418.camel@xxxxxxxxxxx >> >> >> > On Wed, 2011-02-23 at 14:17 -0500, Gary wrote: >> >> >> >> "Jim Lucas" <lists@xxxxxxxxx> wrote in message >> >> >> >> news:4D653673.7040604@xxxxxxxxxxxx >> >> >> >> > On 2/23/2011 4:35 AM, Gary wrote: >> >> >> >> >> "Pete Ford" <pete@xxxxxxxxxxxxx> wrote in message >> >> >> >> >> news:62.C1.32612.D49D46D4@xxxxxxxxxxxxxxx >> >> >> >> >>> 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 >> >> >> >> >> > >> > to get back to your other issue you were having, i've created a test >> > page from your code: >> > http://pastebin.com/WCH6HQ4Q >> > >> > basically, remove the submit, change the onchange event for the select, >> > and then add the javascript function. this should work in all >> > browsers >> > (unless of course you have javascript disabled (which was talked about >> > a >> > few weeks/months ago) >> > >> > NOW, for this issue you have today... checkboxes are an array... so you >> > will need to use it as: >> > <input type="checkbox" name="wahtever[]" value="something"> some text >> > >> > notice the [] in the name attribute of the checkbox? >> > >> > Hope that all works... (this is also not a PHP related question... >> > hasn't really been all along, more like HTML and Javascript, but I am >> > glad to help if i can) >> > >> > Steve >> >> >> Steve >> >> As always thank you. >> >> I'm not sure we are on the same page (unless I don't understand your >> answer >> which of course is entirly possible). I have the checkboxes displayed >> using >> this >> >> print "<td><input type=\"checkbox\" name=\"county$i\" >> value=\"$row[name]\"></td>\n"; >> >> I ended up using a submit button which seems to work fine. >> >> I had the results of those checkboxes being displayed on the next page, >> but >> now it does not. >> >> The query is >> >> mysql_select_db($database_assess, $assess_remote); >> $query_county_result = "SELECT * FROM counties WHERE name ='checked'"; >> $county_result = mysql_query($query_county_result, $assess_remote) or >> die(mysql_error()); >> $row_county_result = mysql_fetch_assoc($county_result); >> $totalRows_county_result = mysql_num_rows($county_result); >> >> The script to display it is >> >> if ( !empty($_POST['county'])) >> foreach ( $_POST['county'] AS $id => $name ) >> echo 'You have selected '. " {$name}".'<br />'; >> >> Frustrating how it was working, now it is not. >> >> Thanks again. >> >> Gary >> > > Gary, > > <input type=\"checkbox\" name=\"county$i\" value=\"$row[name]\"> > > the problem is, is that "county" is not an array... it would be: > county01 > county02 > county03... and so on > > so when you do: > > if ( !empty($_POST['county'])) > foreach ( $_POST['county'] AS $id => $name ) > echo 'You have selected '. " {$name}".'<br />' > > there is no $_POST['county'] as they would all be $_POST['county01'] and > so forth > > NOW... if you change the checkboxes to: > <input type=\"checkbox\" name=\"county[$i]\" value=\"$row[name]\"> > > you will have the array of checkboxes called $_POST['county'] > > > to test simply what the post is, on the page that you're submitting to, > echo "<pre>"; > print_r($_POST); > echo "</pre>"; > exit; > > and it will show you all your $_POST variables that you're sending. > > > Good luck, and BOY has this "thread" has gotten huge... since this is > really an HTML issue (the syntax seems to be HTML, and the PHP coding > seems to correct) you can email me off list to continue this if you'd > like, as to not CLOG the list with the HTML issue... (just trying to be > considerate) > > Steve Yes, thank you very much, that seems to have solved it all. Thank you 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
