Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>With concrete5 blocks, there are two different situations you could be in:</p> <ol> <li>admin user is editing the block (or adding a new block), and you want to save this data to the database.</li> <li>public user is viewing the block, but the block view itself has a form (for example, a contact form block) and you want to do something when the public form is submitted (for example, send a notification email to an admin that someone has filled out the form, or store the submission in a database for future review).</li> </ol> <p>If you're talking about situation #1, you need to put some custom code in the controller's <code>save()</code> method. If you're talking about situation #2, you need to create your own action method in the controller, AND you need to actually have a <code>&lt;form&gt;</code> in the view.php file.</p> <p>UPDATE: Based on the sample code you added to your question, here is the solution: The only way your data can get back to the server is via a form POST. <code>&lt;li&gt;</code> elements are not form fields, and hence the data in them doesn't get POST'ed with the form. So when you add the new <code>&lt;li&gt;</code> element to the page, you should <em>also</em> add a hidden form field, like so:</p> <pre><code> var listItemCounter = 0; $("#addList").click(function() { listItemCounter++; var text = $("#inputList").val() + '&lt;button data-id="' + listItemCounter + '"&gt;x&lt;/button&gt;'; //assign a unique id number to this button, so it knows which hidden field to remove when clicked if(text.length){ $('&lt;li /&gt;', {html: text}).appendTo('ul.featureList'); $('&lt;input type="hidden" name="features[]" value="' + text + '" data-id="' + listItemCounter + '" /&gt;').insertAfter('ul.featureList'); }; }); $('ul').on('click','button', function(el){ $('input[data-id="' + $(this).attr('data-id') + '"]').remove(); //remove the hidden field so it does not get POSTed when user saves $(this).parent().remove(); }); </code></pre> <p>Now, in your block's controller.php file, you will want to add a <code>save()</code> method that will take all of the data from those hidden fields, combine them and put them into the "features" field that you declared in your db.xml file:</p> <pre><code>public function save($args) { $args['features'] = implode("\n", $args['features']); //combine all feature items into one string, separated by "newline" characters parent::save($args); } </code></pre> <p>Finally, in your view.php file, you can convert the list of features (which was saved to the database as one string, with each item separated by a "newline" character) like so:</p> <pre><code>&lt;?php echo nl2br($features); ?&gt; </code></pre> <p>Or if you want to output it as separate list items, you could do something like this:</p> <pre><code>&lt;ul&gt; &lt;?php $features = explode("\n", $features); foreach ($features as $feature) { echo '&lt;li&gt;' . $feature . '&lt;/li&gt;'; } ?&gt; &lt;/ul&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow do I pass a dynamically created list to the controller to save into the database?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJordan Lev
    1. USJordan Lev
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COIt is in situation 1. I am creating a product block and would like to be able to populate a features list dynamically inside the add/edit page. I use an auto.js file to create <li> tags with a value form an input box. These <li> tags and values get displayed underneath. I need to save each <li> + val + </li> so that it will be displayed in the final view.php (both user and admin see). I will post my auto.js and my add/edit.php
      singulars
      1. PO
      1. USuser2066695
    2. COCode posted above.
      singulars
      1. PO
      1. USuser2066695
    3. COI've updated my answer to take into account your new details. Hope it helps!
      singulars
      1. PO
      1. USJordan Lev
 

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