Question

How to create MySQL table in PHP

Answer 1

$db_host     = 'localhost';
$db_user     = 'user_name';
$db_pass     = 'password';
$db_database = 'database_name';
 
$con = mysql_connect($db_host, $db_user, $db_pass) or die('Unable to establish a DB connection');

$sql = "CREATE TABLE IF NOT EXISTS `posts` (
    `post_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `post` text COLLATE utf8_unicode_ci NOT NULL,
    `IP` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
    `add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`post_id`),
    FULLTEXT KEY `post` (`post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"; 
    
$result = mysql_query($sql, $con);
if ( ! $result ) die("Line: " . __LINE__  . " Error: ". mysql_error());   

70+ SQL courses for beginners and professionals