trying to make a survey for school yearbook, need help
 

Hey guys, i just registered here. I have always read posts here but never thought to register.

Anyways, i am looking for some help with this script. 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?



Thanks so much, Dani.

Re: trying to make a survey for school yearbook, need help
 

well i can make one for you please do let me know by email my email is info[at]kmwsoftech.com

Re: trying to make a survey for school yearbook, need help
 

is there no one here that can give me some help with this?

I don't wish to have the program written for me.....

Re: trying to make a survey for school yearbook, need help
 

its a basic php operation, you can learn it by your self..
first is create student table, after that create question table
and in your application you can loop the student in dropdown menu, and you can figure something

Re: trying to make a survey for school yearbook, need help
 

ok so basically i am making a questions table and a name table. Then running code to take that info and export to the survey. Any good places to learn this stuff?

Re: trying to make a survey for school yearbook, need help
 

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.

<?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

Re: trying to make a survey for school yearbook, need help
 

hi dan maybe u can check php.net theres a good resources to learn it, and u can download php manual there ....

Re: trying to make a survey for school yearbook, need help
 

Ok so about this i made the table and entered all the data. Its in a table called grads and there are rows called user_id. I want to retrieve user_id for the drop down menu.

also how do i now generate random passwords for everyone? I made a field called password in the mysql just i don't know how to generate the random password

Re: trying to make a survey for school yearbook, need help
 

Replace student_name with user_id in the query that I have given above. Then change, $row['student_name'] to $row['user_id'].

As I said earlier, generating random password is easy. Check this site. Use that function in your script.

Re: trying to make a survey for school yearbook, need help
 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Etobicoke Collegiate Institute's Grad Survey 2008</title>

</head>



<body>

<form action="handle.php" method="post">



<fieldset><legend>Please complete the following questions. Thanks!</legend>



<label>1. Be on the price is right</label><br />

<select name="priceisright">

  <option value="">Please Choose One Person</option>

  <option value="">Not Voting</option>

  <?php

$conn=mysql_connect($host,$username,$pass);

mysql_select_db($dbname);

$query="select user_id from student";

$result=mysql_query($query);

echo "<select name=\"student_name\">";

while($row=mysql_fetch_array($result)){

   echo "<option value=".$row['user_id'].">".$row['student_name']."</option>";    

}



?>



</select>

<br />





</body>

</html>

But it doesnt seem to work. Sorry i am bugging you so much but i am quite new to php