锐客网

  1. 首页 > 睿知 > it技术 > >

php执行数据库执行语句 php执行函数

IT技术执行

如何利用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
php中执行mysql语句？不可以！如果你的表有5个字段 而你是只要插入两个字段！其他不要插的的要用default（默认）代替！
关于php操作mysql执行数据库查询的一些常用操作汇总php操作mysql步骤：
1.$connect=mysql_connect('localhost','root','123456')
or
die('数据库连接失败 。'mysql_error());链接mysql 。
2.mysql_select_db('database',$connect)选择链接的数据库 。
3.mysql_query('Set
names
gb2312');$sql
=
"select
*
from
blog_article";准备要查询的数据 。
4.$datas
=
mysql_query($sql);执行sql查询 。

推荐阅读


上一篇：华为荣耀60系统升级鸿蒙，华为荣耀6x升级鸿蒙系统

下一篇：linux操作命令考试题，linux操作题库