Single File Uploading in Database in Core PHP  

& Image Validation In Server Side in PHP


<?php

include '../dbconnect.php';

if($_SERVER['REQUEST_METHOD']=='POST'){
    if(isset($_POST['submit']) and !empty($_POST['submit'])){

        $username=isset($_POST['username'])?$_POST['username']:NULL;
        
        if(is_null($username) or empty($username)){
            header("location:{$_REQUEST['/']}?action=username&msg=blank-username");
            exit;
        }

        $file=$_FILES['file'];
        $file_name = $file['name'];
        $file_type = $file['type'];
        $file_tmp_name = $file['tmp_name'];
        $file_error = $file['error'];
        $file_size = $file['size'];
        
        $fs = $file_size/1024;

        $arr = ['jpg','png','jpeg'];
        $fi= explode(".",$file_name);
        $last = end($fi);
        
        if(in_array($last,$arr))
        {
          
            if($fs<=500)
            {
                if($file_error==0)
                {
                 
                    $file_path = __DIR__."/vv/";

                    $upload_files = $file_path.$file_name;
                  
                  if( move_uploaded_file($file_tmp_name,$upload_files))
                  {
                    
                    $insertquery="insert into tbl_user(name,file)values('{$username}','{$file_name}')"; 
                    
                    $ifile=mysqli_query($con,$insertquery);
                    if(!$ifile){
                        die($con);
                    }else{
                        echo "ok";
                    }
                    
                    if($iquery){
            
                        ?>
                        <script>
                        window.alert(" successfully");
                      
                        </script>
            
                        <?php
            
                    }else{
                        ?>
                            <script>
                            window.alert("failed");
                            // window.location.href="register.php";
                            </script>
            
                        <?php
                    }
                  }else{
                    echo "No File Movienig";
                  }
                }else{
    
                    echo "File Uploading Error";
                }

            }else{

                echo "File Size Should be bellow 500kb";
            }

        }else{
            echo "<br> InValid image";
        }

             
    }else{
        header("location:{$_REQUEST['/']}");
    }

}else{
    header("location:register.php");
}




Single File Uploading in Database in Core PHP - By Vritant