 |
|
|  |
|
 |
13³â Àü |
php¿¡¼ Á¦°øµÇ´Â die ÇÔ¼ö´Â Âü Àç¹ÌÀÖ´Â ÇÔ¼öÀÔ´Ï´Ù. Çܸ´ÀÇ´ë»ç ÇÑÁÙÀÌ ¶°¿À¸¥´Ù°í ÇÒ±î¿ä ƯÈ÷ or die ºÎºÐ¿¡¼´Â ½ÇÆÐÇϸé Á׳ª???? ¹«¾ùÀÌ Á׳ª Âü ±Ã±ÝÇÏ°Ô ¸¸µì´Ï´Ù. ¾Æ·¡ ¹®ÀåÀ» óÀ½ ºÃ´Ù¸é µ¥ÀÌŸº£À̽º ¿¬°á¿¡ ½ÇÆÐÇÏ¸é ¿¬°á Ä¿³Ø¼ÇÀÌ Á״±¸³ª¶ó´Â ´À³¦ÀÌ ÆÅÆÅ µé ¼öµµ ÀÖ½À´Ï´Ù.
$connect= mysql_connect("localhost", "root","password") or die ("µ¥ÀÌÅͺ£À̽º Á¢¼Ó½ÇÆÐ");
³·ÀÍÀº php ¼Ò½º»ó¿¡¼ die ÇÔ¼ö´Â MySQL Àü¿ë ÇÔ¼ö¸¦ »ç¿ëÇÒ ¶§ ¸¹ÀÌ µîÀåÇϴµ¥, »ç½ÇÀº MySQL Àü¿ëÇÔ¼ö´Â ¾Æ´Õ´Ï´Ù. ´Ü¼øÈ÷ ¿¡·¯°¡ ¹ß»ýÇÏ¿´À» ¶§ ÇØ´ç ½ºÅ©¸³Æ®¸¦ Á¾·á½ÃÅ°°í °³¹ßÀÚ°¡ ÀǵµÇÑ ¸Þ½ÃÁö¸¦ Ãâ·ÂÇÏ°Ô ÇØÁÖ´Â ÇÔ¼öÀÔ´Ï´Ù. ¾Æ·¡´Â mysql_query ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© SELECT ±¸¹®À» ½ÇÇà½ÃÅ°´Â ªÀº ¿¹ÀÔ´Ï´Ù.
<?php
include("dbcon.php");
$sql = "SELECT * FROM member_charging ";
$sql = $sql . " WHERE mem_uid = '$mem_uid' ORDER BY seq DESC";
$result = mysql_query($sql) or die("¶È¹Ù·ÎÁ» ½áºÁ!!");
?>
À§¿Í °°ÀÌ Ã³¸®ÇÏÁö ¾Ê°í Á»´õ ¿øÃÊÀûÀÎ MySQL ¿¡·¯¸Þ½ÃÁö°¡ ÇÊ¿äÇÏ´Ù¸é mysql_error ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ó¸®ÇÏ¸é µË´Ï´Ù.
<?php
include("dbcon.php");
$sql = "SELECT * FROM member_charging ";
$sql = $sql . " WHERE mem_uid = '$mem_uid' ORDER BY seq DESC";
$result = mysql_query($sql);
if(!$result) echo(mysql_error());
?>
À§ÀÇ ¼Ò½º ½ÇÇà°á°ú ¿¡·¯¸Þ½ÃÁöÀÔ´Ï´Ù. Á»´õ ¿øÃÊÀûÀÌÁö ¾Ê½À´Ï±î?
Å×À̺í 'testdb.member_charging' ´Â Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù.
|
|
̵̧ : 523 |
̵̧
¸ñ·Ï
|
|
|  |
|