Archive for the 'Database' category

In the Search for the Perfect PHP Calendar

Friday, March 10th, 2006

I’m looking for something that will treat each user with its own calendar. It’ll be nice finding something that has a system like that, built-in already. Well, I’ll decide on something in a month or so.
Here are a couple of open-source PHP calendar projects worth to metion:

Monket Calendar | (+AJAX -Internet Explorer support is still […]

Web, JavaScript, PHP, Database, XMLHttp/Ajax | 1 comment

Interesting Article about Date Arithmetic With MySQL

Tuesday, January 17th, 2006

Found a great article at DevShed on “Date Arithmetic With MySQL“. The last few days we’ve been kind of puzzled about how to store and actually utilize dates, throwing them back and forth from PHP to MySQL. There seems to be a lack of documentation about MySQL date functions, I bet alot of people are […]

Web, PHP, Database, MySQL | No comments

Zip Code Database List

Friday, January 13th, 2006

Need a database full with zip codes/cities/area codes/population/counties, and much more? Me too. I’ve found a great one, with more information than you’ll ever need. Just $79.95 and you’re set. Download database as CSV/Access/Excel.

Check it out: Zip Code Database List
It took me a few hours to figure out how to import those two big ass […]

Software, Database, MySQL | No comments

The Data Access Object Pattern

Wednesday, January 11th, 2006

PHP database abstraction? I use ADOdb. Is it enough? NO.
Why?
When dealing with web applications, it’s important to separate your application logic and underlying database. It simpler terms, mixing your input, output, and logic, all together, creates a mess to maintain and extend. There are excellent thoeries about separating your design, logic, and data, and here […]

Web, PHP, Database, DB Access Patterns | No comments

ADOdb - database abstraction library for PHP

Thursday, January 5th, 2006

ADOdb is what really saved my life when moving from Classic ASP to PHP5, it supports a wide variety of database, and has some great functionality features. It supports PHP5 aswell :)
You can find ADOdb here: http://adodb.sourceforge.net/
Here are some examples of your daily database connect and retrieval:

include(‘/path/to/adodb.inc.php’);
$DB = NewADOConnection(‘mysql’);
$DB->Connect($server, $user, $pwd, $db);
# M’soft style data […]

PHP, Database | 2 comments

You are currently browsing the archives for the Database category.

Meta