【php开源代码栏目提醒】:网学会员为广大网友收集整理了,addmusica1.php,希望对大家有所帮助!
<?
include 'open.php';
$str="select * from musica where mu_no='".$mu_no."';";
$result=mysql_query($str,$link);
$num=mysql_num_rows($result);
if ($num!=1)
{
$str="insert into musica values('".$mu_no."','".$mu_name."','".$mu_singer."','".$mu_yr."');";
$result=
mysql_query($str,$link);
$str1="insert into musicb values('".$mu_no."','".$mu_name."','".$mu_singer."','".$song_erone."','".$mu_yr."','".$song_yr1."');";
$result1=my
sql_query($str1,$link);
header("Location:seemusica1.php");
}
else
{
echo "<form action='addmusica.php' method='post'><br>";
echo "此曲号重复,请重新输入!!";
echo "<input type ='submit' value ='请重新登录'>";
echo "</form>";
}
mysql_close($link);
?>