mysql - Should accept the data if the image field is empty using php -

i writing query accept image field svg,png,jpeg format.but if image field empty displaying error while uploading,actually should insert remaining fields name , if not adding image also.here query.

example.php

$title=$_post['blog_title']; $result = str_replace(" ", "-", $title); $description=$_post['blog_description']; if(is_uploaded_file($_files['image']['tmp_name'])){ $name=$_files["image"]["name"]; $type=$_files["image"]["type"]; $size=$_files["image"]["size"]; $temp=$_files["image"]["tmp_name"]; $error=$_files["image"]["error"]; $ext = strtolower(pathinfo($name, pathinfo_extension)); if($error > 0){     die("error while uploading"); }else{     $permissible_extension = array("png", "jpg", "jpeg", "svg", "jpg","jpe");     if(in_array($ext, $permissible_extension)){         if(move_uploaded_file($temp,"upload/".$name)){             $sql = mysql_query("insert blogs(image,blog_title,blog_description)values('$name','$result','$description')");             if($sql){                 header("location:blogimage.php");                   exit();             }else{                 echo "insertion failed";             }         }else{             echo "file couldn't uploaded";         }     }else{         echo "invalid format";     } } }else{ $sql = mysql_query("insert blogs(blog_title,blog_description)values('$result','$description')"); if($sql){     header("location:blogimage.php");       exit(); }else{     echo "insertion failed"; } } 

firstly, mandatory advice against use of mysql_* functions. deprecated, use mysqli_* functions or pdo instead.

now, issue. if want store other informations file when filetype empty or wrong, need insert before test.

below code try:

<?php //connect database using mysqli $name=$_files["image"]["name"]; $type=$_files["image"]["type"]; $size=$_files["image"]["size"]; $temp=$_files["image"]["tmp_name"]; $error=$_files["image"]["error"]; if($error>0)     die("error while uploading"); else {     //insert informations in database here, without upload, info file stored     $query = mysqli_query("insert blogs(image)values('$name')");     if($type == "image/png" || $type == "image/jpg"|| $type == "image/jpeg" || $type == "image/svg" || $type == "image/jpe" || $type==" ")     {         move_uploaded_file($temp,"upload/".$name);         echo "upload complete";      }     else     {            die("format not allowed or file size big!");     } }