创建数据库,数据添加,不会做搜索,请问和数据添加一样实现搜索怎么写,我是纯新手创建数据库
<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Persons
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
FirstName text,
LastName text,
Age text
)";mysql_query($sql,$con);mysql_close($con);
?>
添加数据表单
<html>
<body><form action="insert.php" method="post">
快递单号: <input type="text" name="firstname" />
发件人号码: <input type="text" name="lastname" />
发件人: <input type="text" name="age" />
<input type="submit" />
</form></body>
</html>
添加数据php
<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("my_db", $con);$sql="INSERT INTO Persons (FirstName, LastName, Age)
VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";mysql_close($con)
?>
<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Persons
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
FirstName text,
LastName text,
Age text
)";mysql_query($sql,$con);mysql_close($con);
?>
添加数据表单
<html>
<body><form action="insert.php" method="post">
快递单号: <input type="text" name="firstname" />
发件人号码: <input type="text" name="lastname" />
发件人: <input type="text" name="age" />
<input type="submit" />
</form></body>
</html>
添加数据php
<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("my_db", $con);$sql="INSERT INTO Persons (FirstName, LastName, Age)
VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";mysql_close($con)
?>
其实就是把要搜寻的关键字作为select语句的where条件,把搜寻结果返回
例如:select * from table where id=xxx;