Created
July 24, 2017 23:49
-
-
Save kortstin/637ab5bb88e47c187c7df5b00d665dc2 to your computer and use it in GitHub Desktop.
upload.php
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//importing dbDetails file | |
require_once 'dbConnect.php'; | |
//this is our upload folder | |
$upload_path = 'uploads/; | |
//Getting the server ip | |
$server_ip = gethostbyname(gethostname()); | |
//creating the upload url | |
$upload_url = 'https://kswebdsgn.com/UploadExamples/'.$upload_path; | |
//response array | |
$response = array(); | |
if($_SERVER['REQUEST_METHOD']=='POST'){ | |
//checking the required parameters from the request | |
if(isset($_POST['name']) and isset($_FILES['image']['name'])){ | |
//connecting to the database | |
$con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect...'); | |
//getting name from the request | |
$name = $_POST['name']; | |
$latitude = $_POST['latitude']; | |
$longitude = $_POST['longitude']; | |
//getting file info from the request | |
$fileinfo = pathinfo($_FILES['image']['name']); | |
//getting the file extension | |
$extension = $fileinfo['extension']; | |
//file url to store in the database | |
$file_url = $upload_url . getFileName() . '.' . $extension; | |
//file path to upload in the server | |
$file_path = $upload_path . getFileName() . '.'. $extension; | |
//trying to save the file in the directory | |
try{ | |
//saving the file | |
move_uploaded_file($_FILES['image']['tmp_name'],$file_path); | |
$sql = "INSERT INTO `kswebske_image_upload`.`images` (`id`, `url`, `name`,`latitude`,`longitude`) VALUES (NULL, '$file_url', '$name','$latitude','$longitude');"; | |
//adding the path and name to database | |
if(mysqli_query($con,$sql)){ | |
//filling response array with values | |
$response['error'] = false; | |
$response['url'] = $file_url; | |
$response['name'] = $name; | |
} | |
//if some error occurred | |
}catch(Exception $e){ | |
$response['error']=true; | |
$response['message']=$e->getMessage(); | |
} | |
//displaying the response | |
echo json_encode($response); | |
//closing the connection | |
mysqli_close($con); | |
}else{ | |
$response['error']=true; | |
$response['message']='Please choose a file'; | |
} | |
} | |
/* | |
We are generating the file name | |
so this method will return a file name for the image to be upload | |
*/ | |
function getFileName(){ | |
$con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect...'); | |
$sql = "SELECT max(id) as id FROM images"; | |
$result = mysqli_fetch_array(mysqli_query($con,$sql)); | |
mysqli_close($con); | |
if($result['id']==null) | |
return 1; | |
else | |
return ++$result['id']; | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment