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
No comments posted yet
Your Answer:
Login to answer
162
22
Other forums
temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compi
error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc
Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t
captcha error
I have been trying to implement a captcha in php...
here is the code..
Code: (php) [Select
Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t
Business Health Check
Hello
I need to create an online business health check for a client it will be multiple choi
Varible in trigger - refering to correct schema
Hello
Im having some issues with my trigger.
What I want to do is call opon a differ
Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec
problem in program for counting no of chars using pointers
Hi all, I was trying to make a program which counts number of chars in a string using concpt of poin
Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se