Php学习笔记
我们组在这周进行了相关操作,具体如下
<?php
$con =mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE jiyi",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>
// Create table in jiyi database 创建数据库
mysql_select_db("jiyi", $con);
$sql = "CREATE TABLE jiyicanying 创建表
(
Name varchar(15),
sex varchar(15),
Age int 表中三项
)";
mysql_query($sql,$con);
mysql_close($con);
?>
<?php
$con =mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("jiyi", $con);
mysql_query("INSERT INTO jyiicanying (Name,sex, Age)
VALUES ('cai', 'man', '22')");
mysql_query("INSERT INTO jiyicanying (Name,sex, Age)
VALUES ('xie', 'man', '24')"); 添加两条数据
mysql_close($con);
?>
在实验中,我们试图创建一个跟以前一样的jiyi数据库,斌且在其下创建jyicanying表列名是name,sex and age。
然后我们向表中添加了两个数据,分别是
cai man 22
Xie man 24
蔡贵城,谢讯组
017.10.26