<?php
$dbhost = '10.176.235.54';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'db';

$c = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');

mysql_select_db($dbname);


switch($_GET['action'])
{
  case "search":
  search();
  break;

  case "show":
  show();
  break;

  default:
  index();
  break;
}

function search() {
global $c;
$name=mysql_real_escape_string($_POST['name']);

if(!isset($name) || empty($name)) { die("You cant search for nothing 0.o"); }

$q=mysql_query("SELECT * FROM will WHERE tNAME='{$name}' ORDER BY tID DESC",$c) or die(mysql_error());

if(mysql_num_rows($q) == 0) { echo "No match :["; }
else {
echo "Which one are you?<br><br>";
while($r=mysql_fetch_array($q)) {
echo "> <a href=william.php?action=show&XID={$r['tID']}>{$r['tNAME']}</a><br>";
}
}
}

function show() {
global $c;
$id=(int) abs($_GET['XID']);
if(!isset($id) || ($id == 0)) { die("ID cant be 0 -.-"); }
$q=mysql_query("SELECT * FROM will WHERE tID={$id}",$c) or die(mysql_error());
if(mysql_num_rows($q) > 1) { die("This should never happen..."); }
$r=mysql_fetch_array($q);
echo "Name: {$r['tNAME']} Value: {$r['tVALUE']}<br>";
} //function end


function index() {
echo "
<form action=william.php?action=search method=post>
Name: <input type=text name=name>
<br><input type=submit value=Search>";
}
?>