<?php
//create a connection to the database
$con=mysql_connect("localhost" ,"root","abc");
if(!$con)
{
die('could not connect.' . mysql_error());
}
//create database
if(!mysql_select_db("study1",$con);)
{
if(mysql_query("CREATE DATABASE abc",$con))
{
echo "Database study1 created";
}
else
{
die( 'Error creating database:' . mysql_error());
}
}
//create table
else
{
$sql="CREATE TABLE Persons
(
personID int not null auto_increment,
primary key(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);
die( 'create table error' . mysql_error());
}//insert data into a database table
mysql_query("insert into Persons (FristName,LastName,Age)
values('Peter','Griffin',35)");
mysql_query("insert into Persons (FristName,LastName,Age)
values('Glenn','Quagmire',33)");
die('insert data error'. mysql_error());mysql_close($con);
?>
//create a connection to the database
$con=mysql_connect("localhost" ,"root","abc");
if(!$con)
{
die('could not connect.' . mysql_error());
}
//create database
if(!mysql_select_db("study1",$con);)
{
if(mysql_query("CREATE DATABASE abc",$con))
{
echo "Database study1 created";
}
else
{
die( 'Error creating database:' . mysql_error());
}
}
//create table
else
{
$sql="CREATE TABLE Persons
(
personID int not null auto_increment,
primary key(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);
die( 'create table error' . mysql_error());
}//insert data into a database table
mysql_query("insert into Persons (FristName,LastName,Age)
values('Peter','Griffin',35)");
mysql_query("insert into Persons (FristName,LastName,Age)
values('Glenn','Quagmire',33)");
die('insert data error'. mysql_error());mysql_close($con);
?>
Firstname不是Fristname, 再没发现其它的语法错误
1.if(!mysql_select_db("study1",$con);) 这里有错误哦.去掉分号2.逻辑问题,当mysql_select_db失败之后,会创建一个数据库,创建完成之后,就是后面的insert了,,,,那么你新建的这个DB中的表去哪里呢? 如果mysql_select_db成功,第一次,会创建表,然后写入记录,成功了...如果脚本运行第二次,那么这里就有问题了...创建表会失败...因为表已经存在...
//create a connection to the database
$con=mysql_connect("localhost" ,"root","abc") or die(mysql_error());
//create database
if(!mysql_select_db("study1"))
{
if(mysql_query("CREATE DATABASE abc",$con))
{
echo "Database study1 created";
}
else
{
die( 'Error creating database:' . mysql_error());
}
mysql_select_db("abc");
}
$sql="CREATE TABLE if not exists Persons
(
personID int not null auto_increment,
primary key(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);//insert data into a database table
mysql_query("insert into Persons (FirstName,LastName,Age) values('Peter','Griffin',35)");
mysql_query("insert into Persons (FirstName,LastName,Age) values('Glenn','Quagmire',33)");
die('insert data error'. mysql_error());mysql_close($con);
?>
//create a connection to the database
$con=mysql_connect("localhost" ,"root","abc");
if(!$con)
{
die('could not connect.' . mysql_error());
}
//create database
if(!mysql_select_db("study1",$con)) //这里多了一个;
{
if(mysql_query("CREATE DATABASE abc",$con))
{
echo "Database study1 created";
}
else
{
die( 'Error creating database:' . mysql_error());
}
}
//create table
else
{ $sql="CREATE TABLE Persons
(
personID int(11) not null auto_increment,
FirstName varchar(15),
LastName varchar(15),
Age int(11)
,primary key(personID)
)engine=myisam"; //修改后的
/*
$sql="CREATE TABLE Persons
(
personID int not null auto_increment,
primary key(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
*/
mysql_query($sql,$con);
die( 'create table error' . mysql_error());
}//insert data into a database table
mysql_query("insert into Persons (FristName,LastName,Age)
values('Peter','Griffin',35)"); //insert into Persons (FirstName,LastName,Age)values('Peter','Griffin',35);
mysql_query("insert into Persons (FristName,LastName,Age)
values('Glenn','Quagmire',33)"); //insert into Persons (FirstName,LastName,Age)values('Peter','Griffin',35);
die('insert data error'. mysql_error());mysql_close($con);
?>