Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. <?php
  2. if (!isset($_POST['submit'])) {
  3.   echo "Blank box.  retry";
  4. } else {
  5.   $tag = $_POST['submit'];
  6.  
  7.   $location="localhost";
  8.   $username="sj";
  9.   $password="tc6859LNf8phSMBR";
  10.   $database="sj_xbl";
  11.  
  12.   mysql_connect($location,$username,$password);
  13.   mysql_select_db($database) or die( "Unable to select database");
  14.   $qtag = mysql_real_escape_string($tag);
  15.  
  16.   $to_send = explode(" ", $qtag);
  17.   unset ($result);
  18.   foreach ($to_send as $send_item) {
  19.     $result[] = search($send_item);
  20.   }
  21.   // DEBUG: Show all matching results.
  22.   print_r($result);
  23. }
  24.  
  25.  
  26.   function search($stag) {
  27.     $query="SELECT * FROM `members` WHERE `tag` LIKE '%$stag%'";
  28.     $result=mysql_query($query);
  29.     if(!$result) {
  30.       die(mysql_error());
  31.     }
  32.     unset ($tag);
  33.     while ($row = mysql_fetch_assoc($result)) {
  34.       $tag[] = $row['tag'];
  35.     }
  36.   return $tag;
  37.   }
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement