public function make_banner($author){
$servername = "localhost";
$username = "******";
$password = "";
$dbname = "bolo_creator";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = <<<SQL
SELECT *
FROM wp_usermeta
INNER JOIN wp_users
ON user_id="$author"
WHERE meta_key="agency"
SQL;
if(!$result = $conn->query($sql)){
die('There was an error running the query [' . $db->error . ']');
}
mysqli_close($conn);
$row = $result->fetch_assoc();
$row['meta_value'];
include("header_model.php");
$model = new header_model();
$result = $model->get_agency($row['meta_value']);
$row2 = $result->fetch_assoc();
//show a custom background image for pinecrest bolos
if($row2['name'] == 'Pinecrest'){
echo "
<style type='text/css'>
body {
background-image: url('watermark.jpg');
}
</style> ";
}
?>
<div class="container">
<div id = "pcstation" class="col-md-2" style="text-align:center; padding-top: 25px;">
<img src="<?php echo $row2['logo1'] ?>" width="120" height="137">
</div>
<div class="col-md-8" style=" padding-top: 25px;">
<p style="text-align:center; font-size:15px; text-transform:uppercase; margin-top:10px; color:red;">Unclassified// for official use only// law enforcement sensitive </p>
<h1 style="text-align:center; font-size:24px; margin-bottom:2px; font-weight: bold;"><?php echo $row2['name'] ?> Police Department</h1>
<h3 style="text-align:center; font-size:20px; line-height:1.2em; font-weight:300;"><em><?php echo $row2['st_address'] ?><br><?php echo $row2['city'] ?>, FL, <?php echo $row2['zip'] ?><br><?php echo $row2['phone'] ?></em></h3>
</div>
<div class="col-md-2" style="text-align:center; padding-top: 25px;">
<img src="<?php echo $row2['logo2'] ?>" width="118" height="160">
</div>
<div class = "col-md-12" style="border-bottom: 1px solid #7b7b7b; margin-bottom: 40px;"></div>
</div>
<?php
}//end function
*
* @package Inkness
*/
?>
<?php
include("header_model.php");
//find out the current user's agency (theres some jumping thru hoops,
//will be fixed soon: when BoloSelected.php is added to wordpress)
//case gettin header for new bolo (new bolo form)
$ag_name = get_user_meta(get_current_user_id(), "agency", true);
//get the information of the agency
$model = new header_model();
$result = $model->get_agency($ag_name);
$row = $result->fetch_assoc();
?>
<div class="container">
<div id = "pcstation" class="col-md-2" style="text-align:center; padding-top: 25px;">
<img src="<?php echo $row['logo1'] ?>" width="120" height="137">
</div>
<div class="col-md-8" style=" padding-top: 25px;">
<p style="text-align:center; font-size:15px; text-transform:uppercase; margin-top:10px; color:red;">Unclassified// for official use only// law enforcement sensitive </p>
<h1 style="text-align:center; font-size:24px; margin-bottom:2px; font-weight: bold;"><?php echo $row['name'] ?> Police Department</h1>
<h3 style="text-align:center; font-size:20px; line-height:1.2em; font-weight:300;"><em><?php echo $row['st_address'] ?><br><?php echo $row['city'] ?>, FL, <?php echo $row['zip'] ?><br><?php echo $row['phone'] ?></em></h3>
</div>
<div class="col-md-2" style="text-align:center; padding-top: 25px;">
<img src="<?php echo $row['logo2'] ?>" width="118" height="160">
</div>