[PHP] 纯文本查看 复制代码
<?php
header("Content-type: text/html;charset=utf-8");
require_once("dbfuncs.php");
$link = create_connection();
$sql = "UPDATE `pw_topiccate` SET `ifdel` = 0 WHERE `name` REGEXP '美食.*'";
$result = execute_sql("pw87", $sql, $link);
echo "执行UPDATE语句时共有 " . mysql_affected_rows($link) . " 条记录受影响";
mysql_close($link);
?>
[PHP] 纯文本查看 复制代码
<?php
function create_connection()
{
$link = mysql_connect("localhost", "root", "woaiguaiguai")
or die("Can not connect to database<br><br>" . mysql_error());
mysql_query("SET NAMES utf8");
return $link;
}
function execute_sql($database, $sql, $link)
{
$db_selected = mysql_select_db($database, $link)
or die("Select database failed<br><br>" . mysql_error($link));
$result = mysql_query($sql, $link);
return $result;
}
?>