// grab config.php - database parameters
include("config.php");
// open database connection
$connection = mysqli_connect($server, $user, $pass, $database);
// generate and execute query
$query = "SELECT * FROM kanji ORDER BY cardno ASC";
$result = mysqli_query($connection, $query);
// if records present
if (mysqli_num_rows($result) > 0)
{
?>
// iterate through resultset
$mycounter = 0;
while($row = mysqli_fetch_object($result))
{
$mycounter = $mycounter + 1;
if(fmod($mycounter-1, 8) == 0){echo "\n";}
?>
echo $row->onreading; ?>
echo $row->kunreading; ?>
|
echo "\n";
if(fmod($mycounter, 8) == 0){echo "
\n";}
}
if(fmod($mycounter, 8) != 0){echo "\n";}
?>
}
else
// if no records present - display message
{ echo "
No card found.
"; }
?>