Page 181 - 완) I MDP 프로젝트 작품 보고서(전체과 1학년)1.6
P. 181
- mysql.php
<?php
$conn = mysqli_connect("localhost","root","root","testDB");
if(mysqli_connect_errno()){
echo "Failed to connect to MySQL: ". mysqli_connect_error();
}
$result = mysqli_query($conn,"SELECT * FROM bill");
?>
<style type="text/css">
table, td{
border: 1px solid black;
}
table{
width:60%;
height: 100px;
margin: auto;
text-align: center;
}
</style>
<table>
<tr>
<th> time </th>
<th> price </th>
<th> gift </th>
</tr>
<?php
while($row = mysqli_fetch_array($result)){
echo"
- 174 -
