PHP - Post Data, Forms, And Database

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

Hello,

I'm having a little trouble getting my head around my code here. Basically, I have a table based PHP form in my html page that loops and adds a new row to the table depending on my variables

The table itself displays the amount of 'squads' you have, the name of the individual squads, how many people are in your squad, and an 'add button':

Your Squads: | People | Form Button
Squad 'name' |    2/5   | Add More?
Squad 'name' |    3/5   | Add More?
Squad 'name' |    1/5   | Add More?
Etc .....


Code for this table:
Code: [Select]
      <p><strong> Add Soliders To Squads:</strong>
      <br />Soliders avalible: <? echo $solidersToAdd ?>
   
     <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
    <table width="500" border="0" cellspacing="0" cellpadding="0">
    <?PHP
$max = $squadNumbers - 1;
$i = 0;

while($i <= $max){
$print = $i + 1;
echo"<tr>";
echo"<td width=\"200\" height=\"30\"><strong>Squad: ".$names_split[$i]."</strong></td>";
    echo"<td width=\"200\" height=\"30\">".$content_split[$i]."/5</td>";

if($content_split[$i] != 5){
echo"<td height=\"30\">";
echo"<input name=\"submitAdd\" type=\"submit\" class=\"SquadWeaponSelector\"
id=\"submitAdd_".$i."\" value=\"Add (".$solidersToAdd.")\" /></td>";
}
else{
echo"<td height=\"30\">Squad is full</td>";
}

$i++;
}
?>
    </table>
    </form>
This all works fine, but its the action form I'm struggling with, what I want is to be able to add a person to the specific squad the user pushed the button for and add to the database. NOTE: my database stores the content (players in squad) like so: 2,3,1 as a varchar and I use explode to split it into an array (this is the same with my squad names too).

So here is a snippet of what I got at the top of my document, the form action:

                        Code: [Select]
$squadNumbers = $info['squadNumbers']; // = 3
$squadNames = $info['squadNames'];       // = Alpha,Beta,Oscar
$squadContent = $info['squadContent'];   // = 2,3,1

// split the squad content \\
$content_split = explode(",", $squadContent);

// split the squad names \\
$names_split = explode(",", $squadNames);

$solidersToAdd = 3; // will soon be retrieving off DB

                     if (isset($_POST['submitAdd']) && $solidersToAdd != 0) {
$i = 0;
$max = $squadNumbers - 1;
$newContentArray = array();
while($i <= $max){
$print = $i + 1;
$newContentArray[whatever button was pressed] = 1 + $squadContent[whatever button was pressed];
$i++;
}

//$solidersToAdd--;
$glueContent = $_POST['submitAdd_1']; //implode(",",$newContentArray);
$result = mysql_query("UPDATE users SET squadContent='$glueContent' WHERE username = '$username'") or die(mysql_error());
}
First of, I dont know how to have a button actually pass on a value such as '+1', and I need it to talk specifically to that squad.

I would appreciate any help, many thanks in advance.

I have the following code, (I'm sorry it's so long an it does more that the question asks.)

It's ment to edit, delete and make new links in a mysql database, by also using a link header to home all the links (Like a dropdown menu) And thig manages the links. However then the update, or when the new form is submitted it leaves then titlereg field blank. (The titlereg is the id of the main link, it's called reg in the title_reg database) I know this is complicated and i'm not too good at explaining the problem but any help would be great. I have commented on anything that could help.

<?php
include "../includes/mysql_connect.php";
include "../includes/info_files.php";

echo "<strong>Links</strong><br />";
echo "Currect links:<br /><br />";

if($_POST['submit']){

$name = mysql_real_escape_string($_POST['name']);
$titlereg = mysql_real_escape_string($_POST['titlereg']);
$url = mysql_real_escape_string($_POST['url']);
$id = mysql_real_escape_string($_POST['id']);

mysql_query("UPDATE nav_sub SET name='$name', SET titlereg='$titlereg', SET url='$url' WHERE reg='$id'"); ////////////////////////////////// Here will help, the update MY SQL thingie
echo "Link Changed.<br /><br />";
}
elseif($_POST['remove']){

$id = mysql_real_escape_string($_POST['id']);

mysql_query("DELETE FROM nav_sub WHERE reg='$id'");
echo "Link deleted.<br /><br />";
}
else{
$result = mysql_query("SELECT * FROM nav_sub");

while($row = mysql_fetch_array($result))
  {
echo '<strong>' . $row['name'] . '</strong>';
echo '<form action="" method="post">';
echo 'Name: <input type="text" name="name" value="' . $row['name'] . '" /><br />';
echo 'Link: <input type="text" name="text" value="' . $row['url'] . '" /><br />';
echo 'Navigation title: <select name="titlereg">';

$resultabc = mysql_query("SELECT * FROM nav_title");

while($rowabc = mysql_fetch_array($resultabc))
  {

echo '<option value="' . $rowabc['reg'] . '">' . $rowabc['name'] . '</option>'; ////////////////////////////////// Here is the option
  
  }
echo '</select>';
echo '<input type="hidden" name="id" value="' . $row['reg'] . '" />';
echo '<input type="submit" name="submit" value="Change" /> <input type="submit" name="remove" value="Remove" /><br />';
echo '</form>';
  }
}

echo "New link:<br /><br />";

if($_POST['new_submit']){ ////////////////////////////////// Here!!!!!!!!!!!!!!!
$result = mysql_query("SELECT * FROM nav_sub");

$new_titlereg = $_POST['new_titlereg'];
$new_name = mysql_real_escape_string($_POST['new_name']);
$new_url = mysql_real_escape_string($_POST['new_url']);

mysql_query("INSERT INTO `nav_sub` (`titlereg` ,`reg` ,`name` ,`url`)VALUES ('$new_titlereg', '', '$new_name', '$new_url')"); ////////////////////////////////// here is the MY SQL statement...
echo "Link added.<br /><br />";
}

echo '<form action="" method="post">';
echo 'Name: <input type="text" name="new_name" value="" /><br />';
echo 'Url: <input type="text" name="new_url" value="" /> \\\\ If your linking to a page you made, then the url is index.php?catt=(The categrory you put)&page=(The page you put)<br />';
echo 'Navigation title: <select name="new_titlereg">';

$resultab = mysql_query("SELECT * FROM nav_title");

while($rowab = mysql_fetch_array($resultab))
  {

echo '<option value="' . $rowab['reg'] . '">' . $rowab['name'] . '</option>'; ////////////////////////////////// Here isn't submitting the value in the option
  
  }
echo '</select>';
echo '<input type="submit" name="new_submit" value="Insert" /><br />';
echo '</form>';
?>

By the way, explain simply as I'm only 13

Hi, I've currently started to modify a chat script of mine to output a moderation panel but the moderation page seems empty(blank) every time I load it. What im trying to do is to take the ID part in my URL via the $_GET and look it up in my database table in the column named id, then select that specific row to be able to retrieve the StringyChat_ip and place it into another table to ban the IP and the second thing im trying to do is to be able to delete the specific row from my table.   My Http link look something like    http://imagecrab.fre.../ban.php?id=159   and my ban.php page where I want to lookup the 159 part and do the banning etc looks like

<?
include("admin_code_header.php");


if ($_POST["DeletePost"]) {
    $id = $_POST['id'];
    $query = "DELETE FROM ".$dbTable." WHERE id='".$id."'"; 
    mysql_query($query);
    echo "ID removed from system: ".$id;
  }


if ($_POST["BanIP"]) {
    $IP_To_Add = $_POST["ip"];
    
      $sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
      $result = mysql_query($sql);
  }
$result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'",$db);

  while ($myrow = mysql_fetch_array($result)) {
    $msg = $myrow["StringyChat_message"];
$idm = $myrow["id"];



?>
<html>
<form name="form<? echo $myrow["id"];?>" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<input name="DeletePost" type="submit" id="DeletePost" value="Delete">

<input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
    </form>
</html>
<?
}
?>

hi guys, im new to this forum

I'm new also to php, I need help from you guys:

I want to display personal information from a certain person (the data is on the mysql database) using his name as a link:

example:
               (index.php)
               names
                          1. Bill Gates
                          2. Mr. nice Guy
           
i want to click Bill Gates
 
   (output.php)
     Name: Bill Gates
     Country:xxxx
     Age: xx   
                 etc.

How can i make this or how to learn this?
   
                 

             
               

   
       

I have two forms that I have created.

I wonder if someone could point out where I am going wrong, all data is commented so it should be easier to understand.

form1.php
Code: [Select]
<?php 

    $digest = 0;
    $amount = 0;
$trans_id = 0;
$merchant = "so";
    $remotepassword = "s0";
    
    if ($_POST) {
        $digest_this = $_POST['trans_id'] + $_POST['amount'] + $remotepassword; //combine all my values to be md5'd
        $digest = md5($digest_this); //generate the md5 hash

$amount = $_POST['amount']; //what I think I am doing here is posting the data so it can be retrived 
$trans_id = $_POST['trans_id']; //by a get request on from 2, this is where I need help
$merchant = $_POST['merhcant'];
$remotepassword = $_POST['remotepassword'];

    } // end $_POST

?>   

   <form action="part2.php" method="post">
    <p>

    <label for="trans_id">Invoice Number(s): </label>
              <input id="trans_id" type="text" name="trans_id" /><br />
    <label for="amount">Amount Paying: </label>
              <input id="amount" type="text" name="amount" /><br />
 
 
 
 
<input value="Send" type="submit" /> <input type="reset" />&#160;</p>
 </form>
form2.php
Code: [Select]
<?php 
if ($_GET) {
$digest = $_GET['digest'];  //here I think I am retriving the data I sent with a post request
$merchant = $_GET['merhcant']; //and then storing it in variables
$remotepassword = $_GET['remotepassword'];
$amount = $_GET['amount'];
$trans_id = $_GET['trans_id'];
} // end $_GET
?>

 <form action="https://www.secpay.com/java-bin/ValCard" method="post">
    <p>
    <label for="firstname">First Name: </label>
              <input id="firstname" type="text" name="firstname" /><br />
    <label for="lastname">Last Name: </label>
              <input id="lastname" type="text" name="lastname" /><br />
    <label for="account">Account Number: </label>
              <input id="account" type="text" name="account" /><br />
    <label for="housenumber">House Number/Name: </label>
              <input id="housenumber" type="text" name="housenumber" /><br />     
    <label for="postcode">Postcode: </label>
              <input id="postcode" type="text" name="postcode" /><br />   
    <label for="email">Email: </label>
              <input id="email" type="text" name="email" /><br />
    <label for="notes">Notes: </label>
              <input id="notes" type="text" name="notes" /><br />


<!-- Here I have taken all the inputs from the form that are required to be sent -->
<!-- and given the input_id names as the values required by the pay point servers -->
   
    <input name="callback" value="http://www.sol.co.uk/authorised;http://www.sol.co.uk/declined" type="hidden" />
    <input name="merchant" value="<?php echo "$merhcant"; ?>" type="hidden" /> <!--here I am populating hidden fields with php script data-->
    <input name="remotepassword"  value="<?php echo "$remotepassword"; ?>" type="hidden" />
    <input name="req_cv2" value="true" type="hidden" />
    <input name="options" value="test_status=true" type="hidden" />   
    <input name="digest" value="<?php echo "$digest"; ?>" type="hidden" />
   
<!-- Here I have defined all of the constant hidden values that never change -->
<!-- Now in this section of the form I have defined the value that will change, combining the three fields -->
<!-- that are required in order to create the digest value -->
   <input value="Send" type="submit" /> <input type="reset" />&#160;</p>
 </form>
Thanks for looking, I think its something basic im missing, first time doing this if you hadnt of guessed

Hi guys,

Was wondering if you could help. Apart from using a form are the other ways to POST to a mysql database? e.g. using clicking a link or so.

I know this should be easy...

I have several text input boxes where I enter data to be sent to one column of my database.
Code: [Select]
[while($row = mysql_fetch_array( $result ))
{
$i=1;
if ($row['game_id']='$i')
{
echo "<tr>";
echo "<td>"; echo $row['date'];
echo "</td><td>"; echo $row['team_name'];
echo "</td><td>"; echo $row['owner'];
echo "</td><td>";
echo "<input type='text' size='4' name='result[]'>";
echo "</td></tr>";
Not every box has a value so my array will end up with several numbers and several "blanks".
I echoed the array using Code: [Select]
$result = ("$_POST[result]");
and all the values are returned as expected.

Now I need to UPDATE the "pt_spread" column in the database inserting all the values (even the blank values).

I tried the following but can't get it to actually post anything into the database.
Code: [Select]
<?php

header("Location: admin_main_entry.php");

include("opendatabase.php");

$result = ("$_POST[result]");
foreach ($result as $spread)
{
$sql = "
UPDATE schedule 
SET pt_spread = '$spread'
WHERE week_id = '$weekID'" ;

mysql_query($sql);
}

mysql_close($con)
?>Can anyone show me the correct way to do this? Thanks.

Hello,

I made myself a simple blog system, but in my case "simple" becomes difficult when it comes to writing an article. Have you ever seen that movie about how facebook was created (I think it's called "Social network" or something like that)? As a newbie web developer I noticed how "Mark" was writting his blog post. I think it was an textarea, and when he was writing article, he wrote it with html tags, like <p>. So, I have now the same problem: when I'm writing article, I have to write it with all div's and p's and a's and img's and so on. I want to avoid that. Few ideas did pop to my head: use preg_replace for some elements, and set up some javascript WYSIWYG editor (but i really don't want it, and can't explain why, I just don't like it). I have a couple of css classes for images, both of them resizes images, one resizes it a lot, other not so much, both make them smaller. One class is for image to be on the left, so the text would wap that image from the right. After paragraph I must clear floats with css class. Other image class just takes full width available and if image is bigger that that available width - it resizes image. So no need to clear floats.

How can I make my life easier when I'm writing article to my blog?

Code: [Select]
<?php

$con = mysql_connect("localhost", "root", "");
$name = $_GET['jente_navn'];
$name = mysql_real_escape_string($name);
$ip = $_SERVER['REMOTE_ADDR'];
mysql_select_db("name", $con);

if ( preg_match("/^[^a-z]|[^A-Z]+/i", $name) )
{
die ("Feil: Kan bare bruke gyldige tegn");
}else{
$sql = 'SELECT * FROM banned WHERE name= \'' . $name . '\' OR ip= \'' . $ip . '\'';
$result = mysql_query($sql);

if( mysql_num_rows($result) ){
print "That Name, or your ip adress is. BANNED!";
}
}

$sql = "INSERT INTO girl ('girl','accepted','ip') VALUES ('$name', '0', '$ip');";

if ( mysql_query($sql, $con) ){
mysql_close($con);
header('http://localhost/takk.php');
}else{
mysql_close($con);
header('http://localhost/error.php');
}
?>

I don't get any errors, but it still doesn't post the name in the database, even though the name doesn't exist or ain't banned. :s

Hi..

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

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

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

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

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

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

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

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

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

</ul>
</div>

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

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

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

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

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

?>

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

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

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

</select>
</div>

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

</select>
</div>

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



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


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

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

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

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

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


the problem is only the last data was save.

I will attach my form.

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

Thank you so much for your understanding and help.

Hi guys, I think I may be losing my marbles over this form I've put together. I'm trying to get my code to post the following to a database but my MySQL and PHP isn't that good, so wondering if any one could possibly suggest what I could do?

Here is my code:

Code: [Select]
<?php

// we check if everything is filled in

if(empty($_POST['fname']) || empty($_POST['lname']) || empty($_POST['email']))
{
die(msg(0,"All the fields are required"));
}


// is the sex selected?

if(!(int)$_POST['sex-select'])
{
die(msg(0,"You have to select your sex"));
}


// is the birthday selected?

if(!(int)$_POST['day'] || !(int)$_POST['month'] || !(int)$_POST['year'])
{
die(msg(0,"You have to fill in your birthday"));
}


// is the email valid?

if(!(preg_match("/^[\.A-z0-9_\-\+]+[@][A-z0-9_\-]+([.][A-z0-9_\-]+)+[A-z]{1,4}$/", $_POST['email'])))
die(msg(0,"You haven't provided a valid email"));



// I think here is where I need to put something to get the data into a table!




echo msg(1,"registered.html");


function msg($status,$txt)
{
return '{"status":'.$status.',"txt":"'.$txt.'"}';
}
?>
How do I get the $_POST['day'] and $_POST['month'], $_POST['year'] etc into a table? It should be so easy but my head is hurting from trying lots of things and tutorials online.

Any thoughts my PHP Freaks?

im trying to understand this Post Data script it's not posting, no errors:

postdata.php
Code: [Select]
<?php
 
//create array of data to be posted
//$post_data['firstName'] = 'Name';
$post_data['item_name'] = '12345';
 
//traverse array and prepare data for posting (key1=value1)
foreach ( $post_data as $key => $value) {
    $post_items[] = $key . '=' . $value;
}
 
//create the final string to be posted using implode()
$post_string = implode ('&', $post_items);
 
//we also need to add a question mark at the beginning of the string
$post_string = '?' . $post_string;
 
//we are going to need the length of the data string
$data_length = strlen($post_string);
 
//let's open the connection
$connection = fsockopen('www.example.com', 80);
 
//sending the data
fputs($connection, "POST  /i.php  HTTP/1.1\r\n");
fputs($connection, "Host:  www.example.com \r\n");
fputs($connection,
    "Content-Type: application/x-www-form-urlencoded\r\n");
fputs($connection, "Content-Length: $data_length\r\n");
fputs($connection, "Connection: close\r\n\r\n");
fputs($connection, $post_string);
 
//closing the connection
fclose($connection);

?>

reuslt should be posted here
i.php
Code: [Select]
<?php  require('database_connection.php');?>
<?php if(isset($post_items[0])) {


//$Subscription_id = mysql_real_escape_string($md5c);
//$PropertyID = mysql_real_escape_string($rowData['ID']);
//$User_ID = mysql_real_escape_string($rowData['User_ID']);
$item_name=mysql_real_escape_string($post_items[0]);
$query = 'INSERT INTO SP_subscriptions(id,) values("'.$item_name.'")';
 //$query = 'INSERT INTO SP_subscriptions(id,PropertyID,User_ID) values("'.$item_name.'","'.$PropertyID.'","'.$User_ID.'")';

$success = mysql_query($query);


    }
else
{ $item_name=54321;
$query = 'INSERT INTO SP_subscriptions(id) values('.$item_name.')';
 //$query = 'INSERT INTO SP_subscriptions(id,PropertyID,User_ID) values("'.$item_name.'","'.$PropertyID.'","'.$User_ID.'")';

$success = mysql_query($query);}

//var_dump($_POST);
//var_dump($query);
echo $query;


?>

Hi
I have a little strange problem.

I cannot get the post data from my form. It works fine if there is 10 or 15 user but reaching 40 or more than form values not posting.

This is output of size:
echo (int) $_SERVER['CONTENT_LENGTH'];  ===== 22164

Code: [Select]
if(isset($_POST['hiddenField']))
{
    // do some work;
}

$sql = mysql_query("SELECT id, name FROM user WHERE shop_id = '" .$_SESSION['id']. "' ORDER BY name ASC");
while($row = mysql_fetch_array($sql))
{
echo '
<div style="width:100%; border:solid 1px #CCC; background-color:#f1e7e7; margin-bottom:5px;">
<table class="tableSmall">
<tr><th width="81">' .$row['name']. '</th><th width="71">';
echo $grl_pic .'
</th>
<td width="622"><table width="100%">
<tr>';
for($j=0; $j<7; $j++)
{
$sql2  = mysql_query("SELECT user_master_id, user_start, user_end FROM work_master WHERE user_master_id = '" .$row['id']. "' AND date = '" .$days_no_kanji[$j]. "'");
$row2 = mysql_fetch_array($sql2);
if(mysql_num_rows($sql2) == 0)
{
$start = "00:00";
$end   = "00:00";
$m    = 0;
}
else
{
$start = $row2['user_start'];
$end   = $row2['user_end'];
$m    = 1;
}
echo '
<th><input type="hidden" name="userData[]" value="' .$row['id']. '_' .$j .'_' .$m. '" />
<select name="' .$row['id']. '_' .$j .'_' .$m. '_start">' .ShopHour($start). '</select><br />～<br />
<select name="' .$row['id']. '_' .$j .'_' .$m. '_end">' .ShopHour($end). '</select>
</th>';
}
echo '
</tr>
</table></td>
</tr>
</table>
</div>';
}
Is there someone has any idea why php is not posting?

Guys, quick one.

Im writing a script for a form to post info into a MySql table.

Now rather than just having a single row for input I'd like to have lets say 10 rows, so I can add 10 records to the database.

What I'm pondering is 2 things:

1: can i just repeat
  Code: [Select]
<input type="text" name="opponent" size="27" />
over and over, or is it going to need its own name each time for example;
Code: [Select]
<input type="text" name="opponent2" size="27" />
<input type="text" name="opponent3" size="27" />

2: when it comes to the processing script is it more economical to have the forms input field named the same over and over (if it IS possible) and if not whats the most econimcal way to code my
Code: [Select]
$opp= $_POST['opponent'];
$query="INSERT INTO fixtures (match_date, season, opponent) VALUES ('$date', '$season', '$opp',)";


Your help and comments are appreciated as always guys

Tom