Abstracción de BD

[jmaribau]

Me lo he estado mirando, y no me acaba de convencer, ya que que se trata de hacer una capa encima de la capa de la abstracción a la base de datos.

<?php

mysql_connect("localhost", "mysql_user", "mysql_password")
or
die("could not connect");

mysql_select_db("mydb");

$result = mysql_query("SELECT count(*) FROM users");

$row = mysql_fetch_array($result);

$num_users = $row[0];

mysql_free_result($result);

$result = mysql_query("SELECT name FROM users LIMIT rand(0, $num_users-1) ,1");

$row = mysql_fetch_object($result);

mysql_free_result($result);

echo $row->name;
?>
Now, let's do exactly the same thing using our new class:
<?php


include_once "ez_sql.php";

$name = $db->get_var("SELECT name FROM users LIMIT ".rand(0,$db->get_var("SELECT count(*) FROM users")-1).",1");

echo $name;

?>

Yo tambien te lo monto en 3 linias si quieres:

include_once "config_bd_sql.php";

$row = mysql_fetch_object(mysql_query("SELECT name FROM users LIMIT rand(0, mysql_get_var(mysql_query("SELECT count(*) FROM users");)-1 ,1");;
echo $row->name;