PHP Not Returning Anything

Codewalkers Forums Sponsor:

March 24th, 2003, 07:45 PM

JenniferKearns

Join Date: Apr 2007

Posts: 8

Time spent in forums: < 1 sec
Reputation Power: 0

PHP Not Returning Anything

Hi
I'm having a bit of a problem with a PHP page. It is supposed to select data from the database and return it to the appropriate text boxes in a HTML page.

The code is as follows. If anyone can help, please.

php Code:

Original - php Code

 
 
<html>
<body background=green_ba.jpg>
<img src="whitelogo.bmp" align= "right">
 
<?
 
$Emp_No=$_POST['Emp_No'];
$Wk_No=$_POST['Wk_No'];
 
$connection=mysql_connect (localhost)
or die("cannot make the connection");
 
$db = mysql_select_db ("payroll", $connection)
or die ("Cannot connect to the database");
 
$query= "SELECT * FROM personaldetails WHERE Emp_No='$Emp_No' ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
 
$i=0;
while ($i < $num) 
{
$Emp_No=mysql_result($result,$i,"Emp_No");
$Employee_Surname=mysql_result($result,$i,"Employee_Surname");
$Employee_Firstname=mysql_result($result,$i,"Employee_Firstname");
$Employee_Address=mysql_result($result,$i,"Employee_Address");
$Dept_Id=mysql_result($result,$i,"Dept_Id");
$PPS_No=mysql_result($result,$i,"PPS_No");
$PRSI_Class_ID=mysql_result($result,$i,"PRSI_Class_ID");
$CC_ID=mysql_result($result,$i,"CC_ID");
?>
 
 
<p>
Employee Number: <input type="text" name="Emp_No" value="<? echo "$Emp_No"; ?>"><p>
Employee Surname: <input type="text" name="Employee_Surname" value="<? echo "$Employee_Surname" ?> "><br>
Employee Firstname: <input type="text"  name="Employee_Firstname" value="<? echo "$Employee_Firstname" ?>"> <br>
Employee_Address: <input type="text"  name="Employee_Address" value="<? echo "$Employee_Address" ?>"> <br>
Dept_Id: <input type="text"  name="Dept_Id" value="<? echo "$Dept_Id" ?>"> <br>
PPS_No: <input type="text"  name="PPS_No" value="<? echo "$PPS_No" ?>"> <br>
PRSI_Class_ID: <input type="text"  name="PRSI_Class_ID" value="<? echo "$PRSI_Class_ID" ?>"> <br>
CC_ID: <input type="text"  name="CC_ID" value="<? echo "$CC_ID" ?>"> <br>
 
 
<?
++$i;
}
 
?>
</body>
</html>

March 25th, 2003, 01:32 AM

postalcow

Codewalkers Beginner (1000 - 1499 posts)

Join Date: Apr 2007

Location: Ford CIty, PA USA

Posts: 1,267

Time spent in forums: < 1 sec
Reputation Power: 3

RE: PHP Not Returning Anything

First Connection should be

Code:

$connection = mysql_connect ("localhost", "username", "passwd") or die ("Unable to connect");

not

$connection=mysql_connect (localhost)

Then make your result easier like

Code:

$result = @mysql_query($sql,$connection)
        or die (mysql_error());

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

$Emp_No =$row['Emp_No'];

$Employee_Surname =$row['Employee_Surname'];

and so on

}

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: