PHP pdo 事务回滚代码实例

$this->beginTransaction();
$this->exec('update people set age=2');

//$step1 = mysql教程_error();//你的类里，改成如果执行sql错误，获取错误代码，相应的函数

代码如下	复制代码
$this->exec('INSERT INTO course (course,num) VALUES ("数学",100)'); //$step2 = mysql_error(); if (!$step1 && !$step2) {  $this->commit(); } else {  $this->rollBack(); }

<?php教程
//定义一个数组，用于存放排重后的结果
$result = array();
//读取uid列表文件
$fp = fopen('test.txt', 'r');

while(!feof($fp))
{
$uid = fgets($fp);
$uid = trim($uid);
$uid = trim($uid, " ");
$uid = trim($uid, " ");

if($uid == '')
{
continue;
}
//以uid为key去看该值是否存在
if(empty($result[$uid]))
{
$result[$uid] = 1;
}
}

fclose($fp);

//将结果保存到文件
$content = '';
foreach($result as $k => $v)
{
$content .= $k." ";
}
$fp = fopen('result.txt', 'w');
fwrite($fp, $content);
fclose($fp);
?>　　

<?php
//定义数组，用于存放排重后的结果
$result = array();
//读取第一个uid列表文件，放入$result_1
$fp = fopen('test_1.txt', 'r');
while(!feof($fp))
{
$uid = fgets($fp);
$uid = trim($uid);
$uid = trim($uid, " ");
$uid = trim($uid, " ");
if($uid == '')
{
continue;
}
//以uid为key写入$result，如有重复就会覆盖
$result[$uid] = 1;
}
fclose($fp);
//读取第二个uid列表文件，并进行排重操作
$fp = fopen('test_2.txt', 'r');
while(!feof($fp))
{
$uid = fgets($fp);
$uid = trim($uid);
$uid = trim($uid, " ");
$uid = trim($uid, " ");
if($uid == '')
{
continue;
}
//以uid为key去看该值是否存在
if(empty($result[$uid]))
{
$result[$uid] = 1;
}
}
fclose($fp);
//$result里保存的就排重以后的结果，可以输出到文件，代码省略
?>

代码如下

复制代码

$conn=ADONewConnection('odbc_mssql'); $conn->PConnect("Driver={SQL Server};Server=DLUT-PCSQLEXPRESS;Database=yuyan;",'zhouhao','950288'); $ADODB_FETCH_MODE=ADODB_FETCH_ASSOC; $sqlstr='select * from yuyan where ps教程nNo=?'; $rst=$conn->execute($sqlstr,'005') or die('connect error'); while(!$rst->EOF) { //echo $rst->fields['psnName'].'->'.$rst->fields['www.111cn.net'].''; echo 'dajiahao'; $rst->movenext(); } $rst->close(); $conn->close();

代码如下	复制代码
DELIMITER $$ CREATE DEFINER=`root`@`localhost` FUNCTION `UF_Get_tMaxCode`(   V_iType INT ) RETURNS varchar(10) CHARSET utf8 BEGIN /* 业务描述：根据编码类别产生编码 输入参数： V_iType:编码类别，定义建tMaxCode的iType字段的定义 调用示例： SELECT UF_Get_tMaxCode(1); 创建日期： 创建人： */ DECLARE iCode INT; IF V_iType IN (1,3)

THEN
#非订单类
IF EXISTS (SELECT dtLast FROM tMaxCode WHERE iType=V_iType LIMIT 0,1)
THEN 
SELECT IFNULL(iMax,0)+1 INTO iCode FROM tMaxCode WHERE iType=V_iType;
ELSE
SET iCode=1;
END IF;
SELECT IFNULL(iMax,0)+1 INTO iCode FROM tMaxCode WHERE iType=V_iType;
ELSE
#订单类
IF EXISTS (SELECT iMax FROM tMaxCode WHERE iType=V_iType AND DATEDIFF(dtLast,CURRENT_DATE)=0 LIMIT 0,1)
THEN 
#上次生成时间是当天
  SELECT IFNULL(iMax,0)+1 INTO iCode FROM tMaxCode WHERE iType=V_iType;
ELSE
SET iCode=1;
END IF;
END IF;

代码如下	复制代码
$objPHPExcel->setActiveSheetIndex(0)   ->setCellValue('A1', iconv('gbk', 'utf-8', '中文Hello'))   ->setCellValue('B2', 'world!')   ->setCellValue('C1', 'Hello')   ->setCellValue('D2', 'world!');

//用php 用自带转码函数iconv转换一下就OK了。