1. MySQL ��기 ¶

mysql_connect, mysql_close, mysql_query, mysql_affected_rows, mysql_num_rows, mysql_fetch_row, mysql_fetch_array
mysql_connect ("�� ", "��디", "��드");
- mysql �� 다.
mysql_close();
- mysql �� 끊는다.
mysql_query("문�� 끝�� 미��론 �� 명령�� 력");
- mysql ��를 ��다.
ex) $result = mysql_db_query("zp2002","select * from addressbook order by binary name");
- $result 는 변��, ��결과�� identifier를 ��
mysql_affected_rows
mysql_num_rows
mysql_fetch_row(��결과�� identifier);
- ��결과�� identifier�� 내�� 배��로 ��
  - ex) $row = mysql_fetch_array($result);
mysql_fetch_array(��결과�� identifier);
- mysql_fetch_row ��
- ��결과�� identifier�� 내�� field 명�� 배��로 ��

2. �� ¶

~cpp 
���고로 다������ 명령���들��� 같��� ������결과를 보������다..

1.
mysql_select_db("database1");
mysql_query("select * from table1 by order name");

2.
mysql_query("use database1");
mysql_query("select * from table1 by order name");

3.
mysql_db_query("database1", "select * from table1 by order name");

다�� 단��게 만들�� 본 ��록 ��다..

~cpp 
<!--babo.php-->
<html>
<head>
<title> ������록 </title>
</head>
<body>
<table border=1 cellpadding=2>
<tr align=center> <td> ����� </td> <td width=120> ����������� </td> </tr>
<?php
mysql_connect ("165.194.17.15", "zp2002", "������");
$result = mysql_db_query("zp2002","select * from addressbook order by binary name");
while($row = mysql_fetch_array($result)) {
	echo "<tr> <td>", $row["name"], "</td><td align=center>", $row["phone"], "</td> </tr>";
}
mysql_close();
?>
</table>

<FORM method="POST" action="save.php" >
����� <INPUT type="text" name="name" value="" size=10 maxlength=10> 
����������� <INPUT type="text" name="phone" value="" size=15 maxlength=15> 
 <INPUT type="submit" value="���력" size=5>
</FORM> 

<font size=2 color=red>※ �����과 �����������를 모두 ���력������ ��������� 됩��다.
<br>   ����� 10bytes, ����������� 15bytes ���내로 ���력������������. </font>
</body>
</html>

{{{~cpp

<!~~save.php~~>
<php
if ($_POSTname != "" && $_POSTphone != "") {

mysql_connect("zeropage.org","zp2002","��");
mysql_select_db("zp2002");
mysql_query("insert into addressbook values('$_POSTname', '$_POSTphone')");
mysql_close();

}
?>
<script language="javascript">window.location.replace("babo.php");</script>
}}} �� 로 �� 다. "��록"

PHP

ZP Board/PHP Study/MySQL

Contents

1. MySQL ��기 ¶

2. �� ¶

ZP Board/PHP Study/MySQL

Contents

1. MySQL ���������기 ¶

2. ������������ ¶

1. MySQL ��기 ¶

2. �� ¶