<?php
$vod_name=$_POST['vod_name'];
$vod_cid=$_POST['vod_cid'];
$vod_area=$_POST['vod_area'];
$vod_year=$_POST['vod_year'];
$vod_actor=$_POST['vod_actor'];
$vod_continu=$_POST['vod_continu'];
$vod_pic=$_POST['vod_pic'];
$vod_play=$_POST['vod_play'];
$vod_url=$_POST['vod_url'];
$vod_language=$_POST['vod_language'];
$vod_content=$_POST['vod_content'];
$vod_server=$_POST['vod_server'];
$vod_director=$_POST['vod_director'];
$vod_letter=$_POST['vod_letter'];
$vod_addtime = strtotime($_POST['vod_addtime']);
$conn=mysql_connect('localhost','root','') or die('连接失败');
mysql_select_db('ppvod',$conn) or die('选择数据库失败');
$s_sql="select vod_name from ff_vod where vod_name='".$vod_name."'";
$s_result=mysql_query($s_sql);
$s_row=mysql_fetch_array($s_result);
if($s_row){
$update_sql="update ff_vod set vod_year='".$vod_year."',vod_actor='".$vod_actor."' WHERE vod_name='".$vod_name."'";
$update_result=mysql_query($update_sql);
echo $update_result;
if(mysql_affected_rows($conn)!=0)
echo "修改".$vod_name."成功";
else
echo "修改".$vod_name."失败";
}
else
{
$insert_sql="insert into ff_vod(vod_cid,vod_name,vod_actor) values(".$vod_cid.",".$vod_name.",".$vod_actor.")";
$insert_result=mysql_query($insert_sql) or die('添加失败');
if(mysql_affected_rows($conn)!=0)
echo "添加".$vod_name."成功";
}
echo mysql_error();
?>
$vod_name=$_POST['vod_name'];
$vod_cid=$_POST['vod_cid'];
$vod_area=$_POST['vod_area'];
$vod_year=$_POST['vod_year'];
$vod_actor=$_POST['vod_actor'];
$vod_continu=$_POST['vod_continu'];
$vod_pic=$_POST['vod_pic'];
$vod_play=$_POST['vod_play'];
$vod_url=$_POST['vod_url'];
$vod_language=$_POST['vod_language'];
$vod_content=$_POST['vod_content'];
$vod_server=$_POST['vod_server'];
$vod_director=$_POST['vod_director'];
$vod_letter=$_POST['vod_letter'];
$vod_addtime = strtotime($_POST['vod_addtime']);
$conn=mysql_connect('localhost','root','') or die('连接失败');
mysql_select_db('ppvod',$conn) or die('选择数据库失败');
$s_sql="select vod_name from ff_vod where vod_name='".$vod_name."'";
$s_result=mysql_query($s_sql);
$s_row=mysql_fetch_array($s_result);
if($s_row){
$update_sql="update ff_vod set vod_year='".$vod_year."',vod_actor='".$vod_actor."' WHERE vod_name='".$vod_name."'";
$update_result=mysql_query($update_sql);
echo $update_result;
if(mysql_affected_rows($conn)!=0)
echo "修改".$vod_name."成功";
else
echo "修改".$vod_name."失败";
}
else
{
$insert_sql="insert into ff_vod(vod_cid,vod_name,vod_actor) values(".$vod_cid.",".$vod_name.",".$vod_actor.")";
$insert_result=mysql_query($insert_sql) or die('添加失败');
if(mysql_affected_rows($conn)!=0)
echo "添加".$vod_name."成功";
}
echo mysql_error();
?>
解决方案 »
- 学好web开发必备那些知识了
- 在myeclipse中,页面切换一直出现提示框
- 查询语句包含中文时就查不到结果,求指点
- PHP句点连接符
- 什么情况下用通用ADODB类?
- 购买凌风的php版本指数算法
- 有一个网站,里面的图片每点一次打开的地址不一样,请问用php能获得它每次定向的地址吗?
- 介绍个好的OA系统给我吧!
- 请教各位大虾在php中怎么读取javascript中的变量
- 极度郁闷啊!!php mysql服务器的困惑
- Notice: Use of undefined constant charset - assumed 'charset' in on line 9
- 如何用php给另一个php文件里写html标签
$update_result=mysql_query($update_sql) or die(mysql_error());
运行后浏览器中看到了什么
你最后的 echo mysql_error(); 难道没有告诉你点什么?