



<?php


$host = "webdev.iyaserver.com"; // database server address
$userid = "dent_student"; // database user account name
$userpw = "code4Studentuse"; // database user password
$db = "dent_movies"; // database name

$mysql = new mysqli(
    $host,
    $userid,
    $userpw,
    $db);

if($mysql->connect_errno) {
    echo "db connection error : " . $mysql->connect_error;
    exit();
}
?> 




<!doctype html>



<html>
<head>
<meta charset="utf-8">
<title>Two movie results</title>
<style>
	#container {
		background-color:steelblue;
		width: 90%;
		margin:auto;
		display:flex;
		flex-wrap: wrap;
		padding: 10px;
	}
	h1 {
		flex-basis: 100%;
	}
	.col {
		flex-grow: 1;
		flex-basis: 300px;
		min-height: 300px;
		
	}
	h1, .col {
		background-color: lightsteelblue;
		margin: 10px;
		
	}
</style>
</head>

<body>
	
	<div id="container">
		<h1>headline</h1>
		
		
		
		
		
<?php

$sql =      "SELECT * from view1 WHERE 1=1 AND rating = 'G' AND genre='Comedy";

//  potentially add to $sql with additional WHERE filters like
// $sql .= " AND column  = 'data' OR column like '%term%'";

// potentially add a sort order clause
// $sql .= " ORDER BY columnname";


$results = $mysql->query($sql);

if(!$results) {
    echo "SQL error: ". $mysql->error . " running query <hr>" . $sql . "<hr>";
    exit();
}
// close php block
?>







		<div class="col">
		 
		    <?= $results->num_rows ?>

		    G-rated Comedies
		    <hr>
		    
		    
		    <?php
while( $currentrow = $results->fetch_assoc() ) { // OPEN/active php loop
?>
        <!-- normal html and text, with php output blocks for column values -->
        <?= $currentrow["columnname"] ?> 

<?php
    } // end php loop
?>

			results1
		</div>
		<div class="col">
			results2
		</div>
	</div> 
</body>
</html>
