StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POforeign keys are not being created
primarykey
Id
14173241
data
AcceptedAnswerId
14210180
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-01-05T15:30:23.060
FavoriteCount
0
LastActivityDate
2013-01-08T08:56:00.983
LastEditDate
2013-01-08T06:41:27.863
LastEditorUserId
1808066
OwnerUserId
1808066
ParentId
0
PostTypeId
1
Score
3
ViewCount
165
LastEditorDisplayName
text
Body
<blockquote> Question: Want to perform a Select Query below (must be this query): SELECT QuestionId FROM Question WHERE (QuestionNo = ? AND SessionId = ?) In order to be able to find the QuestionId's in the Question table and store it in the Answer Table for all the answers so that we can determine which answers belong to which question </blockquote> Problem: The problem with the mysqli code is that it is not able to insert the correct QuestionId value. It keeps displaying 0 for QuestionId in the <code>Answer</code> Table. So can somebody fix this in order to be able to be able to display the correct QuestionId? It has to be done the SELECT query provided at top. I have to use that in mysqli. Here are the db tables: Question Table <pre><code>QuestionId (auto) SessionId QuestionNo 4 2 1 5 2 2 6 2 3 </code></pre> Answer Table at moment: <pre><code>AnswerId (auto) QuestionId Answer 7 0 A 8 0 C 9 0 A 10 0 B 11 0 True </code></pre> What Answer Table should look like: <pre><code>AnswerId (auto) QuestionId Answer 7 4 A 8 4 C 9 5 A 10 5 B 11 6 True </code></pre> Below is the code: <pre><code> $questionsql = "INSERT INTO Question (SessionId, QuestionNo) VALUES (?, ?)"; if (!$insert = $mysqli->prepare($questionsql)) { // Handle errors with prepare operation here echo __LINE__.': '.$mysqli->error; } $answersql = "INSERT INTO Answer (QuestionId, Answer) VALUES (?, ?)"; if (!$insertanswer = $mysqli->prepare($answersql)) { // Handle errors with prepare operation here echo __LINE__.': '.$mysqli->error; } //make sure both prepared statements succeeded before proceeding if( $insert && $insertanswer) { $sessid = $_SESSION['id'] . ($_SESSION['initial_count'] > 1 ? $_SESSION['sessionCount'] : ''); $c = count($_POST['numQuestion']); for($i = 0; $i < $c; $i++ ) { $insert->bind_param("ii", $sessionid, $_POST['numQuestion'][$i]); $insert->execute(); if ($insert->errno) { // Handle query error here echo __LINE__.': '.$insert->error; break 1; } } $results = $_POST['value']; foreach($results as $id => $value) { $answer = $value; $lastID = $id; $questionidquery = "SELECT QuestionId FROM Question WHERE (QuestionNo = ? AND SessionId = ?)"; if (!$questionidstmt = $mysqli->prepare($questionidquery)) { // Handle errors with prepare operation here echo __LINE__.': '.$mysqli->error; } // Bind parameter for statement $questionidstmt->bind_param("ii", $lastID, $sessionId); // Execute the statement $questionidstmt->execute(); if ($questionidstmt->errno) { // Handle query error here echo __LINE__.': '.$questionidstmt->error; break 2; } // This is what matters. With MySQLi you have to bind result fields to // variables before calling fetch() $questionidstmt->bind_result($quesid); // This populates $optionid $questionidstmt->fetch(); $questionidstmt->close(); foreach($value as $answer) { $insertanswer->bind_param("is", $quesid, $answer); $insertanswer->execute(); if ($insertanswer->errno) { // Handle query error here echo __LINE__.': '.$insertanswer->error; break 3; } } } //close your statements at the end $insertanswer->close(); $insert->close(); } ?> </code></pre>
Tags
<mysql><sql><database>
Title
foreign keys are not being created
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USManixman
UserOwnerUserId
1. USManixman
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
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POforeign keys are not being created
 UserUserId
 USManixman
 VoteTypeVoteTypeId
 VTBountyStart
2. VO
 singulars
 PostPostId
 POforeign keys are not being created
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POforeign keys are not being created
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.