PHP原生创建数据库

原生创建数据库 创建表 写入数据

<?php

class MYDB{

    /*
     * 创建数据库
     */
    public function cratreMysql( $localhost,$root,$pass,$databses) {

        // 链接服务器
        $con = @mysql_connect($localhost,$root,$pass);

        if (!$con)
        {
            die('Could not connect: ' . mysql_error());
        }

        // 链接数据库
        if(mysql_select_db($databses, $con)){
            echo "Database created";
        }else{

            // 创建数据库
            if (@mysql_query("CREATE DATABASE ".$databses,$con))
            {
                echo "Database created";
            }
            else
            {
                echo "Error creating database: " . mysql_error();
            }
        }


        mysql_close($con);
    }

    /*
     * 创建数据表
     */
    public function createTables($localhost,$root,$pass,$databses,$sql) {

        $con = @mysql_connect($localhost,$root,$pass);
        if (!$con)
        {
            die('Could not connect: ' . mysql_error());
        }

        mysql_select_db($databses, $con);

        if(mysql_query($sql,$con)){
            echo "table created";
        }else{
            echo "Error creating database: " . mysql_error();
        }

        mysql_close($con);
    }

}

$data = new MYDB();

$sql = "CREATE TABLE Persons
                    (
                    FirstName varchar(15),
                    LastName varchar(15),
                    Age int
                    )";

$data->cratreMysql('localhost', 'root', 'root','my_db');

$data->createTables('localhost', 'root', 'root','my_db',$sql);



?>