Clase para acceder a BBDD

[srodenashe]

function ListTables()
{
$database = $this->Database;
$results = mysql_listtables($database);
if (!$results) { return false;}

$i = 0;
$data[0] = mysql_num_rows($results);
while ($i < mysql_num_rows($results)) {
$data[$i+1] = mysql_tablename($results, $i);
$i++;

}




return $data;

}


function create($sql="")
{

if (empty($sql)) { return false;}

if (!eregi("^create",$sql))
{
echo "<h2>Error in command</h2><br> \n";
}

if (empty($this->Conn)) { return false;}

$conn = $this->Conn;
$results = mysql_query($sql,$conn);
echo mysql_error();
if (!$results) { return false;}

return true;
}


function chequeatabla($table)
{
if (mysql_db_query($this->Database,"SHOW FIELDS FROM $table") )
{
return TRUE;
}
else
{
return FALSE;
}

}
function creardatabase($database){

if (!$conn = mysql_connect($server, $user,$password)) { return false;}


$sql = "create database ".$database;
$results = mysql_query($sql,$conn);
echo mysql_error();
if (!$results) { return false;}

return true;
}



function chequeabase($database){
$conn = mysql_connect($server, $user,$password);
if (!$conn)
{
$this-error("No connection !");
return false;
}

if (mysql_db_query($database,"SHOW tables FROM $database") )

{
return TRUE;
}
else
{
return FALSE;
}

}
function devuelveerror(){

return mysql_error();
}
} // End of EU-SQL-Class
?>



Un ejemplo es el siguiente:

<?
include "clase.php";

$bd = new CBBDD();
if (!$bd->init())
{
echo "No se puede conectar con la base de datos";
$bd->close;
exit;
}

$sql = "select * from clientes where id>5";
$rs = $bd->select($sql);
if($rs[0]>0){
$conta=1;
while ($conta <= $rs[0]){
print $rs[$conta]["columna"];
++$conta;
}
}

//Solo muestro la forma de seleccionar datos


?>