$Sno= $_POST['Sno'];
$Clientname= $_POST['Clientname'];
$Contactno = $_POST['Contactno'];
$Dos= $_POST['Dos'];
$Start= $_POST['Start'];
$End= $_POST['End'];
$Dow= $_POST['Dow'];
$Osi= $_POST['Osi'];
$Emhr= $_POST['Emhr'];
$Er= $_POST['Er'];
$Mir= $_POST['Mir'];
$Ea= $_POST['Ea'];
$Cr= $_POST['Cr'];
$Mir1= $_POST['Mir1'];
$Am= $_POST['Am'];
$Ca= $_POST['Ca'];
$Date= $_POST['Date'];
$Image= $_Post['image'];

$sql= "INSERT INTO surveyform(Sno, Clientname, Contactno, Dos, Start, End, Dow, Osi, Emhr,    Er,  Mir,    Ea,   Cr,    Mir1,    Am,   Ca,   Date)
 VALUES('$Sno', '$Clientname', '$Contactno', '$Dos','$Start', '$End', '$Dow', '$Osi', '$Emhr', '$Er','$Mir', '$Ea', '$Cr', '$Mir1', '$Am', '$Ca', '$Date' )";

    if(!mysql_query($sql))
    {
        die('caution record not added' . mysql_error());
    }
        echo"1 record added";





$target_dir = "images/";
$target_file = $target_dir . basename($_FILES["image"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["image"]["tmp_name"]);
    if($check !== false) {
        echo "File is an image - " . $check["mime"] . ".";
        $uploadOk = 1;
    } else {
        echo "File is not an image.";
        $uploadOk = 0;
    }
}
// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
    $uploadOk = 0;
}

// Check file size
if ($_FILES["image"]["size"] > 500000) {
    echo "Sorry, your file is too large.";
    $uploadOk = 0;
}

// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
    echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
    $uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
        echo "The file ". basename( $_FILES["image"]["name"]). " has been uploaded.";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}