php - 如何在php mysql中创建表和字段

Question

我尝试通过 php/mysql 创建一个表及其文件

所以，首先我创建了一个 sql 类:

<?php
class db{


    public $db;
    function __construct(){
        $this->db_connect('localhost','root','','dbmenu');
    }

    function db_connect($host,$user,$pass,$database){
        $this->db = new mysqli($host, $user, $pass, $database);

        if($this->db->connect_errno > 0){
            die('Unable to connect to database [' . $this->db->connect_error . ']');
        }
    }

    function setTables()
    {

        //for created Groups
        $_tableName="groups";
        $_fieldsName=array();
        $_fieldsName = array("id" =>"id int(10) NOT NULL AUTO_INCREMENT",
                      "name"      =>"name varchar(25) COLLATE utf8_persian_ci NOT NULL",
                      "parent"   =>"element varchar(20) COLLATE utf8_persian_ci NOT NULL", 
                      "primary"   =>"PRIMARY KEY (`id`)");
        $this->createTable($_tableName,$_fieldsName);
    }

    function createTable($_tableName,$_fieldsName)
    {

    }
} ?>

有人可以指导我编写createTable($_tableName,$_fieldsName)函数吗？

$db= new db;
$db=setTables();

Answer 1

根据你之前的代码，它会是这样的

function createTable($_tableName,$_fieldsName)
{
    $this->db->query('CREATE TABLE '. $_tableName .
                     ' (' . join(',', $_fieldsName) .');');
}