Creating a database table from code with PHP

Question

I have been experimenting with Python Django, and what I really liked was creating a database table from a model created in Python.

I would love to do the same with PHP. I have been plowing through Packagist without any luck. So I started working on something myself. And you guessed it, it became a project on its own now.

Does anyone know any library, preferably on Packagist that does this? Any other suggestions would be welcome. Also, don't hold back on commenting this method in general. However I really believe that this concept is valuable.

Note: I just like the idea of not having manage all kinds of models in MySql workbench for small projects.

Answer 1

use mysqli or pdo.

Then you input a standard SQL statement in and execute it.
$db=mysqli_connect('localhost','root','xxxx');
mysqli_select_db($db,'db');
mysqli_query($db,"create table scooby { col1 varchar(300),col2 varchar(10);}");

A very simply example with no error checking.