PHP read MySQL data code _php tutorial

Create a new view.php file with the following contents:
Copy CodeThe code is as follows:
$link =mysql_connect ("localhost", "root", "previous Administrator password");
if (! $link) echo "Not connected successfully!";
else echo "connected successfully!";
?>

In this way, we connected to the MySQL database, and then the data read part of the code, according to my MySQL data source table structure of the introduction, we are experimental to read:

Depart varchar (45) Department name
ename varchar (45) Employee name
Pcname varchar PC Name

These three pieces of data.

In the view.php, immediately preceding code continues to write:

Copy CodeThe code is as follows:
mysql_select_db ("Infosystem", $link); Select Database
$q = "SELECT * from Info"; SQL query Statements
mysql_query ("SET NAMES GB2312");
$rs = mysql_query ($q, $link); Get Data Set
if (! $rs) {die ("Valid result!");}
echo "


"; echo " "; while ($row = Mysql_fetch_row ($rs)) echo " "; Show Data echo "

Department Name	Employee Name	PC Name
$row [1]	$row [2]	$row [3]

";
Mysql_free_result ($RS); To close a data set
?>
where "Infosystem" is the database name, "Info" is the name of the table. You can modify it according to your own circumstances as appropriate.

Next, run it ~ how ~ is the data being read smoothly?

http://www.bkjia.com/PHPjc/318952.html www.bkjia.com true http://www.bkjia.com/PHPjc/318952.html techarticle Create a new view.php file with the following: Copy code code as follows: PHP $link =mysql_connect ("localhost", "root", "previous Administrator password"), if (! $link) echo "Not connected successfully!"; Elsee ...

