Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- session_start();
- if(!session_is_registered(myusername)){
- header("location:index.php");
- }
- ?>
- <html>
- <head>
- <link rel="stylesheet" type="text/css" href="style.css" />
- <title>
- [R.I.P] - Astro/Player Database - Database
- </title>
- <div id="banner">
- <img src="graphics/banner.jpeg" alt="banner"/>
- </div>
- <script language="javascript">
- var state = 'hidden';
- function showhide(layer_ref) {
- if (state == 'visible') {
- state = 'hidden';
- }
- else {
- state = 'visible';
- }
- if (document.all) { //IS IE 4 or 5 (or 6 beta)
- eval( "document.all." + layer_ref + ".style.visibility = state");
- }
- if (document.layers) { //IS NETSCAPE 4 or below
- document.layers[layer_ref].visibility = state;
- }
- if (document.getElementById && !document.all) {
- maxwell_smart = document.getElementById(layer_ref);
- maxwell_smart.style.visibility = state;
- }
- }
- //-->
- </script>
- </head>
- <body>
- <br>
- <br>
- <br>
- <div id="nav" align="left">
- <ul>
- <li><a href="/AE/Home.php">Home</a></li>
- <br>
- <li><a href="/AE/Members.php">Members</a></li>
- <br>
- <li><a href="/AE/Profile.php">Profile</a></li>
- <br>
- <li><a href="/AE/Contact.php">Contact</a></li>
- </ul>
- </div>
- <div id="click" align="right">
- <a href="javascript://" onclick="showhide('insert')">Click</a> To Add Member! </div>
- <div id="insert" align="right" style="visibility:hidden;">
- <b>Insert Player Here!</b>
- <form action="insert.php" method="post">
- ID <input type="text" name="ID" />
- <br>
- Name <input type="text" name="Name" />
- <br>
- Guild <input type="text" name="Guild" />
- <br>
- Location <input type="text" name="Location" />
- <br>
- <input type="submit" value="Add to Database" />
- </form>
- </div>
- <div id="Search" div style="position: absolute; top: 350px; right: 530px;">
-                         <b>Input Guild/ID or Player Name.</b>
- <form name="search" method="post" action="<?php $_SERVER[PHP_SELF]?>">
- Seach for: <input type="text" name="find" /> in
- <Select NAME="field">
- <Option VALUE="Name">Name</option>
- <Option VALUE="Guild">Guild</option>
- <Option VALUE="ID">ID</option>
- </Select>
- <input type="hidden" name="searching" value="yes" />
- <input type="submit" name="search" value="Search" />
- </form>
- <?php
- $searching = $_POST['searching'];
- $find = $_POST['find'];
- $field = $_POST['field'];
- if ($searching =="yes"){
- echo "<h3>Search Results</h3><p>";
- if ($find == ""){
- echo "<p>Please Enter a search term";
- exit;
- }
- mysql_connect("localhost", "AE", "") or die(mysql_error());
- mysql_select_db("ae") or die(mysql_error());
- $find = strtoupper($find);
- $find = strip_tags($find);
- $find = trim ($find);
- $query = mysql_query("SELECT * FROM astros WHERE upper($find) LIKE'%$find%'");
- while($result = mysql_fetch_array($query)){
- echo $result['ID'];
- echo " ";
- echo $result['Guild'];
- echo "<br>";
- echo $result['Name'];
- echo "<br>";
- echo "<br>";
- }
- $matches=mysql_num_rows($query);
- if ($matches == 0){
- echo "Sorry, we can not find an entry to match your query<br><br>";
- }
- echo "<b>Searched For:</b> " .$find;
- }
- ?>
- </form>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement