MySQL Connect
MySQL Create
MySQL Insert
MySQL Select
MySQL Where
MySQL Order By
MySQL Update
MySQL Delete
PHP ODBC
-----------------------------------------------------------------------------------------------
MySQL Connect
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('mySQL数据库不能连接: ' . mysql_error());
}
else
{
echo "mySQL连接成功!";
}
echo "<br>";
//关闭连接,其实如果没有此操作,在脚本结束后也会自动关闭连接
mysql_close($con); //看呢,$con就像是句柄之类的东西
echo "mySQL关闭了";
?>
-----------------------------------------------------------------------------------------------
MySQL Create
创建数据库
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('mySQL数据库不能连接: ' . mysql_error());
}
else
{
echo "mySQL连接成功!";
}
echo "<br>";
if
(mysql_query("CREATE DATABASE my_phpsqldb",$con))
{
echo "my_phpsqldb成功建立";
}
else
{
echo "创建数据库失败: " . mysql_error();
}
echo "<br>";
//关闭连接,其实如果没有此操作,在脚本结束后也会自动关闭连接
mysql_close($con); //看呢,$con就像是句柄之类的东西
echo "mySQL关闭了";
?>
运行结果:
mySQL连接成功!
my_phpsqldb成功建立
mySQL关闭了
如果再次运行,结果是:
mySQL连接成功!
创建数据库失败: Can't create database 'my_phpsqldb'; database exists
mySQL关闭了
创建表
// Create table in my_phpsqldb database
mysql_select_db
("my_phpsqldb", $con);
$sql = "CREATE TABLE person
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query
($sql,$con);
echo "创建了CREAT TABLE person";
--------------------------------------------------------------------------------
MySQL Insert
例子:
1)先在index.html中放入以下代码
<html>
<body>
<form action="insert.php" method="post">
Firstname: <input type="text" name="firstname" />
Lastname: <input type="text" name="lastname" />
Age: <input type="text" name="age" />
<input type="submit" />
</form>
</body>
</html>
2)再在insert.php 放入以下代码
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_phpsqldb", $con);
$sql="INSERT INTO person (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)
?>
3)运行, 添加First name 为stephen, lastname为zhu,年龄28, 提交,显示
1 recored added.
---------------------------------------------------------------------------------
MySQL Where
接上面的数据库,来查询下看一看:
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db ("my_phpsqldb", $con);
$result =
mysql_query
("SELECT * FROM person
WHERE FirstName='Stephen'");
while($row =
mysql_fetch_array
($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";
}
?>
---------------------------------------------------------------------------------
MySQL Order By
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_phpsqldb", $con);
$result = mysql_query("SELECT * FROM person ORDER BY Age");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'];
echo " " . $row['LastName'];
echo " " . $row['Age'];
echo "<br />";
}
mysql_close($con);
?>
运行结果可能是:
Stephen Zhu 28
Andy Liu 42
Jackey Chen 46
----------------------------------------------------------------------------------
MySQL Update
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_phpsqldb", $con);
mysql_query("UPDATE Person SET Age = '18'
WHERE FirstName = 'Stephen' AND LastName = 'Zhu'");
mysql_close($con);
?>
运行完之后, 再查看数据库, 年龄已经被改成了18
----------------------------------------------------------------------------------
MySQL Delete
<?php
$con = mysql_connect("localhost","root","mysql");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_phpsqldb", $con);
mysql_query("DELETE FROM person WHERE FirstName='Jacky'");
echo "Jackey DELETED!";
mysql_close($con);
?>
这样就把Jacky的记录删除掉了
----------------------------------------------------------------------------------
PHP ODBC
ODBC是微软的数据库接口标准, 这里不多提了