Saving runtime generated table rows in mysql database using php

reyhan · January 11, 2013

hi i am new to php and i am working on a form which has to generate a table row on the button click , but my problem is that i don't have any idea to how do i save that incremented textbox value in my databasa . Can anyone help me out please it would be a huge favor. i have attached my my php script and html script along with this message

here is my code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[url="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%22>"]http://www.w3.org/TR...nsitional.dtd">[/url]
<html xmlns="[url="http://www.w3.org/1999/xhtml%22>"]http://www.w3.org/1999/xhtml">[/url]
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
		<title>Makhtab</title>
		<link rel="stylesheet" type="text/css" href="form2/view.css" media="all">
			<script type="text/javascript" src="form2/view.js"></script>
			<script type="text/javascript" src="form2/calendar.js"></script>
			<meta http-equiv="Content-Script-Type" content="text/javascript">
				<script type="text/javascript">

						function deleteRow(row)
						{
						var i=row.parentNode.parentNode.rowIndex;
						document.getElementById('POITable').deleteRow(i);
						}


						function insRow()
						{
						console.log( 'hi');
						var x=document.getElementById('POITable');
						var new_row = x.rows[1].cloneNode(true);
						var len = x.rows.length;
						new_row.cells[0].innerHTML = len;

						var inp1 = new_row.cells[1].getElementsByTagName('input')[0];
						inp1.id += len;
						inp1.value = '';
						var inp2 = new_row.cells[2].getElementsByTagName('input')[0];
						inp2.id += len;
						inp2.value = '';
						x.appendChild( new_row );
						}
			</script>
						  <script type="text/javascript">

						function deletezimRow(row)
						{
						var i=row.parentNode.parentNode.rowIndex;
						document.getElementById('zimtable').deleteRow(i);
						}


						function inszimRow()
						{
						console.log( 'hi');
						var x=document.getElementById('zimtable');
						var new_row = x.rows[1].cloneNode(true);
						var len = x.rows.length;
						new_row.cells[0].innerHTML = len;

						var inp1 = new_row.cells[1].getElementsByTagName('input')[0];
						inp1.id += len;
						inp1.value = '';
						var inp2 = new_row.cells[2].getElementsByTagName('input')[0];
						inp2.id += len;
						inp2.value = '';
						x.appendChild( new_row );
						}
			</script>
								<!--<style type="text/css" title="currentStyle">
									@import "tran/css/layout-styles.css";
									@import "tran/css/themes/smoothness/jquery-ui-1.8.4.custom.css";
								</style>-->
			<script  type="text/javascript" src="tran/js/jquery-1.6.1.min.js"></script>
			<script  type="text/javascript" src="tran/js/jquery-ui-1.8.14.custom.min.js"></script>

			<script  type="text/javascript" src="tran/js/jq-ac-script.js"></script>
			</head>
			<body id="main_body" >

				<img id="top" src="form2/top.png" alt="">
					<div id="form_container">

						<h1><a>Untitled Form</a></h1>
						<form id="makhtab" class="appnitro" enctype="multipart/form-data" method="post" action="makhproc.php">
							<div class="form_description">
								<h2>Makhtab Details</h2>
								<!--<p>This is your form description. Click here to edit.</p>-->
							</div>
							  <table border="0px" width="100%">
								<tr>
									<td><label class="description" for="element_1">Code</label></td><td><input id="element_1" name="code" class="element text small" type="text" maxlength="6" value=""/></td>
								</tr>
								<tr>
									<td><label class="description" for="element_1">Name</label></td><td><input id="element_1" name="name" class="element text large" type="text" maxlength="40" value=""/> </td>
								</tr>

								<tr>
									<td><label class="description" for="element_1">Address</label></td><td><input id="element_4_1" name="add1" class="element text large" value="" type="text"></td>
								</tr>
								<tr>
									<td></td><td><input id="element_4_1" name="add2" class="element text large" value="" type="text"></td>
								</tr>
								<tr>
									<td></td><td><input id="element_4_1" name="add3" class="element text large" value="" type="text"></td>
								</tr>
								<tr>
									<td><label class="description" for="element_1">City</label></td><td><select name="cmbcity" class="element text medium" style="font-size:18px;"/>
										<option value=""></option>
										<?php
										mysql_connect("localhost", "root", '') or die(mysql_error());
										mysql_select_db("webapp") or die(mysql_error());
										$result = mysql_query("SELECT `name` from city ") or die(mysql_error());

										while ($year = mysql_fetch_array($result)) {

											echo "<option value='$year[name]'>$year[name]</option>";
										}
										?>
					</select>

								</tr>
																	<tr>
									<td><label class="description" for="element_1">State</label></td><td><select name="cmbstate" class="element text medium" style="font-size:18px;"/>
										<option value=""></option>
										<?php
										mysql_connect("localhost", "root", '') or die(mysql_error());
										mysql_select_db("webapp") or die(mysql_error());
										$result = mysql_query("SELECT `name` from state ") or die(mysql_error());

										while ($year = mysql_fetch_array($result)) {

											echo "<option value='$year[name]'>$year[name]</option>";
										}
										?>
					</select>
																	</tr>
							</tr>
							<tr>
								<td><label class="description" for="element_1">Country</label></td><td><select name="cmbcountry" class="element text medium" style="font-size:18px;"/>
									<option value=""></option>
									<?php
									mysql_connect("localhost", "root", '') or die(mysql_error());
									mysql_select_db("webapp") or die(mysql_error());
									$result = mysql_query("SELECT `name` from country ") or die(mysql_error());

									while ($year = mysql_fetch_array($result)) {

										echo "<option value='$year[name]'>$year[name]</option>";
									}
									?>
									</select>
								<tr>
									<td><label class="description" for="element_1">Telephone</label></td><td><input id="element_1" name="country" class="element text medium" type="text" maxlength="255" value=""/></td>
								</tr>
								<tr>
									<td><label class="description" for="element_1">Mobile</label></td><td><input id="element_1" name="country" class="element text medium" type="text" maxlength="10" value=""/></td>
								</tr>
								<tr>
									<br />
								</tr>

								</table>

									 <tr>
								<br /><p style="border-bottom: 1px dotted #ccc;"></p><br />
								<div class="form_description">
									<h2>Zimmedar Details</h2>
									<!--<p>This is your form description. Click here to edit.</p>-->
								</div>
							</tr>
									 <input type="button" id="addmorezimbutton" value="Add zimmedar" onclick="insRow()"/><br/><br/>
								<table id="zimtable" border="0px" size="100px" cellspacing="0" cellpadding="2">
									<tr>
										<td width="10" align="center"><label class="description">Srno. </label></td>
										<td width="118"><label class="description">Zimmedar Name</label></td>
										<td width="118"><label class="description">Mobile</label></td>

										<td width="10"></td>
										<td width="10" align="center"></td>
									</tr>
									<tr>
										<td>1</td>
										<td width="210"><input  size="40" maxlenght="40" type="text" id="zimame[]"/></td>
										<td width="80"><input  size="10" maxlenght="10" type="text" id="zimmob[]"/></td>

										<!--<td><input  size="45" maxlenght="10" type="text" id="momob"/> </td>-->
										<td><input type="button" id="addzimmore" value="+" onclick="inszimRow()"/></td>
										<td align="center"><input type="button" id="delzimbutton" value="-" onclick="deletezimRow(this)"/></td>
									</tr>

								</table>

																	 <tr>
								<br /><p style="border-bottom: 1px dotted #ccc;"></p><br />
								<div class="form_description">
									<h2>Muallim Details</h2>
									<!--<p>This is your form description. Click here to edit.</p>-->
								</div>
							</tr>
									 <input type="button" id="addmorePOIbutton" value="Add Muallims" onclick="insRow()"/><br/><br/>
									<table id="POITable" border="0px" size="100px" cellspacing="0" cellpadding="2">
										<tr>
											<td width="10" align="center"><label class="description">Srno. </label></td>
											<td width="118"><label class="description">Moallim Name</label></td>
											<td width="118"><label class="description">Mobile</label></td>
											<td width="118"><label class="description">Qabiliyat</label></td>
											<td width="10"></td>
											<td width="10" align="center"></td>
										</tr>
										<tr>
											<td>1</td>
											<td width="210"><input  size="40" maxlenght="40" type="text" id="moname[]"/></td>
											<td width="80"><input  size="10" maxlenght="10" type="text" id="momob[]"/></td>
											<td><select name="cmbmuallim[]" class="element text large" style="font-size:18px;"/>
												<option value=""></option>
												<?php
												mysql_connect("localhost", "root", '') or die(mysql_error());
												mysql_select_db("webapp") or die(mysql_error());
												$result = mysql_query("SELECT `name` from qabiliyat ") or die(mysql_error());

												while ($year = mysql_fetch_array($result)) {

													echo "<option value='$year[name]'>$year[name]</option>";
												}
												?>
												</select></td>
											<!--<td><input  size="45" maxlenght="10" type="text" id="momob"/> </td>-->
											<td><input type="button" id="addmore" value="+" onclick="insRow()"/></td>
											<td align="center"><input type="button" id="delPOIbutton" value="-" onclick="deleteRow(this)"/></td>
									</tr>
								</table>

										 <br /><p style="border-bottom: 1px dotted #ccc;"></p><br />
										 <table border="0px" width="85%">
											 <tbody><tr>
													 <td width="105"><label class="description">No. of Students</label></td>
													 <td width="65"><input type="text" name=stu" size="5" maxlength="5"></input></td>
													 <td width="105"><label class="description">No. of Batches</label></td><td width="14"><input type="text" name="batch" size="5" maxlength="3"></input></td>
												 </tr>
												 <tr>
													 <input type="submit" name="submit" value="Save"></input>

												 </tr>
											 </tbody>



										 </table>	
								</div>
								</div>
						</table>



						</form>  

						</body>
						</html>

makhtab.php

makhproc.php

Dharmender · January 11, 2013

<snip removed 100's of lines of quoted post>

Why you are again and again connecting to database and generating it.

Use it once at top of page. For generating table you can echo tr like this echo "<tr><td>"

PFMaBiSmAd · January 11, 2013

@Dharmender,

Please don't quote entire posts just to reply to them. Only quote things in a post you are specifically calling attention to.

Sign In

Saving runtime generated table rows in mysql database using php

Recommended Posts

reyhan

Link to comment

Share on other sites

Dharmender

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information