Hello.my Friend,Today i found some problem when edit my text and photo update
I have this dir
upload
list.php
edit.php
list.php
PHP Code:
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<table border="1">
<tr > <td>id </td>
<td>Name </td>
<td>email</td>
<td>photo</td>
<td>Edit</td>
</tr>
<?php
$host= "localhost";
$name="root";
$pass="";
$db="test";
$con=mysql_connect($host,$name,$pass);
$seldb=mysql_select_db($db,$con);
$query=mysql_query("SELECT * FROM user");
while($row=mysql_fetch_array($query)){
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><img src="upload/<?php echo $row['photo']; ?>" width="100" height="100"/></td>
<td> <a href="edit.php?id=<?php echo $row[0]; ?>">Edit</a></td>
</tr>
<?
}
?>
</table>
</body>
</html>
edit.php
Code:
<?php
$host= "localhost";
$name="root";
$pass="";
$db="test";
$con=mysql_connect($host,$name,$pass);
$seldb=mysql_select_db($db,$con);
$query=mysql_query("SELECT * FROM user");
if(isset($_GET['id'])){
$id=$_GET['id'];
$query=mysql_query("SELECT * FROM user");
while($row= mysql_fetch_assoc($query)){
?>
<form action="edit.php" method="post" enctype='multipart/form-data'>
Name: <input type="text" name="name" value="<?php echo $row['name']; ?>"/>
Email : <input type="text" name="email" value="<?php echo $row['email']; ?>"/>
Photo: <input type="file" name="photo" value="upload/<?php echo $row['photo']; ?>"/>
<?php
} }
?>
<input type="hidden" name="hid" value="<?php echo $row['id']; ?>"/>
<input type="submit" name="save" value="Update"/>
</form>
<?php
if(isset($_POST['save'])){
$hid=$_POST['hid'];
$name=$_POST['name'];
$email=$_POST['email'];
$photo=$_FILES['photo'];
$update= mysql_query("UPDATE user SET name='$name',email='$email',photo='$photo' WHERE id='$hid'");
move_uploaded_file($_FILES['photo']['tmp_name'], "upload/".$photo);
if($update){
echo "<meta http-equiv=refresh content=0,url=list.php>";
}
}
?>
i just want to change text when i edit the text but my problem is,when
i edit the text if i don't choose the image,which is empty
so,How can i solve the problem ?
Thanks