PHP5 and MySQL database operations

1 Create a database table:

2 reading data

2.1 Build 01.php

2.2 Establishment of Member.php

3 Modifying Data

3.1 Setting up level.php (Modify data)

3.2 Establishment of up_level.php

4 Adding data

4.1 Establishment of add_member.php

4.2 Establishment of newmember.php

5 Creating a class database connection

5.1 Creating a cls_mysql.php class file

5.2 Establishment of test.php

6 Summary

6.1 mysql_connect (): Establish a connection to the MySQL server

6.2 mysql_select_db (): Select Database

6.3 mysql_query (): Execute database query

6.4 mysql_fetch_array (): Get Database records

6.5 mysql_num_rows (): Gets the number of records obtained by the query

6.6 mysql_affected_rows (): Number of rows affected by the most recent operation

6.7 mysql_insert_id (): ID value of the most recent record inserted

From:http://www.cnblogs.com/yongfeng/archive/2010/03/19/1689644.html

PHP5 and MySQL database operations