Learn VBA & Macros in 1 Week!

PHP - Exploded Data - Insert Into Db

Full Excel VBA Course - Beginner to Expert

Exploded Data - Insert Into Db	View Content

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>";

Full Excel VBA Course - Beginner to Expert

Help Using Data From An Exploded Array This Should Be So Simple For Anyone Else

Similar Tutorials

View Content

This is what I have now...im getting an undefined offset error, but $i should be set....unless my loop is a fail? I don't know...

<form action="<?php echo $_SERVER['PHP_SELF']; ?>"method="post">
  <label>URLs delimited by a COMMA</label>
  <textarea name="urls"></textarea>
  <input name="submit" type="submit" value="Submit" />
</form>
<?php
if (isset($_POST['submit'])) {
  $urls = trim($_POST['urls']); // remove white space from user input
  $arr = explode( ",", $urls);  // convert the input into an array
  $count = count($arr); // count the number of items in the array
  for ($i = 0; $i <= $count; $i++) { // setup the loop to stop iteration when $count is met
    echo '<pre><a href="' . $arr[$i] . '>' . $arr[$i] . '</a></pre>'; // Hopefully echo the link list back if all goes well...
  }
}
?>

Unable To Insert The Data Into Data Base

Similar Tutorials

View Content

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

</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"> </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">

</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"> </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

Insert Data To Database Where Data From While Loop

Similar Tutorials

View Content

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;'> <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;'> <input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'> <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;'> <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'> <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;'> <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;'> <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;'> <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.

Array Not Being Exploded Properly

Similar Tutorials

View Content

Code: [Select]
$teamLineUp=explode(";", $team['lineUp']); #This is the team line up
foreach ($teamLineUp as $value) echo "<BR>".$value;

this works fine and outputs what I want EXCEPT if a word has a ' in it; for example the name O'Reilly gets broken into 2 values "O" and "Reilly"; is there a way around this?

Displaying Only The First Part Of An Exploded Php String

Similar Tutorials

View Content

Hey guys I'm having an issue trying to get my PHP to display the first url of my exploded string and non of the others. The SQL table column contains strings like this:

http://www.imgurl.com/image.jpg,http://www.imgurl.com/image2.jpg,http://www.imgurl.com/image3.jpg,http://www.imgurl.com/image4.jpg

If Spaces Occurs 4 Times Or More Within Exploded Quotes...

Similar Tutorials

View Content

I keep having trouble with exploded arrays, every function i go to use within the exploded quotes requires a string not an array. Below im trying to count the spaces and if there are four or more change the data string to the halt string. The problem is most of the functions require a string, is there another way to only count the space characters within quotes without exploding the quotes?

Code: [Select]
$data = 'Hello World This is a test string!';
$halt = 'String had more than 4 spaces.';
$arr = explode('"', $data);
if (substr_count($arr, ' ') >= 4) {
$data = implode('"', $arr);
$data = $halt;

Get Word Count Index Within Exploded Array.

Similar Tutorials

View Content

I'm using the code below to on echo certain words based on their index/key value, this works fine however, im trying to only do this in exploded quotes... the problem is, exploding quotes turns the portion into an array which cant be passed to str_word_count... how can i do the same thing only inside quotes. So that hello world "this is a test" would become: Code: [Select]
Hello World This [0] => Is [1] => a [2] => Test [3]

Im trying to always remove say the 4th word in quotations, or maybe the 3rd and 4th, whatever i want to omit i leave out from the echo, so echo $data[0].' '.$data[3].'; would output "This Test" omitting "Is A"

Code: [Select]
$data = 'hello world "this is a test"';
$data = str_word_count($data, 1);
echo $data[1].' '.$data[2].' '.$data[0];

Insert Data

Similar Tutorials

View Content

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.

Cannot Insert Data Into A Database.. Please Help

Similar Tutorials

View Content

Everything on this page works the form loads and i can insert info into the form but when i click submit it just reloads the page(action="this page") and nothing happens.
thanks in advance
-Adam
Code: [Select]
<?php
require("connection/connection.php");
include("connection/functions.php");
?>
<HTML>
<head>
<meta content="yes" name="apple-mobile-web-app-capable" />
<meta content="index,follow" name="robots" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<link href="" rel="apple-touch-icon" />
<meta content="minimum-scale=1.0, width=device-width, maximum-scale=0.6667, user-scalable=no" name="viewport" />
<meta name="format-detection" content="telephone=no"/>
<link href="css/style.css" rel="stylesheet" media="screen" type="text/css" />
<script src="javascript/functions.js" type="text/javascript"></script>
<title>.: Bookmarks :.</title>
<link href="" rel="apple-touch-startup-image" />

<meta content="apple-mobile-web-app-status-bar-style" content="default" />
</head>
<body class="musiclist">
<div id="topbar">
<div id="title">.: Bookmarks :.</div>
<div id="leftbutton">
<a href="default.html"><img src="images/home.png"></a>
</div>
<div id="rightbutton">
<a href="">Programs</a>
</div>
</div>
<div id="tributton">
<div class="links">
<a id="pressed" href="Bookmarks/Bookmarks.php">Bookmarks</a><a href="Music/Music.html">Music</a><a href="">Movies</a>
</div>
</div>
<div id="content" style="top: 36px">
<form method="post" action="AddBookmark.php">
<span class="graytitle">Add Bookmark</span>
<ul class="pageitem">
<li class="bigfield"><input type="text" name="BookmarkName" placeholder="Bookmark Name" /></li>
<li class="bigfield"><input type="text" name="BookmarkLink" placeholder="Bookmark Link" /></li>
<li class="select"><select name="d">
<?php
                            $getbookmarksections = mysql_query("SELECT * FROM bookmarksections");
                            confirm_query($getbookmarksections);

                            while($getbm = mysql_fetch_array($getbookmarksections)){
$id = $getbm["ID"];
$sn = $getbm["SectionName"];
                             echo "<option value=\"$id\">$sn</option>";
                            }
                        ?>
</select><span class="arrow"></span></li>
<li class="button">
<input name="AddBookmark" type="submit" value="Add Bookmark" />
</li>
</ul>
</form>
<?php
if(isset($_POST["AddBookmark"])){
$SectionID = $id;
$Bookmark = $_POST["BookmarkName"];
$BookmarkLink = $_POST["BookmarkLink"];

$add = "INSERT INTO `bookmarks` (`ID` ,`SectionID` ,`Bookmark` ,`BookmarkLink`)
VALUES ('NULL', '$SectionID', '$Bookmark', '$BookmarkLink')";
  if(confirm_query($add)){
  echo "<span class=\"graytitle\">Bookmark '$BookmarkName' in '$sn' Added.</span>";
  }
}
                ?>
</div>
<div id="footer">
</div>
</body>
</HTML>
<?php
//Close Connection
if(isset($connection)){
mysql_close($connection);
}
?>
this is the code i suspect is not working
Code: [Select]
<?php
if(isset($_POST["AddBookmark"])){
        $SectionID = $id;
        $Bookmark = $_POST["BookmarkName"];
$BookmarkLink = $_POST["BookmarkLink"];

$add = "INSERT INTO `bookmarks` (`ID` ,`SectionID` ,`Bookmark` ,`BookmarkLink`)
VALUES ('NULL', '$SectionID', '$Bookmark', '$BookmarkLink')";
if(confirm_query($add)){
      echo "<span class=\"graytitle\">Bookmark '$BookmarkName' in '$sn' Added.</span>";
        }
}
?>

Xml And Pulling Data To Insert Into Db

Similar Tutorials

View Content

FOr some reason i cant pull data from an XML file to insert into the database, it works without error just adds a blank value in the database?

i have this code at the moment, i guess arrayValue[71] is the value i need to pull and add to the "TABLE2" table, but when i run the script it just adds a blank value in the database?

<?php
include "connect.php";

//Price check Isle 9001! Query EVE-Central API. Example XML file is: http://api.eve-central.com/api/marketstat?typeid=35&regionlimit=10000002
$queryItemList = mysql_query("SELECT * FROM TABLE2;") or die(mysql_error());
$rowCount = mysql_num_rows($queryItemList);
$s=0;
$typeArray = array();
$region = "regionlimit=10000002";
while($s<$rowCount){

$typeID = mysql_result($queryItemList,$s,"typeID");

echo $typeID."<br />";

//echo "start<br />";

$reader = new XMLReader();

//echo "initialized XMLReader<br />";

$url = "http://api.eve-central.com/api/marketstat?typeid=".$typeID;

echo $url.$region."<br />";

$reader->open($url.'&'.$region);

$t=0;

$arrayName = array();

$arrayValue

= array();

while ($reader->read()) {

//echo $reader->name;

$name = $reader->name;

$arrayName[$t] = $name;

if ($reader->hasValue) {

//echo ": " . $reader->value."<br />";

$value = $reader->value;

$arrayValue[$t] = $value;

}

$t++;

}

echo $arrayValue[71];

$import="UPDATE TABLE2 SET marketPrice='$arrayValue[71]' WHERE typeID='$typeID';";

mysql_query($import) or die(mysql_error());

$s++;;
}
print_r($typeArray);

/*print_r($arrayName);
echo "<br />";
echo "<br />";
echo "<br />";
print_r($arrayValue);*/

?>

an example XML file would be:
Code: [Select]


−
<evec_api version="2.0" method="marketstat_xml">
−
<marketstat>
−
<type id="24692">
−
<all>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>0.00</percentile>
</all>
−
<buy>
<volume>0.00</volume>
<avg>0.00</avg>
<max>0.00</max>
<min>0.00</min>
<stddev>0.00</stddev>
<median>0.00</median>
<percentile>0.00</percentile>
</buy>
−
<sell>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>152500000.00</percentile>
</sell>
</type>
</marketstat>
</evec_api>

im looking at pulling the following value from the <sell> section:
Code: [Select]
<median>152500000.00</median>
i am guessing the above should be arrayValue[71] but for some reason its not picking it up.

any help on this would be greatly appreciated as im lost in this script.

Wont Insert New Data

Similar Tutorials

View Content

Hey all Hope ya can help. its almost done just having problems with the new data getting inserted into the current table.
Code: [Select]
foreach($_SESSION as $key => $value) {
$key = $value;
}
echo
$item_number . "<br>" .
$po_number . "<br>" .
$lot_number . "<br>" .
$amount ;

$query = "SELECT * FROM invintory WHERE item_number ='$item_number'";
$result = mysql_query($query)
or die ("couldnt execute query." . mysql_error());
while ($row = mysql_fetch_array($result))
{
$onhand = $row['onhand'];

}
echo
$onhand ;

$newamount=$onhand+$amount;
echo
$newamount;

[color=red]mysql_query("INSERT INTO invintory WHERE item_number ='$item_number'(onhand)
values ('$newamount')");[/color]

mysql_query("INSERT INTO recvied(item_number,po_number,lot_number,amount)
values ('$item_number','$po_number','$lot_number','$amount')");
?>The part in red seems to be the problem

How To Insert This Data Into Mysql Using Php

Similar Tutorials

View Content

Array ( [data] => Array ( [0] => Array ( [latitude] => 22.934566 [longitude] => 79.08728 [type] => county [distance] => 44.328 [name] => Narsinghpur [number] => [postal_code] => [street] => [confidence] => 0.5 [region] => Madhya Pradesh [region_code] => MP [county] => Narsinghpur [locality] => [administrative_area] => [neighbourhood] => [country] => India [country_code] => IND [continent] => Asia [label] => Narsinghpur, India ) ) )

Please Help ! Thanks in Advance

Need Help On Insert Data To Phpmyadmin

Similar Tutorials

View Content

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.

Insert Data With Add Row Function In Php

Similar Tutorials

View Content

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;
}
}
?>

Unable To Insert Data In Db

Similar Tutorials

View Content

Hello....I am using ajax,jquery with php to insert data in db.....but the script is not working.

form.html:
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=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
label{
display:block;
}
</style>
<script type="text/javascript" src="jquery-1.5.min.js">
</script>
<script type="text/javascript">
$(function()
{
$('#submit').click(function(){
$('#container').append('<img src="ajax-loader.gif" id="loading" alt="image" />');

var name=$('#name').val();
var email=$('#email').val();
var d=$('#d').val();
var m=$('#m').val();
var y=$('#y').val();
var add=$('#add').val();
var phone=$('#phone').val();
$.ajax({
url: 'process.php',
type: 'POST',
data: 'name=' + name + '&email=' + email + '&d=' + d + '&m=' + m + '&y=' + y + '&add=' + add + '&phone=' + phone,
success: function(result){
$('#response').remove();
$('#container').append('<p id="response">' + result + '</p>');
$('#loading').fadeOut(500,function(){
$(this).remove();
});
}
});
return false;

});

});

</script>

</head>

<body>
<h2>User Registeration</h2>
<form action="process.php" method="POST">
<div id="container">

Name:<br>
<input type="text" name="name" id="name" /><br>
Email:<br>
<input type="text" name="email" id="email" /><br>
Date Of Birth:<br>
<input type="text" id="d" name="d" size="2" />
<input type="text" id="m" name="m" size="2" />
<input type="text" id="y" name="y" size="4" /><br>
Address:<br>
<input type="text" id="add" name="add" /><br>
Phone:<br>
<input type="text" id="phone" name="phone" /><br>

<input type="submit" name="submit" id="submit" value="GO!" />
</div>
</form>

</body>
</html>

process.php
My db id named "jquery" and table is "tab"

Code: [Select]

<?php
$conns=mysql_connect("localhost","root","");
if(!$conns)
echo "error in connection";
mysql_select_db("jquery", $conns);

$name=$_POST['name'];
$email=$_POST['email'];
$m=$_POST['m'];
$d=$_POST['d'];
$y=$_POST['y'];
$add=$_POST['add'];
$phone=$_POST['phone'];

echo $name,"<br>";
echo $email,"<br>";
echo $m, "<br>";
echo $d,"<br>";
echo $y,"<br>";
echo $add, "<br>";
echo $phone,"<br>";

$query="INSERT INTO tab (name,email,d,m,y,add,phone) VALUES ('$name',$email','$d','$m','$y','$add','$phone')";
if(!mysql_query($query,$conns))
echo "Error";
else
echo "DATA inserted";
?>

The output shown is:
pulkit
pulkit@gmail.com
1
26
1991
lucknow
987576787
Error

For some values i entered.

Insert Data Into Table

Similar Tutorials

View Content

Code: [Select]
$myusername = $_POST['myusername'];
mysql_query("INSERT INTO logedin ( username ) VALUES ('$myusername')") OR die("Could not send the message: <br>".mysql_error());

wont insert anything no error's given even
just trying to insert username into the the loged in table yes i know i spelt loged in wrong but i did that on the db lol

Insert Data Into Mysql

Similar Tutorials

View Content

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

Insert Data Button

Similar Tutorials

View Content

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>

Insert Data From Generated Table?

Similar Tutorials

View Content

Hi guys,
Im making an event booking/reservation site,
I have 5 tables (Malls, Events, Booking, Reservation and Users) which are all connected and doing fine.
I created a function which is this...

function select_all_events_by_mall_id($mall_id)
{

echo "<table id='event_table'>";
echo "<th>Event Name</th>";
echo "<th>Event Location</th>";
echo "<th>Number of Cars</th>";
echo "<th>Description</th>";
echo "<th>Booked</th>";
echo "<th>Reserved</th>";
echo "<th>Reserved Until</th>";
echo "<th>Vacant</th>";
$events_set = select_all_events($mall_id);

while($events = mysql_fetch_array($events_set))
{
echo "<tr>";
echo "<td>" . $events['event_name'] . "</td>";
echo "<td>" . $events['event_location'] . "</td>";
echo "<td>" . $events['number_of_cars'] . "</td>";
echo "<td>" . $events['description'] . "</td>";
// Booked
echo "<td>";
$booked_set = select_all_booking($events['id']);

while($booked = mysql_fetch_array($booked_set))
{

$user_set = select_all_user_booked($booked['users_id']);
while($user = mysql_fetch_array($user_set))
{
echo $user['company'] . ", " . $user['branch'] . "<br />";
}
}

echo "</td>";

// Reserved
echo "<td>";
echo "<ol>";
$reserved_set = select_all_reservation($events['id']);
while($reserved = mysql_fetch_array($reserved_set))
{
if(empty($reserved['events_id']))
{
echo "No Reservation's ";
}
else
{

$reserved_user = select_all_user_reserved($reserved['users_id']);
while($user_set = mysql_fetch_array($reserved_user))
{

echo "<li>" . $user_set['brand'] . ", " . $user_set['branch'] . "</li>";

}

}
}
echo "</ol>";
echo "</td>";

// Expiration Date
echo "<td>";
echo "<ol>";
$reserved_set = select_all_reservation($events['id']);
while($reserved = mysql_fetch_array($reserved_set))
{

$reserved_user = select_all_user_reserved($reserved['users_id']);
while($user_set = mysql_fetch_array($reserved_user))
{

$exp_date = select_all_expiration_date($user_set['id']);
while($date = mysql_fetch_array($exp_date))
{
echo "<li>" . $date['expiration_date'] . "</li>";
}
}

}
echo "</ol>";
echo "</td>";

//Vacant
echo "<td>";
$vacant_set = select_all_booking($events['id']);
$booking_count = mysql_num_rows($vacant_set);
$reserved_count = mysql_num_rows($reserved_set);
$total_count = $booking_count + $reserved_count;
$vacant = $events['number_of_cars'] - $total_count;
if($vacant < 0)
{
echo "This Event is fully booked";
}
else
{
echo $vacant;
}
echo"</td>";

echo "</tr>";
}
echo "</table>";

}

The function starts by receiving an id from picking a mall name from a select tag.
It works fine, it outputs the data on the page like i want it to, but my problem is that i need a way to
add a submit or any button to each generated row that will, when clicked will insert the event id and user id (who clicked it) to my booking/reservation table as a new row.
I tried adding a form inside my function and saving the event id every loop but when i click the submit button i think it doesn't work (or i made a mistake)..
Sorry if my coding sucks, I'm kinda new in php.
Sorry if its kinda confusing my head is spinning right now from thinking this stuff the whole day..
Thanks in advance for any comments and ideas.

Moved: Insert Data To A Table

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319161.0