PHP - Moved: Insert Data To A Table

Hi? im just a beginner in php i just want to ask how to insert a data into a table from a dropdown list. I have concatenate the itemid and description to form the dropdown list. But when i viewed my item_table the itemid and description columns are null. can you help me with this..
this is my php code for the dropdown list...
         <?php
         $query = "SELECT CONCAT(itemid,' ', '-',' ', description) AS Item FROM item_table";
         
         $result = mysql_query($query) or die(mysql_error());
         
         $dropdown = "<SELECT CONCAT(itemid,' ' '-',' ', description) AS Item FROM item_table>";

         while($row = mysql_fetch_assoc($result)) {

         $dropdown .= "\r\n<option value='{$row['Item']}'>{$row['Item']}</option>";

         }
         $dropdown .= "\r\n</select>";

         echo $dropdown;
         ?>

this my code for inserting data into the item_table...

<?php
if(isset($_POST ['submit']))
{
   $itemid = $_POST['itemid'];
   $description = $_POST['description'];
   $datein  = $_POST['datein'];
   $qtyin  = $_POST['qtyin'];
   $unitprice  = $_POST['unitprice'];
   $unit  = $_POST['unit'];
   $category  = $_POST['category'];
   $empid = $_POST['empid'];   
   $message ='';   
   if(($itemid && $description == "")||($itemid && $description == null))
   {
         header("location:IncomingEntry.php?msg=Incorrect");
         exit();
   }
   else
   {
      $link = mysql_connect('localhost', 'root', '') or die(mysql_error());
      $db_selected = mysql_select_db('inventory', $link);
      $message='';      
      $query = "INSERT INTO incoming_table (itemid , description,  datein,  qtyin, unitprice, unit, category, empid) VALUES ('".$itemid."',  '".$description."', '".$datein."',  '".$qtyin."', '".$unitprice."', '".$unit."', '".$category."', '".$empid."')";
      
      if (!mysql_query($query,$link))
      {
        die('Error: ' . mysql_error());
      }
      header("location: IncomingEntry.php?msg=1 record added");   
   }
}
?>

 

Hi guys, im inserting data into the table using drop-down list & multi select list,well it works very well. but i need to make sure i should not insert same StudentID & CourseID twice. here my code for you could anyone tell me pls where should i write code to check existing data?
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
$result  = mysql_query("SELECT * FROM student") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name="sid">';

while($row = mysql_fetch_array($result))
{

    echo '<option value="' . $row['StudentID'] . '">' . $row['StudentName'] . '</option>';
}

echo '</select>';

// ----------------

?>
</div>
<div class="style41" id="Layer7">

<?php
$result  = mysql_query("SELECT * FROM course") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name ="cid[]" multiple="multiple" size="10">';

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

echo '</select>';
mysql_close($con);
?>


------------------------------------
<?php

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
   
 if (!empty($_POST['sid']) && !empty($_POST['cid'])) 
{
    $ct = 0;
    $student = $_POST['sid'];
    foreach ($_POST['cid'] as $key => $course)
    {
     $sql = "INSERT INTO take (StudentID, CourseID) VALUES('".mysql_real_escape_string($student)."',
 '".mysql_real_escape_string($course)."')";
     $query = mysql_query($sql) or trigger_error('MySQL error: ' . mysql_error());
     if (mysql_affected_rows() > 0){$ct++;}
     }
    echo $ct . ' rows added.';
 }  

mysql_close($con);

?>

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table.   I have the following which does hafl the job, can I get some pointers on the rest.  I have looked everywhere and not found a solution, at all.


// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
    die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>



Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
       SELECT ID FROM wp_posts

            WHERE post_title LIKE '%future%'
            AND post_status = 'publish'
            OR post_title LIKE '%option%'
            AND post_content LIKE '%fundamental%'
            AND post_status = 'publish'

            ORDER BY post_date DESC

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

Hi,
Hope somebody can help me because I am relatively new to PHP and I am currently unsure how to implement the following:

Let's assume I have a table like this id_number, name, data1, data2. When displayed on HTML page:
Column id_number should be hidden.
Column name is a link. When you click on this column then value stored in id_number should be used in a query to database. Result should be displayed below the link on the same page. When clicked again data should hide.

I have some idea how to toggle visibility with a simple javascript function. How do i populate the table with hidden data and then extract it later on?

Any help or suggestions are appreciated. Thanks.

I'm creating a report page and can't figure out how to retrieve multiple rows from a table and display them in html. There are 5 data elements in each row and I'm thinking that using a form in the html might be the best way as I'm totally ignorant about tables in html. I'm a newbie to php and can't figure out how to accomplish this. Here's the code that I have so far:

<?php
$filename = NULL;
session_start();
// start of script every time.

//  setup a path for all of your canned php scripts
$php_scripts = '../php/'; // a folder above the web accessible tree
//  load the pdo connection module  
require $php_scripts . 'PDO_Connection_Select.php';

//*******************************
//   Begin the script here
// Connect to the database

if (!$con = PDOConnect("foxclone")):
{
    echo "Failed to connect to database" ;
    exit;
}
else:
{
    $sql = 'SELECT COUNT(IP_ADDRESS) FROM download WHERE FILENAME IS NOT NULL'; 

    $sql1 = 'Update  download t2, ip_lookup t1 set t2.country = t1.country, t2.area = t1.area, t2.city = t1.city where ((t2.IP_ADDRESS) = (t1.start_ip) OR (t2.IP_ADDRESS) > (t1.start_ip)) AND ((t2.IP_ADDRESS) = (t1.end_ip) OR (t2.IP_ADDRESS) < (t1.end_ip)) AND (t2.FILENAME is not null and t2.country is null)';

    $sql2 = 'SELECT (IP_ADDRESS, FILENAME, country, area, city) from download where FILENAME is not null';

// Update the table
    $stmt = $con->prepare($sql1);
    $stmt->execute();  

// Get count of rows to be displayed in table
    $stmt = $con->prepare($sql);
    $stmt->execute() ;
    $cnt = $stmt->fetch(PDO::FETCH_NUM);

// retrieve one row at a time
    $i = 1;
    while($i <= $cnt){
      $stmt = $con->prepare($sql2);
      $row->execute(array(''));  // Do I need an array here?
// from here on, I'm lost

    $i++;

I'd appreciate any guidance you can provide or understandable tutorials you can point me to.

Larry     

I am not sure if the title is correct; I tried my best. I'm a PHP/MySQL beginner and I really need some help. I have a small script that I am using for sending SMS. I recently added a phonebook. The problem with the phonebook right now is that it's available to all users, i.e. they can all update and delete all rows. What I would like to do is make it so that each user can update and delete only their own contacts. I have a table call contacts. Inside that table there is first name, last name, company and phonenumber. How can I accomplish this with PHP & MySQL?

CREATE TABLE IF NOT EXISTS `contacts` (
`contact_id` int(10) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`company` varchar(255) NOT NULL,
`cell_no` text NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(30) NOT NULL,
`uname` varchar(30) NOT NULL,
`u_pass` varchar(60) NOT NULL,
`utype` varchar(30) NOT NULL,
`timezone` varchar(30) NOT NULL,
`uapi_user` varchar(30) NOT NULL,
`uapi_pass` varchar(60) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

<?php
if (isset($_POST['submit'])){
    //form has been submitted1
    $firstname  = trim($_POST['firstname']);
    $lastname   = trim($_POST['lastname']);
    $company    = trim($_POST['company']);
    $cellno = trim($_POST['cell_no']);

    if($firstname == ''){
        echo '<div class="alert alert-danger">First Name is not Valid!</div>';
        exit;
    }elseif($lastname == ''){   
        echo '<div class="alert alert-danger">Last Name is not Valid!</div>';
        exit;
    }elseif($company == ''){    
        echo '<div class="alert alert-danger">Company is not Valid!</div>';
        exit;
    }elseif($cellno == ''){ 
        echo '<div class="alert alert-danger">Cellphone Number is not Valid!</div>';
        exit;

    }else{

        $query = "Select cell_no from contacts where cell_no = '".$cellno."' ";
        $result = mysql_query($query);
        if (!mysql_num_rows($result)) {

        $sql = "INSERT INTO contacts(firstname, lastname, company, cell_no)
                            values('{$firstname}','{$lastname}', '{$company}', '{$cellno}')";
        $result = mysql_query($sql);
        confirm_query($result);

        //echo '<div class="alert alert-success">Successfully added.</div>';
        //exit;
        ?>
                    <script type="text/javascript">
            window.location = "contact_list.php";
        </script>
    <?php
    }
    else{

        echo '<div class="alert alert-danger">Username. already exist!.</div>';
        echo '<p><a href="new_contact.php" class="btn btn-success"> Back </a></p>';
        exit;

    }}

}else{
    $firstname  = "";
    $lastname   = "";
    $company    = "";
    $cellno = "";
}

?>

Hi..

Sorry, if I need to repost my problem in while loop. cause until now I can't resolve my problem in saving all data from while loop.

I have this code StockRequisition.php where FORM was displayed.

<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);
        
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }        
            
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['sr_number'],0,3));
            
            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }                                           
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);   
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items1 = document.getElementById("Items1").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
    
    document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy;
    document.stock_requisition.submit();
    alert("Stock Requisition data save.");
    window.location = "StockRequisition.php";
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>

</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">    
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/> 
</div> 
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";       
     
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 
 while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items1 = $row_sub['Items'];
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];         
     
    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>     
        </tr>";
}
}   
   
               
?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB', 'CCC', 'DDD');
   
   $ApprovedBy = array('EEE', 'FFF', 'GGG', 'HHH');
   
   $ReceivedBy = array('III', 'JJJ', 'KKK', 'LLL');
   
   $IssuedBy = array('MMM', 'NNN', 'OOO', 'PPP'); 

?>

 <div id='Requested_By'>
<label>Requested By:</label>
 <select name="RequestedBy">
 <option value="Select">Select</option>
 <option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
 <option value="CCC" <?php if($_POST['RequestedBy'] == 'CCC') echo "selected='selected'"; ?>>CCC</option>
  <option value="DDD" <?php if($_POST['RequestedBy'] == 'DDD') echo "selected='selected'"; ?>>DDD</option>
 </select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
 <option value="GGG" <?php if($_POST['ApprovedBy'] == 'GGG') echo "selected='selected'"; ?>>GGG</option>
  <option value="HHH" <?php if($_POST['ApprovedBy'] == 'HHH') echo "selected='selected'"; ?>>HHH</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
 <option value="KKK" <?php if($_POST['ReceivedBy'] == 'KKK') echo "selected='selected'"; ?>>KKK</option>
  <option value="LLL" <?php if($_POST['ReceivedBy'] == 'LLL') echo "selected='selected'"; ?>>LLL</option>

</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>
 <option value="OOO" <?php if($_POST['IssuedBy'] == 'OOO') echo "selected='selected'"; ?>>OOO</option>
  <option value="PPP" <?php if($_POST['IssuedBy'] == 'PPP') echo "selected='selected'"; ?>>PPP</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()">
</div>
</form>
</body>
</html>



and here is StockRequisitionSave.php
code for saving data to database :


<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items1 = $_POST['Items1'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items1', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
";  

$result = mysql_query($sql, $con);            
?>


the problem is only the last data was save.

I will attach my form.

I hope somebody can help me..
I really don't know how can I save all data from form into my database.

Thank you so much for your understanding and help.

Hi Team,

I have a php page where I have taken the same userid and linked in the next page and also used show/hide function.

I am able to see that the userid is linking but when i submit the data is not getting insert and also no error

Please help

below is the Tower.php file.

Code: [Select]
<!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=iso-8859-1" />
<title>BHP2</title>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
width:1005px;
height:578px;
z-index:1;
left: 157px;
top: 1px;
background-color: #993399;
}
#Layer2 {
position:absolute;
width:939px;
height:114px;
z-index:1;
left: 35px;
top: 35px;
}
#Layer3 {
position:absolute;
width:451px;
height:169px;
z-index:2;
left: 270px;
top: 296px;
}
#Layer4 {
position:absolute;
width:608px;
height:68px;
z-index:2;
left: 273px;
top: 10px;
}
#Layer5 {
position:absolute;
left:82px;
top:188px;
width:973px;
height:52px;
z-index:2;
}
#Layer6 {
position:absolute;
width:243px;
height:106px;
z-index:2;
left: 68px;
top: 43px;
}
.style1 {
font-size: xx-large;
font-style: italic;
}
.style2 {font-size: 52px}
#Layer7 {
position:absolute;
width:824px;
height:271px;
z-index:2;
left: 44px;
top: 237px;
}
.style4 {
font-size: xx-large;
font-style: italic;
font-weight: bold;
color: #FF9933;
}
#Layer8 {
position:absolute;
width:800px;
height:139px;
z-index:2;
left: 31px;
top: 67px;
}
#Layer9 {
position:absolute;
width:610px;
height:30px;
z-index:2;
left: 34px;
top: 70px;
}
#Layer10 {
position:absolute;
width:611px;
height:25px;
z-index:2;
left: 33px;
top: 110px;
}
#Layer11 {
position:absolute;
width:614px;
height:30px;
z-index:2;
left: 33px;
top: 152px;
}
#Layer12 {
position:absolute;
width:615px;
height:29px;
z-index:2;
left: 32px;
top: 193px;
}
#Layer13 {
position:absolute;
width:187px;
height:35px;
z-index:2;
left: 318px;
top: 239px;
}
-->
</style>
</head>

<body>

<div id="Layer1">
<form id="form5" name="form5" method="link" action="Insert.php">
  <div id="Layer2">
    <div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="65" alt="BHP" /></div>
    <h1 align="center">&nbsp;</h1>
    <div class="style1" id="Layer4">     
      <h1 align="center" class="style2">BHP DATA TRACKER </h1>
    </div>
  </div>
  <div id="Layer7">
    <div align="center"><span class="style4">SELECT THE TOWER BELOW </span>
      <div id="Layer13">
       
  <input type="hidden" name="empid" value="<?php echo $_GET['id']; ?>" size="20">
          <input type="hidden" name="date" value="<?php echo date("Y-m-d H:i:s"); ?>" >
       <input type="submit" name="B1" value="Start !" />
     
      </div>
      <div id="Layer12">
        <div align="left">
         
            <input name="rad1" type="radio" value="RF" id="rad1"  />
            <label >RF</label>
         
        </div>
      </div>
      <div id="Layer11">
        <div align="left">
           <input name="rad1" type="radio" value="ISAP" id="rad1" />
            <label >ISAP</label>
         
        </div>
      </div>
      <div id="Layer10">
        <div align="left">
            <input name="rad1" type="radio" value="GSD" id="rad1" checked="checked" />
            <label >GSD</label>
         
        </div>
      </div>
      <div id="Layer9">
        <div align="left">
            <input name="rad1" type="radio" id="rad1" value="CSD"  />
            <label>CSD</label>
          </p>
        </div>
      </div>
      <br />
    </div>
  </div>
 </form>
</div>
</body>
</html>


Below is the insert.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">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP DATA SUMBIT</title>
<?php
include ("count.php");
?>

<?php
if(isset($_GET['action']))
{
$action = $_GET['action'];
if ($action = 'yes')
{
include ("Connection.php");
$PName = $_POST['rad11'];
$Date = date("Y-m-d H:i:s");
$empidno = $_POST['idd'];
$qsdate = $_POST['testinput'];
$cb1 = $_POST['chkbox1'];
$cb2 = $_POST['chkbox2'];
$cb3 = $_POST['chkbox3'];
$cb4 = $_POST['chkbox4'];
$cb5 = $_POST['chkbox5'];
$Com = $_POST['textfield2'];
$dd1 = $_POST['textfield'];
$dd2 = $_POST['select'];
$dd3 = $_POST['select2'];
$dd4 = $_POST['textfield4'];
$dd5 = $_POST['textfield3'];
$dd6 = $_POST['select3'];
$sev = $_POST['radio1'];
$olddate = $_POST['odate'];
$pname = $_POST['radiobutton'];

$query="INSERT INTO bhp ticketinformation (`userid`, 
`processname`, 
`begindate`, 
`dateposted`, 
`CALL`, 
`EMAIL`, 
`NEW`, 
`EXISTING`, 
`Piroty`, 
`MTICKET`, 
`Services`, 
`group1`,
`group2`, 
`Icall`, 
`Tcreatedtime`, 
`comment`) 
VALUES ( '$empidno' , '$pname' , '$olddate' ,  '$Date' ,  '$cb1' , '$cb2' , '$cb3' , '$cb4' , '$sev' , '$dd1' , '$dd2' , '$dd3' , '$dd4' , '$dd5' , '$dd6' , '$Com')";
mysql_query($query);
Header('location:tower.php?id=' . $empidno);
}
}
?>
<head>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
width:1023px;
height:592px;
z-index:1;
left: 167px;
top: 2px;
background-color: #993399;
}
#Layer2 {
position:absolute;
width:939px;
height:114px;
z-index:1;
left: 59px;
top: 3px;
}
#Layer3 {
position:absolute;
width:451px;
height:169px;
z-index:2;
left: 270px;
top: 296px;
}
#Layer4 {
position:absolute;
width:608px;
height:68px;
z-index:2;
left: 273px;
top: 10px;
}
#Layer5 {
position:absolute;
left:82px;
top:188px;
width:973px;
height:52px;
z-index:2;
}
#Layer6 {
position:absolute;
width:238px;
height:69px;
z-index:2;
left: 68px;
top: 43px;
}
.style1 {
font-size: xx-large;
font-style: italic;
}
.style2 {font-size: 52px}
#Layer7 {
position:absolute;
width:979px;
height:209px;
z-index:2;
left: 32px;
top: 181px;
}
#Layer8 {
position:absolute;
width:194px;
height:36px;
z-index:1;
left: 25px;
top: 15px;
}
#Layer9 {
position:absolute;
width:178px;
height:37px;
z-index:2;
left: 249px;
top: 13px;
}
#Layer10 {
position:absolute;
width:193px;
height:34px;
z-index:3;
left: 443px;
top: 13px;
}
#Layer11 {
position:absolute;
width:204px;
height:32px;
z-index:4;
left: 670px;
top: 15px;
}
#Layer12 {
position:absolute;
width:195px;
height:40px;
z-index:5;
left: 28px;
top: 73px;
}
#Layer13 {
position:absolute;
width:182px;
height:38px;
z-index:6;
left: 250px;
top: 76px;
}
#Layer14 {
position:absolute;
width:197px;
height:36px;
z-index:7;
left: 446px;
top: 77px;
}
#Layer15 {
position:absolute;
width:214px;
height:35px;
z-index:8;
left: 670px;
top: 77px;
}
#Layer16 {
position:absolute;
width:315px;
height:45px;
z-index:9;
left: 16px;
top: 144px;
}
#Layer17 {
position:absolute;
width:343px;
height:43px;
z-index:10;
left: 339px;
top: 145px;
}
#Layer18 {
position:absolute;
width:258px;
height:48px;
z-index:11;
left: 708px;
top: 146px;
}
#Layer19 {
position:absolute;
width:321px;
height:60px;
z-index:3;
left: 59px;
top: 419px;
}
#Layer20 {
position:absolute;
width:197px;
height:41px;
z-index:1;
left: 27px;
top: 6px;
}
#Layer21 {
position:absolute;
width:193px;
height:36px;
z-index:2;
left: 249px;
top: 7px;
}
#Layer22 {
position:absolute;
width:207px;
height:38px;
z-index:3;
left: 453px;
top: 7px;
}
#Layer23 {
position:absolute;
width:237px;
height:36px;
z-index:4;
left: 677px;
top: 9px;
}
#Layer24 {
position:absolute;
width:245px;
height:45px;
z-index:5;
left: 399px;
top: 2px;
}
#Layer25 {
position:absolute;
width:99px;
height:31px;
z-index:6;
left: 288px;
top: 121px;
}
#Layer26 {
position:absolute;
width:87px;
height:29px;
z-index:7;
left: 439px;
top: 123px;
}
-->
</style>

<script language="JavaScript" >
function showInfo()
{
var elem = document.getElementById('verify');
if(document.testform.select3.value == "verify" || document.testform.select3.value == "verify1" )
{
elem.style.display="inline";
}
else
{
elem.style.display="none";
}
}
</script>

<script language="JavaScript">

function validator()
{
if(document.testform.Checkbox1.checked == false &&
document.testform.Checkbox2.checked == false &&
document.testform.Checkbox3.checked == false &&
document.testform.Checkbox4.checked == false)
{
alert ('You did not choose any of the checkboxes!');
return false;
}
if (document.testform.textfield.value =="")
  {
  alert("Enter Max Ticket No");
  return false;
  }
if (document.testform.select.value == "" || document.testform.select.value == "SELECT SERVICE DROP DOWN")
{
alert ('Select the SELECT SERVICE DROP DOWN');
return false;
}
if (document.testform.select2.value == "" || document.testform.select2.value == "SELECT RG GROUP")
{
alert ('SELECT RG GROUP');
return false;
}
if (document.testform.select3.value == "" || document.testform.select3.value == "SELECT GROUPS")
{
alert ('SELECT GROUPS');
return false;
}
if (document.testform.textfield2.value =="")
  {
  alert("Comments Feild is Empty.If there are no Comment then type NA(Not Applicable)");
  return false;
  }
if (document.testform.Checkbox1.checked == false)
document.getElementById("chkbox1").value = "";
else
document.getElementById("chkbox1").value = "EMAIL";
if (document.testform.Checkbox2.checked == false)
document.getElementById("chkbox2").value = "";
else
document.getElementById("chkbox2").value = "NEW";
if (document.testform.Checkbox3.checked == false)
document.getElementById("chkbox3").value = "";
else
document.getElementById("chkbox3").value = "EXISTING";
if (document.testform.Checkbox4.checked == false)
document.getElementById("chkbox4").value = "";
else
document.getElementById("chkbox4").value = "CALL";
alert('Record has been posted in the portal');
}
</script>
</head>

<body>
<div id="Layer1">
  <div id="Layer2">
    <div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="67" alt="BHP" /></div>
    <h1 align="center">&nbsp;</h1>
    <div class="style1" id="Layer4">     
      <h1 align="center" class="style2">BHP DATA TRACKER </h1>
    </div>
  </div>
  <div id="Layer7">

         <form method="POST" action="Insert.php?action=yes&&id=<?php echo $_GET['empid']; ?>" name="testform" onSubmit="return validator();">

    <div id="Layer8">
     
          <input type="checkbox" id="Checkbox4" name="checkbox4" value="CALL" />
          CALL</label>
     
    </div>
    <div id="Layer9">
   
        <label>
          <input type="checkbox" id="Checkbox1" name="checkbox1" value="EMAIL" />
          EMAIL</label>
   
    </div>
    <div id="Layer10">
 
        <label>
          <input type="checkbox" id="Checkbox2" name="checkbox2" value="NEW" />
          NEW</label>
     
    </div>
    <div id="Layer11">

        <label>
          <input type="checkbox" id="Checkbox3" name="checkbox3" value="EXISTING" />
          EXISTING</label>
 
    </div>
    <div id="Layer12">
   
        <label>
          <input name="radio1" type="radio" id="radio1" value="P1" checked="checked" />
          P1</label>
 
    </div>
    <div id="Layer13">
     
        <label>
          <input name="radio1" type="radio" id="radio1" value="P2" />
          P2</label>
     
    </div>
    <div id="Layer14">
 
        <label>
          <input name="radio1" type="radio" id="radio1" value="P3" />
          P3</label>
   
    </div>
    <div id="Layer15">
     
        <label>
          <input name="radio1" type="radio" id="radio1" value="P4" />
          P4</label>
     
    </div>
    <div id="Layer16">
 
        <label>MAXIMUM TICKET
          <input type="text" name="textfield" />
        </label>
     
    </div>
    <div id="Layer17">

        <label>SERVICE DROP DOWN
          <select name="select" style="width: 162px; height: 23px">
            <option>SELECT SERVICE DROP DOWN</option>
            <option>OTHER(FW)</option>
            <option>1 MESSAGE</option>
            <option>1 MOBILITY</option>
            <option>1 VOICE</option>
            <option>1 SAP</option>
            <option>1 PORTAL</option>
            <option>1 COLLAB</option>
            <option>1 GSAP</option>
            <option>1 SECURITY</option>
            <option>1 WAN</option>
            <option>S DOMAIN</option>
            <option>1 AUTH</option>
            <option>1 DOCM</option>
            <option>1 REMOTE</option>
          </select>
        </label>
     
    </div>
    <div id="Layer18">
     
        <label>RG GROUP
          <select name="select2" style="width: 162px; height: 23px">
            <option>SELECT RG GROUP</option>
            <option>I-AM-AU-AM-HWT</option>
            <option>I-EUS-IN-CSC-DSK-CSD</option>
            <option>I-EUS-IN-CSC-DSK-GSD</option>
            <option>I-EUS-GB-DCS-BHPVICFW</option>
            <option>I-ITS-AU-HW</option>
            <option>I-SRM-AU-IAM-LAMU</option>
            <option>I-ITS-AU-SW</option>
            <option>C-BHP-AU-CSC-LSD-NONBRG</option>
            <option>C-BHP-AU-ACN-AQM</option>
          </select>
        </label>
     
    </div>
  </div>
  <div id="Layer19">
 
   <label>SELECT GROUPS
          <select name="select3"  onchange="showInfo()" style="width: 162px; height: 23px">
            <option value="none" >SELECT GROUPS</option>
<option value="verify">TP</option>
            <option value="verify1">OA</option>
            <option>OC</option>
            <option>OTHERS</option>
      </select>
    </label>
    <div id="verify" style="display:none;">

<br/><br/>
<label>INCOMING CALL/EMAIL TIME
          <input type="text" name="textfield4" />
      </label>
<br/><br/>
<label>MAXIMO TICKET CREATED TIME
          <input type="text" name="textfield3" />
      </label>
</div>

    <div id="Layer24">
   
        <label>COMMENTS
          <input type="text" name="textfield2" />
        </label>
     
  </div>
    <div id="Layer26">
   
        <input name="Reset" type="reset" id="Reset" value="Reset" />
     
  </div>
    <div id="Layer25">
        <input type="submit" name="Submit" value="Submit" />
<input type="hidden" name="chkbox1" id="chkbox1" />
    <input type="hidden" name="chkbox2" id="chkbox2" />
    <input type="hidden" name="chkbox3" id="chkbox3" />
    <input type="hidden" name="chkbox4" id="chkbox4" />
<input type="hidden" name="chkbox5" id="chkbox5" />
<input type="hidden" name="rad11" id="rad11" value="<?php echo $_GET['rad1']; ?>" />
     <input type="hidden" name="idd" id="idd" value="<?php echo $_GET['empid']; ?>" />
<input type="hidden" name="odate" id="odate" value="<?php echo $_GET['date']; ?>" />
  </form>
 
</div>
</div>
</div>
</body>
</html>


THANKS IN ADVANCED

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

I have this form. The name of the field is an id of a row in a table. When the user inputs the information into the field, it goes to another page that processes the information. This is the code on the page that processes it:

Code: [Select]
while ($ids = mysql_fetch_array($getIDs) {

$staffID = $ids['id']; //id is the column name in my table

$value = $_POST['$staffID'];


But when I echo $value, it doesn't echo anything. I have made sure that there is a value in the field and if, instead of $_POST['$staffID'], I type a specific ID such as, $_POST['55485'], it will output the value entered in that field. I have not yet grasped the concept of arrays yet so that's why I'm not using one here. Can you just not put a variable in $_POST? Thanks.

Hi guys,

I have an array:

array 
(
[apple]=> red,
[orange] => orange,
[banana] => yellow
)

That I want to insert into the apidata table, the PDO connection is good so I guess my code is wrong:

    $mykeys = implode(', ', array_keys($newarr));
    
    $myplaceholders[] = '(' . implode (", ", array_fill(0, count($newarr), '?')) . ')';
    
    $values = array_values($newarr);

$res = $db->prepare("INSERT INTO apidata (item, value) VALUES $myplaceholders") ;

$res->execute([$mykeys, $values]); 

The apidata table has three fields id (auto_increment) item and value, where am I going wrong?

Thanks

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method. After I implemented insert method to my control.php and execute it, it cannot works and cannot store.

Is there a way to send exploded data into a database without using multiple loops just to do so? My current code, but it only inserts the name value in the database as Array.

$chicken_names = mysql_real_escape_string($_POST['names']);

$chicken_names_exp = explode(' ', $_POST['names']);

foreach($chicken_names_exp as $value)

{

mysql_query("INSERT INTO names VALUES (null, '$chicken_names_exp"', '". $_POST['type'] ."')");

}

echo "Success! You have successfully sent in your chicken names! <a href='index.php'>Home</a>";

i have created a shopping cart.but i dont know how i can add all the choosen data into a database.i just follow the step from youtube.i want to know how i can add one button so all the product will be recorded into database because it already have 1 button to update the shopping cart but it do not have button to record all the choosen product.   here is all the file that i have created.   index2.php

<?
session_start();
error_reporting(E_ALL);
require("connection.php");
if(isset($_GET['page'])){

	$pages=array("products", "cart");
	if(in_array($_GET['page'], $pages)) {
	
		$_page=$_GET['page'];
	
	}else{
	
		$_page="products";
	
	}
	
}else{

$_page="products";

}
?>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>


<body>
</body>
</html>

<link rel="stylesheet" href="style2.css" />

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

<script type="text/javascript">
$(function() {

});
</script> 
</head>

<body>
<div id="container">

<div id="main">
<?php require($_page.".php");     ?>

</div>

<div id="sidebar">
<h1>Cart</h1>

<?php 
if(isset($_SESSION['cart'])){

$sql="SELECT * FROM products WHERE id_product IN (";

foreach($_SESSION['cart'] as $id => $value) {
$sql.=$id.",";
}
$sql=substr($sql, 0, -1).") ORDER BY name ASC";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){

?>
<p><?php echo $row['name'] ?> x <?php echo $_SESSION['cart'][$row['id_product']]['quantity'] ?></p>
<?php }

?>

<hr />
<a href="index2.php?page=cart">Go to Cart</a>


<?php





}else{

echo "<p>Your Cart is empty</p>";

}
?>
</div>

</div>
</body>

products.php

<?php

	if(isset($_GET['action']) && $_GET['action']=="add"){
	
		$id=intval($_GET['id']);
		
		if(isset($_SESSION['cart'][$id])){
		
			$_SESSION['cart'][$id]['quantity']++;
		
		}else{
		
			$sql_s="SELECT * FROM products
				WHERE id_product={$id}";
			$query_s=mysql_query($sql_s);
			if(mysql_num_rows($query_s)!=0){
				$row_s=mysql_fetch_array($query_s);
				
					
					
					$_SESSION['cart'][$row_s['id_product']]=array(
							"quantity" => 1,
							"price" => $row_s['price']
							
							);
				
				
				}else{
				
					$message="This product id it's invalid!";
	

		}
		}
		}
		
		


?>


<h1>Product List</h1>
<?php 

	if(isset($message)){
	echo "<h2>$message</h2>";
	}
?>
<table>
<tr>
    <th>Name</th>
	<th>Description</th>
	<th>Price</th>
	<th>Action</th>
</tr>
<?php
$sql="SELECT * FROM products ORDER BY name ASC";

$query=mysql_query($sql);

while ($row=mysql_fetch_array($query)) {

?>
<tr>
	<td><?php echo $row['name'] ?></td>
	<td><?php echo $row['description'] ?></td>
	<td>RM <?php echo $row['price'] ?></td>
	<td><a href="index2.php?page=products&action=add&id=<?php echo $row['id_product'] ?>">Add To Cart</a></td>
</tr>
<?php
}
?>

</table>

cart.php

<?php
 if(isset($_POST['submit'])){
 
 foreach($_POST['quantity'] as $key => $val) {
 	if($val==0) {
	unset($_SESSION['cart'][$key]);
	}else{
	$_SESSION['cart'][$key]['quantity']=$val;
	
	}
	}
 
 
 }

?>



<a href="index2.php?page=products">Go back to product page</a>
<h1>View Cart</h1>

<form method="post" action"index2.php?page=cart">

<table>
<tr>
	<th>Name</th>
	<th>Quantity</th>
	<th>Price</th>
	<th>Item Price</th>



</tr>
<?php

	$sql="SELECT * FROM products WHERE id_product IN (";

foreach($_SESSION['cart'] as $id => $value) {
$sql.=$id.",";
}
$sql=substr($sql, 0, -1).") ORDER BY name ASC";
$query=mysql_query($sql);
$totalprice=0;
while($row=mysql_fetch_array($query)){
	$subtotal=$_SESSION['cart'][$row['id_product']]['quantity']*$row['price'];
	$totalprice+=$subtotal;

?>
<tr>
<td><?php echo $row['name'] ?></td>
<td><input type="text" name="quantity[<?php echo $row['id_product'] ?>]" size="5" value="<?php echo $_SESSION['cart'][$row['id_product']]['quantity'] ?>"</td>
<td>RM <?php echo $row['price'] ?></td>
<td>RM <?php echo $_SESSION['cart'][$row['id_product']]['quantity']*$row['price'] ?></td>



</tr>



<?php 
}

?>
<tr>
<td>Total Price: <?php echo $totalprice  ?></td>


</tr>

</table>
<button type="submit" name="submit"> Update Cart</button>


</form>
<br />
<p> To remove an item,set the quantity to 0</p>

HI,i am using java script to create a add row function in the php .but when the first row data can insert into database ,the 2nd row data cannot insert into database ,can help me to check my coding? thanks a lot


Code: [Select]
<SCRIPT language="javascript">
        function addRow(tableID) {
 
            var table = document.getElementById(tableID);
 
            var rowCount = table.rows.length;
            var row = table.insertRow(rowCount);
 
            var cell1 = row.insertCell(0);
            var element1 = document.createElement("input");
            element1.type = "checkbox";
            cell1.appendChild(element1);
 
         
            var cell2 = row.insertCell(1);
            var element2 = document.createElement("input");
            element2.type = "text";
            cell2.appendChild(element2);

var cell3 = row.insertCell(2);
            var element3 = document.createElement("input");
            element3.type = "text";
            cell3.appendChild(element3);

var cell4 = row.insertCell(3);
            var element4 = document.createElement("input");
            element4.type = "text";
            cell4.appendChild(element4);

var cell5 = row.insertCell(4);
            var element5 = document.createElement("input");
            element5.type = "text";
            cell5.appendChild(element5);

 
        }
 
        function deleteRow(tableID) {
            try {
            var table = document.getElementById(tableID);
            var rowCount = table.rows.length;
 
            for(var i=0; i<rowCount; i++) {
                var row = table.rows[i];
                var chkbox = row.cells[0].childNodes[0];
                if(null != chkbox && true == chkbox.checked) {
                    table.deleteRow(i);
                    rowCount--;
                    i--;
                }
 
            }
            }
catch(e) {
                alert(e);
            }
        }
 
    </SCRIPT>


THE PHP CODE
Code: [Select]
<?php 
require_once ('../../../Connections/admin_db.php'); 

mysql_select_db("admin_db");

if ((isset($_POST["Submit"])) && ($_POST["Submit"] == "Submit")) {
$i=0;
foreach($_POST['abc'] as $value )
{
   
                 $abc           = $_POST['abc'][$i];
 $level         = $_POST['level'][$i];
     $level_desc    = $_POST['level_desc'][$i];
      $pc_desc       = $_POST['pc_desc'][$i];
 
 
//Insert Data into Instructor Profile Info
$q = "INSERT INTO plo_pc(p_name,plo_id,plo_criteria,plo_level,level_dec,plo_desc)
VALUES ('$list','$plo_id','$abc','$level','$level_desc','$pc_desc') " ; 
 
mysql_query($q) or die(mysql_error()) ;
$i=$i+1;
}
}
?>