performlab/admin.php at master · shafanator/performlab · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN"
   "http://www.w3.org/TR/html4/strict.dtd">
<!--
	To Do List/ Ideas
		load document for authentication
			DB username
			DB password
			location
		data input(separate page)
		make css from website
-->
<?php
define("ROOT",dirname("..").'/');

// Load config file
$_DB = array();
$_VAR = array();
require_once('config.inc.php');

$host=$_DB['host'];
$username=$_DB['user']; // Mysql username
$password=$_DB['pass'];; // Mysql password
$db_name=$_DB['database']; // Database name*/
$tbl_name="prod_info"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY id DESC";
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);
?>
<html lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<title>index</title>
	<meta name="generator" content="TextMate http://macromates.com/">
	<meta name="author" content="Michael Shafran">
	<link rel="stylesheet" type="text/css" href="style.css" />
	<!-- Date: 2012-07-02 -->
</head>
<body>
	<div id="wrapper">
		<div id="header"></div>
		<div id ="sidebar">
			<a href="input.php">Input New Entry</a>
			<a href="admin.php">Admin</a>
			<a href="input.php">Display</a>
		</div>
		<div id="content">
				<p>
					The current Location is "<?php echo $_COOKIE["location"]; ?>"
				<p>
					Would you like to change it?
				<form name="new_cookie" method="post" action="new_cookie.php">
				<table class= 'entry' width="100%" border="0" cellpadding="3" cellspacing="1">
					<tr>
						<td><strong>Location</strong></td>
						<td><input name="loc" type="text" id="loc" size="52" value= "<?php echo $_COOKIE["location"]; ?>"></td>
					</tr>
						<td><input type="submit" name="Submit" value="Submit"></td>
					</tr>
				</table>
				</form>

		</div>
	</div>
</body>
</html>