<?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);
?>
解决方案 »
- Jpgraph 柱形图 怎么让字体竖向排列
- php截图
- setcookie问题!!
- php程序员要学习linux,请高手们推荐一本经典linux的好书
- 应该算是引用的问题吧
- 滚动条,希望在下拉框的最后一个Option下面产生一个滚动条
- 急!!php页面加载不完全的问题,在线等
- “mysqli的怪问题!!”的楼主请来这里!!!
- 有一个"删除"连接,当我点击删除的时候,就弹出一个警告框:"你确定吗?",如果点了确定就进行删除,没有就不错行为
- 如何取得 post 以后的返回页面
- ubuntu11.10如何配置SVN与WEB服务器同步
- 使用jquery发送值到服务器接口,获得返回值,但是参数不能带点号
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);
?>