sarathy_1116 Posted November 7, 2009 Share Posted November 7, 2009 Hi all, I am new to php. I am trying to create a table through php script in mysql server. This is is my code for creating the table <?php $link = mysqli_connect('localhost', 'root', ''); mysqli_query(link, query) $sql = 'CREATE TABLE sample ( EMPID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, FIRSTNAME TEXT, LASTNAME TEXT ) DEFAULT CHARACTER SET utf8'; if (!mysqli_query($link, $sql)) { $output = 'Error creating sample table: ' . mysqli_error($link); include 'output.html.php'; exit(); } $output = 'sample table successfully created.'; include 'output.html.php'; ?> But the problem is am getting this error "Parse error: syntax error, unexpected T_VARIABLE" in line 5.. Any help would be appreciated. Thanks in advance.. Link to comment https://forums.phpfreaks.com/topic/180645-solved-basic-php-mysql-problem/ Share on other sites More sharing options...
ram4nd Posted November 7, 2009 Share Posted November 7, 2009 <?php $link = mysqli_connect('localhost', 'root', ''); mysqli_query(link, query) $sql = 'CREATE TABLE sample ( EMPID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, FIRSTNAME TEXT, LASTNAME TEXT ) DEFAULT CHARACTER SET utf8'; if (!mysqli_query($sql)) { $output = 'Error creating sample table: ' . mysqli_error($link); include 'output.html.php'; exit(); } $output = 'sample table successfully created.'; include 'output.html.php'; ?> Link to comment https://forums.phpfreaks.com/topic/180645-solved-basic-php-mysql-problem/#findComment-953038 Share on other sites More sharing options...
Zane Posted November 7, 2009 Share Posted November 7, 2009 your missing a semicolon after mysql_query Link to comment https://forums.phpfreaks.com/topic/180645-solved-basic-php-mysql-problem/#findComment-953040 Share on other sites More sharing options...
sarathy_1116 Posted November 7, 2009 Author Share Posted November 7, 2009 Thanks a lot ppl. . thank u so much!!! Link to comment https://forums.phpfreaks.com/topic/180645-solved-basic-php-mysql-problem/#findComment-953043 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.