PHP import sql to mysql database method analysis

------Answer-------- The second one has not been done, so pay attention to this issue. Third question: The simplest, you can execute the mysqldump command.

$database ="";//Backup database name
$user="";//Database connection user name
$password="";//Database password
$outputfile="";//Exported backup SQL file path
system($mysqldump." -u".$user." -p".$password." ".$database." > ".$outputfile."");
?>

------Answer-------- These problems of yours can be solved using mysql client software. You can use mysql cc or mysql front to realize your requirements. It will be very troublesome to use the program. ------answer-------- It’s okay if you can’t execute it Or google php mysql class adobdlite ------answer-------- good ------answer-------- For 1 and 3, you can use the command line that comes with mysql to complete the import and export work. Assume that the mysql username and password are root xxx and the database is test import sql mysql -hlocalhost -uroot -pxxx test xxx.sql For excel, standard data can be converted into cvs format data and then imported using tools like phpmyadmin. ------answer-------- Two methods: 1. Directly execute the mysql command to let Mysql read the corresponding file 2. Use PHP to read the file and then execute the file content. ------answer-------- 1,3 is very simple 2. Basically there is no perfect solution in the Chinese environment You can use DOM to write a small program for conversion ------answer-------- It's COM =.=|| ------answer-------- The second question is, you can just write a csv file and import it. You can import data into mysql database ------answer-------- The kind of csv that comes out of excel... =_=|| The data is simple and can be used ------answer-------- Support the 1st and 2nd floor 2. For questions, you can consider mysql odbc ------Answer--------

Quote from froole’s reply on the 7th floor: Two methods: 1. Directly execute the Mysql command and let Mysql read the corresponding file 2. Use PHP to read the file and then execute the file content.

Concise and clear expression ------answer-------- The points above are so high, sweat. ------answer-------- The second question is this. We need to import some files into the database in batches. Previously, ASP read out the .xls files through asp and wrote them into the database. Now I have switched to PHP, and since I am a complete novice, what I want to do is to directly import the organized .xls files into mysql through PHP. Is this not possible? So is there any good way to implement batch import? For example, you want to import the names and student numbers of all students in a school. ------answer-------- Gingzai777 is trying the expert's method. Does the address behind the source have to be an absolute address? ------Answer--------

Quoting the reply from gingzai777 on the 1st floor: 1. Import the existing SQL file into the database and write a function:

$conn=mysql_connect("localhost","root","password");//Specify database connection parameters
function mysql_import($file,$database)//Imported function , the parameters are the SQL file path and the imported library name.
{
mysql_select_db($database);
mysql_query("source '".$file."';");
echo "Import ".$file." file to ".$database." database completed";
}
mysql_close($conn);
?>

+---------Code---------------+

function init_db(){
$file="../install/import.sql";
$conn=mysql_connect($this->dbhost,$this->dbuser,$this-> ;dbpw) or die("Database connection error");
if(!$conn){
echo "Database connection error";
}
 $db=mysql_select_db($this->dbname);
 if($db ){
mysql_query("DROP DATABASE `".$this->dbname."`");
 }
 mysql_query("setnames 'GBK'");
$creatdb=mysql_query("CREATE DATABASE `".$this ->dbname."` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_bin");//Create database
$mysql=mysql_select_db($this->dbname);
//if($mysql){
//echo "Connect" ;
//}else{
//echo "Not connected";
//}
//echo $file;
//$file="source '".$file."'";
//echo $ file;
mysql_query("source '".$file."'");//Initialize the database
mysql_close($conn);
}

------Answer--- ----- 1. Import the existing SQL file into the database and write a function:

$conn=mysql_connect("localhost","root","password");//Specify database connection parameters
function mysql_import($file,$database)//Imported function , the parameters are the SQL file path and the imported library name.
{
mysql_select_db($database);
mysql_query("source '".$file."';");
echo "Import ".$file." file to ".$database." database completed";
}
mysql_close($conn);