<?php
if(isset($_POST['dodaj']))
{
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'usbw';
$db_name = 'zapisi';
$tbl_name = 'vneseni';
$ftp_user = 'ugd';
$ftp_pass = 'kiko';
$ftp_server = "localhost";

$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
mysql_select_db("$db_name")or die("cannot select DB");




$ftp_conn = ftp_connect($ftp_server) or die("Could not connect to $ftp_server");
// login with username and password
$login_result = ftp_login($ftp_conn, $ftp_user, $ftp_pass);


// check connection
if ((!$ftp_conn) || (!$login_result)) {
       echo "FTP connection has failed!";
       echo "Attempted to connect to $ftp_server for user $ftp_user";
       exit;
   } else {
       echo "Connected to $ftp_server, for user $ftp_user";
   }


$Vid = $_POST['vid'];
$Cena = $_POST['cena'];
$Br_Std = $_POST['br_std'];
$Naselba = $_POST['naselba'];
$Dogovor = $_POST['dogovor'];
$Ime = $_POST['ime'];
$Mob = $_POST['mob'];
$Opis = $_POST['opis'];
$uploadDir = 'http://localhost:8080/UGDSmeshtaj/'.'img/';
$fileName = $_FILES['slika']['name'];
$filePath = $uploadDir . $fileName;

if(move_uploaded_file($_FILES["slika"]["tmp_name"],"img/".$_FILES["slika"]["name"]))
{
// If file has uploaded successfully, store its name in data base
$query_image = "INSERT INTO $tbl_name(vid,cena,br_std,naselba,dogovor,ime,mob,opis,slika) VALUES ('".$Vid."','".$Cena."','".$Br_Std."','".$Naselba."','".$Dogovor."','".$Ime."','".$Mob."','".$Opis."','".$filePath."')";
if(mysql_query($query_image))
{
echo "Stored in: " . "img/" . $_FILES["slika"]["name"];
}
else
{
echo 'File name not stored in database';
}
}
else{echo 'File not uploaded';}

}





?>