Databases
StackOverflow2013
Postsdbo
POStore input of dynamically created text fields
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POStore input of dynamically created text fields
    primarykey
    data
    text
    <p>I have made a button which creates a text with name=1,2,3 ... on every click. I want to store all the inputs of these text fields in database. </p> <pre><code>&lt;?php $con = mysqli_connect("localhost", "root","", "abc"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $maxoptions = 10; // I don't want only 10 inputs from text fields // but as many as the user creates and fills for ($i = 1; $i &lt; $maxoptions; $i++) { $sql="INSERT INTO qa (q, a$i) VALUES ('$_POST[q1]', '$_POST[i]')"; // '$_POST[i]' is not working } if (!mysqli_query($con, $sql)) { die('Error: ' . mysqli_error($con)); } mysqli_close($con); ?&gt; </code></pre> <p>Now, how to create columns in the database dynamically with these text fields?</p> <p>Here is the JavaScript code with which I am creating the text fields:</p> <pre><code>var intTextBox1 = 0; //FUNCTION TO ADD TEXT BOX ELEMENT function addElement1() { intTextBox1 = intTextBox1 + 1; var contentID = document.getElementById('content1'); var newTBDiv = document.createElement('div'); newTBDiv.setAttribute('id','strText'+intTextBox1); newTBDiv.innerHTML = "Option" + intTextBox1 + ": &lt;input type='text' id='" + intTextBox1 + "' name='" + intTextBox1 + "'/&gt;"; contentID.appendChild(newTBDiv); } //FUNCTION TO REMOVE TEXT BOX ELEMENT function removeElement1() { if (intTextBox1 != 0) { var contentID = document.getElementById('content1'); contentID.removeChild(document.getElementById('strText'+intTextBox1)); intTextBox1 = intTextBox1 - 1; } } </code></pre> <p>and here is the code of button:</p> <pre><code>&lt;form id="s1form" name="s1form" method="post" action="qno1.php"&gt; &lt;input type="text" name="q1"&gt; &lt;input type="button" value="Add a choice" onClick="javascript:addElement1();" /&gt; &lt;input type="button" value="Remove a choice" onClick="javascript:removeElement1();" /&gt; &lt;div id="content1"&gt;&lt;/div&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USicedwater
    1. USCoop Westerner
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POStore input of dynamically created text fields
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POStore input of dynamically created text fields
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COTry AJAX requests
      singulars
      1. POStore input of dynamically created text fields
      1. USguy777
    2. COBefore you write **any** more SQL code, please read up on [proper escaping](http://bobby-tables.com/php) to avoid nasty [SQL injection bugs](http://bobby-tables.com/). You cannot put `$_POST` values into your query string directly. You **must** use the [`bind_param`](http://php.net/manual/en/mysqli-stmt.bind-param.php) method to properly apply them.
      singulars
      1. POStore input of dynamically created text fields
      1. UStadman
    3. COpossible duplicate of [PHP MySQLi Multiple Inserts](http://stackoverflow.com/questions/1488033/php-mysqli-multiple-inserts)
      singulars
      1. POStore input of dynamically created text fields
      1. UStadman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload