insertimage.php

<?php
        $file_count = count($_FILES['files']['name']);
	$errorFalg = "0" ;
	$errorMessage = "";
        $uploaddir      =       "/tmp/";
        $host           =       "host = 127.0.0.1";
        $port           =       "port = 5432";
        $dbname         =       "dbname = testdb";
	$username       =       $_POST['username'];
	$password       =       $_POST['password'];
        $credentials    =       "user = $username password=$password";
        $conn = pg_connect( " $host $port $dbname $credentials" );
	echo "[{\"success\":true,\"message\":\"Trying to fetch\"},";
	if (!$conn) {
		echo "{\"success\":false,\"message\":\"Please check your credentials\"}]";
	}
	else {
                for ( $i=0;$i<$file_count;$i++) {
                                $img_name = basename($_FILES['files']['name'][$i]);
                                if (strpos($img_name, 'jpeg') !== false || strpos($img_name, 'jpg') !== false || strpos($img_name, 'png') !== false || strpos($img_name, 'JPEG') !== false || strpos($img_name, 'JPG') !== false || strpos($img_name, 'PNG') !== false) {
									$uploadfile = $uploaddir . basename($_FILES['files']['name'][$i]);
									if (move_uploaded_file($_FILES['files']['tmp_name'][$i], $uploadfile)){
													$query = "insert into image values (lo_import('$uploadfile'),'$img_name')";
													$result = pg_query($query);
													if($result){
															unlink($uploadfile);
													}
													else{
															$errorFalg ="1";
															$errorMessage = $errorMessage . " Filename already exists " . $img_name;
															unlink($uploadfile);
													}
									}
									else {
											$errorFalg ="1";
											$errorMessage = $errorMessage . " Error getting image " . $img_name;
									}
                                }
				else if( $img_name != NULL) {
					 $errorFalg ="1";
					 $errorMessage = $errorMessage . " Not supported format (JPEG/JPG/PNG) " . $img_name;
				}
                }
        pg_close($conn);
		if ( $errorFalg == "0" ) {
			echo "{\"success\":true,\"message\":\"Uploaded Successfully\"}]";
		}
		else{
			echo "{\"success\":false,\"message\":\"${errorMessage}\"}]";
		}
	}
?>