|
include ("../db.php");
// Create connection
$conn = mysqli_connect($servername, $username1, $password1, $database1); //lyjq_agenda
// Check connection
if (!$conn)
{
echo "niet connect agenda";
die("Verbinding mislukt: ") ; //. mysqli_connect_error());
}
// Create connection
$conn1 = mysqli_connect($servername, $username, $password, $database); //lyjq_user
// Check connection
if (!$conn1)
{
echo "niet connect user";
die("Verbinding mislukt: "); // . mysqli_connect_error());
}
display_db_table($tablename1, $conn); //toon fieldnames en rijen van totale tabel
function display_db_table($tablename, $connection) //toon fieldnames en rijen van tabel
{
$sql_tabel = "SELECT * FROM $tablename ORDER BY datum";
$result_id = mysqli_query($connection, $sql_tabel);
$column_count = mysqli_num_fields($result_id)-1; //kolom id niet tonen
print("\n");
print("");
for ($column_num = 0;
$column_num < $column_count;
$column_num++)
{
$field_name = mysqli_fetch_field($result_id);
//printf("Name: %s", $field_name ->name);
printf("%s | ", $field_name ->name); //%s kopieert value van $field_name
//$field[$column_num] = $field_name ->name; // om onderaan tabel nog een keer te herhalen
}
print(" \n");
while ($row = mysqli_fetch_row($result_id))
{
if ($row[1] !== "1970-01-01")
{
print("");
for ($column_num = 0;
$column_num < $column_count;
$column_num++)
{
if ($column_num !=1)
{
print("$row[$column_num] | ");
}
else {
print("".date("d-m-Y", strtotime($row[$column_num]))." | ");
}
}
}
print(" \n");
}
print(" \n");
}
$conn->close();
$conn1->close();
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|