First here is the sql code that I store in a file named install.sql:
Code: Select all
DROP TABLE IF EXISTS `doc_classes`;
CREATE TABLE `doc_classes` (
`id` int(5) NOT NULL auto_increment,
`class` varchar(100) NOT NULL,
`package` varchar(100) NOT NULL,
`inherentance` varchar(255) NOT NULL,
`language_version` varchar(100) NOT NULL,
`runtime_version` varchar(100) NOT NULL,
`description` longtext NOT NULL,
PRIMARY KEY (`id`)
);
Code: Select all
<?php
$sql = new mysqli('localhost','root','root','DBName',8888);
$query = file_get_contents('install.sql');
$resource = $sql->multi_query($query);
if($resource){
do{
if($res = $sql->use_result()){
while($row = $res->fetch_object()){
print_r($row); echo "<br/><br/>";
}
}
}
while($sql->next_result());
}
?>