|
|
Ŭ·¡½º¸¦ °®´Ù ¾²±âµµ ¹ö°Å¿î ÃÊÃʺ¸µéÀ» À§ÇÑ ±âÃÊÀûÀÎ µðºñ Á¢±Ù $dbconnect=mysql_connect("localhost","root","1111"); //IP, user, password if(!$dbconnect){ echo 'connect faliled'; exit; } $mysql = mysql_select_db("mydb",$dbconnect); //DB À̸§ if(!$mysql){ mysql_close($dbconnect); echo select failed; exit; } $sqr = "select * from title order by id asc"; //SQL $result = mysql_query($sqr,$dbconnect); if(!$result){ mysql_close($dbconnect); echo query failed; exit; } $rownum = mysql_num_rows($result); // ¿ÀÇ °³¼ö ±¸Çϱâ $colnum = mysql_num_fields($result); // ÇàÀÇ °³¼ö ±¸Çϱâ while($rowarr = mysql_fetch_row($result)){ //ÇÑ Ç྿ ¹Þ¾Æ¼ for($tmp=0;$tmp < $colnum;++$tmp){ // ¿ÀÇ °³¼ö¸¸Å echo $rowarr[$tmp]; //¿©±â¼´Â ±×³É ȸ鿡 Ãâ·ÂÇÑ´Ù. } } mysql_close($dbconnect); ?> »ç¿ëÇÑ ÇÔ¼ö°¡ ±Ã±ÝÇϸé PHP »ç¿ë ¼³¸í¼¸¦ º¸¸é µÈ´Ù. http://kr2.php.net/manual/kr/ [Ãâó] [mysql] php¸¦ ÀÌ¿ëÇÑ ÃÊ¿ø½ÃÀûÀÎ mysql Á¢±Ù|ÀÛ¼ºÀÚ ¿Á¤ |