Only the first word is displayed in the form when editing.

jozin · #1 (**permalink**) 11-02-04, 09:26 PM

Hi everybody,

I have this problem:

I have a list of employees their name, address, and date of birth.

Emp. ID Emp. Name Address Date of Birth

001 Ricky Puno Angeles City, Phil 1985-08-01 edit delete
002 Jim Gomez Quezon City, Phil 1980-05-08 edit delete

My problem is that when I try to edit a data, for example employee 001, only the first word is displayed in the Employee Name field and Address Field:

Emp. ID: 001
Emp. Name: Ricky
Address: Angeles
Date of Birth: 1985-08-01

I don’t know what is wrong with my code. Deleting and saving data in the database(MySQL) is OK.

This is my code when editing or deleting a data is:

echo "<TD>
<A HREF='addeditemp.php?process=edit&empID=
$row->employeeID&empname=$row->employeename=
$row->employeeID&address=$row->Address=
$row->employeeID&bday=$row->Birthday'>edit
</A>
</TD>";
echo "<TD>
<A HREF='Procemp.php?process=del&empID= $row->employeeID&empname=$row->employeename'>delete
</A>
</TD>";

This is my addeditemp.php code:

<HTML>
<?php
include("Opendb.php");
?>
<HEAD>
<TITLE>Add Employee</TITLE>
</HEAD>
<BODY>
<BR>
<BOLD>Add Employee </BOLD>
<BR>
<FORM ACTION="Procemp.php?" method="post">
<input type=hidden name="process" value=<?php echo $process; ?>>
ID:<input type ="text" name="empID" value=<?php if (isset($empID)) { echo $empID; } ?>><BR>
Name:<input type ="text" name="empname" value=<?php if (isset($empname)) { echo $empname; } ?>><BR>
Address:<textarea name="address" cols="50" rows="3" value=<?php if (isset($address)) { echo $address; } ?>></textarea><BR>
Date of Birth:<input type ="text" name="bday" value=<?php if (isset($bday)) { echo $bday; } ?>><BR>
<input type ="submit"><input type="reset">
</FORM>
</BODY>
</HTML>

All of your comments and suggestions will be much appreciated.

Thanks a lot,

Jozin.

moronovich · #2 (**permalink**) 11-02-04, 09:48 PM

hello jozin,
the problem you face right now is because you don't use double quotes to enclose the value of input attribute "value". for example in:

Code:

<input type ="text" name="empname" value=<?php if (isset($empname)) { echo $empname; } ?>>

by rewriting it into

Code:

<input type ="text" name="empname" value="<?php if (isset($empname)) { echo $empname; } ?>" />

the problem should be solved.

regards,

jozin · #3 (**permalink**) 11-03-04, 02:16 AM

Hi moronovich,

Thanks it worked. but there's still an error somewhere.
The result is,

Emp. ID: 001
Emp. Name: Ricky Puno= 1
Address: Angeles City, Pampanga, Phil= 1
Date of Birth: 1985-08-01

How can i remove the "= 1" at the end of the text field?

Thanks for the help.

Jozin

moronovich · #4 (**permalink**) 11-03-04, 04:45 AM

please look at your code:

Code:

echo "<TD>
<A HREF='addeditemp.php?process=edit&empID=
$row->employeeID&empname=$row->employeename=
$row->employeeID&address=$row->Address=
$row->employeeID&bday=$row->Birthday'>edit
</A>
</TD>";

i'm sure you'll soon know why there is always trailing '=1' on the output.

jozin · #5 (**permalink**) 11-06-04, 02:57 AM

Hi,

I can't help but laugh at myself when I realized my mistake. Your absolutely right. The culprit is the way I arranged my code.

I hope you won't get tired of my silly problems.

Thanks a lot and more power.

jozin

moronovich · #6 (**permalink**) 11-07-04, 02:18 AM

you're welcome..