php 日期时间运算比较
摘要：$sql= "select * from t_datestudy where id='4750' and agreemode='2' and school_agree !='1'"; $result = mysql_query($sql,$connection); $app = mysql_fetc
阅读全文
posted @ 2016-05-31 10:11
05 2016 档案
php执行多个存储过程（二）
摘要：使用公共连接文件形式 include_once 'inc/conni.php'; $result = mysqli_query($conni, "call proc_test()"); while( $row = mysqli_fetch_array($result) ){ var_dump($ro
阅读全文
posted @ 2016-05-25 16:22
php执行多个存储过程
摘要：$viewPages = 0; $db = new mysqli('localhost',$MYSQL_USER,$MYSQL_PASS,$MYSQL_DB); if (!mysqli_connect_errno()){ $sql = "call proc_getrelativeviewids('2
阅读全文
posted @ 2016-05-25 16:12
PHP MysqlI操作数据库(转)
摘要：1连接数据库. <!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->//pro
阅读全文
posted @ 2016-05-24 22:07
mysql存储过程
摘要：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
阅读全文
posted @ 2016-05-17 17:32
mysql触发器
摘要：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
阅读全文
posted @ 2016-05-17 17:23
mysql 存储过程 事务处理 （转）
摘要：BEGIN DECLARE t_error INTEGER DEFAULT 0; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1; START TRANSACTION; #这边放sql语句,涉及到的表必须都为InnoDB IF t_er
阅读全文
posted @ 2016-05-17 09:41
