《读取 sql 文件并写入数据库》.docVIP

/*** 读取 sql 文件并写入数据库 * @version 1.01 demo.php 2008/08/21* @author xingshaocheng xingshaocheng@*/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 = ,$commenter = 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($commenter as $comer)??? ??? ??? ??? ??? {??? ??? ??? ??? ??? ??? if(eregi(^(.$comer.),trim($subSentence)))??? ??? ??? ??? ??? ??? {??? ??? ??? ??? ??? ??? ??? $isComment = true;??? ??? ??? ??? ??? ??? ??? break;??? ??? ??? ??? ??? ??? }??? ??? ??? ??? ??? }??? ??? ??? ??? ??? //如果不是注释，则认为是sql语句??? ??? ??? ??? ??? if(!$isComment)??? ??? ??? ??? ??? ??? $newStatement[] = $subSentence;??? ??? ??? ??? ??? ??? ??? ??? ??? }??? ??? ??? }??? ??? ??? ??? ??? ??? $statement = $newStatement;??? ??? }??? ??? //对表名加前缀??? ??? if( != $prefix)??? ??? {??? ??? ??? ??? ??? ??? ??? ??? //只有表名在第一行出现时才有效 例如 CREATE TABLE talbeName??? ??? ??? ??? $regxTable = ^[\`\\]{0,1}[\_a-zA-Z]+[\_a-zA-Z0-9]*[\`\\]{0,1}$;//处理表名的正则表达式??? ??? ?