<?php
/**
* @package Mysql DB Management Examples
* @author Ahmed Elbshry(bondo2@bondo2.info)
* @copyright 2008
* @access public
*/
try{
require './db.class.php';
//ÇáÇÊÕÇá ÈÞÇÚÏÉ ÇáÈíÇäÇÊ ãÚ æÇÎÐ äÓÎå ãä ÇáßáÇÓ Ýì ÎØæÉ æÇÍÏå
$db = new DB('localhost','root','');
//ÇÎÊíÇÑ ÞÇÚÏÉ ÇáÈíÇäÇÊ ÇáÊì ÓäÊÚÇãá ãÚåÇ
$db->UseDB('information_schema');
//ßíÝíÉ ÇáÇÓÊÚáÇã æÇÎÑÇÌ ÇáäÊÇÆÌ Ýì ãÕÝæÝÉ ÍÑÝíÉ æÑÞãíÉ ãÚÇ
$rsArr = $db->SelArr("SELECT * FROM CHARACTER_SETS");
//print_r($rsArr);
echo "<table border='2'><tr><td>";
echo "<table><tr><th colspan='4'><center>Using SelArr Function</center></th></tr>";
for($i=0;$i<count($rsArr);$i++) {
echo "<tr><td>".$rsArr[$i]['CHARACTER_SET_NAME']."</td><td>".$rsArr[$i]['DEFAULT_COLLATE_NAME']."</td><td>".$rsArr[$i]['DESCRIPTION']."</td><td>".$rsArr[$i]['MAXLEN']."</td></tr>";
}
echo "</table></td><td>";
echo "<table><tr><th colspan='4'><center>Using SelArr Function</center></th></tr>";
for($i=0;$i<count($rsArr);$i++) {
echo "<tr><td>".$rsArr[$i][0]."</td><td>".$rsArr[$i][1]."</td><td>".$rsArr[$i][2]."</td><td>".$rsArr[$i][3]."</td></tr>";
}
echo "</table></td></tr></table>";
$db->Close();
}
catch(exception $e) {
echo $e->getMessage();
}
?>
|
