Beispiel #1
0
	/**
	 * Get an array of users who have uploaded images.
	 * @return array
	 */
	public static function GetUploadUsers()
	{
		$tmpUser = new User();
		$columnNames = $tmpUser->getColumnNames();
		$queryColumnNames = array();
		foreach ($columnNames as $columnName) {
			$queryColumnNames[] = 'liveuser_users.'.$columnName;
		}
		$queryColumnNames = implode(",", $queryColumnNames);
		$queryStr = 'SELECT DISTINCT liveuser_users.Id, '.$queryColumnNames
					.' FROM Images, liveuser_users '
                    .' WHERE Images.UploadedByUser = liveuser_users.Id';
		$users = DbObjectArray::Create('User', $queryStr);
		return $users;
	} // fn GetUploadUsers
Beispiel #2
0
<?php

require_once 'model.php';
$pasta = new User();
print_r($pasta->getTables());
print_r($pasta->getColumnNames('albums'));
$pasta->album_name = 'wet noodle race';
$pasta->album_artist = 'rigitoni';
$pasta->album_release = 'too soon';
$pasta->album_sales = 'over 9000';
$pasta->album_genre = 'rock sauce';
$pasta->save();
print_r($pasta->all());