Using the Zend_Db_Table class, which is part of the Zend Framework, we can easily access a specific table in our database. The following code sample shows how simple it is to add a new row using this class. The following code includes our definition for the users controller. <?php require_once ROOT_DIR.’/models/Users.php’; class UsersController extends Zend_Controller_Action [...]
HTML 5 provides us with a relational database running on the web browser. This relational database supports SQLite sql syntax. The following code sample checks whether the web browser supports the HTML 5 relational database. <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “http://www.w3.org/TR/html4/loose.dtd”> <html> <head> <title></title> </head> <body> <script type=”text/javascript”> if(window.openDatabase) { document.write(“support”); } else [...]
This coming spring semester (Spring 2012) I am going to deliver in MTA a course that teaches how to analyse, design and develop the code running on the server side for working with a database. The course includes the following main topics: Relational Databases No SQL Databases Objects Relationship Mapping Most of the slides and [...]
Stanford University allows people from all over the world to take the Introduction to Databases course over the web. The course is offered for free (for a limited period of time). This is a great opportunity for every person who is not familiar with how databases work to acquire this knowledge for free. I believe [...]
