화요일, 11월 16, 2010

간단한 php 샘플입니다

<?
$connect = mysql_connect("localhost","comp188","XXXX") or die("not connected");
mysql_select_db("comp188",$connect);

echo "
<table>
  <tr>
    <td>customerid</td>
    <td>name</td>
    <td>address</td>
    <td>creditcardnumber</td>
  </tr>";

$query = "select * from customer";
$result = mysql_query($query) or die("\n<br>Query:$query\n<br>Error:".mysql_error());
while ( $row = mysql_fetch_array($result) ) {
    echo "
  <tr>
    <td>{$row[customerid]}</td>
    <td>{$row[name]}</td>
    <td>{$row[address]}</td>
    <td>{$row[creditcardnumber]}</td>
  </tr>";
}

echo "
</table>";

?>

댓글 없음:

댓글 쓰기