All pastes #926018 Raw Edit

Something

public text v1 · immutable
·published 2008-03-03 14:22 UTC
rendered paste body
<?
mysql_connect(localhost,"","");
mysql_select_db("btssu") or die("Unable to select database");

function sqlesc($x) {
    return "'".mysql_real_escape_string($x)."'";
}
if ($_SERVER["REQUEST_METHOD"] == "POST"){
	if($_GET["action"]=="add"){
		$name=trim(sqlesc($_POST["name"]));
		$location=trim(sqlesc($_POST["location"]));
		$url=trim(sqlesc($_POST["url"]));
		if (!$name || !$location || !$url){
		//if ($name=="" || $location=="" || $url==""){
			print "Error, missing form data.";
		}else{
			mysql_query("INSERT INTO hosts (name, location, url) VALUES($name,  $location, $url)");
			header("location:hosts.php");
		}
	}else if($_GET["action"]=="rate"){
		$rated=$_POST['rating'];
		if($rated==0){ exit; }
		$id=$_GET["id"];
		list($rate_sum, $rate_num) = mysql_fetch_array(mysql_query("SELECT rate_sum,rate_num FROM hosts WHERE id='".mysql_real_escape_string($id)."'"));
		$rate_sum=$rate_sum+$rated;
		$rate_num++;
		mysql_query("UPDATE hosts SET rate_sum='$rate_sum', rate_num='$rate_num' WHERE id='$id'");
		header("location:hosts.php");
	}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
<link rel="shortcut icon" href="icon/favicon.ico" type="image/x-icon" />
<title>Hosts @ BTSSU.org</title>
<link href="styleLog.css" rel="stylesheet" type="text/css">
</head>
<body>
<center>
<?php
$result=mysql_query("SELECT * FROM hosts");
$hosts_num=mysql_numrows($result);

function tr($x,$y,$noesc=0) {
    if ($noesc)
        $a = $y;
    else {
        $a = htmlspecialchars($y);
        $a = str_replace("\n", "<br />\n", $a);
    }
    print("<tr><td class=\"heading\" valign=\"top\" align=\"right\">$x</td><td valign=\"top\" align=left>$a</td></tr>\n");
}

print "<center><table border=1 cellspacing=0 cellpadding=5><tr bgcolor='#BBBBBB'>
	   <td><b><u>Host</u></b></td>
	   <td><b><u>Location</u></b></td>
	   <td><b><u>URL</u></b></td>
	   <td><b><u>Rating</u></b></td></tr>";
	
	for ($i=0; $i<$hosts_num; $i++) {//For1 
		$id=mysql_result($result,$i,"id");
		$name=mysql_result($result,$i,"name");
		$location=mysql_result($result,$i,"location");
		$url=mysql_result($result,$i,"url");
		$rate_sum=mysql_result($result,$i,"rate_sum");
		$rate_num=mysql_result($result,$i,"rate_num");
		@$rating=$rate_sum/$rate_num;
		$rating=round($rating, 1);		
		print "<tr><input type='text' style='visibility:hidden' name='id' value=$id><td><a href=hostdetails.php?host_id=".$id.">$name</a></td><td>$location</td><td>$url</td><td><form method=\"post\" action=\"hosts.php?action=rate&id=".$id."\"><input type=\"hidden\" name=\"id\" value=\"".$id."\">".($rate_num==0 ? "no rating" : $rating."/5")." 
		<select name=\"rating\">
		<option value=0>(add rating)</option>
		<option value=1>1 - Sucks!</option>
  		<option value=2>2 - Pretty bad</option>
  		<option value=3>3 - Decent</option>
  		<option value=4>4 - Pretty good</option>
  		<option value=5>5 - Great!</option>
		</select><input type=submit value='Rate it!'></form></td></tr>";
		
		
	}//End For1
print "<br>";

/*print("<tr><td>Rating</td><td>
	<select name=\"rating\">
		<option value=1>1 - Sucks!</option>
  		<option value=2>2 - Pretty bad</option>
  		<option value=3>3 - Decent</option>
  		<option value=4>4 - Pretty good</option>
  		<option value=5>5 - Great!</option>
	</select>");*/

ob_start("ob_gzhandler");

	print "<br><br>";
		
	print("<table border=1 cellspacing=0 cellpadding=5>");
	print("<br>Add Host<br>");
	print("<form method=post action=hosts.php?action=add>");
	print("<tr><td class=rowhead>Name</td><td><input type=text name=name size=40></td></tr>");
	print("<tr><td class=rowhead>Location</td><td><input type=text name=location size=40></td></tr>");
	print("<tr><td class=rowhead>URL</td><td><input type=text name=url size=40></td></tr>");
	print("<tr><td colspan=2><input type=submit value='Add' class=btn></td></tr>");
	print("</form></table>");




?>
</center>
</body>
</html>