add.php

这是php专业项目实例开发一书的源代码,希望对大家有所帮助!

<?php
$host="";
$database="books";
$dbusername="root";
$dbpassword="";

$x=mysql_connect($host,$dbusername,$dbpassword);
$x1=mysql_select_db($database);

if ($type=="category")
{
  echo"<table align=\"center\" border=1>";
  echo"<tr><td>Parent Category </td><td>".$parentcategory."</td></tr>";
  echo"<tr><td>Name </td><td>".$catname."</td></tr>";
  echo"<tr><td>Description </td><td>".$catdescription."</td></tr>";
  echo"</table><br><br>";
  
  $query="select categoryid from category where categoryid='".$parentcategory."'";
  $result=mysql_query($query);
  if($row=mysql_fetch_array($result))
  {
    $query2="INSERT into category VALUES('','".$parentcategory."','".$catname."','".$catdescription."')";
    $result2=mysql_query($query2);
//    echo "Category added as <b>".$query."</b>\n";
  } 
  else
  {
   echo "Parentcategory Does Not EXIST !!!";
  }
}
elseif($type=="product")
{

  echo"<table align=\"center\" border=1>";
  echo"<tr><td>Product Category </td><td>".$parentcategory."</td></tr>";
  echo"<tr><td>Name </td><td>".$proname."</td></tr>";
  echo"<tr><td>Author </td><td>".$proauthor."</td></tr>";
  echo"<tr><td>Description </td><td>".$prodescription."</td></tr>";
  echo"<tr><td>Price </td><td>".$proprice."</td></tr>";
  echo"</table><br><br>";

$query="INSERT into products VALUES('','".$proname."','".$proauthor."','".$prodescription."','".$proprice."','".$parentcategory."')";
$result=mysql_query($query);
//echo "Product added as<b> ".$query."</b>\n";
}
else
{
 echo "type should be product/catgory. But it was ".$type. " !!!";
}

?>
<br>
To return to the Admin page <A href="index.htm">click here</a>