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>
}}} μμ μμ€λ‘ μμ±ν νμ΄μ§μ΄λ€. "μ£Όμλ‘"
