StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18709095
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-09-10T00:36:38.750
FavoriteCount
0
LastActivityDate
2013-09-10T00:55:54.143
LastEditDate
2013-09-10T00:55:54.143
LastEditorUserId
283366
OwnerUserId
283366
ParentId
18706771
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
For quickly retrieving a value from something like a <code>SELECT COUNT()</code> query, have a look at <a href="http://www.php.net/manual/pdostatement.fetchcolumn.php" rel="nofollow"><code>PDOStatement::fetchColumn</code></a>, eg <pre><code>$stmt = $pdo->prepare('SELECT COUNT(1) FROM users WHERE email = :email'); $stmt->bindParam(':email', $email); $stmt->execute(); $email_count = $stmt->fetchColumn(); </code></pre> I'd also like to offer some further advice. You shouldn't be creating a <code>PDO</code> connection in your class constructor. This means that every time you instantiate a class extending <code>Database</code>, you create a new connection. Instead, pass the <code>PDO</code> instance as a dependency, eg <pre><code>abstract class Database { /** * @var PDO */ protected $pdo; public function __construct(PDO $pdo) { $this->pdo = $pdo; } } </code></pre> The same goes for your <code>User::insert</code> method. Try to pass any required parameters via method arguments. If you ever want to start writing unit tests for your classes, this will be invaluable <pre><code>public function insert($email) { $stmt = $this->pdo->prepare('SELECT COUNT(1) FROM users WHERE email = :email'); $stmt->bindParam(':email', $email); $stmt->execute(); $email_count = $stmt->fetchColumn(); // and so on </code></pre> And finally, for PHP only files, omit the closing PHP tag <code>?></code>. This will save you from accidentally including whitespace at the end of your files that may be sent to the browser.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhat is the equivalent of bind_result on PDO
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPhil
UserOwnerUserId
1. USPhil
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COthanks, in regards to the database class should I my db connection be in a separate function to the construct? basically like above but not in the construct?
 singulars
 PostPostId
 PO
 UserUserId
 US001221

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.