manusoftar

query.php

Sep 8th, 2013
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.69 KB | None | 0 0
  1. <?
  2. $tipo = $_GET['T'];
  3. $valor = $_GET['V'];
  4.  
  5.  
  6. $db = mysql_connect("smon.com.ar:3306","---","*******");
  7. mysql_select_db("smon",$db);
  8.  
  9. switch ($tipo){
  10.     case 0:
  11.             $query = mysql_query("SELECT * FROM Users WHERE Uname = '" . $valor . "';",$db);
  12.             break;
  13.     case 1:
  14.             $query = mysql_query("SELECT * FROM Users WHERE Mail = '" . $valor . "';",$db);
  15.             break;
  16.     case 2:
  17.             $query = mysql_query("SELECT Preg FROM Users WHERE Uname = '" . $valor . "';", $db);
  18.             $row = mysql_fetch_row($query);
  19.             mysql_close($db);
  20.             echo $row[0];
  21.             return;
  22.             break;
  23. }
  24.  
  25.  
  26. if (mysql_num_rows($query)!=0){
  27.     echo "0";  //El dato existe en la base de datos
  28. } else {
  29.     echo "1";
  30. }
  31. mysql_close($db);
  32.  
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment