Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You need to assign values to $_POST[1] and $_POST[2] to begin with, I've done this for you but normally they would be populated from a form I assume?</p> <p>I'm not sure why you want to do this sort of thing: ${'field'.$key}, but I've left that part as is as I assume you must have a reason.</p> <p>Anyway I've modified your code a bit, see below.</p> <pre><code>$_POST['1'] = '&lt;h1&gt;variable 1&lt;/h1&gt;'; $_POST['2'] = '&lt;h2&gt;variable 2&lt;/h2&gt;'; foreach($_POST as $key =&gt; $value){ ${'field'.$key} = trim(addslashes(strip_tags($value))); echo "POST field info #". $key ." = ". ${'field'.$key}."&lt;br /&gt;"; } </code></pre> <p>The above code outputs:<br /> POST field info #1 = variable 1<br /> POST field info #2 = variable 2</p> <p>On a side note, using field names such as '1' and '2' is not very good. Try using something more descriptive but as I said above I assume you have a reason for doing this.</p> <hr> <p>UPDATE: You can still get this to work for any form even if you are using specific names for the form elements. I have added a few lines below as an example for you.</p> <pre><code>$_POST['email'] = 'example@example.com'; $_POST['password'] = 'hgbks78db'; $_POST['name'] = ''; foreach($_POST as $key =&gt; $value){ if($value==''){ echo 'POST field "'.$key . '" is empty&lt;br /&gt;'; /* I added the name of the field that is empty to an error array so you have a way of storing all blank fields */ $a_error[] = $key; } else{ echo 'POST field "'.$key . '" is not empty&lt;br /&gt;'; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POMaking POST values dynamic within a loop to store as an array?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDrew
    1. USDrew
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMaking POST values dynamic within a loop to store as an array?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you Drew for your response, I will be having a go at this tonight after work. Your correct the form elements are named inside the form as per usual, now the reason I am opting for generic element names is so that the form validation function will work for any form on a site under any circumstance. I have a site planned which will have a population of 15 forms and validating them all personally with specific element names i.e. "email" or "password" would take a lot of lines of code. My mission is to optimise this :)
      singulars
      1. PO
      1. USzealisreal
    2. COHi Drew, your code worked fine for what you posted, my only concern is that using $_POST generically means that the submit element value is also posted as part of that $_POST loop, do you know how I would be able to bypass the $_POST array indexing that value?
      singulars
      1. PO
      1. USzealisreal
    3. COIgnore that, I found the answer, I just unset the $_POST['form'] before the loop.
      singulars
      1. PO
      1. USzealisreal
 

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