PHP Study Notes: MySQL

The PHP connection and MySQL interaction are very convenient, and the API interface is also very similar to the MySQL C API
Test:
Create a MySQL table
Database phpMyAdmin
Table creation statement:

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 using parameters:

<?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);?>

Use parameters as input 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);?>

Test:

$ 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