<?php
	/****************************************************
	*           Yazar: G.Gökmen Korkmaz                                              *
	*           Mail: gokmen.korkmaz@gmail.com                                 *
	*           www.harikaonline.com                                                     *
	****************************************************/	
	class gokmen_data {
		var $system;
		function connect($host,$username,$password,$db) {
			switch($this->system){
				case "MySQL";
					$connect = @mysql_connect($host,$username,$password);
					if (!$connect){
						echo "<table width='100%' height='100%'>\n<tr>\n<td valign='middle' align='center'>\n";
						echo "<table width='30%' height='30%'>\n<tr>\n<td align='center' bgcolor='#CCCCCC'>";
						echo "Baglanti Kurulamadı: ". mysql_error();
						echo "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>";
						exit;
					}
					$select_db = @mysql_select_db($db);
					if (!$select_db){
						echo "<table width='100%' height='100%'>\n<tr>\n<td valign='middle' align='center'>\n";
						echo "<table width='30%' height='30%'>\n<tr>\n<td align='center' bgcolor='#CCCCCC'>";
						echo "Baglanti Kurulamadı: ". mysql_error();
						echo "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>";
						exit;
					}
				break;
				case "PostGreSQL";
					$connect = @pg_connect("host=$host dbname=$db user=$username password=$password");
					if (!$connect){
						echo "<table width='100%' height='100%'>\n<tr>\n<td valign='middle' align='center'>\n";
						echo "<table width='30%' height='30%'>\n<tr>\n<td align='center' bgcolor='#CCCCCC'>";
						echo "Baglanti Kurulamadı: ". pg_last_error($connect);
						echo "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>";
						exit;
					}
				break;
				case "MsSQL";
					$connect = @mssql_connect($host,$username,$password);
					if (!$connect){
						echo "<table width='100%' height='100%'>\n<tr>\n<td valign='middle' align='center'>\n";
						echo "<table width='30%' height='30%'>\n<tr>\n<td align='center' bgcolor='#CCCCCC'>";
						echo "Baglanti Kurulamadı: ". mssql_get_last_message();
						echo "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>";
						exit;
					}
					$select_db = @mssql_select_db($db);
					if (!$select_db){
						echo "<table width='100%' height='100%'>\n<tr>\n<td valign='middle' align='center'>\n";
						echo "<table width='30%' height='30%'>\n<tr>\n<td align='center' bgcolor='#CCCCCC'>";
						echo "Baglanti Kurulamadı: ". mssql_get_last_message();
						echo "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>";
						exit;
					}
				break;
			}
		}
		function query_wiev($sql){
			switch($this->system){
				case "MySQL";
					$result = mysql_query($sql);
					$i=0;
					while($row = mysql_fetch_assoc($result)){
						$rows[$i]=$row;
						$i++;
					}
					return $rows;
				break;
				case "PostGreSQL";
					$result = pg_query($sql);
					$i=0;
					while($row = pg_fetch_assoc($result)){
						$rows[$i]=$row;
						$i++;
					}
					return $rows;					
				break;
				case "MsSQL";
					$result = mssql_query($sql);
					$i=0;
					while($row = msqsql_fetch_assoc($result)){
						$rows[$i]=$row;
						$i++;
					}
					return $rows;					
				break;
			}
		}
		function query_iud($sql){
			switch($this->system){
				case "MySQL";
					mysql_query($sql);
				break;
				case "PostGreSQL";
					pg_query($sql);
				break;
				case "MsSQL";
					mssql_query($sql);
				break;
			}
		}
	}
?>

<?php
	require('gk_classes.php');
	$baglan = new gokmen_data;
	$baglan->system = "MySQL";
	$baglan->connect("localhost","user","password","database");
	$row = $baglan->query_wiev("SELECT * FROM tablo");
?>
<table align='center' width='300' cellpadding='3' cellspacing='0' border='1'>
<?php
	for($i=0;$i<=count($row);$i++){
?>
	<tr>
		<td align='center'><?= $row[$i]['title'] ?></td>
	</tr>
<?php
	}
?>
</table>