From 1a7fa60f6cb2ee26843ca19e37bb4ff44104ad55 Mon Sep 17 00:00:00 2001
From: Bulletin <bulletin@bulletinalpha.tk>
Date: Thu, 29 Dec 2016 16:42:32 -0500
Subject: Added existing progress

---
 dash/headless.php | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 dash/headless.php

(limited to 'dash/headless.php')

diff --git a/dash/headless.php b/dash/headless.php
new file mode 100644
index 0000000..16693cd
--- /dev/null
+++ b/dash/headless.php
@@ -0,0 +1,29 @@
+<?php
+$clicks = 0;
+if (!empty($_GET['clicks'])) $clicks = max(0, intval($_GET['clicks']));
+require('dash_common.php');
+$db = new bdb();
+$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT '.($clicks+10).', 1') or die();
+if ($result->num_rows) {
+  $row = $result->fetch_assoc();
+?>
+      <div class="job">
+        <a href="#" class="jobxbtn"></a>
+        <p class="jobtitle"><a href="ads.php?id=<?=$row['id'];?>"><?=htmlentities($row['title']);?></a></p>
+        <p class="joblocation"><?=htmlentities($row['location']);?></p>
+<?php
+  if (is_null($row['rating']))
+    echo '        <p class="jobstars">Employer Not Rated</p>'.PHP_EOL;
+  else
+    echo '        <p class="jobstars">'.$row['rating'].' Star Employer</p>'.PHP_EOL;
+?>
+        <p class="jobpay">Pays $<?=number_format($row['pay'], 2);?></p>
+        <p class="jobblurb"><?=htmlentities(substr($row['description'], 0, min(strlen($row['description']), 160)));?> <a href="ads.php?id=<?=$row['id'];?>">[...]</a></p>
+        </p>
+
+      </div>
+<?php
+}
+$result->free();
+$db->close();
+?>
-- 
cgit v1.2.3