how to import sql file in mysql database using php

Solutions on MaxInterview for how to import sql file in mysql database using php by the best coders in the world

showing results for - "how to import sql file in mysql database using php"

1<?php
2$conn =new mysqli('localhost', 'root', '' , 'blog_samples');
3
4$query = '';
5$sqlScript = file('database-script.sql');
6foreach ($sqlScript as $line)	{
7	
8	$startWith = substr(trim($line), 0 ,2);
9	$endWith = substr(trim($line), -1 ,1);
10	
11	if (empty($line) || $startWith == '--' || $startWith == '/*' || $startWith == '//') {
12		continue;
13	}
14		
15	$query = $query . $line;
16	if ($endWith == ';') {
17		mysqli_query($conn,$query) or die('<div class="error-response sql-import-response">Problem in executing the SQL query <b>' . $query. '</b></div>');
18		$query= '';		
19	}
20}
21echo '<div class="success-response sql-import-response">SQL file imported successfully</div>';
22?>

similar questions

mysql db connection in php how to connect to a mysql database using php export database to sql dump in php php sql connection using mysql database with php how to connect to a database in php how to read sqlite file in php php sql server connect php connect ms sql server how to import database in phpmyadmin import data from csv to db php

queries leading to this page

import file in database mysql php code mysql load sql from file php import sql file import a sql file to a database with php php mysql file how to upload sql file in mysql php mysql how to import data php export mysql to sql file how to import sql file to mysql with php how to add sql file in php how to import sql file using php mysql import table in database php import sql file into database export mysql database sql file using php how to import sql into php php mysql exe import sql file how to import database in mysql in php how to import data from database to php mysql import sql file to specific database php import from database ph import sql data from database php import database mysql using php import database from php php mysql open local sql file import database php import data from database php php query sql file import sql file to database in php import sql into php php import mysql dump how import sql php php ile sql import import sql file php how to upload sql to database php how to import a php database php sql file import sql file in mysql using php php mysql import sql file importing sql via php import sql file in mysql php php create and import mysql database get php to run and sql file to import into db import database using php script include database in php php import data from sql php import data to mysql database import data at sql php import database using php php execute mysql file how to use sql file as database in php php execute mysql import create php database and import sql sql file import in db php php import mysql database connection import database in php get sql file from site using php load sql file into php import sql in php library php code to import data from sql to mysql mysql import sql file use php php code import sql using php how to import database in php php import database to mysql mysql php import php import sql file to database import sql file on php php import sql import sql file from php how to import a sql file in php php import database from sql file import sql file with php php import file to database how to import mysql database using php code how to connect sql file to php import sql in mysql server upload database by phpcode import to mysql using phpexecel how to import a file in a php database php import from db file how to import sql file in mysql database using php how to import sql file in mysql database using php