asked on
<?php
/* Access to the databse via link commands requires the $link statement
in order for them to be successful, also the term "localhost" stops the $link
failing in the event of a change in your IP Address.*/
$link = mysqli_connect("localhost" , "user", "password", "DbName");
?>
// CONNECTION AND SELECTION VARIABLES FOR THE DATABASE
$db_host = "localhost";
$db_name = "DbName";
$db_user = "user";
$db_word = "password";
// OPEN A CONNECTION TO THE DATA BASE SERVER AND SELECT THE DB
$mysqli = new mysqli($db_host, $db_user, $db_word, $db_name);
// DID THE CONNECT/SELECT WORK OR FAIL?
if ($mysqli->connect_errno)
{
$err
= "CONNECT FAIL: "
. $mysqli->connect_errno
. ' '
. $mysqli->connect_error
;
trigger_error($err, E_USER_ERROR);
}
<?php
$query = "select `partID`, `partDescription`, `qtyInStock`, `sales42D`, `sales14D`, `supplierCompany`, `itemCost` FROM inventory";
if ($result=mysqli_query($link, $query)) {
while ($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row['partID'];?></td>
<td><?php echo $row['partDescription'];?></td>
<td><?php echo $row['qtyInStock'];?></td>
<td><?php echo $row['sales42D'];?></td>
<td><?php echo $row['sales14D'];?></td>
<td><?php echo $row['supplierCompany'];?></td>
<td><?php echo $row['itemCost'];?></td>
</tr>
<?php
}
} else {
echo "It failed!";
}
?>