10 days Learn PHP Day 5

Learning purpose: learn to read data

Let's look at two functions:
    1、mysql_query
Send a query string. Syntax: int mysql_query (string query, int [link_identifier]); Return value: integer

This function sends a query string for MySQL to perform related processing or execution. If the link_identifier parameter is not specified, the program will automatically find the recently opened ID. When the query string is UPDATE, INSERT and DELETE, it may return true or false; If the query string is SELECT, a new ID value will be returned. If false is returned, the query string is not successful but has an error.

2. Mysql_fetch_object returns class data. Syntax: object mysql_fetch_object (int result, int [result_typ]); Return value: class

This function is used to disassemble the query result into a class variable. If the result has no data, the value of false is returned.

Look at a simple example:

Of course, there is a username field in the table user, which is similar to ASP In

Of course, connect first data base , we generally require_once ('conn. php '); The conn.php is the code for connecting to the database mentioned last time.

Two small commands can complete the task of reading data. Today, we will talk about adding, deleting and modifying data next time.