Trouble with PHP, MYSQL drop down

deadz

Hi, I have been stuck with this problem for about a month now and find no answers for it online, as my php knowledge is of little experience i have ran out of methods to sort it out. So here I am asking you guys.

The problem:

Basically, I have two pages coded in php with html inside of them. One has a drop down menu that has students names from the database. The user simply clicks on one of them and click on the submit button to go onto the next page. On the next page is a styled content box with input fields which should display the databases information of that student they entered, but here is the problem, I cant get it to show the information!

Here is the code for the drop down page

<?php

include 'includes/connection.php';

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html"; charset="UTF-8" />
<title>DrivaSoft - Control Panel</title>
<link rel="stylesheet" type="text/css" href="styles.css" />
</head>
<body>

<div id="container">

<div id="logo"></div>
<div id="nav">
<ul class="menu">
<li id="manual"><a href="manual.php"><span>#</span></a></li>
<li id="drivasoft"><a href="http://drivasoft.co.uk"><span>#</span></a></li>
<li id="logout"><a href="logout.php"><span>#</span></a></li>
</ul>
</div>

<div id="custform" class="custform">
<form id="form" name="custform" method="post" action="editprocess.php">
<h1>Select Customer</h1>

<label>Name
<span class="small">Choose student by name</span>
</label>

<?php echo "<select name='select'>";
$query = "SELECT student FROM customers";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
while($row = mysql_fetch_assoc($result)){
echo '<option value='.$row['student'].' selected>'.$row['student'].'</option>';
}
echo "</select>";
?>
<button type="submit" class="submit" name="submit" id="submit">Select Customer</button>
<div class="spacer"></div>

</form>
</div>
</div>

</body>
</html>

Here is the code for the page which should display the info

<?php

include 'includes/connection.php';

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html"; charset="UTF-8" />
<title>DrivaSoft - Control Panel</title>
<link rel="stylesheet" type="text/css" href="styles.css" />
</head>
<body>

<div id="container">

<div id="logo"></div>
<div id="nav">
<ul class="menu">
<li id="manual"><a href="manual.php"><span>#</span></a></li>
<li id="drivasoft"><a href="http://drivasoft.co.uk"><span>#</span></a></li>
<li id="logout"><a href="logout.php"><span>#</span></a></li>
</ul>
</div>
<div id="latestcustcontent">

<div id="latestcustform" class="latestcustform">
<form id="form" name="custform" method="post" action="editsuccess.php">
<h1>Latest Customers</h1>

<label>ID
<span class="small">Student's ID</span>
</label>
<input type="text" name="editcustomer" id="editcustomer" value="<?php
$query = "SELECT id FROM customers WHERE student = ' " . $id . " ' ";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$id = $_POST['student'];
$rr = $row['id'];
echo  $rr; ?>" />

<label>Name
<span class="small">Student's name</span>
</label>
<input type="text" name="student" id="student" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $student . " ' ";
$result = mysql_query($query) or die (mysql_error());
$student = $_POST['student'];
while($row = mysql_fetch_assoc($result))
echo "" . $row['student'] . ""; ?>" />

<label>Date of Birth
<span class="small">Student's dob</span>
</label>
<input type="text" name="dob" id="dob" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $dob . " ' ";
$result = mysql_query($query) or die (mysql_error());
$dob = $_POST['student'];
while($row = mysql_fetch_assoc($result))
echo "" . $row['dob'] . ""; ?>" />

<label>Address
<span class="small">Add student's address</span>
</label>
<input type="text" name="student" id="student" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $phone . " ' ";
$result = mysql_query($query) or die (mysql_error());
$phone = $_POST['student'];
while($row = mysql_fetch_assoc($result))
echo "" . $row['phone'] . ""; ?>" />

<label>Post Code
<span class="small">Add student's post code</span>
</label>
<input type="text" name="student" id="student" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $postcode . " ' ";
$result = mysql_query($query) or die (mysql_error());
$postcode = $_POST['student'];
$row = mysql_fetch_assoc($result);
while($row = mysql_fetch_assoc($result)){
echo "" . $row['postcode'] . "";
}
?>" />

<label>Theory Test
<span class="small">Add student's theory test date</span>
</label>
<input type="text" name="student" id="theory test" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $theory . " ' ";
$result = mysql_query($query) or die (mysql_error());
$theory = $_POST['student'];
while($row = mysql_fetch_assoc($result)){
echo "" . $row['theory test'] . "";} ?>" />

<label>Practical Test
<span class="small">Add student's practical test Date</span>
</label>
<input type="text" name="practical test" id="practical test" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $prac . " ' ";
$result = mysql_query($query) or die (mysql_error());
$prac = $_POST['student'];
while($row = mysql_fetch_assoc($result)){
echo "" . $row['practical test'] . "";} ?>" />

<label>Theory Test Status
<span class="small">Has the student already passed?</span>
</label>
<input type="text" name="theory passed" id="theory passed" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $thoerypass . " ' ";
$result = mysql_query($query) or die (mysql_error());
$theorypass = $_POST['student'];
while($row = mysql_fetch_assoc($result)){
echo "" . $row['theory passed'] . "";} ?>" />

<label>Practical Test Status
<span class="small">Has the student already passed?</span>
</label>
<input type="text" name="practical passed" id="practical passed" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $pracpass . " ' ";
$result = mysql_query($query) or die (mysql_error());
$pracpass = $_POST['student'];
while($row = mysql_fetch_assoc($result)){
echo "" . $row['practical passed'] . "";} ?>" />

<button type="submit" class="editsubmit" name="editsubmit" id="editsubmit">Update Customer</button>
<div class="spacer"></div>

</form>
</div>

</div>
</div>

</body>
</html>

I would appreciate any help

dagon

add print_r($_POST) to the top of editprocess.php you will see what you have to work with

deadz

hi thx for quick reply, this is what I get at top of screen Array ( [select] => Francis [submit] => )

dagon

and you never make use of $_POST['select'] in editprocess.php

Tonata

Dude... You post the name of the select. You are posting student.

To see how to use POST visit: http://www.w3schools.com/php/php_post.asp

when you visit that link: pay attention to this line: "The "welcome.php" file can now use the $POST function to collect form data (the names of the form fields will automatically be the keys in the $POST array):"

When you learn how $_POST is used, it'll be minus 1 problem....

Tonata

deadz;10955631 wrote:
Hi, I have been stuck with this problem for about a month now and find no answers for it online, as my php knowledge is of little experience i have ran out of methods to sort it out. So here I am asking you guys.

<input type="text" name="student" id="student" value="<?php $query = "SELECT * FROM customers WHERE student = ' " . $student . " ' ";
$result = mysql_query($query) or die (mysql_error());
$student = $_POST['student'];
while($row = mysql_fetch_assoc($result))
echo "" . $row['student'] . ""; ?>" />

</html>[/code]

I would appreciate any help

I want you to copy the SELECT statement above and paste it in your DB query browser, run the query in your database environment, see if it'll return any rows, im sure it'll give you an error or return zero rows.

And 1 more thing, more like a Tip: You can select all student information using one SELECT

$sql = 'SELECT  student_information
                                FROM       students'


           if ($results = mysql_query($sql, $connection))
            {
                    $i=0;
                    while($row = mysql_fetch_assoc($results ))
                    {
                            $students[$i] = $row;
                            $i++;
                    }
            }

Then in your display

<?
php for ($i=0; $i<count($students); $i++) {

 echo $students[$i]['dob']
 echo $students[$i]['last_name']
 echo $students[$i]['first_name']
 ?>

deadz

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec )

Tonata

deadz;10955715 wrote:
MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec )

Yes, do you know why? Because There's no student that is the same as ID..

according to your SELECT, you want to return the the IDs where the student is equal to that ID. that condition can never be true... unless your student column values are numbers, or vise versa: your ID values are strings...

maybe what you want is:

'SELECT students FROM table 
WHERE id '. = id

Tonata

Tonata;10955713 wrote:
I want you to copy the SELECT statement above and paste it in your DB query browser, run the query in your database environment, see if it'll return any rows, im sure it'll give you an error or return zero rows.

And 1 more thing, more like a Tip: You can select all student information using one SELECT
$sql = 'SELECT  student_information
                                FROM       students'


           if ($results = mysql_query($sql, $connection))
            {
                    $i=0;
                    while($row = mysql_fetch_assoc($results ))
                    {
                            $students[$i] = $row;
                            $i++;
                    }
            }
Then in your display
<?
php for ($i=0; $i<count($students); $i++) {

 echo $students[$i]['dob']
 echo $students[$i]['last_name']
 echo $students[$i]['first_name']
 ?>

Sorry i quoted the wrong select here..

I wanted to quoted

SELECT id FROM customers WHERE student = id

I saw this SELECT somewhere in your code

Tonata

Hope this helps you, but you need to do research man, You need to know what you are doing before you do it...

Here's part of the solution




<?php 

//IMPORTANT: 
//1.You POST the name of the select, and in this case the name of your select is select
//go back to your form/drop down <select name="select">.. if you want to POST student
//then change the name of your select to student

//2. in the values property (value="echo $row['name']")
//$row['column_name'], you put your database column name you specified in your SELECT

$query = 'SELECT id, name, ... FROM customers WHERE student LIKE \'%'.$_POST['select'].'%\' '; 
if ($results = mysql_query($query , $connection)){
		$row = mysql_fetch_assoc($results);
	}else{
		echo "$query<br />";
		echo mysql_error();
	}
?>
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html"; charset="UTF-8" /> 
<title>DrivaSoft - Control Panel</title> 
<link rel="stylesheet" type="text/css" href="styles.css" /> 
</head> 
<body> 

<div id="container"> 

<div id="logo"></div> 
<div id="nav"> 
<ul class="menu"> 
<li id="manual"><a href="manual.php"><span>#</span></a></li> 
<li id="drivasoft"><a href="http://drivasoft.co.uk"><span>#</span></a></li> 
<li id="logout"><a href="logout.php"><span>#</span></a></li> 
</ul> 
</div> 
<div id="latestcustcontent"> 

<div id="latestcustform" class="latestcustform"> 
<form id="form" name="custform" method="post" action="editsuccess.php"> 
<h1>Latest Customers</h1> 

<label>ID 
<span class="small">Student's ID</span> 
</label> 
<input type="text" name="editcustomer" id="editcustomer" value="<?php echo $row['id'] ?>" /> 

<label>Name 
<span class="small">Student's name</span> 
</label> 
<input type="text" name="student" id="student" value="<?php echo $row['name'] ?>" /> 

<label>Date of Birth 
<span class="small">Student's dob</span> 
</label> 
<input type="text" name="dob" id="dob" value="<?php echo $row['dob'] ?>" /> 

<label>Address 
<span class="small">Add student's address</span> 
</label> 
<input type="text" name="student" id="student" value="<?php echo $row['address'] ?>" /> 

<label>Post Code 
<span class="small">Add student's post code</span> 
</label> 
<input type="text" name="student" id="student" value="<?php echo $row['post_code'] ?>" /> 

<label>Theory Test 
<span class="small">Add student's theory test date</span> 
</label> 
<input type="text" name="student" id="theory test" value="<?php echo $row['theory_test'] ?>" /> 

<label>Practical Test 
<span class="small">Add student's practical test Date</span> 
</label> 
<input type="text" name="practical test" id="practical test" value="<?php echo $row['practical_test'] ?>" /> 

<label>Theory Test Status 
<span class="small">Has the student already passed?</span> 
</label> 
<input type="text" name="theory passed" id="theory passed" value="<?php echo $row['theory_test_status'] ?>" /> 

<label>Practical Test Status 
<span class="small">Has the student already passed?</span> 
</label> 
<input type="text" name="practical passed" id="practical passed" value="<?php echo $row['practical_test_status'] ?>" /> 

<button type="submit" class="editsubmit" name="editsubmit" id="editsubmit">Update Customer</button> 
<div class="spacer"></div> 

</form> 
</div> 

</div> 
</div> 

</body> 
</html>

deadz

dude, its a variable called $id... for $_POST['student'] this must work...

Tonata

deadz;10955723 wrote:
dude, its a variable called $id... for $_POST['student'] this must work...

I don't see it being declared anywhere thats why... plus you are using the = to compare strings. use the keyword LIKE

deadz

thx ok