mysql 自定义函数怎么用
create function `strip_tags`($str text) returns text begin declare $start, $end int default 1; loop set $start = locate("<", $str, $start); if (!$start) then return $str; end if; set $end = locate(">", $str, $start); if (!$end) then set $end = $start; end if; set $str = insert($str, $start, $end - $start + 1, ""); end loop; end;
select strip_tag('<p>aaa</p>')update tbl_name set html=strip_tag(html)
select strip_tag('<p>aaa</p>')update tbl_name set html=strip_tag(html)
CREATE FUNCTION `strip_tags`($str text) RETURNS text BEGIN DECLARE $start, $end INT DEFAULT 1; LOOP SET $start = LOCATE("<", $str, $start); IF (!$start) THEN RETURN $str; END IF; SET $end = LOCATE(">", $str, $start); IF (!$end) THEN SET $end = $start; END IF; SET $str = INSERT($str, $start, $end - $start + 1, ""); END LOOP; END; 不会错的，我刚刚测试了你的指令
你最好写到程序里
$sql =<<< 'SQL'CREATE FUNCTION `strip_tags`($str text) RETURNS text BEGIN DECLARE $start, $end INT DEFAULT 1; LOOP SET $start = LOCATE("<", $str, $start); IF (!$start) THEN RETURN $str; END IF; SET $end = LOCATE(">", $str, $start); IF (!$end) THEN SET $end = $start; END IF; SET $str = INSERT($str, $start, $end - $start + 1, ""); END LOOP; END;SQL;mysql_query($sql) or die(mysql_error());mysql_connect();mysql_select_db('test');$sql =<<< 'SQL'CREATE FUNCTION `strip_tags`($str text) RETURNS text BEGIN DECLARE $start, $end INT DEFAULT 1; LOOP SET $start = LOCATE("<", $str, $start); IF (!$start) THEN RETURN $str; END IF; SET $end = LOCATE(">", $str, $start); IF (!$end) THEN SET $end = $start; END IF; SET $str = INSERT($str, $start, $end - $start + 1, ""); END LOOP; END;SQL;//mysql_query($sql) or die(mysql_error());$rs = mysql_query("select strip_tags('ab')");print_r(mysql_fetch_row($rs));Array( [0] => ab)
select strip_tag('<p>aaa</p>')update tbl_name set html=strip_tag(html)
永久，直到你删去他
永久，直到你删去他
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE FUNCTION `strip_tags`($str text) RETURNS text BEGIN DECLARE $start,' at line 2
$sql =<<< 'SQL'DROP FUNCTION IF EXISTS `strip_tags`CREATE FUNCTION `strip_tags`($str text) RETURNS textBEGIN DECLARE $start, $end INT DEFAULT 1; LOOP SET $start = LOCATE("<", $str, $start); IF (!$start) THEN RETURN $str; END IF; SET $end = LOCATE(">", $str, $start); IF (!$end) THEN SET $end = $start; END IF; SET $str = INSERT($str, $start, $end - $start + 1, ""); END LOOP;END;SQL; 按理说后面要加一个分号的
DROP FUNCTION IF EXISTS `strip_tags`;
但是mysql_query 只能执行一条sql语句，所以它把整个语句当成一条sql语句了，当成一条sql显然是不对的。
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
275
收藏
