<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
I'm learning Kohana <a class="moz-txt-link-freetext" href="http://forum.kohanaphp.com/">http://forum.kohanaphp.com/</a>, which has pretty well
developed drivers for database access, and I believe the MySQL driver
is among the better developed. I chose Kohana because it has a light
footprint, and is OOP. But....<br>
<br>
But there are issues: they haven't dealt well with the issue of
returning error messages (I hope and believe they're working on that
for the next version), and they haven't used the pdo framework
<a class="moz-txt-link-freetext" href="http://ca.php.net/manual/en/book.pdo.php">http://ca.php.net/manual/en/book.pdo.php</a> (again I believe they're
incorporating that into the next version). <br>
<br>
PDO has a standard error reporting mechanism:
<a class="moz-txt-link-freetext" href="http://ca.php.net/manual/en/pdostatement.errorinfo.php">http://ca.php.net/manual/en/pdostatement.errorinfo.php</a><br>
<br>
Nothing is easy.<br>
<br>
- Henrik<br>
<br>
Petko Yotov wrote:
<blockquote cite="mid:200901311316.10672.5ko@5ko.fr" type="cite">
<pre wrap="">On Saturday 31 January 2009 12:52:44 Peter Bowers wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Apologies for the off-topic post, but you guys here are the most
knowledgeable people I know about PHP development...
I'm just starting to get my feet wet with developing an application on a
PHP/MySQL platform. I've got it mostly working as a prototype, but it's
not pretty. I'd like to find some application that will show me elegant
ways of accessing MySQL from PHP...
Do any of you know a good open-source app I could look at to get ideas and
patterns and etc?
</pre>
</blockquote>
<pre wrap=""><!---->
For starting a new program, unless it is a very very simple one and will never
grow larger, I can recommend the use of a PHP framework that is adapted for
MySQL integration. See a list at Wikipedia:
<a class="moz-txt-link-freetext" href="http://en.wikipedia.org/wiki/Php_framework#PHP">http://en.wikipedia.org/wiki/Php_framework#PHP</a>
In the past (2006), I have tried CodeIgniter which had some excellent features
and excellent documentation. See :
<a class="moz-txt-link-freetext" href="http://en.wikipedia.org/wiki/CodeIgniter">http://en.wikipedia.org/wiki/CodeIgniter</a>
<a class="moz-txt-link-freetext" href="http://codeigniter.com/">http://codeigniter.com/</a>
If not a web framework, at least you should use an abstraction layer for the
database access -- instead of the built-in functions mysql_query() and other
mysql_*: your own sql_query() which calls mysql_query() -- to be able to
later migrate to another database engine.
There is also phpclasses.org where you can find a number of useful snippets
(free registration required).
Thanks,
Petko
_______________________________________________
pmwiki-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pmwiki-devel@pmichaud.com">pmwiki-devel@pmichaud.com</a>
<a class="moz-txt-link-freetext" href="http://www.pmichaud.com/mailman/listinfo/pmwiki-devel">http://www.pmichaud.com/mailman/listinfo/pmwiki-devel</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Henrik Bechmann
bechmann.ca
</pre>
</body>
</html>