-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcEntrepreneurship.php
98 lines (98 loc) · 3.98 KB
/
cEntrepreneurship.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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
<?php
@require_once 'includes/config.php';
include('includes/header.php');
?>
<?php
if(isset($_GET['action'])=="Move"){
$id=urldecode(base64_decode($_GET['id']));
$_SESSION['ids'] = $id;
if (!empty($_SESSION['ids'])) {
header("location: postDetails");
}
}
?>
<!-- Top Posts Start -->
<div class="top-post-area">
<div class="container">
<div class="row">
<div class="col-12">
<div class="section-tittle mb-35">
<h2>Entrepreneurship</h2>
</div>
</div>
</div>
<div class="row justify-content-lg-between">
<div class="col-lg-8 col-md-8">
<!-- single-job-content -->
<?php
if (isset($_POST['searchmaster'])) {
$text = $_POST['searchmaster'];
$query = "SELECT * FROM uploads where HEADING LIKE '%$text%' AND CATEGORIES = 'Entrepreneurship' AND APPROVE = 'OK' ORDER BY UP_ID DESC";
$result = mysqli_query($con, $query) or die(mysqli_error($con));
while($row = mysqli_fetch_array( $result))
{
if (strlen($row['STORY']) <=130) {
$out = $row['STORY'];
} else {
$out = substr($row['STORY'], 0, 130) . '...';
}
echo '
<div class="single-job-items mb-30">
<div class="row">
<div class="col-lg-4">
<a href="cEntrepreneurship?id='.urlencode(base64_encode($row['UP_ID'])).'&action=Move"><img src="assets/img/post/'.$row['IMAGES'].'" class="img-fluid" alt=""></a>
</div>
<div class="col-lg-8">
<div class="job-tittle">
<a href="cEntrepreneurship?id='.urlencode(base64_encode($row['UP_ID'])).'&action=Move"><h4>'.$row['HEADING'].'</h4></a>
<p>'.$out.'</p>
</div>
</div>
</div>
</div>';
}
}else{
$query = "SELECT * FROM uploads where CATEGORIES = 'Entrepreneurship' AND APPROVE = 'OK' ORDER BY UP_ID DESC";
$result = mysqli_query($con, $query) or die(mysqli_error($con));
$num = mysqli_num_rows($result);
if ($num > 0) {
while($row = mysqli_fetch_array( $result))
{
if (strlen($row['STORY']) <=130) {
$out = $row['STORY'];
} else {
$out = substr($row['STORY'], 0, 130) . '...';
}
echo '
<div class="single-job-items mb-30">
<div class="row">
<div class="col-lg-4">
<a href="cEntrepreneurship?id='.urlencode(base64_encode($row['UP_ID'])).'&action=Move"><img src="assets/img/post/'.$row['IMAGES'].'" class="img-fluid" alt=""></a>
</div>
<div class="col-lg-8">
<div class="job-tittle">
<a href="cEntrepreneurship?id='.urlencode(base64_encode($row['UP_ID'])).'&action=Move"><h4>'.$row['HEADING'].'</h4></a>
<p>'.$out.'</p>
</div>
</div>
</div>
</div>';
}
}else{
echo '<div class="text-center display-1 justify-content-center">Nothing to Report here</div>';
}
}
?>
</div>
<div class="col-lg-3 col-md-3">
<div class="google-add mb-40 d-none d-lg-block">
<img src="assets/img/gallery/images.jpg" alt="">
</div>
</div>
</div>
</div>
</div>
<!-- Top Posts End -->
<?php
include('includes/footer.php');
?>