StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTrouble with updating table with arrays
primarykey
Id
16317406
data
AcceptedAnswerId
16317934
AnswerCount
3
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2013-05-01T11:36:45.043
FavoriteCount
0
LastActivityDate
2013-05-01T13:38:22.233
LastEditDate
2013-05-01T11:39:39.137
LastEditorUserId
2257413
OwnerUserId
2338440
ParentId
0
PostTypeId
1
Score
0
ViewCount
89
LastEditorDisplayName
text
Body
<p>After being stuck trying to get a grip of how this works, i've decided to ask for some hints to how I can do this.</p> <p>Let me start by saying I have next to no experience with anything like this. I've just gathered some logic by looking at the code and i'm almost done with my project, except for this issue that i've come by.</p> <p>This is the original code (which i am still using another place in the code, this appears to be working just fine).</p> <pre><code>function showCart() { global $db; $cart = $_SESSION['cart']; if ($cart) { $items = explode(',',$cart); $contents = array(); foreach ($items as $item) { $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1; } $output[] = '<form action="kurv.php?action=update" method="post" id="cart">'; $output[] = '<table>'; foreach ($contents as $id=>$qty) { $sql = 'SELECT * FROM varetabel WHERE varenr = '.$id; $result = $db->query($sql); $row = $result->fetch(); extract($row); $output[] = '<tr>'; $output[] = '<td><a href="kurv.php?action=delete&varenr='.$id.'" class="r">Slet</a></td>'; $output[] = '<td>'.$varenavn.'</td>'; $output[] = '<td>DKK '.$pris.'</td>'; $output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>'; $output[] = '<td>DKK '.($pris * $qty).'</td>'; $total += $pris * $qty; $output[] = '</tr>'; $_SESSION['items'] = $contents; // Antal forskellige varer. $_SESSION['qty'] = $qty; } $output[] = '</table>'; $output[] = '<p>Pris total: <strong>DKK '.$total.'</strong></p>'; $output[] = '<div><button type="submit">Opdatér kurv</button></div>'; $output[] = '</form>'; } else { $output[] = '<p>Kurven er tom.</p>'; } return join('',$output); </code></pre> <p>}</p> <p>global $db is connecting to the DB and such, no biggie, and then there is this function from an include:</p> <pre><code> function fetch () { if ( $row=mysql_fetch_array($this->query,MYSQL_ASSOC) ) { return $row; } else if ( $this->size() > 0 ) { mysql_data_seek($this->query,0); return false; } else { return false; } } </code></pre> <p>Now, im trying to use the same method to take the arrays from this code and put them into my database with this code:</p> <pre><code>session_start(); global $db; $items = $_SESSION['items']; $cart = $_SESSION['cart']; $qty = $_SESSION['qty']; if(isset($_SESSION['email'])) { // IF LOGGED IN $sql = mysql_query("SELECT * FROM antalstabel ORDER BY ordrenr DESC LIMIT 1") or die(mysql_error()); $row = mysql_fetch_assoc($sql); $maxordrenr = $row['ordrenr']; $nextnumber = $maxordrenr + 1; $antal = count($items); // COUNTS DIFFERENT ITEMS IN CART. $maxplusantal = $maxordrenr + $antal; $varenrplaceholder = 0; for ($i = $maxordrenr; $i <= $maxplusantal; $i++) { $sql = mysql_query("INSERT INTO antalstabel (ordrenr, varenr) VALUES ('$nextnumber','$varenrplaceholder')") or die(mysql_error()); $nextnumber--; $varenrplaceholder++; } $varenrplaceholder = 0; if ($cart) { $items = explode(',',$cart); $contents = array(); foreach ($items as $item) { $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1; } foreach ($contents as $id=>$qty) { $sql = 'UPDATE antalstabel SET varenr = '.$id.' and antal = '.$qty.' WHERE ordrenr = '.$nextnumber.' and varenr = '.$varenrplaceholder.''; $result = $db->query($sql); $row = $result->fetch(); extract($row); $varenrplaceholder++; } } </code></pre> <p>But it does not appear to be working properly, the code does run, but it does not update the tabel with the values of the arrays.</p> <p>Am i completely wrong or can anyone help me with this issue, i know it is a lot to ask.</p> <p>my own code creates X rows with the same ID depending on how many different items there is in the cart, I am trying to update those existing rows that i've just created with the values i presume is still in the arrays of the <code>showCart()</code> function.</p> <p>Thank you in advance</p>
Tags
<php><mysql>
Title
Trouble with updating table with arrays
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USYadav Chetan
UserOwnerUserId
1. USVictor Nielsen
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POTrouble with updating table with arrays
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId

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.