PHP学习笔记：mysql

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