Kendi yazdığım, bağlantı ve query için kullandığım bir sınıf...
<?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;
}
}
}
?>Kullanım:
<?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>