Adding records from one table to another table in php/mysql

Question

sanbhu2105 0 Light Poster

10 Years Ago

hello, am new here and new to php/mysql coding.
i have 2 tables - tbl_prodstd and tbl_products
tbl_prodstd - std_id, prod_name, prod_desc, prod_photo, prod_brand
tbl_product - prod_id, std_id, prod_name, prod_brand, prod_desc, prod_price, cat, subcat, prod_photo

i created 3 pages - add_prod.php, addprod.php, func.php

the func.php displays prod_name and prod_brand as selects. selecting prod_name displays the related prod_brand. selecting the prod_brand displays the prod_desc.

when i click the add button in add_prod.php, addprod.php executes.
values are inserted to the tbl_product table. all values are being inserted but i dnt know how to add the std_id, prod_desc and prod_photo in tbl_product table. below are each of the codes

add_prod.php

<?php
session_start();
include('db_connect.php');
include('func.php');
?>

<!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>Add product</title>

<link href="CSS/add_prod.css" rel="stylesheet" type="text/css" />

<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script src="SpryAssets/SpryValidationTextarea.js" type="text/javascript"></script>

<script type="text/javascript">
$(document).ready(function() {
    $('#wait_1').hide();
    $('#prod_name').change(function(){
      $('#wait_1').show();
      $('#result_1').hide();
      $.get("func.php", {
        func: "prod_name",
        drop_var: $('#prod_name').val()
      }, function(response){
        $('#result_1').fadeOut();
        setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
      });
        return false;
    });
});

function finishAjax(id, response) {
  $('#wait_1').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
function finishAjax_tier_three(id, response) {
  $('#wait_2').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
</script>

<script type="text/javascript">
$(document).ready(function()
{
$(".cat").change(function()
{
var id=$(this).val();
var dataString = 'id='+ id;

$.ajax
({
type: "POST",
url: "ajax.php",
data: dataString,
cache: false,
success: function(html)
{
$(".subcat").html(html);
} 
});

});

});
</script>

<link href="SpryAssets/SpryValidationTextarea.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
</head>

<body>

<div id="stylized" class="myform">

<form id="form" name="add_prod" method="post" action="addprod.php" enctype="multipart/form-data">

<h2 align="center"><b>- Add Product -</b></h2>

<h3 align="right"><a href="retailer_home.php"><img src="Images/Main Menu/home_icon.png" width="50" height="50" /></a></h3>

<table width="1000" border="0">
    <tr>
    <td><p align="right">Product Name</p></td>
    <td><!--<span id="sprytextfield2">
      <input type="text" name="prod_name" id="prod_name" />
      <span class="textfieldRequiredMsg">A value is required.</span></span>-->
      <select name="prod_name" id="prod_name" class="prod_name">
      <option value="" selected="selected" disabled="disabled">Select Product Name</option>
      <?php
      getprod_name();
      ?>
      </select>
    </tr>
  <tr>
    <td><p align="right">Product Brand</p></td>
    <td><!--<span id="sprytextfield3">
      <input type="text" name="prod_brand" id="prod_brand" />
      <span class="textfieldRequiredMsg">A value is required.</span></span>
      <select name="prod_brand" class="prod_brand">
      </select>-->
      <span id="wait_1" style="display: none;">
      <img alt="Please Wait" src="Images/ajax-loader.gif"/>
      </span>
      <span id="result_1" style="display: none;"></span>

      </td>
  </tr>
  <tr>
    <td><p align="right">Product Description</p></td>
    <td><!--<span id="sprytextarea1">
    <textarea name="prod_desc" id="prod_desc" cols="45" rows="5"></textarea>
    <span class="textareaRequiredMsg">A value is required.</span><span class="textareaMaxCharsMsg">Exceeded maximum number of characters.</span></span>-->
    <span id="wait_2" style="display: none;">
    <img alt="Please Wait" src="Images/ajax-loader.gif"/>
    </span>
    <span id="result_2" style="display: none;"></span>
    </td>
  </tr>
  <tr>
    <td><p align="right">Product Price (MRU)</p></td>
    <td><span id="sprytextfield4">
    <input type="text" name="prod_price" id="prod_price" />
    <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td>
  </tr>
  <tr>
    <td><p align="right">Product Category</p></td>
    <td><span id="spryselect1">
      <select name="cat" class="cat">
        <option selected="selected">--Select Category--</option>
        <?php
            include('db_connect.php');
            $sql=mysql_query("select id,cat_name from tblprod_cat ORDER BY id ASC");
            while($row=mysql_fetch_array($sql))
            {
            $id=$row['id'];
            $data=$row['cat_name'];
            echo '<option value="'.$id.'">'.$data.'</option>';
            } 
        ?>
      </select>
      <span class="selectRequiredMsg">Please select an item.</span></span></tr>
  <tr>
    <td><p align="right">Product Subcategory</p></td>
    <td><span id="spryselect2">
      <select name="subcat" class="subcat">
        <option>--Select Subcategory--</option>
      </select>
      <span class="selectRequiredMsg">Please select an item.</span></span></td>
  </tr>
  <tr>
    <td><p align="right">Product Weight/Capacity</p></td>
    <td><span id="sprytextfield5">
      <input type="text" name="prod_w_c" id="prod_w_c" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
 <!-- <tr>
    <td><p align="right">Please choose a file:</p></td>
    <td><input name="uploaded" type="file" /></td>
  </tr>-->
</table>
<p align="center">
  <input type="submit" class="button" name="button" id="button" value="<-- Add product -->"/>
</p>

</form>

</div>
<script type="text/javascript">
var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4", "currency", {validateOn:["blur"]});
var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "none", {validateOn:["blur"]});
var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["blur"]});
var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2", {validateOn:["blur"]});
</script>
</body>
</html>

addprod.php

<?php

include('db_connect.php');

session_start();

$username = $_SESSION['username'];

$sql=mysql_query("select user_id from tbllogin where username = '$username'");

$prod_name=$_POST['prod_name'];
$prod_brand=$_POST['prod_brand'];
$prod_price=$_POST['prod_price'];
$cat=$_POST['cat'];
$subcat=$_POST['subcat'];
$prod_w_c=$_POST['prod_w_c'];
$url='add_prod.php';


$row=mysql_fetch_array($sql); 

$sql=mysql_query("INSERT INTO tbl_product(user_id, prod_name, prod_brand, prod_price, cat, subcat, prod_w_c) VALUES('$row[user_id]', '$prod_name', '$prod_brand', '$prod_price', '$cat', '$subcat', '$prod_w_c')");

    echo '<META HTTP-EQUIV=Refresh CONTENT="0; URL='.$url.'">';
    echo "<script>alert('This product has been added successfully.')</script>";


?>

func.php

<?php
//**************************************
//     Page load dropdown results     //
//**************************************
function getprod_name()
{
    $result = mysql_query("SELECT DISTINCT prod_name FROM tbl_prodstd") 
    or die(mysql_error());

      while($tier = mysql_fetch_array( $result )) 

        {
           echo '<option value="'.$tier['prod_name'].'">'.$tier['prod_name'].'</option>';
        }

}

//**************************************
//     First selection results     //
//**************************************
if(isset($_GET['func']) && $_GET['func'] == "prod_name") {  
   prod_name($_GET['drop_var']); 
}

function prod_name($drop_var)
{  
    include_once('db_connect.php');
    $result = mysql_query("SELECT * FROM tbl_prodstd WHERE prod_name='$drop_var'") 
    or die(mysql_error());

    echo '<select name="prod_brand" id="prod_brand">
          <option value=" " disabled="disabled" selected="selected">Choose one</option>';

           while($drop_2 = mysql_fetch_array( $result )) 
            {
              echo '<option value="'.$drop_2['prod_brand'].'">'.$drop_2['prod_brand'].'</option>';
            }

    echo '</select> ';
    //echo '<input type="submit" name="submit" value="Submit" />';
    echo "<script type=\"text/javascript\">
$('#wait_2').hide();
    $('#prod_brand').change(function(){
      $('#wait_2').show();
      $('#result_2').hide();
      $.get(\"func.php\", {
        func: \"prod_brand\",
        drop_var: $('#prod_brand').val()
      }, function(response){
        $('#result_2').fadeOut();
        setTimeout(\"finishAjax_tier_three('result_2', '\"+escape(response)+\"')\", 400);
      });
        return false;
    });
</script>";
}

//**************************************
//     Second selection results     //
//**************************************
if(isset($_GET['func']) && $_GET['func'] == "prod_brand") {
   drop_2($_GET['drop_var']); 
}

function drop_2($drop_var)
{  
    include_once('db_connect.php');
    $result = mysql_query("SELECT * FROM tbl_prodstd WHERE prod_brand='$drop_var'") 
    or die(mysql_error());

    /*echo '<select name="prod_desc" id="prod_desc">
          <option value=" " disabled="disabled" selected="selected">Choose one</option>';*/

           while($drop_3 = mysql_fetch_array( $result )) 
            {
              /*echo '<option value="'.$drop_3['prod_desc'].'">'.$drop_3['prod_desc'].'</option>';*/
              echo "<textarea>".$drop_3['prod_desc']."</textarea>";
            }

    /*echo '</select> ';*/

}

?>

how can i write the code to add std_id, prod_desc and prod_photo to the tbl_product?

mysql

1 Contributor
1 Reply
331 Views
1 Day Discussion Span
Latest Post 10 Years Ago Latest Post by sanbhu2105

Reply to this topic

Be a part of the DaniWeb community

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

sanbhu2105 0 Light Poster · Answer 1 · 2013-06-28T14:26:14+00:00

sanbhu2105 0 Light Poster

10 Years Ago

i managed to sort this one out