PHP script

[KaiSheng]

Hey guys. Well, it's me again.

 

I have a question in mind, is there any way possible to create database tables and fields

using php script instead of manually creating it in database?

 

If so, if any of you have any resources about this, i hope you will share it with me

Thanks.

[Ch0cu3r]

 

 

I have a question in mind, is there any way possible to create database tables and fields

using php script instead of manually creating it in database?

Yes, but you still got to type out the queries manually for creating the databases/tables.

 

You're better of using some form of gui such as MySQL Workbench (desktop gui) or using phpMyAdmin (web based gui) to easily manage your MySQL server.

Edited November 14, 2013 by Ch0cu3r

[Barand]

there is an example here http://forums.phpfreaks.com/topic/282860-selectingsearching-rows-of-a-table-based-on-the-value-of-a-field-in-the-table/?do=findComment&comment=1453412

[KaiSheng]

Thank you.

[KaiSheng]

But I need the current date instead of manually keying in the dates

[Barand]

Then you have four options at least:

 

1. Use a MySQL TIMESTAMP type column which will automatically set to current date on INSERT and optionally on UPDATE
2. Use a DATE type column and place CURDATE() into the column on INSERT
3. USE a DATETIME column and place NOW() into the column on INSERT
4. Use PHP to get current date and place that in the date column