How to upload image PHP and insert path in MySQL?

by

On your comment you ask how to upload and store the data to mysql. So here it is:

To get the file, you should have a script in your html like this:

<html>
<body>

     <form action="upload_file.php" method="post" enctype="multipart/form-data">
        <label for="file">Filename:</label>
        <input type="file" name="file" id="file"><br>
        <input type="submit" name="submit" value="Submit">
     </form>

</body>
</html>

Now, on POST, your PHP file should look like this but please take note that you have to check if the file exists on your POST:

if ($_FILES["file"]["error"] > 0)
  {
  echo "Error: " . $_FILES["file"]["error"] . "<br>";
  }
else
  {
  echo "Upload: " . $_FILES["file"]["name"] . "<br>";
  echo "Type: " . $_FILES["file"]["type"] . "<br>";
  echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
  echo "Stored in: " . $_FILES["file"]["tmp_name"];

  }

Since the “Stored in:” part is just the temporary path, you should move to your ‘real’ image path using move_uploaded_file().
Let say the real/default path for your images is in:

$image_dir="/images/";

You just have to move the file using this:

move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $image_dir. $_FILES['uploaded_file']['name']);

And your full path to the image would be

$image = $final_save_dir . $_FILES['uploaded_file']['name'];

There are several ways to store the path to your database:

1st: Is to store just the filename and concatenate the path of the image in PHP using $_SERVER['DOCUMENT_ROOT'] and your default image path like:

$sql="insert into employee_detail( emp_image, employee_name, employee_address,
    employee_contact, employee_designation, employee_salary) 
values( '$image', '$_POST[employee_name]', '$_POST[employee_address]', '$_POST[employee_contact]',
    '$_POST[employee_designation]','$_POST[employee_salary]')";

2nd: Is to store the full path like:

$sql="insert into employee_detail( emp_image, employee_name, employee_address,
    employee_contact, employee_designation, employee_salary) 
values( '".$_SERVER['DOCUMENT_ROOT']."\\images\\".$image."', '$_POST[employee_name]', '$_POST[employee_address]', '$_POST[employee_contact]',
    '$_POST[employee_designation]','$_POST[employee_salary]')";

What I recommend is this approach wherein you will input the partial path (without the root dir) so that later you don’t have a problem on deploying it:

$sql="insert into employee_detail( emp_image, employee_name, employee_address,
    employee_contact, employee_designation, employee_salary) 
values( 'images\\".$image."', '$_POST[employee_name]', '$_POST[employee_address]', '$_POST[employee_contact]',
    '$_POST[employee_designation]','$_POST[employee_salary]')";

And make sure that the images are successfully upload to that default image dir/path.

UPDATE

I also recommend that you use mysqli_* or PDO and use prepare() method /function to prevent sql injection.

More Related Contents:

  1. PHP DateTime supported formats
  2. Can I call a PHP function in a JavaScript click handler?
  3. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  4. Fixing broken UTF-8 encoding
  5. Insert multiple rows with one query MySQL
  6. Why is using a mysql prepared statement more secure than using the common escape functions?
  7. Export MySQL data to Excel in PHP
  8. MySQL – ignore insert error: duplicate entry
  9. localhost vs. 127.0.0.1 in mysql_connect()
  10. “slash before every quote” problem [duplicate]
  11. Call to a member function execute() on boolean in [duplicate]
  12. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  13. How to store the data in unicode in hindi language
  14. PDO + MySQL and broken UTF-8 encoding
  15. How to select multiple rows from mysql with one query and use them in php
  16. php run once and insert twice in mysql database
  17. Connecting to remote MySQL server using PHP
  18. split keywords for post php mysql
  19. Laravel Cannot delete or update a parent row: a foreign key constraint fails
  20. Mysql password expired. Can’t connect
  21. Base table or view not found: 1146 Table Laravel 5
  22. How would I implement a simple site search with php and mySQL?
  23. Check for duplicates before inserting
  24. mysqli_affected_rows in PHP insert
  25. Store html entities in database? Or convert when retrieved?
  26. avoiding MySQL injections with the Zend_Db class
  27. How to create a database-driven multi-level navigation menu using Laravel
  28. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  29. multiple auto increment in mysql
  30. Installing PDO driver on MySQL Linux server

Leave a Comment