PHP creating extra table rows with a given value.

TAVi80

Hello guys. First let me tell you that I'm realy n00b in coding bussiness, my real job involves 3D design not web design, but still I have a very important project and it seems I can only get help by asking YOU people realy nice . 🙇 🙇

So my problem is:...

First on the page I have 2 text fields, for example, one with a "Batch Nr.", and another with "Person Nr".
I also want to have a hidden form with a table that will appear only after I've clicked on the subbmit button (CREATE) in my case.

And here is the catch. My table has only 1 row created, that's the title row, BUT the next rows (the number of) are needed to be created by the given value in the "Person Nr." text box. In other words, if I have 5 persons imputed, than the table will need to have extra 5 rows.

I have drawn a sketch in paint ( :oops: ) to easily understand what I'm asking...:

Then after creatind the rows, I need that the first column to be populated first, with "Batch number", then with a 3 digit nr, from 001 to "Person Nr.", for example 165001.

THANK YOU GUYS IN ADVANCE, I kind of known the principle of how to do this, but I need some code, because PHP programing is not my strongest point.
Thank you again.

dagon

you either need two pages or you will have to use js to create the fields that appear after create

TAVi80

dagon;10902843 wrote:
you either need two pages or you will have to use js to create the fields that appear after create

Ok, can you give a little more details please. For me it doesn't matter if is PHP or JapaScript, as long as I'm able to meke this. Tnks in advance.

dagon

you have to decide which approach to take.

TAVi80

dagon;10902847 wrote:
you have to decide which approach to take.

Ok. I've asked some people they tell me is much simpler in PHP, but I get better results by using JavaScript. Like I said, if anyone decided to help me with, It wont matter what language will use.

Ok, for now I will prefer PHP since I have some basic knowledge.

Thanks.

TAVi80

Here is my page, I really managed to do something here...The problem is I cannot preview the data in the textboxes after writing it, but more important I don't know how to do it to upload all of the data in the MySQL table. I mean, I know for 1 persons, but not for all. Can you help me a little here pls??

<?php require_once('../Connections/DB_rev00.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $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;
}
}

mysql_select_db($database_DB_rev00, $DB_rev00);
$query_Batch_in = "SELECT trainee_code, sur_name, given_name, middle_name, nickname FROM passport_info";
$Batch_in = mysql_query($query_Batch_in, $DB_rev00) or die(mysql_error());
$row_Batch_in = mysql_fetch_assoc($Batch_in);
$totalRows_Batch_in = mysql_num_rows($Batch_in);

mysql_select_db($database_DB_rev00, $DB_rev00);
$query_compcode = "SELECT comp_code FROM comp_info";
$compcode = mysql_query($query_compcode, $DB_rev00) or die(mysql_error());
$row_compcode = mysql_fetch_assoc($compcode);
$totalRows_compcode = mysql_num_rows($compcode);
?><html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Batch Member Input</title>
<style type="text/css">
<!--
#title {
	position:absolute;
	left:150px;
	top:82px;
	width:742px;
	height:154px;
	z-index:1;
}
body {
	background-repeat: no-repeat;
}
#apDiv1 {
	position:absolute;
	left:150px;
	top:163px;
	width:699px;
	height:272px;
	z-index:2;
}
.style5 {font-size: smaller; font-weight: bold; }
.style8 {font-weight: bold}
#apDiv2 {
	position:absolute;
	left:128px;
	top:182px;
	width:727px;
	height:164px;
	z-index:3;
}
#apDiv3 {
	position:absolute;
	left:149px;
	top:637px;
	width:725px;
	height:631px;
	z-index:4;
}
.style10 {
	font-size: small;
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style12 {color: #2A0055}
#list_tbl1 {
	position:absolute;
	left:148px;
	top:503px;
	width:726px;
	height:174px;
	z-index:4;
}
#tbl01 {
	position:absolute;
	left:147px;
	top:503px;
	width:730px;
	height:508px;
	z-index:4;
}
#apDiv4 {
	position:absolute;
	left:148px;
	top:504px;
	width:744px;
	height:484px;
	z-index:4;
}
.style14 {color: #000000}
.style16 {color: #000000; font-weight: bold; }
#apDiv5 {
	position:absolute;
	left:17px;
	top:219px;
	width:105px;
	height:66px;
	z-index:5;
}
#apDiv6 {
	position:absolute;
	left:127px;
	top:442px;
	width:742px;
	height:196px;
	z-index:4;
}
#apDiv7 {
	position:absolute;
	left:102px;
	top:730px;
	width:725px;
	height:191px;
	z-index:4;
}

-->
</style>
</head>

<body>
<div id="apDiv2">
  <p>

<style type="text/css">
body{
    font-size:10pt;
    font-family:Arial,Tahoma,Verdana;
    color:#555;
}
table{
    background:#777;
    border:1px solid #cfcfcf;
}
td,th {
    background:#fff;
    padding:10px;
}
td {
    font-size:10pt;
}
form ul {
    list-style-type:none;
    width:250px;
}
form ul li {
    margin-top:1px;
    padding:10px;
    height:30px;
    border:1px solid #999;
}
strong.err {
    color:#930;
    display:block;
    margin:5px 0px;
}
#tab2 {
    margin-bottom:5px;
}
#tab2 input{
    border:0px;
    background:none;
}
  </style>
</p>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

 <p>
   <?php
error_reporting(0);
$batch = $_POST['batch_nr']; // Get batch textbox
$person = $_POST['person_nr']; // Get person textbox
?>
     </p>
  <table width="177" border="1" cellpadding="2" cellspacing="1" bordercolor="#2A0000">
       <tr>
         <th width="119" align="left" bordercolor="#6E0067" bgcolor="#2A00AA" scope="row"><span class="style12">&#12496;&#12483;&#12481;&#30058;&#21495;</span></th>
         <td width="41" align="center"><input name="batch_nr" type="text" id="batch_nr" value="<?php echo $batch; ?>" size="2" maxlength="3"></td>
       </tr>
       <tr>
         <th align="left" bordercolor="#6E0067" bgcolor="#2A00AA" scope="row"><span class="style12">&#12496;&#12483;&#12481;&#20154;&#25968;</span></th>
         <td align="center"><input name="person_nr" type="text" id="person_nr" value="<?php echo $person; ?>" size="2" maxlength="3"></td>
       </tr>
     </table>

<p class="style10">&#19978;&#35352;&#12398;&#26465;&#20214;&#12391;&#12496;&#12483;&#12481;&#12513;&#12531;&#12496;&#12540;&#30331;&#37682;&#34920;&#20316;&#25104;&#12375;&#12414;&#12377; </p>
 <p>
   <input type="submit" name="submit1" value="&#23455;&#34892;">
</p>
  </form>





</div>



<div id="tbl01">
<?php
    if (isset($_POST['submit1'])) {
    $person = (int)$person;
        if($batch==''||$person=='')
            echo "<strong class='err'>Please ensure that \"Person nr.\" is a number</strong>";
        else {
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<p class="style10">&#12496;&#12483;&#12481;&#12513;&#12531;&#12496;&#12540;&#30331;&#37682;&#34920; </p>
  <span class="style10">&#12300;&#21517;&#21069;&#12301;&#12289;&#12300;&#12491;&#12483;&#12463;&#12493;&#12540;&#12512;&#12301;&#12289;&#12300;&#37197;&#23646;&#20808;&#20250;&#31038;&#12467;&#12540;&#12489;&#12301;&#12434;&#20837;&#21147;&#12375;&#12390;&#12367;&#12384;&#12373;&#12356;</span>

<table width="730" height="99" border="1" cellpadding="2" cellspacing="1" bordercolor="#2A0000" id="tab02">
<tr>
  <th width="100" scope="col"><span class="style14">&#30740;&#20462;&#29983;&#30058;&#21495;</span></th>
  <th colspan="3" scope="col"><span class="style14">&#21517;&#21069;</span></th>
  <th width="108" scope="col"><span class="style14">&#12491;&#12483;&#12463;&#12493;&#12540;&#12512;</span></th>
  <th width="158" scope="col"><p class="style14">&#37197;&#23646;&#20808;&#20250;&#31038;&#12467;&#12540;&#12489;</p></th>
</tr>
<tr>
  <td align="center"><span class="style16">Trainee code</span></td>
  <td width="95" align="center"><span class="style16">Sur Name</span></td>
  <td width="122" align="center"><span class="style16">Given Names</span></td>
  <td width="102" align="center"><span class="style16">Middle Name</span></td>
  <td align="center"><span class="style16">Nickname</span></td>
  <td align="center"><span class="style16">Company Code</span></td>
</tr>


<?php
            for($i=1;$i<=$person;$i++) {
                echo "
                    <tr>
                        <td align='center'><input type='text' name='tc' value='{$batch}00{$i}' size='3' maxlength='3'></td>
                        <td align='center'><input type='text' name='sn' size='7'></td>
                        <td align='center'><input type='text' name='gn' size='7'></td>
                        <td align='center'><input type='text' name='mn' size='7'></td>
						<td align='center'><input type='text' name='nn' size='7'></td>
                        <td align='center'><input type='text' name='cc' size='4'></td>
                    </tr>
                ";
            }
        echo "

  </table>


    <input type='submit' name='submit2' value='Preview'>

    </form>

    ";

    }
}

if (isset($_POST['submit2'])) {
    // How to insert all the data from the texboxes in the mysql table???
    echo "

	I need here to list the data before inserting in the MySQL database table






	<table width='730' height='99' border='1' cellpadding='2' cellspacing='1' bordercolor='#2A0000' id='tab02'>
<tr>
  <th width='100' scope='col'><span class='style14'>&#30740;&#20462;&#29983;&#30058;&#21495;</span></th>
  <th colspan='3' scope='col'><span class='style14'>&#21517;&#21069;</span></th>
  <th width='108' scope='col'><span class='style14'>&#12491;&#12483;&#12463;&#12493;&#12540;&#12512;</span></th>
  <th width='158' scope='col'><p class='style14'>&#37197;&#23646;&#20808;&#20250;&#31038;&#12467;&#12540;&#12489;</p></th>
</tr>
<tr>
  <td align='center'><span class='style16'>Trainee code</span></td>
  <td width='95' align='center'><span class='style16'>Sur Name</span></td>
  <td width='122' align='center'><span class='style16'>Given Names</span></td>
  <td width='102' align='center'><span class='style16'>Middle Name</span></td>
  <td align='center'><span class='style16'>Nickname</span></td>
  <td align='center'><span class='style16'>Company Code</span></td>
</tr>




</table>








	";		
 }

?>


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

mysql_free_result($compcode);
?>

Thanks in advance