Have problem with Form.

pavelazad

hello im new and having a problem. i have a form with fields NAME and ADDRESS for personal information and also have couple of fields for Job experience. By clicking link user can extend job fields. i m giving u the code below:

html>

<head>

<title>title</title>

var counter = 0; // counter for naming the elements

function moreFields()

{

counter++;

var newFields = document.getElementById('readroot').cloneNode(true);

newFields.id = '';

newFields.style.display = 'block';

var newField = newFields.childNodes;

for (var i=0;i<newField.length;i++)

{

var theName = newField.name

if(theName)

{

newField.name = theName + counter;

newField.id = theName + counter;

}

}

var insertHere = document.getElementById('writeroot');

insertHere.parentNode.insertBefore(newFields,insertHere);

}

// -->

</script>

</head>

<body onload="moreFields()">

<div id="readroot" style="display: none">
<div align="center">Job Experience <br>
Company:
<input type="text" name="company[]" size="70">
<br>
Post :
<input type="text" name="post[]" size="70">
<br>
Job Duties:
<textarea name="duties[]" cols="60" rows="10"></textarea>
<input type="button" value="Add New Line" onClick="moreFields()">
<input type="button" value="Remove" style="font-size: 10px" onClick="this.parentNode.parentNode.removeChild(this.parentNode);">
</div>
</div>

<form method="post" action="test1.php">
Name:<input type="text" name="name" size="70"><br>
Address:<input type="text" name="add" size="70">

<span id="writeroot"></span>

<p class="hr"> </p>

<input type="submit" value="Send form">

</form>

</body>

</html>

problem 1: i m not getting the value of NAME and ADDRESS field. How can i get it??
problem 2: how can i insert the above form's input in mysql table in a single row. my table is with ID, NAME, ADDRESS, COMPANY, POST, DUTIES, DATE.

pls pls help me.

sheephat

focussing on this part only as this is the only part which submits:

<form method="post" action="test1.php">
Name:<input type="text" name="name" size="70"><br>
Address:<input type="text" name="add" size="70">

<span id="writeroot"></span>

<p class="hr">&nbsp;</p>

<input type="submit" value="Send form">

</form>

Can we have a look at your code in test1.php?

benracer

To get the values from this form the POST function is needed...

<?php
$name = $_POST['name'];
$address = $_POST['add'];

// run query ect...

?>

pavelazad

actually i haven't prepared the test1.php yet. yes i did just getting the value from my form. this is the code:

<?php
$name = $POST['name'];
$address = $POST['address'];

echo $name;
echo $address;

foreach ($company as $input1)
{
echo $input1;
}
foreach ($post as $input2)
{
echo $input2;
}
foreach ($duties as $input3)
{
echo $input3;
}

Please tell me how can i put all these data into mysql in a single row?? my table fields are ID, NAME, ADDRESS, COMPANY, POST, DUTIES, DATE.

i normally can input data just for 1 job experience but wht happened if cusomter have more than 1 job experience? do i have to create TABLE dynamically?? if so how can i do it??

pls help me.

benracer

1) Address will not be sent as in your form its name is add.
2) You could run one insert and two updates

pavelazad

thanx. i corrected my form. im getting all the values from my form. As u told..
2) You could run one insert and two updates

pls tell me how can i do it?? pls help me.

pavelazad

Any one can help??

My form (GIVEN BELOW) has a part which expand according to user requirement. how can i get and insert all the values from the form in mysql table in a single row?? my table fields are ID, NAME, ADDRESS, COMPANY, POST, DUTIES.

pls give me code that how can i do it??

<html>

 <head>

   <title>TITLE</title>

   <meta content="">

   <style></style>



<script language="javascript">





var counter = 0; // counter for naming the elements



function moreFields()

{

counter++;

var newFields = document.getElementById('readroot').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;

 newField[i].id = theName + counter;

 }

}

var insertHere = document.getElementById('writeroot');

insertHere.parentNode.insertBefore(newFields,insertHere);

}



// -->

</script>



</head>

 <body onload="moreFields()">



<div id="readroot" style="display: none">
  <div align="center">Job Experience <br>
    Company:
   <input type="text" name="company[]" size="70">
    <br>
    Post :
    <input type="text" name="post[]" size="70">
    <br>
    Job Duties:
    <textarea name="duties[]" cols="60" rows="10"></textarea>
    <input type="button" value="Add New Line" onClick="moreFields()">
    <input type="button" value="Remove" style="font-size: 10px" onClick="this.parentNode.parentNode.removeChild(this.parentNode);">
  </div>
</div>



<form method="post" action="test1.php">
Name:<input type="text" name="name" size="70"><br>
Address:<input type="text" name="address" size="70">



<span id="writeroot"></span>

<p class="hr">&nbsp;</p>




<input type="submit" value="Send form">



</form>





 </body>

</html>

Ikul

benracer wrote:
To get the values from this form the POST function is needed...
<?php
$name = $_POST['name'];
$address = $_POST['add'];

// run query ect...

?>

Doesn't that require to pass the information to the page? Is there a way to 'pull' the information out, instead of being 'given' it?

benracer

No, when you post a form to a page somehow it is saved in a tempory file, the data is then only accessed when the retrieve is used... $GET or $POST.