Databases
StackOverflow2013
Postsdbo
PO$_POST[ ] and mysql_fetch_arrays together
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO$_POST[ ] and mysql_fetch_arrays together
    primarykey
    data
    text
    <p>I'm working on outputting data from two different sources into an HTML table. One source is a <code>mysql_fetch_array</code>, the other is a <code>$_POST</code> array. There are three <code>&lt;td&gt;</code> tables from mysql and one from <code>$_POST</code> outputting via a while loop. To associate the arrays on the output page, I planned to store the <code>$_POST</code> data in the table via the row id and then query the whole row further down the page.</p> <p>The issue I have is that I can't seem to get the <code>$_POST</code> array values UPDATED into the row correctly. The last value in the <code>$_POST</code> array is all what's stored in all selected fields.</p> <p>The input page arrays are captured with <code>id [ ]</code> and <code>unit_ass[ ]</code> and are passed to the output page.</p> <p>The output page code:</p> <pre><code>require_once ("../includes/db_connect.inc"); $pid = array_filter($_POST['id']); $gid = implode(",", $pid); $sua = array_filter($_POST['unit_ass']); foreach($sua as $value) echo $value . "&lt;br&gt;"; // this outputs correct values in the correct order. foreach($sua as $value) mysql_query("UPDATE $tbl_name SET unit_ass='$value' WHERE id IN ( $gid )"); </code></pre> <p>Just stripping empty keys with <code>array_filter()</code> ... When I echo the values in the first foreach statement, they are displayed correctly and in correct order.</p> <p>However, only the last value from the <code>$sua</code> array is updating the table rows as determined by $gid. The foreach isn't iterating the array values and performing the UPDATE as it should. The data via <code>id[ ]</code> is displayed correctly further down the page via a <code>mysql_fetch-array</code> in a while loop.</p> <p>I've been staring at this for several hours now and can't seem to find the solution. Any help is appreciated.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USThestudiokid
    1. USThestudiokid
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO$_POST[ ] and mysql_fetch_arrays together
      1. USnowayyy
      1. VTFavorite
    2. VO
      singulars
      1. PO$_POST[ ] and mysql_fetch_arrays together
      1. This table or related slice is empty.
      1. VTDownMod
    1. COyou want to update value `unit_ass` of each row whose id is in `$gid` to corresponding value in `$sua`?
      singulars
      1. PO$_POST[ ] and mysql_fetch_arrays together
      1. USBao Nhan
    2. COIf this is your complete code sample, then you need to define `$tbl_name`.
      singulars
      1. PO$_POST[ ] and mysql_fetch_arrays together
      1. UShafichuk
    3. COAll of the database connection stuff along with $tbl_name is contained in the require_once file at the top.
      singulars
      1. PO$_POST[ ] and mysql_fetch_arrays together
      1. USThestudiokid
 

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