Concert details

[insert_php]
if (get_query_var(“ID”)) {
$ID = get_query_var(“ID”);
}

$db=mysqli_connect(“localhost”,”kristoflodewijk”,”Gd52CDpi”,”kristoflodewijk”);
if (mysqli_connect_errno($db))
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}

$sql_q = “SELECT * FROM music_concerts WHERE ID='”.$ID.”‘”;

$result = mysqli_query($db,$sql_q);

$row = mysqli_fetch_array($result);

echo “

” ;
$band_q =”SELECT * FROM music_bands WHERE ID='”.$row[‘band_ID’].”‘”;
$band = mysqli_query($db, $band_q);
$band_info = mysqli_fetch_array($band);
echo “

“;
$venue_q =”SELECT * FROM music_venues WHERE ID='”.$row[‘venue_ID’].”‘”;
$venue = mysqli_query($db, $venue_q);
$venue_info = mysqli_fetch_array($venue);
echo “

“;
echo “

“;
if (empty($row[‘setlist’])) {
echo “

Date “.$row[‘date’] .”
Band: “.$band_info[‘name’].”
Venue “.$venue_info[‘name’].”
More info “.$row[‘more_info’].”

Setlist Not available

“;
} else {
echo “

“;
}
[/insert_php]

Back to concert overview