国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

? ??? ?? PHP ???? PHP PDO ?????? ?? ??? ??? ??

PHP PDO ?????? ?? ??? ??? ??

Jul 25, 2016 am 08:51 AM

  3. /**

  4. * ?????? PDO ??
  5. */
  6. class MysqlPdo {
  7. public static $PDOStatement = null;
  8. /**
  9. * ?????? ?? ???? ??
  10. * @var array
  11. * @access public
  12. */
  13. public static $config = array();
  14. /**
  15. * ?? ?? ?? ??
  16. * @var bool
  17. * @access public
  18. */
  19. public static $pconnect = false;
  20. /**
  21. * ?? ???
  22. * @var string
  23. * @access public
  24. */
  25. public static $error = '';
  26. /**
  27. * ??? ??, Pdo ???? ??? ????? ??????? ?? ???? ?????.
  28. * @var object
  29. * @access public
  30. */
  31. protected static $link;
  32. /**
  33. * ?????? ?? ??
  34. * @var bool
  35. * @access public
  36. */
  37. public static $connected = false;
  38. /**
  39. * ?????? ??
  40. * @var string
  41. * @access public
  42. */
  43. public static $dbVersion = null;
  44. /**
  45. * ?? SQL ?
  46. * @var string
  47. * @access public
  48. */
  49. public static $queryStr = ' ';
  50. /**
  51. * ????? ??? ???? ID
  52. * @var ??
  53. * @access public
  54. */
  55. public static $lastInsertId = null;
  56. /**
  57. * ??? ?? ??? ?? ?????.
  58. * @var ??
  59. * @access public
  60. */
  61. public static $numRows = 0;
  62. // ???? ??? ?
  63. public static $transTimes = 0;
  64. /**
  65. * ???,
  66. * @param $dbconfig ?????? ?? ?? ??, array('ServerName', 'UserName', 'Password', 'DefaultDb', 'DB_Port', 'DB_TYPE')
  67. */
  68. ?? ?? __construct($dbConfig=''){
  69. if (!class_exists('PDO') ) self::throw_Exception("???? ??: PDO");
  70. //????? ???? ??? ?? ??? ??? ?????
  71. if (!is_array($dbConfig)) {
  72. $dbConfig = ??(
  73. '??? ??' => DB_HOST,
  74. '??? ??' => DB_USER,
  75. '????' => DB_PWD,
  76. '??????' => DB_NAME,
  77. '??? ??' => ; DB_PORT,
  78. 'dbms' => DB_TYPE,
  79. 'dsn' => DB_TYPE.":host=".DB_HOST.";dbname=".DB_NAME
  80. );
  81. }
  82. if(empty($dbConfig['hostname'])) self::throw_Exception("?????? ??? ???? ??");
  83. self::$config = $dbConfig;
  84. if(empty( self:: $config['params'])) self::$config['params'] = array();
  85. /**************************************?? ???************ *******************************/
  86. if (!isset(self::$ link) ) {
  87. $configs = self::$config;
  88. if(self::$pconnect) {
  89. $configs['params'][constant('PDO::ATTR_PERSISTENT')] = true;
  90. }
  91. {
  92. self::$link = new PDO( $configs['dsn'], $configs['username'], $configs['password'],$configs[ 'params' ?? ]);
  93. } catch (PDOException $e) {
  94. self::throw_Exception($e->getMessage());
  95. }
  96. if(!self::$link ) {
  97. self::throw_Exception('PDO ?? ??');
  98. false ??;
  99. }
  100. self::$link->exec('SET NAMES '.DB_CHARSET);
  101. self: :$dbVersion = self::$link->getAttribute(constant("PDO::ATTR_SERVER_INFO"));
  102. // ??? ????? ??
  103. self::$connected = true;
  104. // ?????? ?? ?? ?? ?? ??
  105. unset($configs);
  106. }
  107. return self::$link;
  108. }
  109. /**
  110. * ?? ?? ??
  111. * @access ??
  112. */
  113. ?? ?? ?? () {
  114. self::$PDOStatement = null;
  115. }
  116. /************************/
  117. /* ?????? ??*/
  118. /************************/
  119. /**
  120. * ?? ?? ??? ????
  121. * @access ??
  122. * @return ??
  123. */
  124. ?? ?? getAll($sql=null) {
  125. if($sql != null)
  126. {
  127. self::query($sql) ;
  128. }
  129. //??? ?? ??
  130. $result = self::$PDOStatement->fetchAll(constant('PDO::FETCH_ASSOC'));
  131. return $result;
  132. }
  133. /**
  134. * ?? ?? ????
  135. * @access ??
  136. * @param string $sql SQL ??
  137. * @param ?? $seek ??? ??
  138. * @return ??
  139. */
  140. ?? ?? getRow($sql=null) {
  141. if($sql != null)
  142. {
  143. self::query($sql ) ;
  144. }
  145. // ?? ?? ??
  146. $result = self::$PDOStatement->fetch(constant('PDO::FETCH_ASSOC'),constant('PDO::FETCH_ORI_NEXT')) ;
  147. return $result;
  148. }
  149. /**
  150. * SQL ?? ???? ?? ?? ?? ??? ???? ??
  151. * @access ??
  152. * @param string $sql SQL ??
  153. * @return ??
  154. */
  155. ?? ?? doSql($sql='') {
  156. if(self::isMainIps($sql) ) {
  157. return self::execute($sql);
  158. }else {
  159. return self::getAll($sql);
  160. }
  161. }
  162. /**
  163. * ??? ID? ???? ???? ??? ??(?? ??? ???? ??)
  164. * @access ??
  165. * @param ?? $priId ?? ? ID
  166. * @param string $tables ??? ??? ??
  167. * @param string $fields ?? ??
  168. * @return ArrayObject ??? ???
  169. */
  170. ?? ?? findById($tabName,$priId,$fields='*'){
  171. $sql = 'SELECT %s FROM %s WHERE id=%d';
  172. self ??: : getRow(sprintf($sql, self::parseFields($fields), $tabName, $priId));
  173. }
  174. /**
  175. * 尋找記錄
  176. * @access function
  177. * @param string $tables 資料表名
  178. * @param mixed $where 查詢條件
  179. * @param string $fields 欄位名稱
  180. * @param string $order 排序
  181. * @param string $limit 取多少條資料
  182. * @param string $group 分組
  183. * @param string $having
  184. * @param boolean $lock 是否加鎖
  185. * @return ArrayObject
  186. */
  187. 靜態(tài)函數(shù) find($tables,$where="",$fields='*',$order=null,$limit=null,$group=null,$ having=null) {
  188. $sql = 'SELECT '.self::parseFields($fields)
  189. .' FROM '.$tables
  190. .self::parseWhere($where)
  191. .self::parseGroup($group)
  192. .self::parseHaving($having)
  193. .self::parseOrder( $order)
  194. .self::parseLimit($limit);
  195. $dataAll = self::getAll($sql);
  196. if(count($dataAll)==1){$rlt=$ dataAll[0];}else{$rlt=$dataAll;}
  197. return $rlt;
  198. }
  199. /**
  200. * 插入（單一）記錄
  201. * @access function
  202. * @param mixed $data 資料
  203. * @param string $table 資料表名
  204. * @return false | integer
  205. */
  206. function add($data,$table) {
  207. //過濾提交資料
  208. $data=self::filterPost($table,$data);
  209. foreach ($data as $key=>$val){
  210. if(is_array( $ val) && strtolower($val[0]) == 'exp') {
  211. $val = $val[1]; // 使用表達(dá)式 ???
  212. }elseif (is_scalar($val)){
  213. $val = self::fieldFormat($val);
  214. }else{
  215. //刪除複合物件
  216. 繼續(xù);
  217. }
  218. $data[$key] = $val;
  219. }
  220. $fields = array_keys($data);
  221. array_walk($fields, array($this, 'addSpecialChar'));
  222. $fieldsStr = implode(',', $fields);
  223. $values = array_values($data);
  224. $valuesStr = implode(',', $values);
  225. $sql = '插入'.$table.' ('.$fieldsStr.') VALUES ('.$valuesStr.')';
  226. return self::execute($sql);
  227. }
  228. /**
  229. * 更新記錄
  230. * @access function
  231. * @param mixed $sets 資料
  232. * @param string $table 資料表名
  233. * @param string $where 更新條件
  234. * @param string $limit
  235. * @param string $order
  236. * @return false | integer
  237. */
  238. 靜態(tài)函數(shù)update($sets,$table,$where,$limit=0,$order='') {
  239. $sets = self::filterPost($table,$sets);
  240. $sql = '更新「.$表」。 self::execute($sql );
  241. }
  242. /**
  243. * 儲存某個欄位的值
  244. * @access function
  245. * @param string $field 要儲存的欄位名稱
  246. * @param string $value 欄位值
  247. * @param string $ table 資料表
  248. * @param string $where 儲存條件
  249. * @param boolean $asString 欄位值是否為字串
  250. * @return void
  251. */
  252. 靜態(tài)函式setField($field, $value, $table, $condition="", $asString=false ) {
  253. //如果有'(' 視為SQL 指令更新否則更新欄位內(nèi)容為純字串
  254. if(false === strpos($value,'(') || $asString) $value = '"'.$value .'"';
  255. $sql = '更新'.$table.' SET '.$field.'='.$value.self::parseWhere($condition);
  256. 回傳self::execute( $sql);
  257. }
  258. /**
  259. * 刪除記錄
  260. * @access function
  261. * @param mixed $where 為條件Map、Array或String
  262. * @param string $table 資料表名
  263. * @param string $limit
  264. * @param string $order
  265. * @return false | integer
  266. */靜態(tài)函式($where,$table,$limit='',$order='' ) {
  267. $sql = 'DELETE FROM '.$table.self::parseWhere($where).self::parseOrder($order).self::parseLimit($limit);
  268. 回傳self::執(zhí)行($sql);
  269. }
  270. /**
  271. ----------------------------------------------- -----------
  272. * 修改或儲存資料(僅用於單表操作)
  273. * 有主鍵ID則為修改，無主鍵ID則為增加
  274. * 修改記錄：
  275. ---------------------------------------------- ------------
  276. * @access function
  277. ---------------------------- ------------------------------
  278. * @param $tabName 表名
  279. * @param $aPost 提交表單的$_POST
  280. * @param $priId 主鍵ID
  281. * @param $aNot 要排除的一個字段或數(shù)組
  282. * @param $aCustom 自訂的數(shù)組，附加到資料庫中保存
  283. * @param $isExits 是否已經(jīng)存在存在：true, 不存在：false
  284. ------------------------------- ---------------------------
  285. * @return Boolean 修改或儲存是否成功
  286. -------- --------------------------------------------------
  287. */
  288. 函數(shù)saveOrUpdate($tabName, $aPost, $priId="", $aNot="", $aCustom="" , $isExits=false) {
  289. if(empty($tabName) || !is_array($aPost) || is_int($aNot)) return false;
  290. if(is_string($aNot) && !empty($aNot)) $aNot = array($aNot);
  291. if(is_array($aNot) && is_int(key ) ($aNot))) $aPost = array_diff_key($aPost, array_flip($aNot));
  292. if(is_array($aCustom) ) && is_string(key($aCustom))) $aPost = array_merge($aCustom))) $aPost = array_merge($aCustom))) $aPost = aPostge($aPost , $aCustom);
  293. if (empty($priId) && !$isExits) { // 新增
  294. $aPost = array_filter ($aPost, array($this, 'removeEmpty'));
  295. return self::add($aPost, $tabName);
  296. }else { //修改
  297. return self::update($aPost, $tabName, "id=".$priId);
  298. }
  299. }
  300. /**
  301. * ?? ??? sql ? ????
  302. * @access ??
  303. * @param
  304. * @return String ??? SQL
  305. */
  306. ?? ?? getLastSql() {
  307. $link = self::$link;
  308. if ( !$link ) return false;
  309. return self::$queryStr;
  310. }
  311. /* *
  312. * ????? ??? ID ????
  313. * @access ??
  314. * @param
  315. * @return ?? ????? ??? ??? ID
  316. */
  317. ?? ?? getLastInsId(){
  318. $link = self::$link;
  319. if ( !$link ) return false;
  320. return self::$lastInsertId;
  321. }
  322. /**
  323. * DB ?? ????
  324. * @access ??
  325. * @param
  326. * @return ???
  327. */
  328. ?? ?? getDbVersion(){
  329. $link = self::$link;
  330. if ( !$link ) return false;
  331. return self::$dbVersion;
  332. }
  333. /**
  334. * ?????? ??? ?? ????
  335. * @access ??
  336. * @return ??
  337. */
  338. ?? ?? getTables() {
  339. $info = array();
  340. if(self::query ("??? ??")) {
  341. $result = self::getAll();
  342. foreach ($result as $key => $val) {
  343. $info[$key] = current( $val);
  344. }
  345. }
  346. return $info;
  347. }
  348. /**
  349. * ??? ???? ?? ?? ????
  350. * @access ??
  351. * @return ??
  352. */
  353. ?? ?? getFields($tableName) {
  354. //獲取數(shù)據(jù)庫聯(lián)接
  355. $link = self::$link;
  356. $sql = "SELECT
  357. ORDINAL_POSITION ,COLUMN_NAME, COLUMN_TYPE, DATA_TYPE,
  358. IF(ISNULL(CHARACTER_MAXIMUM_LENGTH), (NUMERIC_PRECISION NUMERIC_SCALE ), CHARACTER_MAXIMUM_LENGTH ) AS MAXCHAR,
  359. IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY, EXTRA, COLUMN_COMMENT
  360. FROM
  361. INFORMATION_SCHEMA.COLUMNS
  362. WHERE
  363. TABLE_NAME = :tabName AND TABLE_SCHEMA='".DB_NAME."'";
  364. self::$queryStr = sprintf($sql, $tableName);
  365. $sth = $link->prepare($sql);
  366. $sth->bindParam(':tabName', $ tableName);
  367. $sth->execute();
  368. $result = $sth->fetchAll(constant('PDO::FETCH_ASSOC'));
  369. $info = array();
  370. foreach($result as $key => $val) {
  371. $info[$val['COLUMN_NAME']] = array(
  372. '??' => $val['ORDINAL_POSITION'],
  373. '??' => $val[ 'COLUMN_NAME'],
  374. '??' => $val['COLUMN_TYPE'],
  375. 'd_type' => $val['DATA_TYPE'],
  376. '??' => ['MAXCHAR'],
  377. 'notnull' => (strtolower($val['IS_NULLABLE']) == "???"),
  378. 'default' => $val['COLUMN_DEFAULT'],
  379. '??' => (strtolower($val['COLUMN_KEY']) == '??'),
  380. 'autoInc' => (strtolower($val['EXTRA']) == ' auto_increment'),
  381. 'comment' => $val['COLUMN_COMMENT']
  382. );
  383. }
  384. // 有錯誤則拋take異常
  385. self::haveErrorThrowException();
  386. $info ??;
  387. }
  388. /**
  389. * ?????? ??
  390. * @access ??
  391. */
  392. ?? ?? close() {
  393. self::$link = null;
  394. }
  395. / **
  396. * SQL ?? ?? ???
  397. * @access ??
  398. * @param string $str SQL ??
  399. * @return string
  400. */
  401. ?? ?? escape_string($str) {
  402. return addedlashes($str);
  403. }
  404. /************************/
  405. /* 內(nèi)part操? ?? */
  406. /************************/
  407. /**
  408. * ??? ???? ??? ?????
  409. * @access ??
  410. * @return
  411. */
  412. static function haveErrorThrowException() {
  413. $obj =empty(self::$PDOStatement) ? self::$link : self::$PDOStatement;
  414. $arrError = $obj->errorInfo();
  415. if($arrError[0] !== '00000') { // 有錯誤信息
  416. self::$error = $arrError[0]."|".$arrError[2]. "
    [ SQL ] : ".self::$queryStr."
    ";
  417. self::throw_Exception(self::$error);
  418. false? ??;
  419. }
  420. //主要針對execute()???拋出異常
  421. if(self::$queryStr=='')self::throw_Exception('??? ?? ?????

    [ SQL語句 ] :');
  422. }
  423. /**
  424. * where ??
  425. * @access ??
  426. * @param $where ?? ?? ??
  427. * @return ???
  428. */
  429. ?? ?? ?? ??($where) {
  430. $whereStr = '';
  431. if( is_string($where) || is_null($where)) {
  432. $whereStr = $where;
  433. }
  434. ? ? ??($whereStr)?'':' WHERE '.$whereStr;
  435. }
  436. /**
  437. * order ??
  438. * @access function
  439. * @param mixed $order ??
  440. * @return string
  441. */
  442. ?? ?? parseOrder($order) {
  443. $orderStr = '';
  444. if(is_array($order))
  445. $orderStr .= ' ORDER BY '.implode(',', $order);
  446. else if(is_string($order) && !empty($order))
  447. $orderStr .= ' ORDER BY '.$order;
  448. return $orderStr;
  449. }
  450. /**
  451. * ????
  452. * @access ??
  453. * @param string $limit
  454. * @return string
  455. */
  456. ?? ?? parseLimit($limit) {
  457. $limitStr = '';
  458. if(is_array($limit) )) {
  459. if(count($limit)>1)
  460. $limitStr .= ' LIMIT '.$limit[0].' , '.$limit[1].' ';
  461. else
  462. $limitStr .= ' LIMIT '.$limit[0].' ';
  463. } else if(is_string($limit) && !empty($limit)) {
  464. $limitStr .= ' LIMIT '.$limit.' ';
  465. }
  466. $limitStr ??
  467. }
  468. /**
  469. * ?? ??
  470. * @access ??
  471. * @param ?? $group
  472. * @return ???
  473. */
  474. ?? ?? parseGroup($group) {
  475. $groupStr = '';
  476. if(is_array($group))
  477. $groupStr .= ' GROUP BY '.implode(',', $group);
  478. else if(is_string($group) && !empty($group))
  479. $groupStr .= ' GROUP BY '.$group;
  480. empty($groupStr)?'':$groupStr;
  481. }
  482. /**
  483. * have分析
  484. * @access ??
  485. * @param string $having
  486. * @return string
  487. */
  488. ?? ??parseHaving($having) {
  489. $havingStr = '';
  490. if(is_string($having) && !empty($having))
  491. $havingStr .= ' HAVING '.$having;
  492. return $havingStr;
  493. }
  494. /**
  495. * ?? ??
  496. * @access ??
  497. * @param ?? $??
  498. * @return ???
  499. */
  500. function parseFields($fields) {
  501. if(is_array($fields)) {
  502. array_walk($fields, array($this, 'addSpecialChar'));
  503. $fieldsStr = implode(',', $fields);
  504. }else if(is_string($fields) && !empty($fields)) {
  505. if( false === strpos($fields,'`') ) {
  506. $fields =explode(',',$fields);
  507. array_walk($fields, array($this, 'addSpecialChar'));
  508. $fieldsStr = implode(',', $fields );
  509. }else {
  510. $fieldsStr = $fields;
  511. }
  512. }else $fieldsStr = '*';
  513. return $fieldsStr;
  514. }
  515. /**
  516. * ??? ???? ? ???? ?? ??
  517. * @access ??
  518. * @param ?? $? ??
  519. * @return ???
  520. */
  521. ??? ?? parseSets($sets) {
  522. $setsStr = '';
  523. if(is_array($sets)){
  524. foreach ($sets as $key=> $val){
  525. $key = self::addSpecialChar($key);
  526. $val = self::fieldFormat($val);
  527. $setsStr .= "$key = ".$val. ",";
  528. }
  529. $setsStr = substr($setsStr,0,-1);
  530. }else if(is_string($sets)) {
  531. $setsStr = $sets;
  532. }
  533. return $setsStr;
  534. }
  535. /**
  536. * ?? ?? ??
  537. * @access ??
  538. * @param ?? $value
  539. * @return ??
  540. */
  541. ?? ?? fieldFormat(&$value) {
  542. if(is_int($value)) {
  543. $value = intval($value);
  544. } else if(is_float($value)) {
  545. $value = floatval($value);
  546. } elseif(preg_match('/^(w* ( |-|*|/)?w*)$/i',$value)){
  547. // 支持在字段的值里face直接使用其它字段
  548. // 例如 (?? 1) (??)必須包含括號
  549. $value = $value;
  550. }else if(is_string($value)) {
  551. $value = '''.self::escape_string($value).''';
  552. }
  553. return $value;
  554. }
  555. /**
  556. *
  557. ? ?? ?? ? ??? ??? ` ??* ??? ??? ???? mysql? ?? ???? ??
  558. * @access ??
  559. * @param ?? $?
  560. * @return ??
  561. */
  562. ?? ?? addSpecialChar(&$value) {
  563. if( '*' == $value | | false !== strpos($value,'(') || false !== strpos($value,'.') || false !== strpos($value,'`')) {
  564. //如果包含* 或者 使用了sql方法 則不?處理
  565. } elseif(false === strpos($value,'`') ) {
  566. $value = '`'.trim($value).'` ';
  567. }
  568. return $value;
  569. }
  570. /**
  571. ---------------------------------- ----------
  572. * ? ?? ??
  573. ------------- ---- ------------
  574. * @access ??
  575. ---------- ----- ----------------
  576. * @param ?? $ ?
  577. ---------------------------- ----- -------------
  578. * @return ??
  579. ---------- ---- -----------------
  580. */
  581. ?? ?? RemoveEmpty($value){
  582. return !empty($value);
  583. }
  584. /**
  585. * ?? SELECT, SHOW ? ?? ??? ?? ?? ??
  586. * @access ??
  587. * @param string $sql sql ??
  588. * @return ??
  589. */
  590. ?? ?? ??($sql='') {
  591. // 獲取數(shù)據(jù)庫聯(lián)接
  592. $link = self::$link;
  593. if ( !$link ) return false;
  594. self::$queryStr = $sql;
  595. //釋放前次的查詢結(jié)果
  596. if ( !empty(self::$PDOStatement) ) self ::free();
  597. self::$PDOStatement = $link->prepare(self::$queryStr);
  598. $bol = self::$PDOStatement->execute();
  599. // 有錯誤則拋 Out異常
  600. self::haveErrorThrowException();
  601. return $bol;
  602. }
  603. /**
  604. * ?????? ?? ??
  605. * @access ??
  606. * @param string $sql ???
  607. * @param boolean $lock ?? ??(???? ?? ?? ??)
  608. * @return void
  609. ?? ?? ??($sql='',$lock=false) {
  610. if(empty($sql)) $sql = $this->queryStr
  611. return $this->_execute; ($SQL)
  612. }*/
  613. /**
  614. * INSERT, UPDATE, DELETE ???
  615. * @access ??
  616. * @param string $sql sql ??
  617. * @return ??
  618. * /
  619. ?? ?? ??($sql='') {
  620. // 獲取數(shù)據(jù)庫聯(lián)接
  621. $link = self::$link;
  622. if ( !$link ) return false;
  623. self::$queryStr = $sql;
  624. //釋放前次的查詢結(jié)果
  625. if ( !empty(self::$PDOStatement) ) self::free();
  626. $result = $link ->exec(self::$queryStr);
  627. // ?? false;
  628. } else {
  629. self::$numRows = $result;
  630. self::$lastInsertId = $link->lastInsertId();
  631. return self::$numRows;
  632. }
  633. }
  634. /**
  635. * ?????? ?? ???? ??
  636. * @access private
  637. * @param string $query SQL ??
  638. * @return boolen ?? ??? ?? false ??
  639. */
  640. ?? ?? isMainIps($query) {
  641. $queryIps = 'INSERT|UPDATE|DELETE|REPLACE|CREATE|DROP|LOAD DATA|SELECT .* INTO|COPY |ALTER|GRANT|REVOKE|LOCK|UNLOCK';
  642. if (preg_match('/^s*"?(' . $queryIps . ')s /i', $query)) {
  643. true? ?????.
  644. }
  645. false ??;
  646. }
  647. /**
  648. * POST ?? ??? ???
  649. * @access private
  650. * @param ?? $data POST ?? ???
  651. * @param string $table ??? ??? ??
  652. * @return ?? $newdata
  653. */
  654. ?? ?? filterPost($table,$data) {
  655. $table_column = self::getFields( $table);
  656. $newdata=array();
  657. foreach($table_column as $key=>$val){
  658. if(array_key_exists($key,$data) && ($data[$ ?])!==''){
  659. $newdata[$key] = $data[$key];
  660. }
  661. }
  662. return $newdata;
  663. }
  664. / **
  665. * ?? ??
  666. * @access ??
  667. * @return void
  668. */
  669. ?? ?? startTrans() {
  670. //數(shù)據(jù)rollback 支持
  671. $link = self::$link;
  672. if ( !$link ) return false;
  673. if (self::$transTimes == 0) {
  674. $link->beginTransaction();
  675. }
  676. self::$transTimes ;
  677. return ;
  678. }
  679. /**
  680. * ??? ?? ???? ?? ??? ?????.
  681. * @access ??
  682. * @return boolen
  683. */
  684. ?? ?? ??() {
  685. $link = self::$link;
  686. if ( !$link ) return false;
  687. if (self::$ transTimes > 0) {
  688. $result = $link->commit();
  689. self::$transTimes = 0;
  690. if(!$result){
  691. self::throw_Exception( self::$error());
  692. false ??;
  693. }
  694. }
  695. true ??;
  696. }
  697. /**
  698. * ???? ??
  699. * @access ??
  700. * @return bolen
  701. */
  702. ?? ?? ?? () {
  703. $link = self::$link;
  704. if ( !$link ) return false;
  705. if (self::$transTimes > 0) {
  706. $result = $link->rollback();
  707. self::$transTimes = 0;
  708. if(!$result){
  709. self::throw_Exception(self:: $error());
  710. false ??;
  711. }
  712. }
  713. true ??;
  714. }

  715. /**

  716. * ?? ??
  717. * @access ??
  718. * @return void
  719. */
  720. ?? ?? throw_Exception($err){
  721. echo '
    ??:'.$err.'
    ';
  722. }
  723. }

復(fù)代碼


? ????? ??
? ?? ??? ????? ???? ??? ??????, ???? ?????? ????. ? ???? ?? ???? ?? ??? ?? ????. ???? ??? ???? ???? ??? ?? admin@php.cn?? ?????.

? AI ??

Undresser.AI Undress

Undresser.AI Undress

???? ?? ??? ??? ?? AI ?? ?

AI Clothes Remover

AI Clothes Remover

???? ?? ???? ??? AI ?????.

Video Face Swap

Video Face Swap

??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!

???

??? ??

???++7.3.1

???++7.3.1

???? ?? ?? ?? ???

SublimeText3 ??? ??

SublimeText3 ??? ??

??? ??, ???? ?? ????.

???? 13.0.1 ???

???? 13.0.1 ???

??? PHP ?? ?? ??

???? CS6

???? CS6

??? ? ?? ??

SublimeText3 Mac ??

SublimeText3 Mac ??

? ??? ?? ?? ?????(SublimeText3)

???

??? ??

?? ????
1747
16
Cakephp ????
1600
56
??? ????
1542
28
PHP ????
1400
31
???
PHP ?? API ????? ?? ??? ?????? PHP ?? API ????? ?? ??? ?????? Jun 14, 2025 am 12:27 AM

ToversionAphp ??, forclarityandeasofrouting, ac

PHP?? ?? ? ??? ????? ????????? PHP?? ?? ? ??? ????? ????????? Jun 20, 2025 am 01:03 AM

TOSECURELYHANDLEAUSTENCENDACTIONANDACTERIZINGINPHP, FORCUCTSESTEPS : 1. ALWAYSHASHPASSWORTHPASSWORD_HASH () ? VERVERIFYUSINGPANSWORD_VERIFY (), usePREPAREDSTATEMENTSTOPREVENTSQLINGERGED, andSTOREUSERSESSEATAIN $ _SESSIONSAFTERLOGIN.2.impleplempletrole ?? ACCESSC

PHP? ?? ?? (??)? ???? ?? ?? ? ? ????? PHP? ?? ?? (??)? ???? ?? ?? ? ? ????? Jun 14, 2025 am 12:25 AM

phpdoesnothaveAbuilt-inweakMapButofferSweakReference.1.WeakReenceAllowsholdingReferences withoutpreventinggarbageCollection.2.ItusteForCaching, Eventlisteners, andMetAdataWithoutAftingObjectLifeCycles.3.youcoucococococococcinccing

PHP? ?? ? ?? ?? ????? ????? ???? ?????? PHP? ?? ? ?? ?? ????? ????? ???? ?????? Jun 14, 2025 am 12:25 AM

ProceduralAndObject-OrientedProgramming (OOP) InphpDiffersiMINTIFINTIONTERINGLISTURE, ??? ? ? DATAHANDLING

PHP?? ?? ???? ??? ??? ?? ? ? ??????? PHP?? ?? ???? ??? ??? ?? ? ? ??????? Jun 19, 2025 am 01:05 AM

PHP?? ?? ???? ???? ????? ??? ?? ??? ???? ?? ??? ??? ??? ???? ????. 1. finfo_file ()? ???? ?? ?? ??? ???? ???/jpeg? ?? ?? ?? ? ?????. 2. uniqid ()? ???? ??? ?? ??? ???? ? Web ?? ????? ??????. 3. php.ini ? html ??? ?? ?? ??? ???? ???? ??? 0755? ?????. 4. Clamav? ???? ???? ???? ??? ??????. ??? ??? ?? ???? ????? ???? ?? ??? ????? ???? ??? ? ??? ?????.

PHP?? == (??? ??)? === (??? ??)? ???? ?????? PHP?? == (??? ??)? === (??? ??)? ???? ?????? Jun 19, 2025 am 01:07 AM

PHP?? ==? ==? ?? ???? ?? ??? ??????. == ?? ??? ?? ?? ?????. ?? ??, 5 == "5"? true? ????, ?? ??? ???? ?? ?? ??? ????? ????? (? : 5 === "5"? false? ?????. ?? ?????? ===? ? ???? ?? ?????? == ?? ??? ??? ???? ?????.

PHP? NOSQL ?????? (? : MongoDB, Redis)? ??? ?? ??? ? ????? PHP? NOSQL ?????? (? : MongoDB, Redis)? ??? ?? ??? ? ????? Jun 19, 2025 am 01:07 AM

?, PHP? ?? ?? ?? ?????? ?? MongoDB ? Redis? ?? NOSQL ??????? ?? ??? ? ????. ?? MongoDBPHP ???? (PECL ?? Composer? ?? ??)? ???? ????? ????? ??? ?????? ? ???? ????? ??, ??, ?? ? ?? ??? ?????. ??, Predis ????? ?? Phpredis ??? ???? Redis? ???? ?? ? ?? ? ??? ???? ??? ????? Phpredis? ???? ?? Predis? ?? ??? ?????. ? ? ?? ??? ???? ? ????? ????.

php (, -, *, /, %)?? ?? ??? ??? ?????? php (, -, *, /, %)?? ?? ??? ??? ?????? Jun 19, 2025 pm 05:13 PM

PHP?? ?? ??? ??? ???? ??? ??? ????. 1. ?? ??? ?? ? ?? ??? ??? ???? ???? ??? ? ????. ??? ??? ???? ????? ????? ???? ????. 2. ?? ?? ?? - ??, ??? ???? ?? ??? ?????. 3. ?? ???? ??? ??? ???? ??? ??? ?????. 4. Division? / ??? ???? 0?? ??? ?? ????? ??? ?? ??? ?? ? ? ????. 5. ???? ??? ???? ?? ?? ? ?? ??? ???? ? ??? ? ???, ??? ?? ? ? ??? ??? ???? ?????. ? ???? ???? ???? ??? ??? ??? ???? ?? ??? ? ??????? ????.

See all articles