Latest Useful Web Resources and Links #1, March 2016

I created this page as a running repository of useful, miscellaneous web notes for later reference. Javascript & JQuery How to get the latest version of JQuery: Useful info about Javascript and JQuery source maps -- an explanation about what they are and how they are used: http://elijahmanor.com/the-magic-of-the-jquery-1-9-source-map/ Parsley -- A reliable and easy…

MySQL DATE_FORMAT: Grouping Date & Time value fields into single days made easy

To conform a datetime field to just a date in your results and make it easy to group TIMESTAMP fields in the format "2015-12-25 12:23:23" so you can group any datetime value into actual days for daily reports, use "DATE_FORMAT" below: In other words, if you have values from a SELECT statement that are…

Changing getArrayResult() to getArray() fixes weird Symfony Doctrine gotcha

A strange Symfony Doctrine issue got me the other day.  I guess it's a lack of clear understanding of how Doctrine hydrates database query results when using getArrayResult() instead of getArray().  It seems that getArrayResult() returns just the first record from your query, no matter how many records the query actually returns but getArray() returns…

Planning to design or redesign an organization’s database? Get back to basics and refer to MySQL’s reserved keyword list

Oracle's MySQL is a staple in the open source web environment world.  Being familiar with the reserved words the database uses is just one way to make sure you don't have to refactor code or special-escape field names in queries later with the menacing back tick: ` Here is the link to MySQL's reserved keyword's…

MySQL: Using sub-selects to filter results of one table that is not contained in another table

In MySQL, if you have two tables with a shared index and you would like to show the results of one table where the index is not within another table, you can use "NOT IN". Try Googling "MySQL NOT IN" and you get everything but this command, it's almost as if they need to…