简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)
Home > Backend Development > PHP Tutorial > body text

php mysql数据库导入脚本(示例)

WBOY
Release： 2016-07-25 08:55:09
Original
944 people have browsed it
  3. //php实现mysql数据导入
  4. define("DbHost", "localhost"); //数据库主机
  5. define("DbUser", "root"); //数据库用户
  6. define("DbPass", "password"); //数据库口令
  7. mysql_connect(DbHost,DbUser,DbPass) or die("不能连接服务器!");
  8. mysql_create_db("dbname") or die("不能建立数据库,可能您已经安装过了");
  9. mysql_select_db("dbname") or die("不能选择数据库,安装失败");
  10. $fp=fopen("install.sql","r") or die("不能打开SQL文件,请检查");
  11. $sql=fread($fp,filesize("install.sql"));
  12. fclose($fp);
  13. $sql=explode(";",$sql);
  14. for($i=0;$i mysql_query($sql[$i]);
  15. echo "安装成功";
  16. ?>
复制代码

1，SQL文件中没有创建数据库语句时

  3. define("DbHost", "localhost"); //数据库主机
  4. define("DbUser", "root"); //数据库用户
  5. define("DbPass", "password"); //数据库口令
  6. define("DbName", "dbname"); //数据库名
  7. mysql_connect(DbHost,DbUser,DbPass) or die("不能连接服务器!");
  8. mysql_create_db(DbName) or die("不能建立数据库,可能您已经安装过了");
  9. mysql_select_db(DbName) or die("不能选择数据库,安装失败");
  10. $fp=fopen("install.sql","r") or die("不能打开SQL文件,请检查");
  11. $sql=fread($fp,filesize("install.sql"));
  12. fclose($fp);
  13. $sql=explode(";",$sql);
  14. for($i=0;$i mysql_query($sql[$i]);
  15. echo "安装成功";
  16. ?>
复制代码

2，SQL文件中有创建数据库语句(即包含CREATE DATABASE和USE语句)时

  3. define("DbHost", "localhost"); //数据库主机
  4. define("DbUser", "root"); //数据库用户
  5. define("DbPass", "password"); //数据库口令
  6. mysql_connect(DbHost,DbUser,DbPass) or die("不能连接服务器!");
  7. $fp=fopen("install.sql","r") or die("不能打开SQL文件,请检查");
  8. $sql=fread($fp,filesize("install.sql"));
  9. fclose($fp);
  10. $sql=explode(";",$sql);
  11. for($i=0;$i mysql_query($sql[$i]);
  12. echo "安装成功";
  13. ?>
复制代码


Related labels：
php mysql数据库导入脚本(示例)
source：php.cn
Previous article：php5.4以下模拟getimagesizefromstring函数 Next article：PHP变量作用域与地址引用问题解析
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact [email protected]
Latest Articles by Author
Latest Issues
Connect Visual Studio Code to a remote MySQL database: Simplify the connection process I know this should be more focused, but I've wasted an entire day doing this and I can't f...
From 2023-10-24 20:41:24
0
2
231
How to export partial rows of a MySQL table from WHERE clause? How to export certain rows of MySQL table using where clause from PHP script? I have a MyS...
From 2023-10-21 11:41:17
0
2
271
"Converting JavaScript Variables to PHP: JavasScript variables converted to PHP" So I'm wondering if there is a way to pass Javascript variables into PHP. I'm making a scr...
From 2023-09-18 11:50:08
0
1
183
How to access MysqlServer on my PC via a PHP script on a remote hosting server I have installed MysqlServer and MysqlWorkbench on my computer. The server is running well...
From 2023-09-06 17:40:54
0
1
244
How to dynamically generate table names in SQL queries? I have a SQL query that uses a MySQL database to get information from it. The table name i...
From 2023-09-03 19:57:51
0
1
213
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！