Untitled

</head>


<body>

    <!-- FORM -->
    <div class="container">
        <div class="page-header">

            <h1>UPLOAD</h1>
        </div>

    <!-- PHP Insert -->
     <?php
     if($_POST){

        // GET DB
         include '../config/database.php';
         try{


            $query = "INSERT INTO products
                      SET name=:name, email=:email, description=:description,
                      value=:value, image=:image";
            $stmt = $con->prepare($query);

            $name=htmlspecialchars(strip_tags($_POST['name']));
            $email=htmlspecialchars(strip_tags($_POST['email']));
            $description=htmlspecialchars(strip_tags($_POST['description']));
            $value=htmlspecialchars(strip_tags($_POST['value']));

            //HERE WE START TO WORK WITH IMAGE
            $image=!empty($_FILES["image"]["name"])
                    ? sha1_file($_FILES['image']['tmp_name']) . "-" . basename($_FILES["image"]["name"])
                    : "";
            $image=htmlspecialchars(strip_tags($image));


            $stmt->bindParam(':name', $name);
            $stmt->bindParam(':email', $email);
            $stmt->bindParam(':description', $description);
            $stmt->bindParam(':value', $value);
            $stmt->bindParam(':image', $image);


            if($stmt->execute()){
                echo "<div class="alert alert-success">Saved.</div>";

            // NEXT IMAGE STEP
            if($image){


            $target_directory = "../uploads/";
            $target_file = $target_directory . $image;
            $file_type = pathinfo($target_file, PATHINFO_EXTENSION);

            $file_upload_error_messages="";

            }


            $check = getimagesize($_FILES["image"]["tmp_name"]);
            if($check!==false){
            }else{
               $file_upload_error_messages.="<div>ERROR for this image</div>";
            }

            $allowed_file_types=array("jpg", "jpeg", "png", "gif");
            if(!in_array($file_type, $allowed_file_types)){
               $file_upload_error_messages.="<div>JPG, JPEG, PNG, GIF select one of this types.</div>";
            }


            if(empty($file_upload_error_messages)){
                if(move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)){
                }else{
                    echo "<div class='alert alert-danger'>";
                    echo "<div>ERROR.</div>";
                    echo "<div>RELOAD.</div>";
                    echo "</div>";
                }
            }


            else{
                echo "<div class='alert alert-danger'>";
                echo "<div>{$file_upload_error_messages}</div>";
                echo "<div>SELECT IMAGE.</div>";
                echo "</div>";
            }
             }  else{
                echo "<div class='alert alert-danger'>PROBLEM WITH UPLOADING.</div>";
             }

            }


         catch(PDOException $exception){
             die('ERROR: ' . $exception->getMessage());
         }
     }
     ?>


    <!-- POST HTML FORM -->
    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="post" enctype="multipart/form-data">
        <table class='table table-hover table-responsive table-bordered'>
            <tr>
                <td>Name</td>
                <td><input type='text' name='name' class='form-control' id="preview_name"/></td>
            </tr>
            <tr>
                <td>Email</td>
                <td><input type='email' name='email' class='form-control' id="preview_email"/></td>
            </tr>
            <tr>
                <td>Description</td>
                <td><textarea name='description' class='form-control' id="preview_description"></textarea></td>
            </tr>
            <tr>
                <td>Status</td>
                <td><span>ACT</span><input type="hidden" name='value' class='form-control' id="preview_value" value="ACT" /></td>
            </tr>
            <tr>
                <td>Image</td>
                <td><input type="file" name="image" class='btn btn-primary' accept="image/*" onchange="loadFile(event)" /></td>
            </tr>
            <tr>
                <td></td>
                <td>
                    <input type='submit' value='SAVE' class='btn btn-success' />
                    <a href='index.php' class='btn btn-primary'>Back home</a>
                </td>
            </tr>
        </table>
    </form>

    </div>

<?php
$host = "localhost";
$db_name = "php_beginner_crud_level_1";
$username = "root";
$password = "";
try {
$con = new PDO("mysql:host={$host};dbname={$db_name}", $username, $password);
}
?>

CREATE TABLE `products` (
`id` int(11) NOT NULL,
`name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`description` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`value` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`image` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 INSERT INTO `products` (`id`, `name`, `email`, `description`, `value`, `image`) VALUES
  (1, 'Norman', 'Norm1@gmail.com', 'Nice Guy', 'ACT', ''),
  (2, 'Lassy', 'Lass2@gmail.com', 'Monster', 'ACT', '');

   ALTER TABLE `products`
   ADD PRIMARY KEY (`id`);