php如何取sql,php取地址符

本文目錄一覽：

• 1、php怎麼獲取上一條執行的sql語句
• 2、PHP如何取得mysql字段值並記算時間？
• 3、如何利用PHP執行.SQL文件

php怎麼獲取上一條執行的sql語句

原生代碼不支持獲取上一次執行的

sql語句

，ThinkPHP用getLastSql()函數獲取的，代碼如下：

class UserModel extends Model(BaseModel){

public function test($data){

$model = M(‘user’);

$model-add($data);

$sql = $model-getLastSql();

} TP還有一種種方法就是直接用_sql，這個更方便！

1.

$model-_sql();方法實際執行的就是

2.

$model-getLastSql();用_sql注意中文

亂碼

問題，相來說還是getlastsql比較快，_有時候會因為中文編碼出錯

至於大小寫的問題根本不存在

php不區分這些大小寫的。

PHP如何取得mysql字段值並記算時間？

兩種方式 ：

1、可以直接用SQL 里的函數 sum() ;

如：”select sum(字段) as num from tab “; //sum 取該字段所有列的總和

2、用PHP函數 sum($array) ； //取數組中值的總和

當然 字段必須是int型的

如何利用PHP執行.SQL文件

本篇文章是對使用PHP執行 SQL文件的實現代碼進行了詳細的分析介紹 需要的朋友參考下  

demo php:

複製代碼 代碼如下: ?php /** * 讀取 sql 文件並寫入數據庫 * @version demo php */ class DBManager {     var $dbHost = ;     var $dbUser = ;     var $dbPassword = ;     var $dbSchema = ;     function __construct($host $user $password $schema)     {         $this dbHost = $host;         $this dbUser = $user;         $this dbPassword = $password;         $this dbSchema = $schema;     }     function createFromFile($sqlPath $delimiter = (;/n)|((;/r/n))|(;/r) $prefix = $menter = array( # ))     {         //判斷文件是否存在         if(!file_exists($sqlPath))             return false;         $handle = fopen($sqlPath rb );           $sqlStr = fread($handle filesize($sqlPath));         //通過sql語法的語句分割符進行分割         $segment = explode(“;” trim($sqlStr));         //var_dump($segment);         //去掉注釋和多餘的空行         foreach($segment as $statement)         {             $sentence = explode(“/n” $statement);             $newStatement = array();             foreach($sentence as $subSentence)             {                 if( != trim($subSentence))                 {                     //判斷是會否是注釋                     $isComment = false;                     foreach($menter as $er)                     {                         if(eregi(“^(” $er “)” trim($subSentence)))                         {                             $isComment = true;                             break;                         }                     }                     //如果不是注釋 則認為是sql語句                     if(!$isComment)                         $newStatement[] = $subSentence;                                   }             }             $statement = $newStatement;         }         //對錶名加前綴         if( != $prefix)         {                    //只有表名在第一行出現時才有效 例如 CREATE TABLE talbeName             $regxTable = “^[/`/ /”]{ }[/_a zA Z]+[/_a zA Z ]*[/`/ /”]{ }$”;//處理表名的正則表達式             $regxLeftWall = “^[/`/ /”]{ }”;             $sqlFlagTree = array(                     “CREATE” = array(                             “TABLE” = array(                                     “$regxTable” =                                 )                         )                     “INSERT” = array(                             “INTO” = array(                                 “$regxTable” =                             )                         )                     );             foreach($segment as $statement)             {                 $tokens = split(” ” $statement[ ]);                 $tableName = array();                 $this findTableName($sqlFlagTree $tokens $tableName);                 if(empty($tableName[ leftWall ]))                 {                     $newTableName = $prefix $tableName[ name ];                 }                 else{                     $newTableName = $tableName[ leftWall ] $prefix substr($tableName[ name ] );                 }                 $statement[ ] = str_replace($tableName[ name ] $newTableName $statement[ ]);             }         }               //組合sql語句         foreach($segment as $statement)         {             $newStmt = ;             foreach($statement as $sentence)             {                 $newStmt = $newStmt trim($sentence) “/n”;             }             $statement = $newStmt;         }         //用於測試                //var_dump($segment);         //writeArrayToFile( data txt $segment);         //         self::saveByQuery($segment);         return true;     }     private function saveByQuery($sqlArray)     {         $conn = mysql_connect($this dbHost $this dbUser $this dbPassword);         mysql_select_db($this dbSchema);         foreach($sqlArray as $sql)         {             mysql_query($sql);         }               mysql_close($conn);     }     private function findTableName($sqlFlagTree $tokens $tokensKey= $tableName = array())     {         $regxLeftWall = “^[/`/ /”]{ }”;         if(count($tokens)=$tokensKey)             return false;               if( == trim($tokens[$tokensKey]))         {             return self::findTableName($sqlFlagTree $tokens $tokensKey+ $tableName);         }         else         {             foreach($sqlFlagTree as $flag = $v)             {                   if(eregi($flag $tokens[$tokensKey]))                 {                     if( ==$v)                     {                         $tableName[ name ] = $tokens[$tokensKey];                         if(eregi($regxLeftWall $tableName[ name ]))                         {                             $tableName[ leftWall ] = $tableName[ name ]{ };                         }                         return true;                     }                     else{                         return self::findTableName($v $tokens $tokensKey+ $tableName);                     }                 }             }         }         return false;     } } function writeArrayToFile($fileName $dataArray $delimiter=”/r/n”) {     $handle=fopen($fileName “wb”);     $text = ;     foreach($dataArray as $data)     {         $text = $text $data $delimiter;     }     fwrite($handle $text); } //測試 $dbM = new DBManager( localhost w f test ); $dbM createFromFile( data sql null fff_ ); ? lishixinzhi/Article/program/PHP/201311/21281