So i have about 300 students that all need to be placed in option statements (html). I need these names then put into a drop down menu for students to choose.

The issue is, i have maybe 30 questions, which means that i have a hell of a long script. Is there anyway using mysql to import these names whenever i need them into a drop down menu?

Also i plan to get the script to submit to a mysql database, what is the easiest way to do that and will allow me to extract the choices the easiest?

And last thing i need to know how from those names i submit into the database to use them also in my verification script. I would liek to generate random passwords for all the users then have them printed out and handed out to the students for them to login. How can i get that done? Also how do i hook it up to a login page?

Originally Posted by nav33n

If you have these 300 students info in a table, then just fetch their info by using loops. Say, for example, you have student table with their info. You get the dropdown by doing something like this.

Help with Code Tags

php Syntax (Toggle Plain Text)

<?php
$conn=mysql_connect($host,$username,$pass);
mysql_select_db($dbname);
$query="select student_name from student";
$result=mysql_query($query);
echo "<select name=\"student_name\">";
while($row=mysql_fetch_array($result)){
   echo "<option value=".$row['student_name'].">".$row['student_name']."</option>";    
}
....

<?php $conn=mysql_connect($host,$username,$pass); mysql_select_db($dbname); $query="select student_name from student"; $result=mysql_query($query); echo "<select name=\"student_name\">"; while($row=mysql_fetch_array($result)){ echo "<option value=".$row['student_name'].">".$row['student_name']."</option>"; } ....

This will put all the student names in the select box.


30 questions ? What 30 questions ? About your second question, yes, you can write a function and whenever you need values from the table, you can call that function.



If you want to submit the user's input to a table, you do it using an insert statement. When the user submits the page, the form variables are accessed as $_POST['variable_name'] or $_GET['variable_name'] depending upon the method you want.



You will find a lot of scripts on the net to generate random password. If you want a simplest random password generator, have an array of alphanumerics. (a-z A-Z 0-9). Generate a random number and fetch that array element.

Cheers,
Nav