PHP multiple file upload and store the path in DB

freakunleash · February 18, 2011

Hi Guys,

I need help for in storing data from PHP from array in mysql. I'm very new to PHP/Mysql and have started learing it just few weeks back. I'm tryting to build a website for myself.

I'm having tough time trying to insert the data from Form in mysql. I have a form where user update the company name and insert there product name with there image. I want to rename the image with the corresponding text field value and insert the upload path in the table.

my FORM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
body,td,th {
color: #000;
font-family: Tahoma, Geneva, sans-serif;
font-size: 80%;
}
body {
background-color: #9CF;
}
table {
background: #CCF;
}
th {
font: bold normal 16px/normal "Times New Roman", Times, serif;
text-transform: capitalize;
color: #00F;
background: #FFC;
}
td {
font: bold 14px Georgia, "Times New Roman", Times, serif;
text-transform: capitalize;
color: #3A00FF;
background: #FF9;
}
</style>
</head>

<body>

<form action="upload-file1.php" method="post" enctype="multipart/form-data" name="form">
<strong>Company Name:</strong> <input name="product" type="text" />



  <br />
  <table>
  <tr bgcolor="#FF9900">
    <th colspan="3" bgcolor="#CCFFFF">filter    </th>
    <th colspan="5" bgcolor="#CCFFFF">heater</th>
    </tr>
  <tr><td>filter1</td><td><input name="filter[]" type="text" id="filter"/> <td><input name="img_filter[]" type="file" /></td><td>heater1: </td>
    <td><input name="heater[]" type="text" id="heater"/></td> <td><input name="img_heater[]" type="file" /></td> </tr>
<tr><td>filter2</td><td><input name="filter[]" type="text" id="filter"/> <td><input name="img_filter[]" type="file" /></td><td>heater2: </td>
  <td><input name="heater[]" type="text" id="heater"/></td> <td><input name="img_heater[]" type="file" /></td> </tr>
<tr><td>filter3</td><td><input name="filter[]" type="text" id="filter"/> <td><input name="img_filter[]" type="file" /></td><td>heater3: </td>
  <td><input name="heater[]" type="text" id="heater"/></td> <td><input name="img_heater[]" type="file" /></td> </tr>
<tr><td>filter4</td><td><input name="filter[]" type="text" id="filter"/> <td><input name="img_filter[]" type="file" /></td><td>heater4: </td>
  <td><input name="heater[]" type="text" id="heater"/></td> <td><input name="img_heater[]" type="file" /></td> </tr>
<tr><td>filter5</td><td><input name="filter[]" type="text" id="filter"/> <td><input name="img_filter[]" type="file" /></td><td>heater5: </td>
  <td><input name="heater[]" type="text" id="heater"/></td> <td><input name="img_heater[]" type="file" /></td> </tr>


</table>
  <br />
  <br />
  <input name="submit" type="submit" value="submit" />
</form>



</body>
</html>

my PHP Code

<?php require("connect.php"); ?>

<?php

$product = $_POST['product'];
echo $product;
if(isset($_POST["submit"])){
  $sql = "INSERT INTO company (product) VALUES ('$product')";
  $query = mysql_query($sql) OR DIE(mysql_error());
  $comp_id = mysql_insert_id();
  echo $sql;
}
?>

<?php

        function filter()
        {
                if(isset($_POST['submit'])) {
                        
                        foreach($_POST['filter'] as $key => $val) {
                                if(trim($val) != '')
                                        $filter[] = $val;
                        }
                    
                        $total_records_filter = count($filter);
        
                        for($i = 0; $i < $total_records_filter; $i++) {
        
                                $prod_val = $filter[$i];
                        
                                $sql_prod = "INSERT INTO filter(filter_id, filter)
                                                          VALUES('', '$prod_val')";
                                echo $sql_prod.'<br>';
                                mysql_query($sql_prod) OR die(mysql_error());
                        }        
                }
        }
        
        filter();

function heater()
        {
                if(isset($_POST['submit'])) {
                        
                        foreach($_POST['heater'] as $key => $val) {
                                if(trim($val) != '')
                                        $heater[] = $val;
                        }
                    
                        $total_records_heater = count($heater);
        
                        for($i = 0; $i < $total_records_heater; $i++) {
        
                                $dir_val = $heater[$i];
                        
                                $sql_dir = "INSERT INTO heater(heater_id, heater)
                                                          VALUES('', '$dir_val')";
                                echo $sql_dir.'<br>';
                                mysql_query($sql_dir) OR die(mysql_error());
                        }        
                }
        }
        
        heater();
?>

<?php mysql_close($link)?>

My Table structure

company

comp_id int(5) PK

product varchar(50) No

filter

filter_id int(5) PK

filter varchar(25) No

filter_path varchar(100) No

heater

heater_id int(5) PK

heater varchar(25) No

heater_path varchar(100) No

company_filter

id int(5) PK

comp_id int(5) PK FK (From company table)

filter_id int(5) PK FK (From filter table)

company_heater

id int(5) PK

comp_id int(5) PK FK (From company table)

heater_id int(5) PK FK (From heater table)

Regards

BW

Sign In

PHP multiple file upload and store the path in DB

Recommended Posts

freakunleash

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information