추적 • php_error_reporting • arduino • phpvirtualbox • php_composer • php_thread_safe

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

다음 판		이전 판
tech:php_mysql_table [2011/08/01 02:37] – 새로 만듦 vaslortech:php_mysql_table [2021/01/24 07:43] (현재) – [Php Mysql Table] 1.238.85.38
줄 1: 줄 1:
 +{{tag>tech php_mysql_table}}
 +======Php Mysql Table======
  
 +
 +
 +
 +<code php>
 +
 +<html>
 +<body>
 +<?php
 +$username="username";
 +$password="password";
 +$database="your_database";
 +
 +mysql_connect(localhost,$username,$password);
 +@mysql_select_db($database) or die( "Unable to select database");
 +$query="SELECT * FROM tablename";
 +
 +//WHERE field1-name='1'
 +
 +$result=mysql_query($query);
 +
 +$num=mysql_num_rows($result);
 +
 +mysql_close();
 +?>
 +<table border="0" cellspacing="2" cellpadding="2">
 +<tr>
 +<th><font face="Arial, Helvetica, sans-serif">Value1</font></th>
 +<th><font face="Arial, Helvetica, sans-serif">Value2</font></th>
 +<th><font face="Arial, Helvetica, sans-serif">Value3</font></th>
 +<th><font face="Arial, Helvetica, sans-serif">Value4</font></th>
 +<th><font face="Arial, Helvetica, sans-serif">Value5</font></th>
 +</tr>
 +
 +<?php
 +$i=0;
 +while ($i < $num) {
 +
 +$f1=mysql_result($result,$i,"field1");
 +$f2=mysql_result($result,$i,"field2");
 +$f3=mysql_result($result,$i,"field3");
 +$f4=mysql_result($result,$i,"field4");
 +$f5=mysql_result($result,$i,"field5");
 +?>
 +
 +<tr>
 +<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
 +<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
 +<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
 +<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
 +<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
 +</tr>
 +
 +<?php
 +$i++;
 +}
 +?>
 +</body>
 +</html>
 +</code>
 +
 +
 +
 +
 +
 +
 +
 +