/** * 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
<?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());