1. MySQL 사용하기 ¶
- mysql_connect, mysql_close, mysql_query, mysql_affected_rows, mysql_num_rows, mysql_fetch_row, mysql_fetch_array
- mysql_connect ("ì ‘ì†�í• ì„œë²„ì£¼ì†Œ", "ì•„ì�´ë””", "패스워드");
- mysql ì—� ì ‘ì†�한다.
- mysql ì—� ì ‘ì†�한다.
- mysql_close();
- mysql ì ‘ì†�ì�„ ë�ŠëŠ”ë‹¤.
- mysql ì ‘ì†�ì�„ ë�ŠëŠ”ë‹¤.
- mysql_query("문장 ë��ì�˜ ì„¸ë¯¸ì½œë¡ ì—†ì�´ ì‹¤í–‰í• ëª…ë ¹ì–´ ìž…ë ¥");
- mysql 함수를 실행한다.
- mysql 함수를 실행한다.
- ex) $result = mysql_db_query("zp2002","select * from addressbook order by binary name");
- $result 는 변수�름, 실행결과� identifier를 받�
- $result 는 변수�름, 실행결과� identifier를 받�
- mysql_affected_rows
- mysql_num_rows
- mysql_fetch_row(실행결과� identifier);
- 실행결과ì�˜ identifierì�˜ ë‚´ìš©ì�„ 배열로 ì €ìž¥
- ex) $row = mysql_fetch_array($result);
- ex) $row = mysql_fetch_array($result);
- 실행결과ì�˜ identifierì�˜ ë‚´ìš©ì�„ 배열로 ì €ìž¥
- mysql_fetch_array(실행결과� identifier);
- mysql_fetch_row � 확장�
- 실행결과ì�˜ identifierì�˜ ë‚´ìš©ì�„ field 명ì�„ 사용하여 배열로 ì €ìž¥
- mysql_fetch_row � 확장�
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
<php
if ($_POSTname != "" && $_POSTphone != "") {
mysql_connect("zeropage.org","zp2002","암호");
mysql_select_db("zp2002");
mysql_query("insert into addressbook values('$_POSTname', '$_POSTphone')");
mysql_close();
}mysql_select_db("zp2002");
mysql_query("insert into addressbook values('$_POSTname', '$_POSTphone')");
mysql_close();
?>
<script language="javascript">window.location.replace("babo.php");</script>
}}} 위� 소스로 작성한 페�지�다. "주소�"










