Location: PHPKode > scripts > mysql2object > mysql2object/example.php
<?
	require_once('database.class.php');
	
	echo '<pre>';
	try {

		$testDatabase = new Database(new DB('mysql://admin:hide@address.com/testDatabase'));
		
		echo '<b>Example 1 - get all tables in database:</b><br>';
		print_r($testDatabase->all); echo '<br>';
		
		echo '<b>Example 2 - get all columns from selected table:</b><br>';
		print_r($testDatabase->pp_users->all); echo '<br>';
		
		echo '<b>Example 3 - get informations on selected table :</b><br>';
		echo '<li>Table name: '.$testDatabase->pp_users->Name.'<br>';
		echo '<li>Engine: '.$testDatabase->pp_users->Engine.'<br>';
		echo '<li>Version: '.$testDatabase->pp_users->Version.'<br>';
		echo '<li>Row format: '.$testDatabase->pp_users->Row_format.'<br>';
		echo '<li>Number of rows: '.$testDatabase->pp_users->Rows.'<br>';
		echo '<li>Number of columns: '.$testDatabase->pp_users->Columns.'<br>';
		echo '<li>...etc...<br><br>';
		
		echo '<b>Example 4 - get all values from selected column:</b><br>';
		print_r($testDatabase->pp_users->username->all); echo '<br>';
		
		echo '<b>Example 5 - get informations on selected column :</b><br>';
		echo '<li>Column type: '.$testDatabase->pp_users->username->Type.'<br>';
		echo '<li>Null: '.$testDatabase->pp_users->username->Null.'<br>';
		echo '<li>Key: '.$testDatabase->pp_users->username->Key.'<br>';
		echo '<li>Default: '.$testDatabase->pp_users->username->Default.'<br>';
		echo '<li>Extra: '.$testDatabase->pp_users->username->Extra.'<br>';
		echo '<br>';

		echo '<b>Example 6 - get selected value from selected column:</b><br>';
		print_r($testDatabase->pp_users->username(5)); echo '<br><br>';
		
		echo '<b>Example 7 - gets all data sorted by selected columns:</b><br>';
		print_r($testDatabase->pp_users->sort('username desc','email')); echo '<br>';

		echo '<b>Example 8 - gets data from some selected columns:</b><br>';
		print_r($testDatabase->pp_users->columns('username','email')); echo '<br>';
		
		echo '<b>Example 9 - gets data from all columns which accept one/more conditions :</b><br>';
		print_r($testDatabase->pp_users->select(array('views', '>', 900),array('userid', '<', 10))); echo '<br>';

		echo '<b>Example 10 - gets data from one column which accept one/more conditions :</b><br>';
		print_r($testDatabase->pp_users->userid->select(array('>', 5),array('<',10))); echo '<br>';

		echo '<b>Example 11 - join data from selected table on defined condition :</b><br>';
		print_r($testDatabase->pp_users->join($testDatabase->pp_usergroups, $testDatabase->pp_users->usergroupid, $testDatabase->pp_usergroups->groupid));

		echo '<b>Example 12 - union data from two tables :</b><br>';
		print_r($testDatabase->forum_usertitle->union($testDatabase->areckitest));

		echo '<b>Example 13 - gets data with composed functions/conditions :</b><br>';
		$testDatabase->pp_users->createComposedCondition('test1');
		$testDatabase->pp_users->join($testDatabase->pp_usergroups, $testDatabase->pp_users->usergroupid, $testDatabase->pp_usergroups->groupid);
		$testDatabase->pp_users->select(array('views', '>', 0));
		$testDatabase->pp_users->columns('username','email','groupname');
		$testDatabase->pp_users->union($testDatabase->old_pp_users, array('username'=>'old_username','email'=>'old_email', 'groupname'=>'password'));
		$testDatabase->pp_users->sort('email desc');
		$testDatabase->pp_users->endComposedcondition('test1');
		print_r($testDatabase->pp_users->test1);

		
	} catch (Exception $xx) {
		echo 'Error: '.$xx->getMessage();
	}
	
	echo '</pre>';
?>
Return current item: mysql2object