<link href="default.css" rel="stylesheet" type="text/css" />
<?
require_once("mysql.inc.php");
$connect = new MySQL_Func();
$connect->DB(); //Now Connected
$query = "SELECT * FROM users";
$result = $connect->query($query); //query example
echo "<CENTER>---Querying---</CENTER><BR>";
while($dresult = mysql_fetch_array($result,MYSQL_ASSOC)){
print_r($dresult);
echo "<BR><BR>";
}
//Numrows example
echo "<CENTER><BR><BR>---Get Number Of Rows---<BR><BR></CENTER>" . $connect->numrows($query) . " Users exists!";
//Now Field Extractor
echo "<CENTER><BR><BR>---Field Extractor---<BR>(User ID:1) Username: " . $connect->ex("$query WHERE USER_ID=1","USERNAME") . "<BR></CENTER>";
echo "<CENTER><BR><BR>---Listing Fields Of The Table---<BR><BR></CENTER>";
$lfield = $connect->list_fields($query,0);
print_r($lfield);
echo "<CENTER><BR><BR>---Field Properties Of The Table---<BR><BR></CENTER>";
$pfield = $connect->field_property("hostigen_cse305","users",0);
print_r($pfield);
echo "<CENTER><BR><BR>---Listing Tables Of The Db---<BR><BR></CENTER>";
print_r($connect->list_tables("hostigen_cse305"));
echo "<CENTER><BR><BR>---Optimizing Tables---<BR><BR></CENTER>";
$connect->optimize("hostigen_cse305");
echo "<CENTER><BR><BR>---Listing Whole Table Into an Array---<BR><BR></CENTER>";
$table=$connect->listHoleTable("users");
print_r($table);
echo "<BR><BR><BR>";
echo "NEW FUNCTION getArray";
echo "<BR><BR><BR>";
$newResult=$connect->getArray($query);
print_r($newResult);
echo "<BR><BR><BR>";
echo $newResult[0]["USERNAME"];
$connect->close();
?>
|
Download
