query.php

<?
include("../php/sqlconn.php");

$tipo = $_GET['T'];
$valor = $_GET['V'];



//$start_time = microtime(TRUE);
//$db = mysqli_connect("","manusoftar","77503462");
//$end_time = microtime(TRUE);
//mysqli_select_db("smon",$db);



switch ($tipo){
    case 0:
            $query = new PreparedQuery("SELECT Count(*) AS 'Num' FROM Users WHERE Uname = :name");
            $query->select(array('name' => $valor));


            //$query = mysqli_query("SELECT Count(*) AS 'Num' FROM Users WHERE Uname = '" . $valor . "';",$db);

            break;
    case 1:
            $query = new PreparedQuery("SELECT Count(*) AS 'Num' FROM Users WHERE Mail = :mail");
            $query->select(array('mail' => $valor));

//          $query = mysqli_query("SELECT Count(*) AS 'Num' FROM Users WHERE Mail = '" . $valor . "';",$db);
            break;
    case 2:
            $query = new PreparedQuery("SELECT Preg FROM Users WHERE Uname = :name");
            $query->select(array('name' => $valor));
//          $query = mysqli_query("SELECT Preg FROM Users WHERE Uname = '" . $valor . "';", $db);
            $row = $query->fetch_all();
//          mysqli_close($db);
            echo $row[0];
            return;
            break;
}

//echo '<p>' . number_format(($end_time-$start_time) * 1000,2) . 'ms</p>';

if ($query->fetch_row()){
    //var_dump($query->row['Num']);
    if ($query->row['Num']!=0){
        echo "0";  //El dato existe en la base de datos
    } else {
        echo "1";
    }
}
//mysqli_close($db);


?>