I'm trying to modify an image in my database by the id of the product, my table is called products and my id is product_id, only when doing the UPDATE in my file upload_image.php does not modify the image.
<?php
if($_SERVER['REQUEST_METHOD'] == "POST" && isset($_FILES["fileToUpload"]["type"])){
/* Llamar la Cadena de Conexion*/
include ("../config/db.php");
include ("../config/conexion.php");
$id_producto=intval($_POST['id_producto']);
$target_dir = "../imagenes/";
$carpeta=$target_dir;
if (!file_exists($carpeta)) {
mkdir($carpeta, 0777, true);
}
$target_file = $carpeta . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
$check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
if($check !== false) {
$errors[]= "El archivo es una imagen - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
$errors[]= "El archivo no es una imagen.";
$uploadOk = 0;
}
}
// Check if file already exists
if (file_exists($target_file)) {
$errors[]="Lo sentimos, la imagen ya existe.";
$uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 524288) {
$errors[]= "Lo sentimos, el archivo es demasiado grande. Tamaño máximo admitido: 0.5 MB";
$uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
$errors[]= "Lo sentimos, sólo archivos JPG, JPEG, PNG & GIF son permitidos.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
$errors[]= "Lo sentimos, tu imagen no fue insertada.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
$messages[]= "La imagen se ha sido insertado correctamente.";
$ruta=$_FILES["fileToUpload"]["name"];
$update=mysqli_query($con,"UPDATE products SET url_image ='$ruta' WHERE id_producto='$id_producto'");
echo $id_producto;
} else {
$errors[]= "Lo sentimos, hubo un error subiendo la imagen.";
}
}
if (isset($errors)){
?>
<div class="alert alert-danger alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
<strong>Error!</strong>
<?php
foreach ($errors as $error){
echo"<p>$error</p>";
}
?>
</div>
<?php
}
if (isset($messages)){
?>
<div class="alert alert-success alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
<strong>Aviso!</strong>
<?php
foreach ($messages as $message){
echo"<p>$message</p>";
}
?>
</div>
<?php
}
}
?>
under the UPDATE statement I made an echo to see which id of the product I get and print to me that the id_product is 0, what I want to know is how to get the id of the product that in my table is 1 but I get the value 0. thank you very much !!