建站
咨詢
售后
建站咨詢
新聞中心
如何利用PHP執(zhí)行.SQL文件
本篇文章是對使用PHP執(zhí)行 SQL文件的實現(xiàn)代碼進行了詳細的分析介紹 需要的朋友參考下 ?
公司主營業(yè)務：網(wǎng)站建設、網(wǎng)站制作、移動網(wǎng)站開發(fā)等業(yè)務。幫助企業(yè)客戶真正實現(xiàn)互聯(lián)網(wǎng)宣傳，提高企業(yè)的競爭能力。創(chuàng)新互聯(lián)是一支青春激揚、勤奮敬業(yè)、活力青春激揚、勤奮敬業(yè)、活力澎湃、和諧高效的團隊。公司秉承以“開放、自由、嚴謹、自律”為核心的企業(yè)文化，感謝他們對我們的高要求，感謝他們從不同領域給我們帶來的挑戰(zhàn)，讓我們激情的團隊有機會用頭腦與智慧不斷的給客戶帶來驚喜。創(chuàng)新互聯(lián)推出京山免費做網(wǎng)站回饋大家。
demo php:
復制代碼 代碼如下: ?php /** * 讀取 sql 文件并寫入數(shù)據(jù)庫 * @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) ??????? { ?????? ??????????? //只有表名在第一行出現(xiàn)時才有效 例如 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
php 如何把一條sql語句寫入數(shù)據(jù)庫
?php
$dbhost = 'localhost:3306'; // mysql服務器主機地址
$dbuser = 'root'; // mysql用戶名
$dbpass = '123456'; // mysql用戶名密碼
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn ){
die('連接失敗: ' . mysqli_error($conn))
;}
echo '連接成功br /'; // 設置編碼，防止中文亂碼mysqli_query($conn , "set names utf8");
$runoob_title = '學習 Python';
$runoob_author = 'RUNOOB.COM';
$submission_date = '2016-03-06';
$sql = "INSERT INTO runoob_tbl ".
"(runoob_title,runoob_author, submission_date) ".
"VALUES ".
"('$runoob_title','$runoob_author','$submission_date')";
mysqli_select_db( $conn, 'RUNOOB' );$retval = mysqli_query( $conn, $sql );
if(! $retval ){
die('無法插入數(shù)據(jù): ' . mysqli_error($conn))
;}
echo "數(shù)據(jù)插入成功\n";
mysqli_close($conn);
?
按照步驟開始，多看PHP手冊。
php中使用sql語句寫入數(shù)據(jù)，怎樣在$_POST['ID']插入一個變量
改成{$_POST['Region'.$jc]},
原先的{$_POST['Region".$jc."']}，{}里的“”是相對獨立的，不合外面的“”配對，也就是說“”就是單引號包含的一串字符串中的字符，所以，顯而易見的PHP不會對".$jc."做concat處理，只是作為一串字符。
當前標題：phpsql寫入數(shù)據(jù) php數(shù)據(jù)庫寫入
URL網(wǎng)址：http://fisionsoft.com.cn/article/dddjsji.html
