xihong

摘要：$sql= "select * from t_datestudy where id='4750' and agreemode='2' and school_agree !='1'"; $result = mysql_query($sql,$connection); $app = mysql_fetc 阅读全文

摘要：使用公共连接文件形式 include_once 'inc/conni.php'; $result = mysqli_query($conni, "call proc_test()"); while( $row = mysqli_fetch_array($result) ){ var_dump($ro 阅读全文

摘要：$viewPages = 0; $db = new mysqli('localhost',$MYSQL_USER,$MYSQL_PASS,$MYSQL_DB); if (!mysqli_connect_errno()){ $sql = "call proc_getrelativeviewids('2 阅读全文

摘要：1连接数据库. <!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->//pro 阅读全文

摘要：BEGIN DECLARE orderNo varchar(100) DEFAULT null; select order_no into orderNo from t_orderpay where order_no=p2 and step='2'; if orderNo <>'' and left 阅读全文

摘要：DELIMITER $$CREATE TRIGGER trg_synccomsuminfo AFTER UPDATE ON t_orderpay FOR EACH ROW BEGIN IF OLD.step != NEW.step THEN call proc_paysync(NEW.order_n 阅读全文

摘要：BEGIN DECLARE t_error INTEGER DEFAULT 0; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1; START TRANSACTION; #这边放sql语句,涉及到的表必须都为InnoDB IF t_er 阅读全文