PHP连接和mysql的交互非常非常方便,API接口也和mysql 的C api非常相似
测试:
新建一个mysql表
数据库phpmyadmin
建表语句:
CREATE TABLE IF NOT EXISTS `student` (
`id` int(11) NOT NULL,
`name` varchar(60) NOT NULL,
`age` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
使用参数 作为输入insert:
<?php
$con = mysql_connect("192.168.1.104","root","123456");
if (!$con)
{
die('connect failed: ' . mysql_error());
}
mysql_select_db("phpmyadmin", $con);
if(!mysql_query("insert into student VALUES($argv[1], '$argv[2]', $argv[3])"))
{
die('Insert Error: ' . mysql_error());
}
else
{
echo "Insert Success";
}
mysql_close($con);
?>
使用参数作为输入select:
<?php
$con = mysql_connect("192.168.1.104","root","123456");
if (!$con)
{
die('connect failed: ' . mysql_error());
}
mysql_select_db("phpmyadmin", $con);
$result = mysql_query("SELECT * FROM student where id = $argv[1]");
while($row = mysql_fetch_array($result))
{
echo "name: " . $row['name'] . "\n";
echo "id: " . $row['age'] ;
echo "\n";
}
mysql_close($con);
?>
测试:
$ php insert_test.php 1 peter 20
Insert Success
$ php insert_test.php 2 lucy 30
Insert Success
$ php select_test.php 1
name: peter
id: 20
$ php select_test.php 2
name: lucy
id: 3