이미지업로드를 하고있는데 인서트문을 업데이트 문으로 변경하고싶습니다...
<?php
$link=mysqli_connect("localhost","id","pw","테이블명");
$file_path = "uploads/";
$file_path = $file_path . basename( $_FILES['uploaded_file']['name']);
if(move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $file_path)) {
// replace $host,$username,$password,$dbname with real info
mysqli_query($link,"INSERT INTO uploads (filename,path) VALUES ('".$_FILES['uploaded_file']['tmp_name']."','".$file_path."')");
mysqli_close($link);
} else{
echo "fail";
}
?>
ㅇ이코드를 업데이트문으로 변경하고싶습니다.
밑에코드는 제가해봣는데 자꾸 안되서ㅠㅠ도와주십쇼ㅠㅠ
<?php
$link=mysqli_connect("localhost","id","pw","테이블명");
$file_path = "uploads/";
$file_path = $file_path . basename( $_FILES['uploaded_file']['name']);
if(move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $file_path)) {
// replace $host,$username,$password,$dbname with real info
$filename = $_POST['filename'];
$path = $_POST['path'];
$no = $_POST['no'];
mysqli_query($link,"update user set
filename = '$filename',
path = '$path'
where no = '$no'");
mysqli_close($link);
} else{
echo "fail";
}
?>