Learn VBA & Macros in 1 Week!

PHP - Inserting Values From Array Into Mysql Database

Full Excel VBA Course - Beginner to Expert

Inserting Values From Array Into Mysql Database	View Content

Hello there, I'm really new at PHP and I've been reading several beginner tutorials so please accept my apologies for any stupid questions I may ask along the way. I've gotten as far as installing XAMPP, set up a database plus PHP form and I'm struggling to figure out how to insert values from an array into my database. I've learnt the code in one particular way (see beginner tutorials) so I was wondering if you could help me keeping this in mind. I know there'll be a million better ways to do what I'm doing but I fear I will be bamboozled with different code or differently structured code. Anyway the tutuorials I'm reading don't see to cover how I can insert an array of values into my database, just singular values. In the attached file, I have 10 rows of 2x text inputs (20 text inputs total). Each row allows the user to enter a CarID and CarTitle. I've commented out the jQuery which validates the inputs so I can build a rudimentary version of this validation with PHP. I thought that because the line $sql="INSERT INTO carids_cartitles (CarID, CarTitle) VALUES ($id, $title)"; is inside the foreach, means that for each pair of values from the form it'd insert to the database. It doesn't do this. If I enter two or more CarIDs and CarTitles, only one pair of values gets saved to the database. I'm sorry if I haven't explained this well enough, any questions please let me know. Many thanks for your help in advance. Attached Files form.php 4.43KB 5 downloads

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Mysql Query Not Inserting A New Set Of Values Into Database

Inserting A Form Containing Checkbox Array Into Mysql Database

Php >> Mysql Querying Database With String Array Values

Inserting Values Via Php To Sql Database

Inserting Values Into Database Using For Loop?

Inserting Multiple Values Into Mysql

Inserting Values To A Database Table Depending On The Value Of A Drop Down Menu

Inserting Multiple Values Into The Same Mysql Column

Inserting Multiple Checkbox Values Into Mysql

Inserting Array Of Data Into Database

Issue With Inserting Array Into Database

Data Not Inserting In Mysql Database

Help With Inserting Record In Mysql Database

Getting Mysql Syntax Error When Inserting Php Value In Database..?

Inserting Array Data Into Multiple Rows Of Database

Script Not Inserting All User Input From Array Into Database

Inserting Multiple Form Checkbox Results To Mysql Database

Inserting Multidimensional Array Value Into Mysql

Trouble Inserting Array Variables Into Mysql

Need Help Fetching Array Values From Database! Please! :))

Learn VBA & Macros for Excel in 1 Week!

Mysql Query Not Inserting A New Set Of Values Into Database

Similar Tutorials

I have posted one set of values into my database and it worked fine but when i input another set they wont go inside unless i changes the value of the primary index colum. I want to be able to insert a new values regardless of the primary index value. Any idears...?

Inserting A Form Containing Checkbox Array Into Mysql Database

Similar Tutorials

So I've spent 2 days now searching the web on how to make my checkbox array on my form insert the value selected by the user into my database. Here is the code that I've written. All fields except for the checkbox array works fine.

<?php virtual('/budgets/Connections/connAdmin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if (isset($_POST['submit'])) {
$workStyle = $_POST['art_photos'];

// Setting up a blank variable to be used in the coming loop.
$allStyles = "";

// For every checkbox value sent to the form.
foreach ($workStyle as $style) {
// Append a string called $allStyles with the current array element, and then add a comma and a space at the end.
$allStyles .= $style . ", ";
}

// Delete the last two characters from the string.
$allStyles = substr($allStyles, 0, -2);

echo "<p>The resulting string is: <strong>$allStyles</strong></p>\r\n";

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO daily_budget (rundate, slug, reporter, budgetInfo, notes, `section`, deadline, art_photos sidebar, sBudget) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['rundate'], "text"),
GetSQLValueString($_POST['slug'], "text"),
GetSQLValueString($_POST['reporter'], "text"),
GetSQLValueString($_POST['budgetInfo'], "text"),
GetSQLValueString($_POST['notes'], "text"),
GetSQLValueString($_POST['section'], "text"),
GetSQLValueString($_POST['deadline'], "text"),
                 GetSQLValueString($_POST['art_photos'], "text"),
GetSQLValueString($_POST['sidebar'], "text"),
GetSQLValueString($_POST['sBudget'], "text"));

mysql_select_db($database_connAdmin, $connAdmin);
$Result1 = mysql_query($insertSQL, $connAdmin) or die(mysql_error());
}

?>

<!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>Budget Record</title>

</head>

<body>
<?php
if (isset($error)) {
   echo '<ul>';
   foreach($error as $alert) {
      echo "<li class='warning'>$alert</li>\n";
   }
   echo '</ul>';
}
?>
<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1">
<table align="center" width="60%" border="2" bgcolor="#FFFFFF">
<tr valign="baseline">
<td width="14%" align="right" nowrap="nowrap"><STRONG>Rundate:</STRONG></td>
<td width="86%">
<input type="text" name="rundate" size="30" value="" id="jQueryUICalendar2"/>
<script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar2
jQuery("#jQueryUICalendar2").datepicker();

// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar2
</script></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><STRONG>Section:</STRONG></td>
<td>
<select name="section">
<option value=""></option>
<option value="A1">A1</option>
<option value="Pickup All">Pickup All</option>
<option value="Region">Region</option>
<option value="Atlantic">Atlantic</option>
      <option value="Business">Business</option>
<option value="Features">Features</option>
<option value="Sports">Sports</option>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Slug:</strong></td>
<td><span id="sprytextfield2">
<input type="text" name="slug" value="" size="32" />
<span class="textfieldRequiredMsg">REQUIRED</span></span><span style="color: #F00; font-weight: bold; font-size: 10px;"></span></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Budget Information:</strong></td>
<td><span id="sprytextarea1">
<textarea name="budgetInfo" cols="50" rows="4"></textarea>
<span class="textareaRequiredMsg">Required.</span></span><span style="color: #F00; font-weight: bold; font-size: 11px;"></span></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Notes:</strong></td>
<td><input type="text" name="notes" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Reporter:</strong></td>
<td><span id="sprytextfield3">
<input type="text" name="reporter" value="" size="32" />
<span class="textfieldRequiredMsg">Required.</span></span><span style="color: #F00; font-weight: bold; font-size: 10px;"></span></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Deadline:</strong></td>
<td><input type="text" name="deadline" size="30" value="Enter date" id="jQueryUICalendar1"/><script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar2
jQuery("#jQueryUICalendar1").datepicker();

// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar2
</script> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Artwork:</strong></td>
<td><label>
<input type="checkbox" name="art_photos[]" value="factbox" id="art_photos_0" />
Factbox</label>

<label>
<input type="checkbox" name="art_photos[]" value="graphic" id="art_photos_1" />
Graphic</label>

<label>
<input type="checkbox" name="art_photos[]" value="photo" id="art_photos_2" />
Photo</label>

<label>
<input type="checkbox" name="art_photos[]" value="video" id="art_photos_3" />
Video</label>
<br /></td>
</tr>
<tr>

</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> <strong>Sidebar:</strong></td>
<td valign="baseline"><span id="spryradio2">
<label>
<input type="radio" name="sidebar" value="y" id="sidebar_0" />
Yes</label>
<br />
<label>
<input type="radio" name="sidebar" value="n" id="sidebar_1" />
No</label>
<br />
<span class="radioRequiredMsg"><strong style="font-size: 11px">REQUIRED.</strong></span></span>

</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><strong>Sidebar Information:</strong></td>
<td><input type="text" name="sBudget" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Insert record" /></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1" />
</form>

<p> </p>
<h3><a href="/new_budget/admin/manage_budgets.php"><strong>View your budget entry, make changes or delete your budget.</strong></a></h3>
<script type="text/javascript">

</script>
</body>
</html>

Php >> Mysql Querying Database With String Array Values

Similar Tutorials

Hey there...

I'm so stuck on this problem I was hoping someone could help...

I need to query a MySQL Database using array values...

Here is my array ... $query_keywords = Array ( [7] => business [10] => home [11] => depo )

Here is my php ...$query = "SELECT * FROM product WHERE product_name, product_comment IN ($query_keywords)";
$result=mysql_query($query);

if(mysql_num_rows($result) > 0)
{
echo "results";
}
else
{
echo "no results";
}

Unfortunately, I get this ...
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in blah\blah\results.php on line 99

Please help me
All comments greatly appreciated...

Inserting Values Via Php To Sql Database

Similar Tutorials

Hi guys,

I am building a website with basic e-commerce functionality, using php and using xampp to test it.
I am having issues when attempting to submit a quantity (into table orders) using a form and validating it against an existing value (from table products), giving a response on whether there is sufficient quantity in the second table. I am then, in another page (same one performing the validations), attempting to then show a result based on the initial quantity entered, with a summary of the order details and calculation of the quantity * price to display a total as well. This has all been built from scratch, however I may have taken the wrong approach for these two pages... any assistance or insight as to where I am going wrong would be greatly appreciated.

Here is the page I have placed the products, existing quantity and a text field they are able to enter their desired quantity:

Code: [Select]
<?php
session_start();
require_once "../database/db.php";
require_once "../includes/functions.php";

$page_title = 'Product Catalogue';
include_once "header.php";

$conn = mysqli_connect ($dbhost, $dbuser, $dbpassword, $dbname);

$query = "SELECT * from products";

$result = mysqli_query($conn, $query);

if (!$result)
{
include_once "header.php";
die ("Error, could not query the database");
}

else
{ $rows = mysqli_num_rows($result);

if ($rows>0)
{

while ($row = mysqli_fetch_array($result))
{
?>
<form>
<br />
<br />
<br />
<table>
<tr>
<td style="width: 200px">Product Code:</td>
<td><?php echo $row['ProductCode']; ?></td>
</tr>
<tr>
<td>Product Name:</td>
<td><?php echo $row['ProductName']; ?></td>
</tr>
<tr>
<td>Product Description:</td>
<td><?php echo $row['ProductDescription']; ?></td>
</tr>
<tr>
<td>Product Colour:</td>
<td><?php echo $row['ProductColour']; ?></td>
</tr>
<tr>
<td>Product Price:</td>
<td>$<?php echo number_format($row['ProductPrice'],2); ?></td>
</tr>
<tr>
<td>Product Image:</td>
<td><img src="<?php echo $row['ProductImagePath']?>"/></td>
</tr>
<tr>
<td>Quantity in Stock:</td>
<td><?php echo $row['ProductQuantity']; ?></td>
</tr>
</table>
</form>
<form method="post"action="processQuantity.php">
<table>
<tr>
<td style="width: 200px">Quantity:</td>
<td><input type="number" name="Quantity" id="Quantity" value="<?php if (isset ($quantity)) echo $quantity; ?>"size = "20" /></td>
<td><input type="submit" name="Purchase" value= "Purchase" /></td>
</tr>
</table>
</form>
<hr />
<?php
}
include "footer.html";
}
}
?>
Here is the page that I am using to validate the data as well as show a result based on the entered amount:

Code: [Select]
<?php

session_start();

require_once "../includes/functions.php";
require_once "../database/db.php";

$quantity = $_POST['Quantity'];
$productquantity = $_POST['ProductQuantity'];
$orderid = $_POST['orderid'];
$productcode = $_POST['productcode'];
$productprice = $_POST['productprice'];
$total = $quantity * $productprice;

$error_message = '';

if ($error_message != '')
{
include_once "displayCatalogue-PlaceOrder.php";
exit();

$conn = mysqli_connect ($dbhost, $dbuser, $dbpassword, $dbname);

if (!$conn)
{
echo "Error";
}
else
{
//sanitise date
$scustomerid = sanitiseMySQL($customerid);
$sproductcode = sanitiseMySQL($productcode);
$squantity = sanitiseMySQL($quantity);
$sproductprice = sanitiseMySQL($productprice);
$sorderdate = sanitiseMySQL($orderdate);

$query = "select productquantity from products where productcode = '$sproductcode'";

$result = msqli_query ($conn, $query);

$productquantity = mysqli_num_rows($result);

if ($quantity < $productquantity)
{
$error_message = "You cannot order more than what is currently instock";
include_once "displayCatalogue-PlaceOrder.php";
exit ();
}
else
{
$row = mysqli_fetch_row($result);

$query = "INSERT into orders (customerid, productcode, quantity, productprice, orderdate) values ('$scustomerid', $sproductcode', '$squantity', '$sproductprice', '$sorderdate')";

$result = mysqli_query($conn, $query);

$row = mysqli_affected_rows($conn);

if ($row > 0)
{
include "header.php";?>
<h3>Order Confirmation</h3>
<p>Thank you, your order is now being processed.</p>
<table>
<tr>
<td style="width: 200px">Order Number:</td>
<td><?php echo $orderid; ?></td>
</tr>
<tr>
<td>Product Code:</td>
<td><?php echo $productcode; ?></td>
</tr><tr>
<td>Quantity:</td>
<td><?php echo $quantity; ?></td>
</tr>
<tr>
<td>Price:</td>
<td><?php echo $productPrice; ?></td>
</tr>
<tr>
<td>Total Cost of Order:</td>
<td><?php echo $total; ?></td>
</tr>
</table>

<?php
include "footer.html";
}
else
{
$error_message ="Error placing your order, please try again";
include "displayCatalogue-PlaceOrder.php";
exit();
}
}
}
}
//this is used to validate the quantity entered against what is available in the database
?>

Inserting Values Into Database Using For Loop?

Similar Tutorials

Is it possible to use for loop to insert values into database using for loop?
Or what would be the another way to insert these values into the database if the number of values being entered differs from one time to another? Here is basically what I am trying to do:
mysql_query("INSERT INTO MaxMillionsNum SET
Day='$weekday',
DrawDate='$CompleteDate',
DateTime='$timestamp',
for($i=1; $i<=$SetNumber; $i+=1){
for($j=0; $j<7; j+=1){
$NumberName="Number".$i.$v[$j];//Generating name of database field
$$NumberName=$Match[0][$j];//Here I would store the $Match value into the fieldname name created above
}
}
Tries='$RunCounter'");

Inserting Multiple Values Into Mysql

Similar Tutorials

Hi People

i'm a newb at this so bare with me but i currently have a php file called Newkpi.php which has a select statement in. this selects data from a table called "StaffList".
this then populates the page with a html table with 14 records (this will increase/decrease over time) i then have some extra text boxes to enter more detail into like service amaount service date and so on.
when i click the submit button i want it to cycle through each row and insert the data into a separate table called "Services". however i cannot for the life of me get this to work and need some help with it. people find attached the code for Newkpi and see if you can help me with this.

in total i want it to take the names from stafflist and populate Services with the names and the extra detail which is entered on the page

Much Thanx in advance

SLOWIE

Inserting Values To A Database Table Depending On The Value Of A Drop Down Menu

Similar Tutorials

Hello all

Ok here is the problem...
I want when a user inputs the requested data to the text fields , the script to insert those data in the prope table depending on the choise the user does by choosing one option from the drop down menu.
Below is the php code (apparently not working)

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
$site_type = $_REQUEST['category_selection'];
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "link_submission") && ($site_type = "Web_Sites")) {
  $insertSQL = sprintf("INSERT INTO partner_sites (url, url_title, anchor_text, `description`, webmaster_name, webmaster_email, category) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['url_field'], "text"),
                       GetSQLValueString($_POST['title_field'], "text"),
                       GetSQLValueString($_POST['anchor_field'], "text"),
                       GetSQLValueString($_POST['description_field'], "text"),
                       GetSQLValueString($_POST['webmaster_nane_field'], "text"),
                       GetSQLValueString($_POST['webmaster_email_field'], "text"),
                       GetSQLValueString($_POST['category_selection'], "text"));

  mysql_select_db($database_content_conn, $content_conn);
  $Result1 = mysql_query($insertSQL, $content_conn) or die(mysql_error());

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "link_submission") && ($site_type = "Blogs")) {
  $insertSQL = sprintf("INSERT INTO partner_blogs (url, url_title, anchor_text, `description`, webmaster_name, webmaster_email, category) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['url_field'], "text"),
                       GetSQLValueString($_POST['title_field'], "text"),
                       GetSQLValueString($_POST['anchor_field'], "text"),
                       GetSQLValueString($_POST['description_field'], "text"),
                       GetSQLValueString($_POST['webmaster_nane_field'], "text"),
                       GetSQLValueString($_POST['webmaster_email_field'], "text"),
                       GetSQLValueString($_POST['category_selection'], "text"));

  mysql_select_db($database_content_conn, $content_conn);
  $Result1 = mysql_query($insertSQL, $content_conn) or die(mysql_error());

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "link_submission") && ($site_type = "Directories")) {
  $insertSQL = sprintf("INSERT INTO partner_directories (url, url_title, anchor_text, `description`, webmaster_name, webmaster_email, category) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['url_field'], "text"),
                       GetSQLValueString($_POST['title_field'], "text"),
                       GetSQLValueString($_POST['anchor_field'], "text"),
                       GetSQLValueString($_POST['description_field'], "text"),
                       GetSQLValueString($_POST['webmaster_nane_field'], "text"),
                       GetSQLValueString($_POST['webmaster_email_field'], "text"),
                       GetSQLValueString($_POST['category_selection'], "text"));

  mysql_select_db($database_content_conn, $content_conn);
  $Result1 = mysql_query($insertSQL, $content_conn) or die(mysql_error());
}

And the html form

<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="link_submission" id="link_submission">

<table width="630" border="0" align="center" cellpadding="5" cellspacing="5">
  <tr>
    <td width="76">URL:*</td>
    <td width="519"><label for="url_field"></label>
      <span id="sprytextfield1">
      <label for="url_field"></label>
      <input name="url_field" type="text" id="url_field" size="50" />
      <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td>
    </tr>
  <tr>
    <td>Anchor Text:*</td>
    <td><label for="anchor_field"><span id="sprytextfield2">
      <input type="text" name="anchor_field" id="anchor_field" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></label></td>
    </tr>
  <tr>
    <td>URL Title:*</td>
    <td><label for="title_field"><span id="sprytextfield3">
      <input type="text" name="title_field" id="title_field" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></label></td>
    </tr>
  <tr>
    <td>Description:*</td>
    <td><span id="sprytextarea1">
    <label for="description_field"></label>
    <textarea name="description_field" id="description_field" cols="45" rows="3"></textarea>
    <span id="countsprytextarea1"> </span><span class="textareaRequiredMsg">A value is required.</span><span class="textareaMaxCharsMsg">Exceeded maximum number of characters.</span></span></td>
    </tr>
  <tr>
    <td>Webmaster Name:*</td>
    <td><label for="textfield2"><span id="sprytextfield4">
      <input type="text" name="webmaster_nane_field" id="webmaster_nane_field" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></label></td>
    </tr>
  <tr>
    <td>Webmaster E-mail:*</td>
    <td><label for="textfield3"><span id="sprytextfield5">
    <input name="webmaster_email_field" type="text" id="webmaster_email_field" size="40" />
    <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></label></td>
    </tr>
  <tr>
    <td>Category:*</td>
    <td><span id="spryselect1">
      <label for="category_selection"></label>
      <select name="category_selection" id="category_selection">
        <option>Select An Option</option>
        <option value="Web_Sites">Web Sites</option>
        <option value="Blogs">Blogs</option>
        <option value="Directories">Directories</option>
      </select>
<span class="selectRequiredMsg">Please select an item.</span></span></td>
  </tr>
  <tr>
    <td> </td>
    <td><label for="select"></label>
      <input type="submit" name="button" id="button" value="Url Submission" /></td>
    </tr>
</table>
<input type="hidden" name="MM_insert" value="link_submission" />
</form>

Im begging for your help.....

Inserting Multiple Values Into The Same Mysql Column

Similar Tutorials

Inserting Multiple Checkbox Values Into Mysql

Similar Tutorials

So first of all, I have a confession, I used Dreamweaver to take care of all my database work. Pheww. Now that I got that of my chest, I am having problems, not only with my lack of experience working with databases, but with my script also. I need to insert multiple checkbox values into my database into the same cell. So I have searched around and I thought I had found a fairly good approach, but with Dw's hodgepodge of overcomplicated mess, I am finding problems integrating it. The error I am getting post submission is "Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\gov\ballot.php on line 10
Column 'involvement' cannot be null" So if you would, could you debug my script and give me some instruction along to way so that I can learn a little something too? Here is my script:

<?php require_once('Connections/ballot.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "Ballot")) {
  $insertSQL = sprintf("INSERT INTO votes (`first`, `last`, gender, grade, involvement, schedule, party, `time`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first'], "text"),
                       GetSQLValueString($_POST['last'], "text"),
                       GetSQLValueString($_POST['gender'], "text"),
                       GetSQLValueString($_POST['grade'], "text"),
                       GetSQLValueString($_POST['involvement'], "text"),
                       GetSQLValueString($_POST['schedule'], "text"),
                       GetSQLValueString($_POST['party'], "text"),
                       GetSQLValueString($_POST['time'], "text"));

  mysql_select_db($database_ballot, $ballot);
  $Result1 = mysql_query($insertSQL, $ballot) or die(mysql_error());

  $insertGoTo = "thanks.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_ballot, $ballot);
$query_Recordset1 = "SELECT * FROM votes";
$Recordset1 = mysql_query($query_Recordset1, $ballot) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!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>Please Place your Vote Below</title>
</head>

<body style="background-image:url(images/bg.jpg); background-repeat:repeat-x; background-color:#000000;">
<table align="center" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" border="0">
<tr><td>
<div style="border:thin; border-color:000000; border-style:groove; width:700px; background-color:ffffff;">
<div align="center"><a href="index.php"><img src="images/header.jpg" alt="Mock Elections 2010" /></a></div>
<div style="margin:10px; margin-top:30px;">
Before continuing to vote, in order to count your vote, we ask that you please ensure you are adhereing to the following guidelines:
</div>
<div style="margin:30px">
  <p>- When putting your name, remember to put your full legal name. NO nicknames.<br />
    - Be sure that all your information is valid otherwise your vote will not be counted.
    <br />
  </p>
</div>
<div style="margin-left:150px; margin-right:150px; margin-top:50px;">
<form action="<?php echo $editFormAction; ?>" method="POST" name="Ballot">
First Name:  <input type="text" name="first" /><br />
Last Name:  <input type="text" name="last" /><br />
<div>Gender: 
<label>
Male <input type="radio" value="Male" name="gender" /></label>
<label>Female <input type="radio" value="Female" name="gender" /></label>
</div>
Grade: 
<select name="grade">
  <option selected="selected"> </option>
  <option value="7">7</option>
  <option value="8">8</option>
  <option value="9">9</option>
  <option value="10">10</option>
  <option value="11">11</option>
  <option value="12">12</option>
  <option value="Teacher">Teacher</option>
  <option value="Staff">Staff</option>
</select><br />
<div>Involvement: 
  <label>
    <input type="checkbox" name="involvement[]" value="Athletics" id="involvement_0" />
    Athletics</label>
  <label>
    <input type="checkbox" name="involvement[]" value="Co-Curricular" id="involvement_1" />
    Co-Curricular</label>
  <label>
    <input type="checkbox" name="involvement[]" value="Clubs" id="involvement_2" />
    Clubs</label>
</div>
<div>Schedule: 
<label><input type="radio" value="C4" name="schedule" />C4</label>
<label><input type="radio" value="All Day" name="schedule" />All Day Hauser Student</label>
</div>
<div>Party: 
<label><input type="radio" value="PokePartay" name="party" />PokePartay</label>
<label><input type="radio" value="Equilibrium" name="party" />Equilibrium Party</label>
</div>
<br />
<input type="Submit" value="Submit" />
<input type="hidden" value="<?php
$tz =  new DateTimeZone('America/Indianapolis');
$date = new DateTime('now', $tz);
echo $date->format('m-d-Y h:i:s') . "\n";
?>" name="time" />
<?php
if (isset($_POST['submit'])) {
   $involvements = $_POST['involvement'];

   foreach($involvements as $involvement) {
      $query2 = "INSERT INTO votes (involvement) VALUES ('$involvement')";
      $result2 = mysql_query($ballot, $query2) or die(mysql_error());
   }
}
?>
<input type="hidden" name="MM_insert" value="Ballot" />
</form>
</div>
<br />
<br />
<br />
<br />
</div>

</td>
</tr>
</table>

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Thanks,
Philip Ulrich

Inserting Array Of Data Into Database

Similar Tutorials

I am setting up a PHP & MySql shopping cart.

When a user adds products they are stored as sessions.

The cart displays the products in an array:

foreach($_SESSION as $product => $quantity)

So the product is the product_id, and the quantity is the quantity of that product which has been added.

When getting the information from the database to display it, it reads like this

1-----2 (product_id = 1, quantity = 2)
2-----1 (product_id = 2, quantity = 1)
3-----3 (product_id = 3, quantity = 3)
11---12 (product_id = 11, quantity = 12)
4-----1 (product_id = 4, quantity = 1)

I'm basically trying to insert the product_id and quantity into a table called cart.

I've been stuck for days and can still only manage to insert 1 row of values

Searching around I saw that some people inserted arrays using implode or explode functions first, but I'm not sure how that would work in this case

Any ideas?

Issue With Inserting Array Into Database

Similar Tutorials

hey there I have an issue when I am inserting an array into the database. When I run the insert statements the records get inserted but it is sometimes one less record than is in the table and sometimes even less. for example if I have 5 records it only inserts the first 4. This is confusing because when I echo out the statement in the loop it shows all 4 insert statements. my loop for inserting looks like this:

if(isset($_SESSION['cushArray'])){

    foreach($_SESSION['cushArray'] as $key => $value){
        $getCushSKU = "SELECT SKU FROM Cushion WHERE Name = '".$value['Cushion']."'";
        //echo $getCushSKU;
        $resultGetCushSKU = mysql_query($getCushSKU);
        $getResultGetCushSKU = mysql_fetch_assoc($resultGetCushSKU);
        //echo $getResultGetCushSKU['SKU'];
        $getFabricSKU = "SELECT SKU FROM Fabric WHERE Name = '".$value['Fabric']."'";

        $resultGetFabricSKU = mysql_query($getFabricSKU);
        $getResultGetFabricSKU = mysql_fetch_assoc($resultGetFabricSKU);

        if($_SESSION['cushArray'][$i]["ContWeltFabric"] != "N/A"){
            $getWeltFabricSKU = "SELECT SKU FROM Fabric WHERE Name = '".$value['ContWeltFabric']."'";
            $resultGetWeltFabricSKU = mysql_query($getWeltFabricSKU);
            $getResultGetWeltFabricSKU = mysql_fetch_assoc($resultGetWeltFabricSKU);
        }else{
            $getResultGetWeltFabricSKU = "N/A";
        }

        $sqlCush = "INSERT INTO OrdersCushion(OrderID, ProductSKU, FabricSKU, WeltFabricSKU, Quantity, ButtonColor, ZipperColor, Fill) VALUES('".$getOrderIDNum['OrderID']."', '".$getResultGetCushSKU['SKU']."', '".$getResultGetFabricSKU['SKU']."', '".$getResultGetWeltFabricSKU['SKU']."', '".$value['Quantity']."', '".$value['Button']."', '".$value['Zipper']."', '".$value['Fill']."') ";

        //echo $sqlCush;

        $resultCush = mysql_query($sqlCush);
    }

}

any help is much appreciated

Data Not Inserting In Mysql Database

Similar Tutorials

hello friends,
actually i am trying to insert data in mysql
database.
here is my code

<?php
	include_once("../includes/database.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Insert Product</title>
</head>

<body>
	<form action="insert_product.php" method="post" enctype="multipart/form-data">
    	<table align="center" width="600">
        <tr align="center">
        	<td colspan="8"><h2> Insert New Post</h2></td>
        </tr>
        <tr>
        	<td align="right"><b>Product Title :</b></td>
            <td><input type="text" name="product_title"  size="50" style="background-color:#06C; color:#FFF"  /></td>
        </tr>
         <tr>
        	<td align="right"><b>Product Category :</b></td>
            <td>
            	<select name="product_cat" style="background-color:#06C; color:#FFF" >
                	<option>Select A Category </option>
                    <?php 
						$get_cats = "SELECT * FROM categories";	
						$run_cats = mysqli_query($con, $get_cats);
						while($row_cats = mysqli_fetch_array($run_cats)){
							$cat_id = $row_cats['cat_id'];
							$cat_title = $row_cats['cat_title'];
							echo "<option value='$cat_id'>$cat_title</option>";
						}
					?>
                </select>
            </td>
        </tr>
         <tr>
        	<td align="right"><b>Product Platform :</b></td>
            <td>
            	<select name="product_brand" style="background-color:#06C; color:#FFF" >
                	<option>Select A Platform </option>
                    <?php 
						$get_brands = "SELECT * FROM brands";	
						$run_brands = mysqli_query($con, $get_brands);
						while($row_brands = mysqli_fetch_array($run_brands)){
							$brand_id = $row_brands['brand_id'];
							$brand_title = $row_brands['brand_title'];
							echo "<option value='$brand_id'>$brand_title</option>";
						}
					?>
                </select>
            </td>
        </tr>
         <tr>
        	<td align="right"><b>Product Image :</b></td>
            <td><input type="file" name="product_image"  /></td>
        </tr>
         <tr>
        	<td align="right"><b>Product Price :</b></td>
            <td><input type="text" name="product_price" style="background-color:#06C; color:#FFF"  /></td>
        </tr>
         <tr>
        	<td align="right" valign="top"><b>Product Description :</b></td>
            <td><textarea name="product_desc" cols="50" rows="10" style="background-color:#06C; color:#FFF"  ></textarea></td>
        </tr>
         <tr>
        	<td align="right"><b>Product Keywords :</b></td>
            <td><input type="text" name="product_keywords" size="50" style="background-color:#06C; color:#FFF" /></td>
        </tr>
         <tr align="center">
            <td colspan="8"><input type="submit" name="insert_post" value="Submit Now" /></td>
        </tr>
        </table>
    </form>
</body>
</html>

<?php
	if(isset($_POST['insert_post'])){
		$product_title = $_POST['product_title'];
		$product_cat = $_POST['product_cat'];
		$product_brand = $_POST['product_brand'];
		$product_price = $_POST['product_price'];
		$product_desc = $_POST['product_desc'];
		$product_keywords = $_POST['product_keywords'];
		$product_image = $_FILES['product_image']['name'];
		$product_image_tmp = $_FILES['product_image']['tmp_name'];
		move_uploaded_file($product_image_tmp,"product_image/$product_image");
		
		$sql = "INSERT INTO products (product_cat,product_brand,product_title,product_price,product_desc,product_image,product_keywords) VALUES ('$product_cat','$product_brand','$product_title','$product_price','$product_desc','$product_image','$product_keywords')";
		$query = mysqli_query($con, $sql);
		if($query){
			echo "<script>alert('Product Has Been Inserted')</script>";	
			echo "<script>windoow.open('insert_product.php','_self')</script>";
			exit();
		}else{
			echo "<script>alert('errror')</script>";	
		}
	}
?>

but somehow its not inserting
data into my table can somebody tell wherre
m i doing mistake.

the categories and brands are displaying from database. But its not inserting data

here is my database script.

 <?php
 $con = mysqli_connect("localhost","root","","sg");
?>

Help With Inserting Record In Mysql Database

Similar Tutorials

[/code]
Hi //open the connection
$conn = mysql_connect("localhost", "techhom1_test", "pro176");

//pick the database to use
mysql_select_db("testDB", $conn);

//create the sql statement
$sql = "INSERT INTO master_name values ('', '$firstname')";

//execute
if (mysql_query($sql,$conn)){
echo "Record Added!";
} else{
echo "Somethin went wrong";
}

the code above is insert code and working with out any errors but when i am submitting text into data using method below it is sending echo back Somethin went wrong.I think i am confused with the write name of the user table

database is ***_test
my tables are
duty_number
master_name

in this _test user i am trying to add first name in master_name field so here is the submit code

Code: [Select]
<FORM ACTION=insert.php METHOD=POST>
<P>text to add:<br>
<input type=text name=master_name size=30>
<p><input type=submit name=submit value=Insert Record></p>
</FORM>

My table below in Data base

[code]Field Type Null Default Comments
name_id smallint(5) Yes NULL
name_dateaddedn datetime Yes NULL
name_datemodified datetime Yes NULL
firstname varchar(75) Yes NULL
lastname varchar(75) Yes NULL

can someone please look at the code and find the error for me Thanks

Getting Mysql Syntax Error When Inserting Php Value In Database..?

Similar Tutorials

Im building a list of offers and adding them to a table in a database.

Pretty much all it is is HTML. Im inserting an ahref link that has a php echo in it. So it looks like this:

<div class="offerlinks"><a href="http://website.com/offer/blahblah&blah=blah&sid=<?php echo $_SESSION['uid'];?>">Offer name</a><br><b>Info:</b> Signup<br><b>Value</b> 1 pt</div>

When I insert this (through my form) I get mysql error 1064 which is syntax error. I tested it without the php & it gives me 0, which worked fine.

I need the php code so I can append userid to the SID var.

Am I doing something wrong? Well I guess I obviously am so the real question is what am I doing wrong & how could I do it the right way?

Thanks guys

Inserting Array Data Into Multiple Rows Of Database

Similar Tutorials

I am trying to array data to database against same id. Here is code. form.php

<form name="users" method="post" action="order_submit.php" enctype="multipart/form-data" onSubmit="return validate();" id="inv_form">
<div class="formSep">
<select name="company" onChange="showSubcat(this);">
<option value="">Company</option>
<?php $s1 = mysql_query("select * from leads where lead_customer='Lead' ") or die (mysql_error());
while($s2 = mysql_fetch_array($s1))
{ ?>
<option value="<?php echo $s2['id']; ?>"><?php echo $s2['company']; ?></option>


<?php 


} ?>
</select>

</div>

<div class="formSep">

<table class="table invE_table">
<thead>
<tr>
<th></th>
<th>Item</th>
<th>Unit</th>
<th>Unit Cost ($)</th>
<th>Qty</th>
<th>Tax (%)</th>
<th>Total ($)</th>
</tr>
</thead>
<tbody>
<tr class="inv_row">
<td class="inv_clone_row"><i class="icon-plus inv_clone_btn"></i></td>
<td><input type="text" class="span12" name="invE_item[]" /></td>
<td><input type="text" class="span12" name="invE_description[]" /></td>
<td><input type="text" class="span12 jQinv_item_unit" name="invE_unit_cost[]" /></td>
<td><input type="text" class="span12 jQinv_item_qty" name="invE_qty[]" /></td>
<td><input type="text" class="span12 jQinv_item_tax" name="invE_tax[]" /></td>
<td><input type="text" readonly class="span12 jQinv_item_total" name="invE_total[]" /></td>
</tr>
<tr class="last_row">
<td colspan="5">&nbsp;</td>
<td colspan="2">
<p class="clearfix">Subtotal: <span class="invE_subtotal">$<span>0.00</span></span></p>
<p>Tax: <span class="invE_tax">$<span>0.00</span></span></p>
<p>Discount: <span class="invE_discount">$<span>0.00</span></span></p>
<p><strong>Balance: <span class="invE_balance">$<span>0.00</span></span></strong></p>
</td>
</tr>
</tbody> 
</table>
</div>

Here invE_item[], invE_description[], invE_unit_cost[].... are the array , i mean dynamically one can add as many as items and its details. In my order_submit.php page

<?php

error_reporting(0);
include("connect.php");
include("admin_auth.php"); 

if(isset($_POST['save']))
{

$company = $_POST['company'];
$contact_person = $_POST['contact_person'];
$billing = $_POST['billing_address'];
$shipping = $_POST['shipping_address'];
$reference = $_POST['reference'];
$t_c = $_POST['t_c'];
$payment = $_POST['payment'];
$ship_in = $_POST['ship_inst'];
$validity = $_POST['validity'];
$currency = $_POST['currency'];
$order_for = $_POST['order_for'];
$assigned_to = $_POST['assigned_to'];
$item = $_POST['invE_item'];
$unit = $_POST['invE_description'];
$price = $_POST['invE_unit_cost'];  
$qty= $_POST['invE_qty'];   
$tax = $_POST['invE_tax'];  
$total = $_POST['invE_total'];  

$sql = mysql_query("insert into orders (order_id, company_id, contact_person, billing_address, shipping_address, reference, t_c, payment, shipping_inst, validity, order_for, currency, assigned_to, last_modified, order_quote) values ('', ".$company.", '".$contact_person."', '".$billing."', '".$shipping."', '".$reference."', '".$t_c."', '".$payment."', '".$ship_in."', ".$validity.", '".$order_for."', '".$currency."', '".$assigned_to."', NOW(), 'Order')");

$last_id = mysql_insert_id();

$msql = "insert into order_line_items (id, order_id, company_id, item, unit, unit_cost, quantity, tax, total) values ('', ".$last_id.", ".$company.", '".$item."', '".$unit."', ".$price.", ".$qty.", ".$tax.", ".$total.")";


$l1 = mysql_query($msql) or die (mysql_error());    
}

I want to insert each item in different row with $last_id , as in the attached image . Please somebody help me in this Attached Files db.PNG 11.01KB 4 downloads

Script Not Inserting All User Input From Array Into Database

Similar Tutorials

Before I get into my problem a couple of things.
First, this is a work project. My organization cannot afford a full time developer so as a database guy I'm being asked to develop a web based data system using php/html/mysql/javacript/etc. So I am not asking anyone to help me cheat or violate an honor code for a school project. Also I am having to learn PHP on the fly, by the seat of my pants. Second, my organization is using a version of PHP older that 5.5.X and I am powerless to update the version. So I know that some of the syntax I am using has been deprecated in more recent PHP versions. I don't mean to sound snarky or ungrateful but I really need some help solving this problem versus unhelpful comments about deprecated code. Third I am adapting code from the guys at TechStream so H/T to them.
Here is what I am trying to build. My office helps other offices in my large organization manage their records through the creation of a file plan. We are currently using a clunky, user-unfriendly Access database that was created back in 2009. I am tasked to transition that Access hoopty into a proper, web-based, user friendly system. The index.php form page consists of 2 parts.
You can see the original TechStream demo he http://demo.techstre...ssing-with-PHP/
I've adapted the top part of the form ("Travel Information") for my users to enter information about their office such as Office Name, Office Code, Office Chief, Creator (the user), Status and date. I've adapted the bottom part of the form ("Passenger Details") to be "Folder Details". This is an html table where users can add up to 10000 rows to list all the folders for their office by entering the folder name in the text box and then assign descriptors to each folder using the drop down menus. I've changed the drop down menus to reflect the descriptors we need, i.e. file-series, classification, media type. The user needs the flexibility to add folders as the number of folders will vary between offices. This adding and deleting of folders is accomplished dynamically through a javascript script.js file.
Now, here's my problem. When the user clicks submit button that fires a php script that runs an insert into query to place the array data into the backend mysql database. However, when the foreach loop is only inserting the office office from the top portion of the form with the first folder in the bottom portion of the form. In other words let's say the user fills out the top part with his office information and then adds 5 folders into the html table at the botton. The first folder will be inserted into the database table with both office information and folder information. However the subsequent 4 folders will have their folder information inserted into the table but the office information fields will be null. The office information needs to be inserted with each folder the user adds to the html table piece.
I suspect that my foreach loop is only capturing that office information on the first iteration of the loop and then flushing or deleting the office information after the first loop. Also, I suspect there is some disconnect between the html table for entering individual folders and the top part of the form that is not in html format. Any help I can get is most welcome. Thanks in advance! Code is below.
index.php

    <?php
    session_start();
    if(!isset($_SESSION['myusername'])) {
    header('Location:index.php');
     }

    echo $_SESSION['myusername'];
    echo '<a href="logout.php"><span>Logout</span></a></li>';

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
        <title>Records Management File Plan Application</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
        <link rel="stylesheet" type="text/css" href="css/default.css"/>
        <script type="text/javascript" src="js/script.js"></script>
    </head>
    <body>    
        <form action="InsertFileDetailArraytoDB.php" class="register" method="POST">
            <h1>Office File Plan Application/h1>
            <fieldset class="row1">
                <legend>Office Information</legend>
                <p>
                    <label>Office Code *
                    </label>
                    <input name="officecode[]" type="text" required="required"/>
                    <label>Date*
                    </label>
                    <select class="date" name="day[]">
                        <option value="1">01
                        </option>
                        <option value="2">02
                        </option>
                        <option value="3">03
                        </option>
                        <option value="4">04
                        </option>
                        <option value="5">05
                        </option>
                        <option value="6">06
                        </option>
                        <option value="7">07
                        </option>
                        <option value="8">08
                        </option>
                        <option value="9">09
                        </option>
                        <option value="10">10
                        </option>
                        <option value="11">11
                        </option>
                        <option value="12">12
                        </option>
                        <option value="13">13
                        </option>
                        <option value="14">14
                        </option>
                        <option value="15">15
                        </option>
                        <option value="16">16
                        </option>
                        <option value="17">17
                        </option>
                        <option value="18">18
                        </option>
                        <option value="19">19
                        </option>
                        <option value="20">20
                        </option>
                        <option value="21">21
                        </option>
                        <option value="22">22
                        </option>
                        <option value="23">23
                        </option>
                        <option value="24">24
                        </option>
                        <option value="25">25
                        </option>
                        <option value="26">26
                        </option>
                        <option value="27">27
                        </option>
                        <option value="28">28
                        </option>
                        <option value="29">29
                        </option>
                        <option value="30">30
                        </option>
                        <option value="31">31
                        </option>
                    </select>
                    <select name="month[]">
                        <option value="1">January
                        </option>
                        <option value="2">February
                        </option>
                        <option value="3">March
                        </option>
                        <option value="4">April
                        </option>
                        <option value="5">May
                        </option>
                        <option value="6">June
                        </option>
                        <option value="7">July
                        </option>
                        <option value="8">August
                        </option>
                        <option value="9">September
                        </option>
                        <option value="10">October
                        </option>
                        <option value="11">November
                        </option>
                        <option value="12">December
                        </option>
                    </select>                   

                    <select name="year[]">
                        <option value="2013">2013
                        </option>
                        <option value="2014">2014
                        </option>
                        <option value="2015">2015
                        </option>
                        <option value="2016">2016
                        </option>                       
                    </select>

                </p>
                <p>
                    <label>Office Chief*
                    </label>
                    <input name="officechief[]" required="required" type="text"/>

                    <label>Status*
                    </label>
                    <select name="status[]">
                        <option value="Draft">Draft
                        </option>
                        <option value="Submitted">Submitted
                        </option>
                        <option value="Approved">Approved
                        </option>
                    </select>
                </p>
                <p>
                    <label>Creator *
                    </label>
                    <input name="creator[]" required="required" type="text"/>
                </p>
                <div class="clear"></div>
            </fieldset>
                <fieldset class="row2">
                <legend>Folder Details</legend>
                <p>
                    <input type="button" value="Add Folder" onClick="addRow('dataTable')" />
                    <input type="button" value="Remove Folder" onClick="deleteRow('dataTable')"     />
                    <p>(All actions apply only to entries with check marked check boxes.)</p>
                </p>
            <table id="dataTable" class="form" border="1">
                <tbody>
                    <tr>
                    <p>
                        <td><input type="checkbox" required="required" name="chk[]"     checked="checked" /></td>
                        <td>
                            <label>Folder Name</label>
                            <input type="text" required="required" name="BX_NAME[]">
                        </td>
                        <td>
                            <label for="BX_fileseries">File Series</label>
                            <select id="BX_fileseries required="required"   name="BX_fileseries[]">
                            <option>100-01-Inspection and Survey/PII-NO</option>
                            <option>200-02-Credit Card Purchases/PII-NO</option>
                            <option>300-07-Time and Attendance/PII-YES</option>                         
                        </td>
                        <td>
                            <label for="BX_classification">Classification</label>
                            <select id="BX_classification" name="BX_classification"         required="required">
                                <option>Unclassified</option>
                                <option>Confidential</option>
                                <option>Secret</option>
                                <option>Top Secret</option>
                                <option>Ridiculous Top Secret</option>
                                <option>Ludicrous Top Secret</option>
                            </select>
                        </td>
                        <td>
                            <label for="BX_media">Media</label>
                            <select id="BX_media" name="BX_media" required="required">
                                <option>Paper</option>
                                <option>Shared Drive</option>
                                <option>Film</option>
                                <option>Floppy Disk</option>
                                <option>Mixed</option>
                                <option>Other</option>
                            </select>
                        </td>
                            </p>
                        </tr>
                        </tbody>
                        </table>
                        <div class="clear"></div>
                    </fieldset>

                <input class="submit" type="submit" value="File Plan Complete &raquo;" />


                <div class="clear"></div>
                </form>

            </body>

    </html>

PHP script with foreach loop to loop through the array from index.php and insert into database: InsertFileDetailArrayToDB.php

    /*
    When the user has finished entering their folders, reviewed the form inputs for accuracy and clicks the submit button, this will loop through all folder entries and using the SQL insert into query will place them in the database.  When it     completes     data insertion it will redirect the user back to the file detail input form*/

    <?php

    /*this part requires the user to be logged in and allows their user name to be included in the insert into query.
    If you remove the "ob_start();" piece it will screw up the header statement down at the botton.  
    See the comments by the header statement for an explanation of its purpose*/

    ob_start();
    session_start();
    if(!isset($_SESSION['myusername'])) {
    header('Location:index.php')
    }

    /*these two lines would ordinarily display the user name and a link a
    allowing the user to log out. However this php script does not output anything
    so the user will never it.*/
    echo $_SESSION['myusername'];
    echo '<a href="logout.php"><span>Logout</span></a></li>';

    ?>

    <?php

    /*this include statement connects this script to the MySQL database
    so the user form inputs can be inserted into the file_plan_details
    table*/

    include ('database_connection.php');

    foreach($_POST['BX_NAME'] as $row=>$BX_NAME)

    {
        $BX_NAME1 = mysql_real_escape_string($_POST['BX_NAME');
        $officecode1 = mysql_real_escape_string($_POST['officecode'][$row]);
        $username1 = mysql_real_escape_string($_SESSION['myusername'][$row]);
        $day1 = mysql_real_escape_string($_POST['day'][$row]);
        $month1 = mysql_real_escape_string($_POST['month'][$row]);
        $year1 = mysql_real_escape_string($_POST['year'][$row]);
        $creator1 = mysql_real_escape_string($_POST['creator'][$row]);
        $officechief1 = mysql_real_escape_string($_POST['officechief'][$row]);
        $status1 = mysql_real_escape_string($_POST['status'][$row]);
        $BX_fileseries1 = mysql_real_escape_string($_POST['BX_fileseries'][$row]);
        $BX_classification1 = mysql_real_escape_string($_POST['BX_classification'][$row]);
        $BX_media1 = mysql_real_escape_string($_POST['BX_media'][$row]);

        $fileplandetailinsert1 = "INSERT INTO file_plan_details (folder_name, office_code, user_name, day, month, year, creator, office_chief, status, file_series, classification, media)
                  VALUES             ('$BX_NAME1','$officecode1','$username1','$day1','$month1','$year1','$creator1','$officechief1','$status1','$BX_fileseries1','$BX_classification1','$BX_media1')";


        mysql_query($fileplandetailinsert1);

            }

           /*this header statement redirects the user back to the folder detail input form after it inserts data into the db
           After I build a main navigation page, I will switch out index.php with whatever I name
           the script that will produce the main navigation page*/

           header('Location:index.php');

           ?>

script.js

function addRow(tableID) {
    var table = document.getElementById(tableID);
    var rowCount = table.rows.length;
    if(rowCount < 10000){                            // limit the user from creating fields more than your limits
        var row = table.insertRow(rowCount);
        var colCount = table.rows[0].cells.length;
        for(var i=0; i<colCount; i++) {
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
        }
    }else{
         alert("Maximum Passenger per ticket is 5.");
               
    }
}

function deleteRow(tableID) {
    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) {
            if(rowCount <= 1) {                         // limit the user from removing all the fields
                alert("Cannot Remove all the Passenger.");
                break;
            }
            table.deleteRow(i);
            rowCount--;
            i--;
        }
    }
}

Edited by mac_gyver, 17 December 2014 - 01:13 PM.
code tags around posted code please

Inserting Multiple Form Checkbox Results To Mysql Database

Similar Tutorials

Inserting Multidimensional Array Value Into Mysql

Similar Tutorials

Hi Guys

Clearly I still have lots to learn...

I am trying to insert (using mysqli) multi-dimensional array values into the database, but when i do the value that gets stored ends up as "$Array[1][1]".

Here's the test query i am running:

Code: [Select]
$sql = "INSERT INTO teams (company) VALUES ('$myarray[1][1]')";
$mysqli->query($sql);

So do i need to break the data out of the multidimensional array for the insert? Or is there some syntax thing i've missed?

Or worse still do i actually need to do:

Code: [Select]
$value1 = $myarray[0][0];

Any help would be very much appreciated!

Drongo

Trouble Inserting Array Variables Into Mysql

Similar Tutorials

I am trying to insert values stored within two dimensional array into mysql database but it does not work as I would expect it. The locations in mysql are defined as char length of 2. When I print_r the array it shows:
Array( [0] => Array ( [0] => 04 [1] => 22 [2] => 27 [3] => 28 [4] => 39 [5] => 43 [6] => 47 )) but when I insert them into the mysql like this:
Number1A='$MaxMillionsNumber[0][0]',
Number1B='$MaxMillionsNumber[0][1]',
Number1C='$MaxMillionsNumber[0][2]',
Number1D='$MaxMillionsNumber[0][3]',
Number1E='$MaxMillionsNumber[0][4]',
Number1F='$MaxMillionsNumber[0][5]',
Number1G='$MaxMillionsNumber[0][6]';

my values in mysql all show as Ar
What am I doing wrong?

Need Help Fetching Array Values From Database! Please! :))

Similar Tutorials

I have made an autocomplete form... originally the values were static:

$aUsers = array(
"Adams, Egbert",
"Altman, Alisha",
"Archibald, Janna",
);

Now I want the values from a database table DEVICES row name DeviceName:

$sql = "SELECT DeviceName FROM DEVICES";
$res = mysql_query($sql);

$aUsers = array();
while ($row = mysql_fetch_assoc($res)) {
$aUsers[] = $row;
}

It will not display the values in my autocomplete form when text is entered.... but with static data it will. Im confused!

Thank you