My Personal Library

Citations for Adapted Code

Expandable bibrecords adapted from W3Schools tutorial article How to Create a Collapsible Section.

SQL code to create a separate title column for sorting that omits title-initial articles ('a', 'an', 'the') adapted from a Stack Overflow comment posted by user GDP.
I started learning how to concatenate the same field accross multiple rows of data from a Stack Overflow comment posted by user che.
I learned how to alias table joins in order to join the same table (in my case `person`, which could refer to an author, editor, translator, or artist) from a Stack Overflow comment posted by user András Ottó.

Code to separate library database results across multiple pages was adapted from the My Programming Tutorials tutorial Create Pagination with PHP and MySQL.

MySQL Aggregate (GROUP BY) Function Descriptions
This article was helpful in designing my SQL query to group various fields together.
To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem
This article helped me to determine that is is more efficient to store image files directly on my server rather then store them in my database as binary data.