All pastes #97003 Raw Edit

Unnamed

public php v1 · immutable
#97003 ·published 2006-07-23 09:37 UTC
rendered paste body
//already connected & selected database//If cmd has not been initializedif(!isset($cmd)) {   $result = mysql_query("select * from webpages order by id");       while($r=mysql_fetch_array($result))    {       $pagedesciption=$r["pagedesciption"];      $keywords=$r["keywords"];      $pagebody=$r["pagebody"];      $pagename=$r["pagename"];      $id=$r["id"];           echo "$pagename - <a href='edit.php?cmd=edit&id=$id'>Edit</a>";      echo "<br>";    }}if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit"){   if (!isset($_POST["submit"]))   {      $id = $_GET["id"];      $sql = "SELECT * FROM webpages WHERE id=$id";      $result = mysql_query($sql);              $myrow = mysql_fetch_array($result);      echo "<form action=save.php method=post>";      echo "<input type=hidden name=id value=$myrow[$id]>";      echo "Page Name:";      echo "<INPUT TYPE=TEXT NAME=title VALUE=$myrow[pagename] SIZE=30><br>";      echo "Keywords:";      echo "<INPUT TYPE=TEXT NAME=keywords VALUE=$myrow[keywords] SIZE=30><br>";      echo "Description:";      echo "<INPUT TYPE=TEXT NAME=pagedesciption VALUE=$myrow[pagedesciption] SIZE=30><br>";      echo "Page Body:";      echo "<TEXTAREA NAME=pagebody ROWS=10 COLS=30>$myrow[pagebody]</TEXTAREA><br>";      echo "<input type=hidden name=cmd value=edit>";      echo "<input type=submit name=submit value=submit>";      echo "</form>";   }}////////////save.php////////////   if ($_POST["$submit"])   {      $pagename = $_POST["pagename"];	  $pagedesciption= $_POST["pagedesciption"]; 	  $pagebody = $_POST["pagebody"];	  $keywords = $_POST["keywords"];	  	        $sql = "UPDATE webpages SET pagename='$pagename',pagedesciption='$pagedesciption',pagebody='$pagebody',keywords='$keywords', WHERE id=$id";      $result = mysql_query($sql);	}	include("edit.php");