Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <ol> <li>First of all, don't include single quotes in a double quote string when you're referencing arrays, you risk to have an "encapsed string" error.</li> <li> You also include a double quoted string in <code>"item_qty"</code> which will likely result in an error.</li> <li>Close the <code>option</code> tags with <code>/&gt;</code> as best practice.</li> <li>Your <code>LABEL</code> tag is not used properly. The correct syntax is: <code>&lt;label for='html_element_id'&gt;My pretty label&lt;/label&gt; &lt;input id='html_element_id ... (my form control) ... /&gt;</code> and it's pretty useless (though always more semantic and structured) with other controls than checkboxes or radios.</li> <li> You may cosider using a <code>TABLE</code> instead of <code>P</code> tags to have everything lined up. Better, you could use CSS to line up things, much better practice.</li> <li><p>If you hard-code the choices it can be difficult to handle requirement changes: what if you need quantities from 1 to 10? What if you choose to use a textbox instead of a <code>SELECT</code>?</p> <pre><code>while($t_row = mysql_fetch_assoc($get_items)) { // Generate quantity string - can change the $qty string // for any imput method you like $qtyName = "item_qty[]"; $qty = "&lt;select name='" . $qtyName . "'&gt;"; for ($i=1; $i&lt;6; $i++) { // close the option tag as best practice! $qty .= "&lt;option value='" . $i . "' /&gt;"; } $qty .= "&lt;/select&gt;"; echo sprintf("&lt;p&gt;%s &lt;input type='text' READONLY name='item_price[]' value='%s' /&gt;&lt;/label&gt; &lt;input type='text' READONLY name='item_fees[]' value='$s' /&gt; " . $qty . "&lt;/p&gt;", $t_row['item_price'], $t_tow['item_fee']); } </code></pre></li> </ol> <p>Collecting the data would be simple:</p> <pre><code>$sum = 0; $fees = $_POST['item_fee']; $qtys = $_POST['item_qty']; $prices = $_POST['item_price']; $total = count($prices); for ($i = 0; $i&lt;total; $i++) { $item_fee = $fees[$i] + 0; // trick to filter only numerical values and avoid data tampering $item_price = $price[$i] + 0; $item_quantity = $qtys[$i] + 0; $item_total = $item_price + $item_fee * $item_quantity; $sum += $item_total; } </code></pre> <p>I too agree that having a direct representation of prices in you form can lead anyway to data tampering, the user that suggested you to check against a database has given a very wise advice.</p>
    singulars
    1. This table or related slice is empty.
    1. POGet values from HTML in a multidimensional array and calculate values using PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USCranio
    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. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO"Close the option tags with /> as best practice." It really depends on the doctype. XHTML requires />. HTML 4 doesn't allow it. HTML 5 allows it, as optional.
      singulars
      1. PO
      1. USTiberiu-Ionuț Stan
    2. COYou're right, but you might agree with me that following the XHTML requirements, even if not mandatory, leads to more readable and debuggable HTML (expecially in large pages, complex layouts). That's why I've suggested a "best practice", by the way, and not "you _must_". This said, your observation is 100% correct and useful to stress :)
      singulars
      1. PO
      1. USCranio
 

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