如何使用php安装数据库？

Question

I am currently writing the database install file that automatically installs the database for the user so the Software can run. However, I am just wondering:

Is there a way to just push a SQL file through it?

As of the moment I am having to do:

$tbl_users = "CREATE TABLE Users (
              uid INT(255) UNSIGNED AUTO_INCREMENT PRIMARY KEY
              )";

if($db->query($tbl_users) === TRUE) {
    // do the next creation of a table ...

for each table and then manually add the rows as well.

If anyone could just give me some advice it would be appreciated; I am just wondering if the SQL file would be insecure though if it is possible.

Since this is forum software and a lot of people seem to like free hosting when using it, I cannot use shell_exec because it is disabled by most free hosting providers.

Read my comments for a better understanding.

Answer 1

If you are using shared hosting and don't have phpmyadmin or can't upload more than 2MB files or some other problem then you should install MySQL Workbench.

Create a connection to the mysql server using the settings supplied by the hosting provider and run your sql.

or to run your SQL script via PHP do the following:

<?php 
  $db = mysqli_connect("localhost", "root", "my_password", "database"); 
  if (mysqli_connect_errno()) { 
     printf("Connect failed: %s
", mysqli_connect_error()); 
     exit();
  } 
  $query = file_get_contents("myfile.sql"); 
  if (mysqli_multi_query($db, $query)) 
     echo "Success"; 
  else
     echo "Fail";