RMBstore status

From RMBwiki

[edit] Cart and Order Processing Completed

I now have a working shopping cart and the ability to take credit card orders via the web! I split this functionality into a sub-project called RMBcart.

--Rich 15:00, 17 October 2006 (EDT)

[edit] Subversion

Project is under subversion source control now. RMBcart sources and RMBstore are in seperate repository modules^*

• RMBstore needs RMBcart, so I am using svn:externals property to keep RMBcart sources inside RMBstore working copy, which allows them to still be developed seperately.

--Rich 14:49, 18 October 2006 (EDT)

[edit] Repository Browser

A subversion repository browser has been set up at http://www.richbellamy.com/repository/

--Rich 14:49, 18 October 2006 (EDT)

[edit] SQL Abstraction Layer

An abstraction layer between RMBstore and the SQL server beneath it has been mostly completed. I have dubbed it "Database Magic". It provides methods like sqlMagicGet() which can be used like this:

$parm = array('customer' => 12, 'date' => "2006-10-23");
$result = sqlMagicGet("myordertable", $parm);

Which replaces code like this:

$sqlconnection = mysql_connect('localhost', 'mysql_user', 'mysql_password');
mysql_select_db('mysql_database', $sql);
$query = "SELECT * FROM myordertable WHERE `customer`='12' AND `date`='2006-10-23'";
$result = mysql_query($query, $sqlconnection);

Database Magic also creates and maintains the mysql tables automatically, making RMBcart installation and upgrading much easier.

There is also a base class for Database Magic called DatabaseMagicObject. All classes and objects in RMBstore will extend this class, because it provides a lot of common functionality, including loading and saving object to and from the database, and building relational tables between objects automatically.

--Rich 23:32, 23 October 2006 (EDT)

[edit] Main Classes Continue to Evolve

The major work of RMBstore is moving forward quite nicely. Three main classes have been defined and their display code is almost completed.

I have decided to generate all output using the Document Object Model. This allows me to think of displaying the code in a much more modular and object-oriented way, and also forces me to stay in compliance with the W3C xhtml standard. I am endeavoring to make it through the project on xhtml-strict, we shall see.

An added benefit of that is all learning I do modifying the DOM server-side with PHP ports over to client-side with Javascript because PHP and Javascript have a very similar interface to modifying DOM's. Generating the XML replies for my AJAX calls will be much easier as well.

--Rich 00:45, 25 October 2006 (EDT)

[edit] Functioning Project

Sheesh, I forgot about this page. . .

Well, at this point I have an excessively ugly, but mostly functional product on my hands :)

Try it out!

--Rich 22:20, 14 December 2006 (EST)

[edit] New Development Beginning

Yeah I am back at it again. First task is to AJAX-ize the interfaces. I am going to create a new tag on the repository for RMBstore that marks this revision.

--Rich 20:45, 3 April 2007 (EDT)