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 |
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 |
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 |
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 |
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 |