A common issue most PHP developers run into is what date format should be used between PHP and MySQL. Converting can be a big pain, and their favorite formats could not be any different. CodeIgniter has a lot of great date functions (aka, “helpers“), but none really fit the bill to make it really simple to convert PHP time (seconds since Unix Epoch) to MySQL’s datetime format, which is really the best way to store dates...

Introduction One feature many popular sites implement is persistent login, or the ability for a user to stay logged in for long periods of time – well beyond the time they last visited the site and subsequently closed their browser. Many basic login protocols web developers put in place either deal with cookies, which is valid until the date the web developer has specified, or sessions, which are only valid until the browser is...

There are plenty of tutorials and articles on uploading files to a server, but not quite as many about uploading to a database. Developing database-driven (or at least supported) applications is almost a right of passage for the bonafide PHP developer. As your applications become more ambitious and the database plays a larger role in them, uploading files to your database instead of the file server makes more sense in many scenarios. The...