mysql> SELECT * FROM `fb64_key` WHERE 1 LIMIT 0 , 30;
+------+------------------+
| fbid | fbkey |
+------+------------------+
| 1 | bcbe3365e6ac95ea |
+------+------------------+
1 row in set (0.00 sec)mysql>我要用PHP这样写,判断fbkey里是否包含:bcbe3365e6ac95ea,如果有的话,就算PHP输出有,并删除!如果没有,就输出错误。这代码怎么写???
+------+------------------+
| fbid | fbkey |
+------+------------------+
| 1 | bcbe3365e6ac95ea |
+------+------------------+
1 row in set (0.00 sec)mysql>我要用PHP这样写,判断fbkey里是否包含:bcbe3365e6ac95ea,如果有的话,就算PHP输出有,并删除!如果没有,就输出错误。这代码怎么写???
<?php
mysql_connect("","","");
mysql_select_db();
$query = mysql_query("select * from fb64_key where fbkey='bcbe3365e6ac95ea'") or die("查询错误");
if(isset($query)){
echo "存在bcbe3365e6ac95ea";
mysql_query("delete * from fb64_key where fbkey='bcbe3365e6ac95ea'") or die("删除不成功");
echo "已成功删除"
}else{
echo "错误,不存在bcbe3365e6ac95ea";
}
?>
用if(isset())不行啊,我试过了
$query = mysql_query($sql);
if(mysql_affected_rows() == 0){
echo '没有记录';
}else{
$sql = "DELETE FROM fb64_key WHERE fbkey=''bcbe3365e6ac95ea'";
mysql_query($sql);
}
$query = mysql_query($sql);
if(!($rows = mysql_fetch_array())){
echo '没有记录';
}else{
$sql = "DELETE FROM fb64_key WHERE fbkey=''bcbe3365e6ac95ea'";
mysql_query($sql);
}
如果是包含,则需要在查询时加入like 条件.
mysql 有个一 aff_rows 函数之类的,看影响函数来判断
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if ($row > 0){
// show
// delete
}else{
// show error
}