<?php
require_once("DB.php"); // Using PEAR::DB because it supports alot more stuff than the mysql api supplied with PHP
$result = "";
$db =& DB::connect("mysqli://$DB_USER:$DB_PASS@$DB_SERVER/$DB_USE");
if(DB::isError($db)) {
$result = "Cannot connect to database server.";
}else if (isset($_POST['query']) && strlen($_POST['query']) > 0) {
$sth = $db->query($_POST['query']);
if(DB::isError($db)) {
$result = "Query error";
}else {
$result = "Query completed";
}
$sth->free();
$db->disconnect();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyAdmin RIVAL</title>
</head>
<body>
<?php if (strlen($result)) { echo "<h3>$result</h3>"; } ?>
<form action="rival.php" method="post">
<input name="query" type="text" value="<?php echo $_POST['query']; ?>" />
<input type="submit" />
</form>
</body>
</html>
