60 likes | 147 Views
Post-Module PHP Functions and MySQL. BTM 395: Internet Programming. Default function parameters. PHP CodePad exercise: http:// codepad.org/lWbpmr1D You can do this in JavaScript, but it is rather convoluted. Passing arguments by reference. [Top Hat exercises]. PHP Manual.
E N D
Post-Module PHP Functions and MySQL BTM 395: Internet Programming
Default function parameters • PHP CodePadexercise: http://codepad.org/lWbpmr1D • You can do this in JavaScript, but it is rather convoluted
Passing arguments by reference • [Top Hat exercises]
PHP Manual • PHP Manual: Official documentation for PHP • PHP Language Reference: list of all language features • PHP Function Reference: list of all extended functions that are standard PHP • Many of these functions are included in special modules that might or might note be installed by your web host
Brief history of MySQL • Created in 1995 by MySQL AB, a Swedish company • “My” is the name the daughter of one of the creators, Monty Widenius • 2008: Sun Microsystems acquired MySQL AB • 2009: Monty Widenius forked MySQL to create MariaDB when Oracle attempted to buy Sun Microsystems • “Maria” is Monty Widenius’ youngest daughter • MariaDB maintains 100% compatibility with MySQL • 2010: Oracle acquired Sun Microsystems with MySQL • A number of MySQL lead developers have moved to MariaDB • 2012: Many major MySQL users started switching to MariaDB Source: Wikipedia
Open source competitors of MySQL • SQLite: small, embedded single-user databases • Possibly the most widely deployed database in the world, whether open-source or proprietary • PostgreSQL: #3 OSS database, after MySQL • Better for enterprise-class applications than MySQL • Faster for larger-scale applications • MySQL may be faster for read-heavy applications • MongoDB: non-relational document-oriented database • Suitable for very large, unstructured data sets