How can I save a picture using php?
First we get image_id
global $con; $con = new mysqli($host, $user, $password, $db); mysqli_query($con, "INSERT INTO user_images (image_user_id) VALUES ('$session_user_id')"); $image_id = mysqli_insert_id($con); And how can you save the images/$image_id.jpg type as images/$image_id.jpg and update image_url
mysqli_query($con, "UPDATE user_images SET image_url = $image_id WHERE user_id = $session_user_id"); Php code
<?php if ($_SERVER['REQUEST_METHOD'] == 'POST') { $targ_w = $targ_h = 200; $jpeg_quality = 90; $src = $_FILES['image']['name'].'.jpg'; $img_r = imagecreatefromjpeg($src); $dst_r = ImageCreateTrueColor( $targ_w, $targ_h ); imagecopyresampled($dst_r,$img_r,0,0,$_POST['x'],$_POST['y'], $targ_w,$targ_h,$_POST['w'],$_POST['h']); header('Content-type: image/jpeg'); imagejpeg($dst_r,null,$jpeg_quality); exit; } ?>