Insert dynamic textbox value in query

Question

Here is my javascript and php code and also one form. How can i insert value for multiple dynamic text box in table.please let me know how to put an array in query to insert a value Query of my code.

<?
if(isset($_POST['submit']) && $_POST['submit']=="Submit")
{

  $filter_attr=$_POST['filter_attr'];

    $query=mysql_query("insert into filter (filter_attr,addedon)values ('".$filter_attr."','".date("Y-m-d H:i:s")."')");

  }
?>


<script language="javascript">
var i = 1;
function changeIt()
{

my_div.innerHTML = my_div.innerHTML +"<br><input type='text' size='70' id='filter_attr' name='filter_attr'+ i>"
i++;
}
</script>

<tr height="20"></tr>
<tr height="25">
<td width="30%">Filter Attribute</td>
<td width="50%"><input type="text" name="filter_attr" size="70" id="filter_attr" filter="50"><div id="my_div"></div></td>
<td width="20%"> <input type="button"  value="ADD" onClick="changeIt()"></td>
</tr>
</table>
</form>

score 1 · Answer 1 · answered Jan 07 '15 at 06:38

just giving a demo of how you can achieve it

  $postedData=$_POST;
  $keys = implode(',', array_keys($postedData));
  $values = implode(',', $postedData);

    $query=mysql_query("insert into filter ('".$keys."',addedon)values ('".$values."','".date("Y-m-d H:i:s")."')");

  }
?>

code is not tested so please tacke care of that

score 1 · Answer 2 · answered Jan 07 '15 at 06:54

@Vidhipriya Joshi, u should make some changes in your existing code like below: In HTML file , you do:

<input type="text" name="filter_attr[]" size="70" id="filter_attr" filter="50">

Note: name attribute is an array to store all input values, and also do the same in js and php files..

Suggestion: Better to use jquery append function inplace of innerHTML.

See the link for more guidness..

Add/Remove Input Fields Dynamically in php

Hope it will fullfill your need.. :)

score 1 · Answer 3 · answered Jan 07 '15 at 07:01

Just Modify your JS script

    <script language="javascript">
    var i = 1;
    Function changed ()
    {

my_div.innerHTML = my_div.innerHTML +"<br><input type='text' size='70' id='filter_attr[]' name='filter_attr'+ i>"
    i++;
    }
    </script>

After submit your form you will get filter_attr in php

Try this.

score 1 · Answer 4 · edited May 23 '17 at 10:33

Here's the PHP for processing the form:

<?php
// before form submitted $_POST has a null value
if( isset($_POST) && $_POST != null) {
    $post = $_POST['filter_attr'];

   // assuming an input contains only alphabetical characters
   if ( ctype_alpha( $post ) || is_array( $post ) ) {

       // var_dump($post); 
       // rest of processing, i.e. create insert query ...
  }
   else
   {
     // the data is unacceptable, so you may wish to end the script.
     exit;
   }
}    
?>

Here's the JavaScript:

<script language="javascript">
var i = 1;
function changeIt()
{
var d = document;
d.getElementById("my_div").innerHTML += "<br>";
d.getElementById("my_div").innerHTML += "<input type='text' size='70' id='filter_attr" + i  +  "'  name='filter_attr[]'><br>";
i++;
}
</script>

PHP will recognize that the submitted form contains an array of filter_attr data if the name attribute of the static and dynamic inputs is "filter_attr[]". However, the id must be unique if you wish JavaScript to access it using document.getElementById. Thus the first dynamic input has an id of "filter_attr1" and a name of "filter_attr[]".

Please note:

it is better to write: document.getElementById("my_div") than to use the id or name directly (see discussion at Why don't we just use element IDs as identifiers in JavaScript?)
Creating dynamic inputs is preferable using the DOM and its methods, If you wish, you may use jQuery which simplifies working with DOM.
The above HTML seems to be missing a submit button. However, even if it is present in the actual code, the following code does not work:

if ( isset( $_POST['submit'] ) && $_POST['submit'] == "Submit") {

When a form gets submitted via a POST or a GET request, what gets submitted are key-value pairs of data, i.e. data coming from form elements where the user had to supply some kind of response whether it's text or marking a checkbox or radio button. The submit button facilitates submitting the data but it itself does not get submitted if you fail to name and the name must be the same as its type, i.e. "submit". I respectfully suggest the way my preceding PHP code does which answers the questions, "Was a form submitted? And, if so does it contain any data?"

The code needs to assume that the post could be tainted. That means you need to validate the posted data before using it.
The mysql extension has been deprecated as of PHP5.5; see discussion at The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead.
Lastly, using an HTML TABLE should be restricted for displaying tabular data and should not be used for layout. Instead, use DIV elements and by styling them you can achieve the desired layout. This result will be semantically correct and save on memory.

Insert dynamic textbox value in query

4 Answers4