MainelyDesign.com Blog

Invalid Date Value Error in MySQL

Posted on 09/09/2009 at 02:26 pm | Viewed 12,823 times | 0 comments

I ran into an interesting issue with valid dates and MySQL on Windows.  I wrote a CakePHP import function that basically moves MySQL data from one DB to the other.  I never thought that I would see an error related to an invalid date, but I did.

What determines if a date value is invalid (read: warning) or unacceptable (read: error)?

Read: Invalid Date Value Error in MySQL | View: Comments

Importing an Excel file into CakePHP

Posted on 04/16/2009 at 02:42 pm | Viewed 33,754 times | 0 comments

I needed to be able to upload an excel file, parse the file, and then add each row as a separate database entry.  I had this working for a CSV file using the php built-in function fgetcsv(), but the client switched to using an excel file (instead of direct PHP access to the in-house database, we decided to have the client upload a CSV/Excel file). 

Read: Importing an Excel file into CakePHP | View: Comments