Regarding representing and storing dates after 2037, I need to analyze this discussion further.
Y2038 Problem
Leave a reply
Tag Archives: MySQL
MySQLi
Here is a nice article explaining mysqli, including prepared statements.
So, the question is, how do you use a prepared statement when the number of parameters is variable? I think the answer is here, but I have to study it.
Get Auto Increment Value in MySQL
Situation: Updating 2 tables at the same time. The second table is keyed to the auto increment column of the first table. How do you get the auto increment value for the row you just entered?
This answers the question.
Nice Article about SQL joins
From codinghorror.com
New PHP Project & Name Parsing
Thinking about developing a mysql database for help with case management in my firm. Learned alot by using XAMPP and the excellent PHP Development Series video tutorials at Lecture Snippets.
Jonathon Hill‘s PHP Human Name Parsing, improving Keith Beckman’s script.
Jason Priem’s page about parsing human names in PHP.
Here is the same type thing in javascript by Josh Frasier.
Another javascript name parser by Jerry Davidson.
Chris West’s blog post about javascript name parsing.