You may have noticed, and possibly found yourself quite frustrated by, the fact that I have not updated “The Yii Book” in quite some time. Once again (once again!) my sincerest apologies for the delay. I have not been as productive on “The Yii Book”, or as communicative, as of late as I would have liked, or as you certainly deserve. Though a lack of updates or information conveys nothing to you, “The Yii Book” has been constantly at the forefront of my mind, and no one wants it to be done more than I. I know that progress has been somewhere between slow and terrible, and while there are reasons, I don’t want to make excuses. Basically it’s been a ton of work, and life is complicated. I can see how it could seem from the outside that I’m not prioritizing “The Yii Book”, but it’s on my mind constantly, I’m well aware of how poorly I’ve done (in terms of the schedule), and I really am making decisions towards the goal of finishing it. On that note…Continue Reading...
Archives For PHP
I just posted a couple of support pages for the 2nd edition of my “Effortless E-commerce with PHP and MySQL” book. The main URL for the book is:
I recently came across an article titled “9 Ways to Make the Payment Process Easy for Online Customers”. The article describes nine best practices for e-commerce sites: what you should do to have the best possible conversion rate. I definitely stress most, if not all, of these points in my “Effortless E-commerce with PHP and MySQL” book, but they are policies and approaches worth repeating. If you do any kind of web development, and especially if you do e-commerce, give this quick article a read. The only thing the article leaves out is how to convince your client that you’re right when it comes to implementing these policies, especially the one about not requiring accounts to complete orders!Continue Reading...
The great people at the Northeast PHP conference have made videos of all the presentations available online at YouTube. How great is that?
All of the videos, linked by presentation, can be found on this Northeast PHP page: http://www.northeastphp.org/pagesContinue Reading...
Whenever you begin working with a database, you introduce more possible causes of errors. Thus, you must learn additional debugging strategies. When using PHP to run queries on the database, the problems you might encounter include:
An inability to connect to the database
A database error thrown because of a query
The query not returning the results or having the effect that you expect
None of the above, and yet, the output is still incorrect
On a non-framework site, you just need to watch for database errors to catch the first two types of problems. There’s a simple and standard approach for debugging the last two types:
Use PHP to print out the query being run.
Run the same query using another interface to confirm the results.
Debug the query until you get the results you want.
When using a framework, these same debugging techniques are a little less obvious, in part because you may not be directly touching the underlying SQL commands. Thankfully, Yii will still be quite helpful, if you know what switches to flip.