<?php
        // extract data from form; store in variable
    $caseName =  $_POST["caseName"];
    $caseClient =  $_POST["caseClient"];
    $caseArchitect =  $_POST["caseArchitect"];
    $caseInteriorDesigner =  $_POST["caseInteriorDesigner"];
    $caseEngineer =  $_POST["caseEngineer"];
    $caseContract =  $_POST["caseContract"];
    $caseInformation =  $_POST["caseInformation"];
    $caseValue =  $_POST["caseValue"];

    if ( isset( $_FILES['upload'] ) ) {
        $name_array = $_FILES['upload']['name'];
        $size_array = $_FILES['upload']['size'];
        $type_array = $_FILES['upload']['type'];
        $tmp_name_array = $_FILES['upload']['tmp_name'];
        $allowed = array(
                         'image/jpeg' => 'jpg',
                         'image/pjpeg' => 'jpg',
                         'image/gif' => 'gif',
                         'image/png' => 'png'
                         );

        //Check if in allowed list
        $allowed_mime = array_keys($allowed);
        foreach($_FILES['upload']['type'] as $file_mime) {
            if (!in_array(strtolower($file_mime), $allowed_mime)) {
                die('failed!');
            }
        }

		(!move_uploaded_file( $tmp_name_array, getcwd() . "/uploaded/" . $name_array  )
		{
		die('failed!');
		}

        $dsn = 'mysql:host=localhost;dbname=jasonglo_db ';
        $username = 'jasonglo_usr';
        $password = 'yt987210d';
            //
            // DB connection was made
            //
        $pdo = new PDO($dsn, $username, $password);



            //loop over array to get names. Make sure we have actual content.
        if ( count( $name_array ) > 0 && $name_array !== false ) {

                    //Prepare query
            $statement = $pdo->prepare( 'INSERT INTO commercial(caseImage,caseImage2,caseImage3,caseName,caseClient,caseArchitect,caseInteriorDesigner,caseEngineer,caseValue,caseContract, caseInformation) VALUES (?,?,?,?,?,?,?,?,?,?,?)' );

                    //use a different index in the event that the numeric keys in the name array are not ordered correctly
            $index = 1;



            foreach ( $name_array as $key => $filename ) {

                $statement->bindParam( $index, $name_array[$key], PDO::PARAM_STR );
                $index++;
            }
            $english_format_number = number_format($caseValue);
            $statement->bindParam(4, $caseName, PDO::PARAM_STR );
            $statement->bindParam(5, $caseClient, PDO::PARAM_STR );
            $statement->bindParam(6, $caseArchitect, PDO::PARAM_STR );
            $statement->bindParam(7, $caseInteriorDesigner, PDO::PARAM_STR );
            $statement->bindParam(8, $caseEngineer, PDO::PARAM_STR );
            $statement->bindParam(9, $caseValue, PDO::PARAM_STR );
            $statement->bindParam(10, $caseContract, PDO::PARAM_STR );
            $statement->bindParam(11, $caseInformation, PDO::PARAM_STR );


            $statement->execute();

        }
    }
    ?>