if(!mysql_connect("localhost","root",""))
{
echo ""."db Connect error"."
";
die();
}
mysql_select_db("cdcol");
?>
DB SIMPLE Connect
| |
title |
name |
year |
status |
|
if($_REQUEST['interpret']!="")
{
if($jahr=="")$jahr="NULL";
$titel=htmlentities($_REQUEST['titel']);
$interpret=htmlentities($_REQUEST['interpret']);
$jahr=htmlentities($_REQUEST['jahr']);
mysql_query("INSERT INTO cds (titel,interpret,jahr) VALUES('$titel','$interpret',$jahr);");
}
if($_REQUEST['action']=="del")
{
mysql_query("DELETE FROM cds WHERE id={$_REQUEST['id']};");
}
$result=mysql_query("SELECT id,titel,interpret,jahr FROM cds ORDER BY interpret;");
$i=0;
while( $row=mysql_fetch_array($result) )
{
if($i>0)
{
echo "";
echo " | ";
echo "
";
}
echo "";
echo "| | ";
echo "".$row['interpret']." | ";
echo "".$row['titel']." | ";
echo "".$row['jahr']." | ";
echo "OK | ";
echo " | ";
echo "
";
$i++;
}
echo "";
echo " | ";
echo "
";
?>