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
出处:http://blog.csdn.net/yfkiss/article/details/6868336