In essence it doesn't matter so much which convention you use as long you use a convention, use it consistently and the convention itself doesn't come with too much complexity of it's own and is based on a clear philosophy. The naming convention I use in any environment or language uses simple prefixes and is based on two points: 1. the name should show the origin of the variable/function/table/query and what more; 2. it should show the functional context / meaning In other words: 1. Where can I find it; 2. What does it mean. Of course, the naming convention must be combined with structure conventions. Just thinking along ... Roberto ----- Original Message ----- From: "Paul Burney" <paul.lists@burney.ws> To: "Charles Kline" <ckline@rightcode.net>; "PHP Database List" <php-db@lists.php.net> Sent: Sunday, March 30, 2003 5:19 PM Subject: Re: naming conventions > on 3/30/03 9:52 AM, Charles Kline at ckline@rightcode.net appended the > following bits to my mbox: > > > i was just wondering if there are any naming conventions when creating > > database connections. most of my books use > > > > $sql = "SQL STRING"; > > > > and > > > > $sth = $db->query() or $result = $db->query() > > > > I have no idea what sth stands for in this case, but was curious how > > others name stuff. > > I usually just use $query or $q for "query," $res or $r for "result," $row > or $s for the returned array, and $dbh for the database connection. I got > the latter from the standard Perl database connection, "dbh -> Data Base > Handle." > > If I recall correctly, the $sth also comes from the standard perl examples. > The standard PHP example, from http://www.php.net/manual/en/ref.mysql.php , > uses $link for the connection, $query for the query, and $line for the > returned record array. > > A lot of database classes use $db as the new object. > > Hope that helps. > > Sincerely, > > Paul Burney > <http://paulburney.com/> > > <?php > while ($self != "asleep") { > $sheep_count++; > } > ?> > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
