PHP file form question

Question

My Code :

<?php
function dbAdd($first_name , $image) {

//mysql connect database code...

mysql_query("INSERT INTO users SET first_name = '".$first_name."', image = '".$image."'");
$mysql_close($sql);
} 

if($_SERVER['REQUEST_METHOD']=='POST') {
dbAdd($_POST['first_name'], $_POST['image']);
}
?>

<form enctype="multipart/form-data" method="post" action="">
First Name : <input type="text" name="first_name" >
Image : <input type="file" name="image"> 
<input type="submit"> 
</form>

The form "file" is to upload. I know that. But I wonder how to get the values so I can put the path of image in the database. The code is already working. The $first_name can already save to the database.

Thank you for the answers.
Jordan Pagaduan

SQL injections! Read up on PDO and prepared statements $pdo->prepare("WHERE first_name=?"). Or use input sanitization at least, $_POST->text('first_name'); — mario
– mario, Commented May 31, 2010 at 0:05

a_m0d · Accepted Answer · 2010-05-30 23:52:12Z

4

The file will be uploaded to a temporary place on the server when the form is submitted.

Once the form has been submitted, the $_FILES variable will contain all the files submitted. In your case, you could access the uploaded file using $_FILES['image']. Most likely you will want to move the file out of the temporary directory to a safer place.

For more info, have a look at the PHP manual on the topic, specifically the page on handling POST uploads. That second page has an example for you on how to move the uploaded file (have a look at the move_uploaded_file() method).

answered May 30, 2010 at 23:52

a_m0d

12.2k15 gold badges60 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jan K. · Accepted Answer · 2010-05-30 23:54:06Z

0

Straight from W3C: Upload form & $_FILE variable

answered May 30, 2010 at 23:54

Jan K.

1,6182 gold badges14 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP file form question

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related