freakunleash 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.