连接上了Mysql,接着就可以创建数据库和表了。
创建数据库的命令很简单
CREATE DATABASE my_db;
而在PHP中执行一般的SQL语句都是使用mysql_query()这个函数的,即创建数据库的代码可以简单写为:
<html>
<body>
<?php
$con=new mysqli('localhost','root','java');
if(!$con){
die("could not connect: ".mysql_error());
}
echo "Hello mysql";
if(mysql_query('CREATE TABLE my_db', $con))
{
echo "Database created";
}
else
{
echo "error creating database: ".mysql_error();
}
mysqli_close($con);
?>
</body>
</html>
访问对应的页面,问题出现了:
Hello mysql
Warning: mysql_query() expects parameter 2 to be resource, object given in /usr/local/apache2/htdocs/mysqlConnect.php on line 10
error creating database:
说mysql_query()的第二个参数要是个resource,也就是说new mysqli()出来的con不是一个resource……费解
好吧,试试前面一节说的
$con=@mysql_connect('localhost','root','java');
来连接Mysql
<html>
<body>
<?php
$con=@mysql_connect('localhost','root','java');
if(!$con){
die("could not connect: ".mysql_error());
}
echo "Hello mysql<br>";
if(mysql_query('CREATE TABLE my_db', $con))
{
echo "Database created";
}
else
{
echo "error creating database: ".mysql_error();
}
mysql_close($con);
?>
</body>
</html>
现在可以了:
Hello mysql
Database created
数据库建好了,数据表也就比较好弄了:
<html>
<body>
<?php
$con=@mysql_connect('localhost','root','java');
if(!$con){
die("could not connect: ".mysql_error());
}
echo "Hello mysql<br>";
if(mysql_query('CREATE TABLE my_db', $con))
{
echo "Database created";
}
else
{
echo "error creating database: ".mysql_error();
}
mysql_select_db("my_db", $con);
$sql='CREATE TABLE PERSONS
(
FirstName varchar(15),
LastName varchar(15),
Age int
)';
mysql_query($sql, $con);
mysql_close($con);
?>
</body>
</html>
可以查看数据库中确实已经创建了表Persons