-
Notifications
You must be signed in to change notification settings - Fork 0
/
latestjobs.php
69 lines (61 loc) · 1.98 KB
/
latestjobs.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<h3>Latest Job Listings</h3>
<ul>
<?php
/**
* Created by PhpStorm.
* Time: 2:28 PM
*/
$dbhost = 'localhost';
$dbuser = "user21";
$dbpass = "6k1kTPLe";
$dbname = "user21db";
//*** create a connection object
$conn = mysql_connect($dbhost, $dbuser, $dbpass)
or die (mysql_error());
mysql_select_db($dbname)
or die (mysql_error());
function myTruncate($string, $limit, $break=".", $pad="...")
{
// return with no change if string is shorter than $limit
if(strlen($string) <= $limit) return $string;
// is $break present between $limit and the end of the string?
if(false !== ($breakpoint = strpos($string, $break, $limit))) {
if($breakpoint < strlen($string) - 1) {
$string = substr($string, 0, $breakpoint) . $pad;
}
}
return $string;
}
//*** execute the query
$query = "SELECT job.jid as id, types.t_name as name,types.color as color, job.title as title, job.company_name as company,
job.description as description, job.city as city,
job.state as state, job.post_date as created
FROM job,types where job.type_id = types.tid ORDER BY created desc";
// $query = "SELECT * FROM job, types GROUP BY jid ORDER BY post_date DESC";
$result = mysql_query($query);
$num = mysql_num_rows($result);
if ($num==0) { ?>
<li><img src="images/noresults.jpg"></li>
<?php }
else
{
while ($jobs = mysql_fetch_assoc($result)) {?>
<hr/>
<li>
<div class="type">
<span style="background:<?php echo $jobs['color']; ?>"><?php echo $jobs['name']; ?></span>
</div>
<div class="description">
<h5><a href="details.php?id=<?php echo $jobs['id']; ?>"><?php echo $jobs['title']; ?></a>
(<?php echo $jobs['city']; ?>, <?php echo $jobs['state']; ?>)</h5>
<span id="list_date">
<?php echo date($jobs['created']); ?>
</span>
<p><?php echo myTruncate($jobs['description'], 200, " "); ?></p>
</div>
</li>
<?php
}
}
mysql_free_result($result); ?>
</ul>