<?php
//方法:删除数据库数据
function Deleted ( $userid ) {
require( "common.inc" );
//首先连接数据库
$this->connectdb ( ); //去空格,然后进行类型转换
$userid = trim ( $userid ); //新增
if ( is_integer( $userid ) )
{
//从数据库删除记录
$this->result = mysql_db_query( $DB , "delete from $DB_NAME where id=" . $uesrid . ";" );
//出错处理
if ( !$this->result ) {
$this->err_no = mysql_errno ( );
$this->err_text = mysql_error ( );
echo ( "<br><br>数据删除错误<br><br><hr><br>\n" . "错误号 :" . $this->err_no . "<br><br>\n" . "错误原因 : " . $this->err_text . "<br>\n" );
return false;
} else {
return true;
}
}
//新增
else {
echo 'userid参数错误';
}
}
?>
//方法:删除数据库数据
function Deleted ( $userid ) {
require( "common.inc" );
//首先连接数据库
$this->connectdb ( ); //去空格,然后进行类型转换
$userid = trim ( $userid ); //新增
if ( is_integer( $userid ) )
{
//从数据库删除记录
$this->result = mysql_db_query( $DB , "delete from $DB_NAME where id=" . $uesrid . ";" );
//出错处理
if ( !$this->result ) {
$this->err_no = mysql_errno ( );
$this->err_text = mysql_error ( );
echo ( "<br><br>数据删除错误<br><br><hr><br>\n" . "错误号 :" . $this->err_no . "<br><br>\n" . "错误原因 : " . $this->err_text . "<br>\n" );
return false;
} else {
return true;
}
}
//新增
else {
echo 'userid参数错误';
}
}
?>
$this->result = mysql_db_query( $DB , "delete from $DB_NAME where id=" . $uesrid 很明显$userid;和$uesrid 不同,参数错误!
require( "common.inc" );
//首先连接数据库
$this->connectdb ( ); //去空格,然后进行类型转换
$userid = trim ( $userid );
if($userid = ( int )$userid){ //从数据库删除记录
$this->result = mysql_db_query( $DB , "delete from $DB_NAME where id=" . $uesrid . ";" );
//出错处理
if ( !$this->result ) {
$this->err_no = mysql_errno ( );
$this->err_text = mysql_error ( );
echo ( "<br><br>数据删除错误<br><br><hr><br>\n" . "错误号 :" . $this->err_no . "<br><br>\n" . "错误原因 : " . $this->err_text . "<br>\n" );
return false;
} else{
return true;
}
}
else{
$this->err_text="不合理的参数";
return false;
}
}
require( "common.inc" );
//首先连接数据库
$this->connectdb ( ); //去空格,然后进行类型转换
$userid = trim ( $userid );
if($userid = ( int )$userid){ //从数据库删除记录
$this->result = mysql_db_query( $DB , "delete from $DB_NAME where id=" . $userid . ";" );
//出错处理
if ( !$this->result ) {
$this->err_no = mysql_errno ( );
$this->err_text = mysql_error ( );
echo ( "<br><br>数据删除错误<br><br><hr><br>\n" . "错误号 :" . $this->err_no . "<br><br>\n" . "错误原因 : " . $this->err_text . "<br>\n" );
return false;
} else{
return true;
}
}
else{
$this->err_text="不合理的参数";
return false;
}
}
变成:
$sql="delte from $DN_NAME where id=".$userid;echo $sql;
如果sql语句在查询分析器里面没有问题,再来看代码。