This article details a basic Paypal IPN processor implemented with QCodo. Details include the database schema, a simple form to direct the user to paypal for payment completion, and the paypal IPN processor which will store the transaction details in the previously defined database. The code for this example can be downloaded here.
Read the rest of this entry »
In the spirit of being on the bleeding edge, I’ve just finished updating the qcodo examples to work with QCodo beta 3. I’ve also updated QMatrix.
For those who are contemplating updating a project to beta 3, you should know that it is a bit of work depending on the size of your project. There is nothing too difficult, but with a few constants changing names, and a query logic changing, you may have many simple changes to make to your code. So give yourself some time if you plan to bite the bullet and upgrade. In my limited (1 day) experience with beta 3, I will say that the upgrade is worth the effort. The sql query changes look like it will make it very easy to add custom queries to your project. I know there are many other changes, but that’s the one that jumped out and bit me first, and the one that took me the most time to accommodate. I’m not sure yet when I’ll bite the bullet for baseballdata, but I already did for another project I have going.
I just finished releasing QMatrix. It’s at qforge. QMatrix is an extension QPaginated control which displays its datasource across multiple rows and columns as a single item per cell. This is slightly different than QDataGrid which displays a single item per row. My motivation for creating this class was a need to display a bunch of images in a table, but I’m sure there are other interesting uses. You can see QMatrix in action here.
After taking the summer off I decided to get back into the swing by updating baseballdata.net. I’ve added Team stats pages. You can find teams by year and get detailed pitching and hitting stats, as well as rosters. I’m sure there is another tutorial in there somewhere, so I’ll be adding that soon as well. In the mean time, you check out the changes at baseballdata.net.
The first installment of this series described a technique for creating a flexible page templating system for Qcodo. This article picks up where that one left off and expands our template to create a more interesting layout for our pages. If you haven’t yet read the first article, you read it here.
Read the rest of this entry »
Qcodo is a fantastic PHP framework which uses code generation to accelerate the process of developing database driven websites. It not only generates all of the CRUD code for data objects, it also has a set of form objects from which to build the presentation layer. Out of the box it generates some basic forms to view and edit the data objects. This is the first in a series of articles discussing a simple technique for creating a consistent look and feel for a Qcodo site, while at the same time making it very easy to change the look of all or some of the pages at any time.
Read the rest of this entry »
After a few weeks of development, baseballdata.net is now useable. It uses of the statistics database available at Baseball-Databank. The site was developed using the QCodo framework. There is still much work to do to add more statitics pages, but I decided that there were no more excuses for not opening up to the public. It also gives me the topic for the first assortedbits tutorial. The page templating system that was developed for baseballdata is interesting, so that will be our first tutorial. Look for that in the next few days.
So I’ve finally gotten around to setting this site up. It will consist of odds and ends related to software development. The site is called assortedbits because it will be a collection of bits based on whatever I am interested in working on at the time I post. Right now I am exploring baseball databases and PHP frameworks, so that will be the first topic. I hope you find the information useful.