Connection PHP to MySql

1) mysql_connect 함수로 MySql 연결

C:\Program Files\Apache Group\Apache2\htdocs\MySqlEx1\connect.php

 

<?
$connect = mysql_connect("localhost","small","password");  
mysql_select_db("company", $connect); 
$result = mysql_query("select * from friend", $connect);

if (!$result) {

echo "거짓! 테이블이 없는데요.";
}else {
echo "참! user 테이블에 모든 데이터를 선택하였습니다.";
}
mysql_close($connect);
?>

 

IE에서 http://localhost/MySqlEx1/connect.php 실행

 

결과 >

참! user 테이블에 모든 데이터를 선택하였습니다.

 

2) mysql_num_rows 함수로 데이터 행의 개수 구하기

C:\Program Files\Apache Group\Apache2\htdocs\MySqlEx1\num_rows.php

 

<?
$connect = mysql_connect("localhost","small","password"); 
mysql_select_db("company", $connect);
$result = mysql_query("select * from friend", $connect);
$num = mysql_num_rows($result);
echo "$num";
mysql_close($connect);
?>

 

결과 >

2

 

3) mysql_fetch_array 함수로 쿼리의 결과를 한 줄 배열로 보여주기

 

C:\Program Files\Apache Group\Apache2\htdocs\MySqlEx1\fetch_array.php

 

<?
$connect = mysql_connect("localhost","small","password");
mysql_select_db("company", $connect);
$result = mysql_query("select * from friend", $connect);
while($row=mysql_fetch_array($result)) {
echo "no : $row[0] | name : $row[1] | tel : $row[2]<br>";
echo "no : $row[no] | name : $row[name] | tel : $row[tel]<br>";
}
mysql_close($connect);
?>

 

결과 >

no : 1 | name : James Kim | tel : 1089971234
no : 1 | name : James Kim | tel : 1089971234
no : 2 | name : Fernando Torres | tel : 1089977777
no : 2 | name : Fernando Torres | tel : 1089977777