<?php
require "db.php";
?>
<form action="upload.php" method="post" enctype="multipart/form-data">
                <label for="file1">وێنەیەك بار بكە لە نێو كۆمپیوتەرەكەتەوە</label>
                <input type="file" id="file1" name="file" required>
              </span>
            </div>
            <div class="col-sm-2">  
              <button type="submit" class="btn btn-primary btn-block"  name="submit">
                <i class="icon-upload icon-white"></i> Upload
              </button>
            </div>
          </div>
             </form>


            </div>
        </div>
        <hr>
<?php
$statusMsg = '';

// File upload path
$targetDir = "../images/";
 if (isset($_FILES["file"]["name"])){
$fileName = basename($_FILES["file"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
}
if(isset($_POST["submit"]) && !empty($_FILES["file"]["name"])){
    // Allow certain file formats
    $allowTypes = array('jpg','png','jpeg','gif','pdf');
    if(in_array($fileType, $allowTypes)){
        // Upload file to server
        if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){
            // Insert image file name into database
    $query1 = $db->query("SELECT * FROM `t2` WHERE  file_name ='$fileName'");
    while($row1 = $query1->fetch(PDO::FETCH_ASSOC)) {
$myur2=$row1['file_name'];
}
if (isset($myur2)){}
         
         else{
         //insert y data
            $insert = $db->query("INSERT into t2 (file_name, uploaded_on) VALUES ('".$fileName."', NOW())");         
            if($insert){
                $statusMsg = "The file ".$fileName. " has been uploaded successfully. <br><br><br><br><br>";
            }else{
                $statusMsg = "File upload failed, please try again.";
            } }
        }else{
            $statusMsg = "Sorry, there was an error uploading your file.";
        }
    }else{
        $statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, & PDF files are allowed to upload.';
    }
}else{
    $statusMsg = 'Please select a file to upload.';
}

// peshandany anjame upload.
echo $statusMsg;
?>
</body