having probem inserting data into db table

Posted on 16th Feb 2014 07:03 pm by admin

hi

i have a table with following columns in it
Code: candidate_id, degree, cgpa, institute
and i have a dynamic form with some javascript in it. the problem in php script i think not in js. this form has two buttons when "need more fields" button and "submit" button. when the user clicks more fields button then three more fields appears. when user fills this form and press submit it it goes to db and insert there. the problem is when user fills as many fields as he wants but only first three fields enters into the db. and remaining of them does not enter. you can pick out what i am doing wrong in the following code.

Code: <script type="text/javascript">
var counter = 0;
//var counter = 0;
//Start a counter. Yes, at 0
function add_phone() {
counter++;
//I find it easier to start the incrementing of the counter here.
var newFields = document.getElementById('add_phone').cloneNode(true);
newFields.id = '';
newFields.style.display = 'block';
var newField = newFields.childNodes;
for (var i=0;i<newField.length;i++) {
var theName = newField[i].name
if (theName)
newField[i].name = theName + counter;
//This will change the 'name' field by adding an auto incrementing number at the end. This is important.
}
var insertHere = document.getElementById('add_phone');
//Inside the getElementById brackets is the name of the div class you will use.
insertHere.parentNode.insertBefore(newFields,insertHere);
}

</script>


<form name="add_a_phone" action="qualificationProcess.php" method="post" enctype="multipart/form-data">
<fieldset>
<div id="phone">
Degree:<input type="text" name="degree_0" value="" />

cgpa:<input type="text" name="cgpa_0" value="" />

institute:<input type="text" name="institute_0" value="" />

</div>
<div id="add_phone" style="display: none;">
Degree:<input type="text" name="degree_" value="" />

cgpa:<input type="text" name="cgpa_" value="" />

institute:<input type="text" name="institute_" value="" />

</div>
<input type="hidden" name="lastId" value="<?php echo $lastId; ?>"/>
<input type="button" id="add_phone()" onclick="add_phone()" value="Give me more fields!" />

<input type="submit" name="submit" value="submit" />
</fieldset>
</form>


<?php

//echo $lastId;

if(isset($_POST['submit']))
//This checks to make sure submit was clicked
{
echo "You clicked submit!
";
echo "Here is your data
";
echo "
";
if ($_POST['cgpa_0'])
//This checks that the proper field has data
{
$continue = FALSE;
$i = 0;
while ($continue == FALSE)
{
if (isset($_POST['degree_'.$i]))
//This looks for an entry after 0 and increments
{
echo $_POST['degree_'.$i] . " = " . $_POST['cgpa_'.$i] . "
";
//Echoing the data
//$id = $_POST['id_'.$i];
$lastId = $_POST['lastId'];
$degree = $_POST['degree_'.$i];
$cgpa = $_POST['cgpa_'.$i];
$institute = $_POST['institute_'.$i];


$db = mysql_connect("localhost");
mysql_select_db("jobolicious", $db);
$query = "INSERT INTO qualification (candidate_id, degree, cgpa, institute) VALUES ('$lastId', '$degree', '$cgpa', '$institute')";
$result = mysql_query($query);
//The four lines above is the example on how the data would be put into a MySQL database. It's not used here
}
else
{
$continue = TRUE;
}
$i++;
}
}
}

?>
and one more thing is in the candidate_id column only one id will be enter. i mean when one user come and fills as many fields as he wants but for those fields this column should have only one id. and also this id is taken from other form through hidden input

Your Answer:

Login to answer

Other forums

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

Making multiple rows with one query
I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is

Table sorting
Hi,

I'm trying to modify the following in order to make the output table sorted alphabeticall

How can i use [] tags instead of <> tags for profiles??
On my site im making ive made it so u can register, login and u have a profile which u can update..<

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

Remore client postprocessing phase getting dump SAPSQL_ARRAY_INSERT_DUPREC
Hello Expects,I have started remore client copy. Data was copied successfully. but while running pos

unexpected T_STRING
error log "[Sat Jan 09 18:27:58 2010] [error] [client 127.0.0.1] PHP Parse error: syntax error

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

Display thumbnails as square while retaining aspect ratio
I am trying to figure out a way to make an image display as a square, for example 80x80 pixels, when

form class help (oop php5)
Hidy Ho Neighbors,

I'm forcing myself to learn oop/classes for php5. It seems like a good id