<th>Description</th>
<th>Vertical Image</th>
<th>Background Image</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
require_once "../config.inc.php";
$db = Database::obtain(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
$db->connect();
$p = new Projects('unknown', BASE_DOMAIN);
$projects = $p->get_projects();
for ($i = 0; $i < count($projects); $i++) {
$id = $projects[$i]['id'];
$cat_id = $projects[$i]['project_category_id'];
$name = $projects[$i]['name'];
$other = $projects[$i]['other'];
$vertical_img = $projects[$i]['vertical_img'];
$bg_img = $projects[$i]['bg_img'];
$description = $projects[$i]['description'];
$active = $projects[$i]['active'];
$cat_name = $p->get_category_name($cat_id);
echo "<tr id=\"" . $id . "\">";
// next field client_id
//not editable
echo "<td>";
echo $id;
// Check to see if we need to log a user out
if (isset($_GET['logout'])) {
if ($_GET['logout']) {
$user->logout();
header('Location: index.php');
}
}
$loggedIn = $user->is_logged_in();
$pageTitle = "AMStevenson Software Engineer | Home Page";
// Set meta description for the page
$metaDescription = "Software developer with over 3 years experience. Free interview to discuss customer needs. I can help with all your website, mobile and desktop development requirements.";
include_once "includes/header.php";
$projects = new Projects($db);
// Get each project
$result = array();
$result = $projects->get_projects();
$projects->array_shuffle($result);
?>
<?php
include_once "includes/header.php";
?>
<!-- Banner -->
<section id="banner">
<div class="inner">
<div class="logo"><span class="icon fa-book"></span></div>
<h2>Adam Stevenson </h2>
<p>Welcome to my corner of the internet. <br> Feel free to browse through my software development projects and nerdy blogs!</p>
</div>
</section>
Other <?php
echo $project_category_name;
?>
Projects:<br>
<?php
echo $other;
?>
<div class="projectIcons">
<?php
$p = new Projects('member', BASE_DOMAIN);
$results = $p->get_projects();
for ($x = 0; $x < count($results); $x++) {
$id = $results[$x]['id'];
$project_category_id = $results[$x]['project_category_id'];
$name = $results[$x]['name'];
$description = $results[$x]['description'];
$other = $results[$x]['other'];
$bg_img = $results[$x]['bg_img'];
$vertical_img = $results[$x]['vertical_img'];
$project_category_name = $p->get_category_name($project_category_id);
$project_category_name = $project_category_name['name'];
$project_link = preg_replace('/\\s+/', '_', $project_category_name);
$project_link = str_replace('-', '_', $project_link);
$project_category_icon = $p->get_category_icon($project_category_id);
//$project_category_icon = $project_category_name['icon'];
if (isset($project_category_icon['icon'])) {
