Jump to content

[SOLVED] Basic PHP Mysql problem


sarathy_1116

Recommended Posts

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

<?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';
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.