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 trying 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