Post-Module PHP Functions and MySQL

apatheticyogurtΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 6 μήνες)

61 εμφανίσεις

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


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