melbourne1815 Posted February 1, 2012 Report Posted February 1, 2012 hi i need help on posting multiple inputs in a single button...while using mysql_fetch_array here is my codes: <? $re6 = mysql_query('select username from users where course = "BSIT" and yearlevel = "FOURTH"'); ?> <br /> <h1>Post Grade</h1> <h1>IT, Fourth Year</h1> <br />Please fill the following form to send The Grade<br /> <? $n = 0; while($row = mysql_fetch_row($re6)) { echo'<form action="grade_post.php" method="post">'; echo'Recipient<span class="small">(Username)</span><input type="text" value="'.$row['username'].'" readonly="readonly" id="recip" name="recip[' . $n . ']" />'; echo'Subject<input type="text" value="'.htmlentities($otitle, ENT_QUOTES, 'UTF-8').'" id="title" name="title[' . $n . ']" />'; echo'<input type="hidden" value="FOURTH" id="year" name="year[' . $n . ']" />'; echo'<input type="hidden" value="FIRST" id="sem" name="sem[' . $n . ']" />'; echo'Grade<input type="text" id="message" name="message[' . $n . ']" ><br />'; ++$n; } ?> i get all my recipients in every input type, but when i tried to post it in my database not all of them are posted rather only one of them are posted in my database ...what i want to happen is that all of my recipients in every input type will be posted in my database with different ids'...help pls... Quote
mopardude Posted February 20, 2012 Report Posted February 20, 2012 Out of curiosity is the only recorded that is posted that last record you inputed? From what you have posted here your variables that hold the field data is over writing each other because your using the same variables for each record. Quote
jbwebdesign Posted March 18, 2012 Report Posted March 18, 2012 hi i need help on posting multiple inputs in a single button...while using mysql_fetch_array here is my codes: <? $re6 = mysql_query('select username from users where course = "BSIT" and yearlevel = "FOURTH"'); ?> <br /> <h1>Post Grade</h1> <h1>IT, Fourth Year</h1> <br />Please fill the following form to send The Grade<br /> <? $n = 0; while($row = mysql_fetch_row($re6)) { echo'<form action="grade_post.php" method="post">'; echo'Recipient<span class="small">(Username)</span><input type="text" value="'.$row['username'].'" readonly="readonly" id="recip" name="recip[' . $n . ']" />'; echo'Subject<input type="text" value="'.htmlentities($otitle, ENT_QUOTES, 'UTF-8').'" id="title" name="title[' . $n . ']" />'; echo'<input type="hidden" value="FOURTH" id="year" name="year[' . $n . ']" />'; echo'<input type="hidden" value="FIRST" id="sem" name="sem[' . $n . ']" />'; echo'Grade<input type="text" id="message" name="message[' . $n . ']" ><br />'; ++$n; } ?> i get all my recipients in every input type, but when i tried to post it in my database not all of them are posted rather only one of them are posted in my database ...what i want to happen is that all of my recipients in every input type will be posted in my database with different ids'...help pls... What does your grade_post.php file look like?? What does your database structure look like? i'm not sure if this helps but you can try doing something like here: <?php //first build the query.... $re6 = mysql_query('select username from users where course = "BSIT" and yearlevel = "FOURTH"') or die(mysql_error()); //lets create the html form tag outside of our loop. ?> <form action="grade_post.php" method="post"> <?php while($row = mysql_fetch_array($re6, MYSQL_ASSOC)) { //this is where our loop begins.... //we only want to loop our input fields with the different usernames as values inside them. ?> <input type="text" name="recip[]" value="<?php echo $row['username']; ?>"><br> <?php } ?> <input type="submit" value="Submit Form!"> </form> <?php //the code above should output all your users in a seperate input. (i'm not sure why you would need this done but if that's what you want, then this is how you would do it.) //if you explain a bit more in detail on what you are looking to do then maybe i can help you solve this problem. ?> Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.