count()

auddog

I have a form that I want to keep bringing up until a count matches the quantity. I'm not sure how to do this and everything that I try just fails. I'm listing my code to show that I'm bringing in some variables from another page. I'm just not sure where to place count code.

<?php

//start session
session_start();

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

  //Initialize error array
  $errors = array();

  //check for a serial number
  if (empty($_POST['serial_no'])) {
      $errors[] = 'You forgot the serial number.';
      }

//Check for Total errors
if(empty($errors)) {

  //add information to database
  //include statement for database connectivity
  include 'config.php';

  // create a new mysqli object with default database
  $connection = mysqli_connect($hostname, $username, $password, $dbname) or die ("Unable to connect");

  // sql to INSERT a new record
  $sql = "INSERT INTO production
  (order_no, item_no, serial_no, price, fk_prodline_id)
  values
  ('$_POST[order_num]', '$_POST[item_num]', '$_POST[serial_no]', '$_POST[price]', '2')";

  //excute query
  $result = mysqli_query($connection, $sql) or die ("Error in query: $sql. ".mysqli_error());

  // close connection
  mysqli_close($connection);

 $qty_count = $count;

 ++$qty_count;

 //redirect to serial number input form again
  header("Location: horiz_entry_sn.php");

//if - else $errors
} else {

//report the errors
echo '<h1>Error!</h1>The following error(s) occurred: <br /><p>';
foreach ($errors as $msg) {

//print the errors message
echo "- $msg<br />\n";
}

echo '<p><p>Please go back and try again</p></p>';
}

//if - else statement isset
} else {

//recall session variables and assign to form variables
$price = $_SESSION['price'];

$order_num = $_SESSION['order_num'];

$item_num = $_SESSION['item_num'];

$quantity = $_SESSION['quantity'];

//$count = $_SESSION['count'];

?>
<script>
function toForm() {
document.horiz.serial_no.focus();
}
</script>
<html>
<head>
	<title>Intranet</title>
</head>
<?php

echo $count;

?>


<body onload="toForm()" BGCOLOR=#FFFFFF topmargin="0" leftmargin="0"
    marginheight=0 marginwidth=0 rightmargin=0 bottommargin=0>


<center>
  	<table border=0 cellpadding=0 cellspacing=0 width=100% vailn=top>
  	  <!-- server side include leftside nav table -->
        <!-- end of left side nav -->
        <br>
        <form name="horiz" method="post" action="horiz_entry_sn.php">
<div align="center">
  <p>&nbsp;</p>
  <table width="350" border="1" cellpadding="2" bordercolor="#000033"
    style='border-collapse: collapse'>
    <tr>
      <td colspan="3" bgcolor="#3399FF"><div align="center"><strong>
      <font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Order Number: <?php echo $order_num; ?></font></strong></div></td>
    </tr>
    <tr>
      <td colspan="3" bgcolor="#3399FF"><div align="center"><strong>
      <font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Item Number: <?php echo $item_num; ?></font></strong></div></td>
    </tr>
    <tr>
      <td colspan="3" bgcolor="#3399FF"><div align="center"><strong>
      <font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Quantity: <?php echo $quantity; ?></font></strong></div></td>
    </tr>
    <tr>
        <td>
		<table border=0 cellpadding=3 cellspacing=0 width=99%>
    <tr>
      <td width=100%><font size="2" face="ARIAL, SANS-SERIF">
      <p><strong>Serial Number:</strong><br>
              <input type="text" name="serial_no" size=50 maxlength=75>
      </p>
      </td>
    </tr>
    <tr>
      <td colspan="3">&nbsp;</td>
    </tr>
    <tr>
      <td colspan="3"><div align="center">
        <input type="submit" name="submit" value="submit">
        <input type="hidden" name="submitted" value="true" />
        <input type="hidden" name="price" value="<?php echo $price; ?>">
        <input type="hidden" name="order_num" value="<?php echo $order_num; ?>">
        <input type="hidden" name="item_num" value="<?php echo $item_num; ?>">
        <input type="hidden" name="quantity" value="<?php echo $quantity; ?>">
        <input type="hidden" name="qty_count" value="<?php echo $quantity; ?>">
      </div></td>
    </tr>
  </table>
<?php
}
?>

I would also like to have the somewhere on the page show the count (i.e. 3 of 12). If anyone knows of any white papers on something like this, I would be very interested. Thanks for any help you may be able to provide.

leatherback

hi,

Coud you please be more specific. You have been trying some things, yet your question is very generic. So if my reply is miles off.. Please explain a bit more..

From your post I understand:

=> You have something defining a quantity
=> You want to echo out a form, for as many times as the quantity?

Say, you have your form in a variable:

$formvar = "<form action=.....yadieyadieyadie";
$i=0;
While($i < $quantity)
  {
  echo $formvar;
  $i++;
  }

Echoing the count is easily done by
echo $i;

So, I am not sure what the questio is.

auddog

Wow, I never thought about it that way. If you don't mind can I ask a couple more questions. In what you show above that means I would need to echo out my entire form??? Is there an easy way to do that? I get where your going with this, I'm just not sure about echoing the whole form.

Will_Poulson

Generally you want to make a functions that echoes out form, then foreach loop up to the number you desire. The problem is you data names are doing to conflict with eachother, so you need to send the function which step of the loop you are on, then either append a 1 2 to each of your values, or have each loop of the form section send out as an array, and then count through that on the other side.

probably use a hidden value as your count indicator, rather than a fill-in form element.

Also, probably not echo out the whole form (method, actiion and such) just the repeated section.

Good luck