StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMaking a databaseDo() function for hooking PDO queries
primarykey
Id
12434093
data
AcceptedAnswerId
12434230
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-09-15T02:40:25.197
FavoriteCount
0
LastActivityDate
2012-09-15T05:02:16.703
LastEditDate
2012-09-15T02:52:49.573
LastEditorUserId
616443
OwnerUserId
1632175
ParentId
0
PostTypeId
1
Score
5
ViewCount
159
LastEditorDisplayName
text
Body
<p>So I started <a href="http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html#7.1" rel="nofollow">this tutorial</a> as an intro to the PHP PDO. Up until now I've only worked with basic <code>mysql_*</code> type queries. </p> <p>I've noticed that, throughout the tutorial, the <code>connect -> do action -> disconnect</code> pattern is repeated, and only the <code>do action</code> part ever changes. </p> <p>In a real-world setting, would it be a good idea to eliminate repetition by creating a function into which queries can be passed? </p> <p>For example:</p> <h2>a function for handling queries:</h2> <pre><code><?php function databaseDo($action) { $db_hostname = 'localhost'; $db_username = 'root'; $db_password = 'root'; try { // Establish DB connection $dbh = new PDO("mysql:host=$hostname;dbname=mysql", $db_username, $db_password); echo 'Connected to database'; // Do something $action($dbh); // <- here goes whatever action we wish to perform // Close connection $dbh = null; } catch(PDOException $e) { echo $e->getMessage(); } ?> </code></pre> <p>Then, suppose I want to perform the action in the first example of the PDO tutorial, I would set it like this:</p> <pre><code><?php // Define action $insert = function($dbh) { $query = "INSERT INTO animals(animal_type, animal_name) VALUES ('kiwi', 'troy')"; $exec = $dbh->exec($query); echo $exec; }; // Perform action databaseDo($insert); ?> </code></pre> <h2>Scope of $dbh</h2> <p>I am using $dbh as an argument. Is this the proper way of passing a variable to a function like this without making it global? </p>
Tags
<php><function><pdo>
Title
Making a databaseDo() function for hooking PDO queries
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USj08691
UserOwnerUserId
1. USo_o_o--
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
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POMaking a databaseDo() function for hooking PDO queries
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POMaking a databaseDo() function for hooking PDO queries
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POMaking a databaseDo() function for hooking PDO queries
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.