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 20Insert Success$ php insert_test.php 2 lucy 30Insert Success$ php select_test.php 1name: peterid: 20$ php select_test.php 2name: lucyid: 3