StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19574098
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-10-24T18:47:56.307
FavoriteCount
0
LastActivityDate
2013-10-24T18:47:56.307
LastEditDate
LastEditorUserId
0
OwnerUserId
454533
ParentId
19573918
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<h2>Failing but not reporting an error</h2> <p>Change <code>PDO</code>'s error reporting.</p> <pre><code>$MyConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); </code></pre> <p>If there is an SQL error, PDO should report it now.</p> <h2>Select the Database</h2> <p>The only error I see in your query other than possible errors caused by variable interpolation is that the table name is not fully qualified. If you have not selected the DB already, it may need to be.</p> <pre><code>$MyConnection = new PDO("mysql:host=localhost;dbname=DBNAME"); // or in the query "INSERT INTO DBNAME.AMP_USERS ..." </code></pre> <p><em><strong>Note</em></strong> that you would not literally write <code>DBNAME</code> but rather what the actual name of your database is.</p> <h2>Use Prepared Statements</h2> <p>You should do this regardless to protect against injection, but based on the contents of the variables you are using, they may be causing problems as well.</p> <pre><code>$stmt = $MyConnection->prepare(" INSERT INTO AMP_USERS (Username, Password, Lastname, Email) VALUES (?,?,?,?) "); $stmt->execute(array($username, $password, $lastname, $email)); </code></pre> <p>Using named parameters like <code>$stmt->execute(array(":username" => $username))</code> or using <code>$stmt->bindParam(":username", $username)</code> (or <code>bindValue</code>) is also valid.</p> <hr> <p>If these explanations do not help you solve your problem you have omitted important data from your question.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP PDO prepare statement failure
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USExplosion Pills
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POPHP PDO prepare statement failure
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
2. VO
  singulars
  PostPostId
  PO
  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.