function showMyAds()
{
require 'dbase.php';
$name = $_SESSION['userAccount'];
//show posted ads
$stmt = $mysqli->prepare("SELECT * FROM ads WHERE seller=?");
if (!$stmt) {
printf("Query Prep Failed: %s\n", $mysqli->error);
exit;
}
$stmt->bind_param('s', $name);
$stmt->execute();
$result = $stmt->get_result();
echo "<table>\n\t\t\t\t<tr>\n\t\t\t\t<th>Title:</th>\n\t\t\t\t<th>Snippet</th>\n\t\t\t\t<th>Price:</th>\n\t\t\t\t<th>Seller:</th>\n\t\t\t\t<th>Category:</th>\n\t\t\t\t<th>Reserve Price:</th>\n\t\t\t\t</tr>";
while ($row = $result->fetch_assoc()) {
$_SESSION['Description'] = $row['snippet'];
echo "<tr>";
echo "<td>" . htmlentities($row['title']) . "</td>";
echo "<td>" . htmlentities($row['snippet']) . "</td>";
echo "<td>" . htmlentities($row['price']) . "</td>";
echo "<td>" . htmlentities($row['seller']) . "</td>";
echo "<td>" . htmlentities($row['catagory']) . "</td>";
echo "<td>" . htmlentities($row['reserve']) . "</td>";
echo "<td>";
deleteAd($row['id']);
editAd($row['id']);
echo "</td>";
echo "</tr>";
}
$stmt->close();
echo "</table>";
}
}
$user = getUserData($_SESSION['uid']);
if (isset($_POST['finalize'])) {
$res = createCampaign($_POST);
if ($res) {
redirect('advertisement.php?mode=manage');
}
}
if (isset($_POST['finalize_edit'])) {
$res = editCampaign($_POST, intval($_GET['cid']));
if ($res) {
redirect('advertisement.php?mode=manage');
}
}
if (isset($_GET['action']) && $_GET['action'] == 'delete') {
deleteAd(intval($_GET['cid']));
redirect('advertisement.php?mode=manage');
}
if (isset($_GET['action']) && $_GET['action'] == 'pause') {
startAd(intval($_GET['cid']), intval($_GET['status']));
redirect('advertisement.php?mode=manage');
}
?>
<div class="inner-page-wrapper">
<div class="finance advertisement inner-page content">
<?php
include DIR_INCLUDE . 'left_nav.php';
?>
