StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19381980
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-10-15T13:03:02.477
FavoriteCount
0
LastActivityDate
2013-10-15T13:24:38.420
LastEditDate
2013-10-15T13:24:38.420
LastEditorUserId
1208233
OwnerUserId
1208233
ParentId
19366476
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<blockquote> <p>Can I not make one PDO object and have that defined in all of my scripts? As well as a UserMapper object?</p> </blockquote> <h3>You're actually looking for a Front Controller.</h3> <p>That is, in order to avoid the same instantiation of the same classes, you should have prepared them. Most people usually do this in <code>bootstrap.php</code>, that "tweaks" all required dependencies.</p> <p>But a front controller implementation also includes a dispatcher and a router. I won't go deep into this, but focus on the problem you're trying to solve instead.</p> <h3>Factory pattern</h3> <p>It basically abstracts instantiation logic. The benefits are: 1) you can delay object instantiation 2) You avoid global state, which is bad for unit-testing. The simplified version of it would look like as:</p> <pre><code>class UserFactory { private $pdo; private $cache = array(); public function __construct($pdo) { $this->pdo = $pdo; } public function build($mapper) { if (isset($this->cache[$mapper])) { return $this->cache[$mapper]; } else { // Inject an instance into a mapper $instance = new $mapper($this->pdo); // Save the state into a cache $this->cache[get_class($instance)] = $instance; return $instance; } } } </code></pre> <h3>And finally</h3> <p>A very simplified version of bootstrap-er would look like as,</p> <pre><code><?php /* File : bootstrap.php */ $dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass, array(PDO::ATTR_PERSISTENT => true)); // Include here UserFactory class $userFactory = new UserFactory($dbh); // Its kinda ready to be used </code></pre> <p>You would simply include in all scripts that need to access Users</p> <pre><code><?php /* File: main.php */ include(__DIR__ . '/bootstrap.php'); $getUser = $userFactory->build('UserMapper'); $user = $getUser->findByUserId(41); echo $user->getEmail(); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCould someone give a perfect example of a basic "user" object system, using PDO?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USYang
UserOwnerUserId
1. USYang
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. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.