StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSelected meal must show me the right price but he show me a error Call to a member function fetch_assoc() on a non-object in
primarykey
Id
15812338
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-04-04T13:15:43.273
FavoriteCount
0
LastActivityDate
2013-04-04T13:28:57.390
LastEditDate
LastEditorUserId
0
OwnerUserId
2087310
ParentId
0
PostTypeId
1
Score
-1
ViewCount
71
LastEditorDisplayName
text
Body
<p>What I want is that when I select one meal that he show me the meal and the right price. Now he show me the meals but when i select one of these meals there are comes a error. </p> <p>Error: Call to a member function fetch_assoc() on a non-object in </p> <p>When I in mwvp.php this code removed. Then you see al prices that stored in database.</p> <p>You can see under this the removed code en the orginal.</p> <p>Change Meal.php</p> <pre><code><?php include ("connection.php"); ?> <!DOCTYPE html> <html> <head> <title>Kantine</title> <link rel="stylesheet" type="text/css" href="test.css"> <meta charset="utf-8"> <script src="js/jquery.min.js"></script> <script type="text/javascript"> function getMeals(str) { $('#meal_data').text(""); if (str == "select") return; $('#meal_data').load('mwvp.php?q='+str); } </script> </head> <body> <div id="container"> <div id="logo"></div> <div id="header"> <h1>Change Meal</h1></div> <div id="menu"> <a href="Addmeal.php"><img src="Addmeal.png"/></a> </div> <div id="content"> <?php $result = mysqli_query($con,"SELECT meal, price FROM Meals "); echo '<select name="Meals"onchange="getMeals(this.value)"><option value="select">Choose Meal</option>'; while ($row = $result->fetch_assoc()) { echo "<option value=\""."\">" . $row['meal']."</option>\n"; echo '<br />'; } echo '</select>'; echo '<ul id="meal_data">'; echo '</ul>'; mysqli_close($con); ?></div> <div id="footer"></div></div> </body> </html> </code></pre> <p>Original mwvp.php</p> <pre><code><!DOCTYPE html> <html> <meta charset="utf-8"> <?php $q = $_GET["q"]; include("connection.php"); $result = mysqli_query($con, "SELECT meal, price FROM meals WHERE meal = " .$q); while ($row = $result->fetch_assoc()) { echo '<input name="price" type="text" value="'.$row['price'].'" />'; } ?> </html> </code></pre> <p>Removed code in mwvp.php</p> <pre><code><!DOCTYPE html> <html> <meta charset="utf-8"> <?php include("connection.php"); $result = mysqli_query($con, "SELECT meal, price FROM meals") while ($row = $result->fetch_assoc()) { echo '<input name="price" type="text" value="'.$row['price'].'" />'; } ?> </html> </code></pre>
Tags
<php><javascript><mysqli>
Title
Selected meal must show me the right price but he show me a error Call to a member function fetch_assoc() on a non-object in
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMMTjoelkerT
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POSelected meal must show me the right price but he show me a error Call to a member function fetch_assoc() on a non-object in
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
CommentsPostId
1. CODuplicate of http://stackoverflow.com/a/15447204/285587
  singulars
  PostPostId
  POSelected meal must show me the right price but he show me a error Call to a member function fetch_assoc() on a non-object in
  UserUserId
  USYour Common Sense

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.