Model example

<?php
//Model page - database interactivity

//create db connection
$myDsn = 'mysql:host=localhost; dbname=world';
$myUser = 'root';
$myPass = '';

$myPdo = new PDO($myDsn, $myUser, $myPass);

/*-----------------------------------------------------------------------
Name:	selectCities
Desc:	retrieves a recordset containing all fields for all cities
Para:	none
Retn:	$statement - a PDO statement object containing the result set.
-----------------------------------------------------------------------*/
function selectCities() {
	//SQL statement
	$sql = 'SELECT * FROM city';

	//prepare and execute
	global $myPdo;
	//$statement = $myPdo->prepare($sql);
	//$result = $statement->execute();
	$result = $myPdo->query($sql);

	return $result;
}

?>