/**
  * Parse a string; mainly used for output filter.
  * @param string $String
  * @param mixed $Object Object related to the string in some way
  * @param string $Format The string-formatter that will parse the string.
  * @param string $FormatPurpose Use the FORMAT_STRING_FOR_DISPLAY constant.
  * @return string
  */
 function FormatString($String, $Object, $Format, $FormatPurpose)
 {
     $sReturn = $this->StringManipulator->Parse($String, $Object, $Format, $FormatPurpose);
     // Now pass the string through global formatters
     $sReturn = $this->StringManipulator->GlobalParse($sReturn, $Object, $FormatPurpose);
     return $sReturn;
 }
Beispiel #2
0
    echo $courseObj->name;
    ?>
</h5>
                                                            <div class="sc_accordion_content">
                                                                <div class="wpb_text_column wpb_content_element ">
                                                                    <div class="wpb_wrapper">
                                                                        <p><?php 
    echo StringManipulator::trimStringToFullWord(200, strip_tags($courseObj->description));
    ?>
..</p>
                                                                        <p>Date: <?php 
    echo $courseObj->endDate;
    ?>
</p>
                                                                        <p><a href="<?php 
    echo SITE_URL . 'course/' . $courseObj->id . '/' . StringManipulator::slugify($courseObj->name) . '/';
    ?>
">View Full Details</a></p>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                    </div>
                                                    <?php 
}
?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </section> <!-- /section class="post_content" itemprop="articleBody" -->	
 /** Method that fetches events from database for JQuery Data Table
  * @param string $column Column name of the data to be fetched
  * @param string $condition Additional condition e.g  event_id > 9
  * @param string $sort column name to be used as sort parameter
  * @return JSON JSON encoded event details
  */
 public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
 {
     $sql = "SELECT {$column} FROM event ORDER BY {$sort}";
     if (!empty($condition)) {
         $sql = "SELECT {$column} FROM event WHERE {$condition} ORDER BY {$sort}";
     }
     if ($customSql != "") {
         $sql = $customSql;
     }
     $data = $this->dbObj->fetchAssoc($sql);
     $result = array();
     $fetEventStat = 'icon-check-empty';
     $fetEventRolCol = 'btn-warning';
     $fetEventRolTit = "Activate Event";
     if (count($data) > 0) {
         foreach ($data as $r) {
             $fetEventStat = 'icon-check-empty';
             $fetEventRolCol = 'btn-warning';
             $fetEventRolTit = "Activate Event";
             if ($r['status'] == 1) {
                 $fetEventStat = 'icon-check';
                 $fetEventRolCol = 'btn-success';
                 $fetEventRolTit = "De-activate Event";
             }
             $result[] = array($r['id'], utf8_encode('<div style="white-space:nowrap"><button data-id="' . $r['id'] . '" data-image="' . $r['image'] . '" data-name="' . $r['name'] . '"  data-location="' . $r['location'] . '" class="btn btn-danger btn-sm delete-event" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button  data-id="' . $r['id'] . '"  data-image="' . $r['image'] . '" data-name="' . $r['name'] . '" data-location="' . $r['location'] . '"  data-date-time="' . $r['date_time'] . '" class="btn btn-info btn-sm edit-event"  title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTdescriptionholder">' . utf8_encode($r['description']) . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-status="' . $r['status'] . '"  class="btn ' . $fetEventRolCol . ' btn-sm activate-event"  title="' . $fetEventRolTit . '"><i class="btn-icon-only ' . $fetEventStat . '"> </i></button></div>'), utf8_encode($r['name']), utf8_encode('<img src="../media/event/' . utf8_encode($r['image']) . '" width="40" height="30" alt="Pix">'), StringManipulator::trimStringToFullWord(90, strip_tags(utf8_encode($r['description']))), utf8_encode($r['date_time']), utf8_encode($r['location']), utf8_encode($r['date_added']));
             //
         }
         $json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
     } else {
         $json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
     }
     $this->dbObj->close();
     //header('Content-type: application/json');
     return json_encode($json);
 }
                                                                    <h6 class="sc_team_item_title">
                                                                        <a href="<?php 
    echo SITE_URL . 'member/' . $memberObj->id . '/' . StringManipulator::slugify($memberObj->name) . '/';
    ?>
"><?php 
    echo $memberObj->name;
    ?>
</a>
                                                                    </h6>
                                                                    <div class="sc_team_item_position"><?php 
    echo $memberObj->qualification;
    ?>
</div>       
                                                                    <div class="sc_team_item_position">
                                                                        <a href="<?php 
    echo SITE_URL . 'member/' . $memberObj->id . '/' . StringManipulator::slugify($memberObj->name) . '/';
    ?>
" data-animation="animated fadeInUp normal" class="sc_button sc_button_square sc_button_style_filled sc_button_bg_menu sc_button_size_small aligncenter animated fadeInUp normal" style="margin-top:10px;margin-bottom:4px;">VIEW INFO</a>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <?php 
}
?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="sc_line sc_line_style_solid" style="margin-top:0px;margin-bottom:0px;border-top-style:solid;"></div>
                                    </div>
<?php

$thisPage->title = StringManipulator::trimStringToFullWord(62, stripslashes(strip_tags(WebPage::getSingleByName($dbObj, 'title', CURRENT_PAGE))) . ' - ' . WEBSITE_AUTHOR);
$thisPage->description = StringManipulator::trimStringToFullWord(150, trim(stripslashes(strip_tags(WebPage::getSingleByName($dbObj, 'description', CURRENT_PAGE)))));
$thisPage->keywords = WebPage::getSingleByName($dbObj, 'keywords', CURRENT_PAGE);
$thisPage->author = WEBSITE_AUTHOR;
 public static function trimStringToFullWord($length, $string)
 {
     if (StringManipulator::mb_strlen($string) <= $length) {
         $string = $string;
         //do nothing
     } else {
         $string = preg_replace('/\\s+?(\\S+)?$/u', '', StringManipulator::mb_substr($string, 0, $length));
     }
     return $string;
 }
 /** Method that fetches courses from database for JQuery Data Table
  * @param string $column Column name of the data to be fetched
  * @param string $condition Additional condition e.g category_id > 9
  * @param string $sort column name to be used as sort parameter
  * @return JSON JSON encoded course details
  */
 public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
 {
     $sql = "SELECT {$column} FROM course ORDER BY {$sort}";
     if (!empty($condition)) {
         $sql = "SELECT {$column} FROM course WHERE {$condition} ORDER BY {$sort}";
     }
     if ($customSql != "") {
         $sql = $customSql;
     }
     $data = $this->dbObj->fetchAssoc($sql);
     $result = array();
     $fetCourseStat = 'icon-check-empty';
     $fetCourseRolCol = 'btn-warning';
     $fetCourseRolTit = "Activate Course";
     if (count($data) > 0) {
         foreach ($data as $r) {
             $courseMediaLink = '';
             $fetCourseStat = 'icon-check-empty';
             $fetCourseRolCol = 'btn-warning';
             $fetCourseRolTit = "Activate Course";
             $fetCourseFeat = 'icon-eye-close';
             $fetCourseFeatCol = 'btn-warning';
             $fetCourseFeatTit = "Make Featured Course";
             if ($r['status'] == 1) {
                 $fetCourseStat = 'icon-check';
                 $fetCourseRolCol = 'btn-success';
                 $fetCourseRolTit = "De-activate Course";
             }
             if ($r['featured'] == 1) {
                 $fetCourseFeat = 'icon-eye-open';
                 $fetCourseFeatCol = 'btn-success';
                 $fetCourseFeatTit = "Remove Course as Featured";
             }
             if ($r['media'] != '') {
                 $courseMediaLink = '<a href="' . SITE_URL . 'media/course/' . $r['media'] . '">View Media</a>';
             }
             $result[] = array($r['id'], utf8_encode($r['name']), utf8_encode($r['short_name']), CourseCategory::getName($this->dbObj, $r['category']), utf8_encode($r['start_date']), utf8_encode($r['end_date']), utf8_encode($r['code']), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['description'])))), utf8_encode($courseMediaLink), utf8_encode($r['currency'] . ' ' . number_format($r['amount'])), utf8_encode('<img src="../media/course-image/' . utf8_encode($r['image']) . '" width="60" height="50" style="width:60px; height:50px;" alt="Pix">'), utf8_encode($r['date_registered']), utf8_encode(' <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-currency="' . $r['currency'] . '" data-short-name="' . $r['short_name'] . '" data-category="' . $r['category'] . '" data-start-date="' . $r['start_date'] . '" data-end-date="' . $r['end_date'] . '" data-code="' . $r['code'] . '" data-description ="" data-media="' . $r['media'] . '"  data-image="' . $r['image'] . '" data-amount="' . $r['amount'] . '" data-date-registered="' . $r['date_registered'] . '" class="btn btn-info btn-sm edit-course"  title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTdescriptionholder">' . $r['description'] . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-currency="' . $r['currency'] . '" data-status="' . $r['status'] . '"  class="btn ' . $fetCourseRolCol . ' btn-sm activate-course"  title="' . $fetCourseRolTit . '"><i class="btn-icon-only ' . $fetCourseStat . '"> </i></button> <button data-id="' . $r['id'] . '" data-media="' . $r['media'] . '"  data-image="' . $r['image'] . '" data-name="' . $r['name'] . '" class="btn btn-danger btn-sm delete-course" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-currency="' . $r['currency'] . '" data-featured="' . $r['featured'] . '"  class="btn ' . $fetCourseFeatCol . ' btn-sm make-featured-course"  title="' . $fetCourseFeatTit . '"><i class="btn-icon-only ' . $fetCourseFeat . '"> </i></button>'));
             //
         }
         $json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
     } else {
         $json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
     }
     $this->dbObj->close();
     //header('Content-type: application/json');
     return json_encode($json);
 }
    echo SITE_URL . 'member/' . $memberObj->id . '/' . StringManipulator::slugify($memberObj->name);
    ?>
/" title="title" class="main-color-1-hover"><?php 
    echo $memberObj->name;
    ?>
</a></h3>
                                                        <div class="text-info" style="display:block;line-height:1.3;font-size:9px;text-transform:none; margin-bottom:6px">(<?php 
    echo $memberObj->qualification;
    ?>
)</div>
                                                        <h4 class="small-text text-success"><?php 
    echo $memberObj->field;
    ?>
</h4>
                                                        <p style="text-align:justify"><?php 
    echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($memberObj->bio))));
    ?>
</p>
                                                        <ul class="list-inline social-light text-center">
                                                            <li><a class="btn btn-default social-icon" href="mailto:<?php 
    echo $memberObj->email;
    ?>
"><i class="fa fa-envelope"></i></a></li>
                                                            <li><a class="btn btn-default social-icon" href="<?php 
    echo $memberObj->website;
    ?>
"><i class="fa fa-globe"></i></a></li>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </div>
Beispiel #9
0
            case 'dateTime':
                $dateTimeParam = explode(' ', $event[$value]);
                $eventTime = $dateTimeParam[1];
                $dateParam = explode('/', $dateTimeParam[0]);
                $dateObj = DateTime::createFromFormat('!m', $dateParam[1]);
                $eventObj->{$key} = $dateParam[2] . ' ' . $dateObj->format('F') . ', ' . $dateParam[0] . '.';
                break;
            default:
                $eventObj->{$key} = $event[$value];
                break;
        }
    }
}
//Override page-properties
$thisPage->title = StringManipulator::trimStringToFullWord(62, stripslashes(strip_tags($eventObj->name . " - " . WEBSITE_AUTHOR)));
$thisPage->description = StringManipulator::trimStringToFullWord(150, trim(stripslashes(strip_tags($eventObj->description))));
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
    <?php 
include 'includes/meta-tags.php';
?>
    <style type="text/css">img.wp-smiley,img.emoji {display: inline !important;border: none !important;box-shadow: none !important;height: 1em !important;width: 1em !important;margin: 0 .07em !important;vertical-align: -0.1em !important;background: none !important;padding: 0 !important; }</style>
    <link rel='stylesheet' id='rs-plugin-settings-css'  href='<?php 
echo SITE_URL;
?>
plugins/revslider/rs-plugin/css/settings1dc6.css?ver=4.6.5' type='text/css' media='all' />
    <link rel='stylesheet' id='themerex-prettyphoto-style-css'  href='<?php 
echo SITE_URL;
?>
Beispiel #10
0
    ?>
</p>
                        <p><strong>Start Date:</strong> <?php 
    echo str_replace("-", "@", $contestObj->startDate);
    ?>
</p>
                        <p><strong>End Date:</strong> <?php 
    echo str_replace("-", "@", $contestObj->endDate);
    ?>
</p>
                        <p>
                            <a href="<?php 
    echo SITE_URL . "contest/{$contestObj->id}/" . StringManipulator::slugify($contestObj->title) . "/";
    ?>
" class="btn btn-primary">Enter Now!</a> <a href="<?php 
    echo SITE_URL . "contest/{$contestObj->id}/" . StringManipulator::slugify($contestObj->title) . "/";
    ?>
" class="btn btn-default">More Info!</a>
                        </p>
                    </div>
                </div>
            </div>
            <?php 
}
?>
        </div>
        <!-- /.row -->
        <hr>
        <!-- Footer -->
        <footer>
            <div class="row">
Beispiel #11
0
            $cfg->infoMessage = '<h3>Contest invitation failed!</h3> <p>Please try again later.</p>';
        }
    } else {
        $cfg->infoMessage = $thisPage->showError($errorArr);
    }
}
//Refered Visitor's Handler
if (filter_input(INPUT_GET, "referer") != NULL && filter_input(INPUT_GET, "invitee") != NULL) {
    $entrantObj->email = Entrant::getSingle($dbObj, 'email', filter_input(INPUT_GET, "referer", FILTER_VALIDATE_INT));
    $entrantObj->friends = filter_input(INPUT_GET, "invitee") ? filter_input(INPUT_GET, "invitee") : "";
    $entrantObj->contest = $thisContestId;
    $friendNamesList = Entrant::getSingle($dbObj, 'names', $entrantObj->email);
    $friendEmailsList = Entrant::getSingle($dbObj, 'friends', $entrantObj->email);
    $friendEmailsArr = explode(",", $friendEmailsList);
    $friendNamesArr = explode(",", $friendNamesList);
    $inviteeName = $friendNamesArr[array_search(trim($entrantObj->friends), $friendEmailsArr)];
    //strrpos($friendNamesList, $friendNamesArr[array_search(trim($entrantObj->friends), $friendEmailsArr)]."[m]");
    if (in_array(trim($entrantObj->friends), $friendEmailsArr) && !strrpos($inviteeName, "[m]")) {
        if ($entrantObj->emailExists() == true) {
            //Existing Entrant handler
            $entrantObj->point = Number::getNumber($contestObj->point) + Entrant::getSingle($dbObj, 'point', $entrantObj->email);
            //fetch current point
            $entrantObj->updateSingleRaw($dbObj, "point", $entrantObj->point, $entrantObj->email);
            $entrantObj->updateSingleRaw($dbObj, "names", str_ireplace($inviteeName, $inviteeName . "[m]", $friendNamesList), $entrantObj->email);
        }
    }
    $thisPage->redirectTo(SITE_URL . "contest/{$contestObj->id}/" . StringManipulator::slugify($contestObj->title) . "/");
}
include 'includes/other-settings.php';
$thisPage->author = $cfg->author;
include $cfg->templateLoc . $cfg->templateName . '/index.php';
 private static function _resizeThumb($arr)
 {
     $temp_file_path = $arr['img_src'];
     if (StringManipulator::get_last_character_in_string($temp_file_path) == '/') {
         $temp_file_path = substr($temp_file_path, 0, -1);
     }
     $arr['temp_file_destination'] = substr($temp_file_path, 0, strrpos($temp_file_path, '/'));
     $arr['temp_file_name'] = substr($temp_file_path, strrpos($temp_file_path, '/'));
     $arr['final_file_destination'] = $arr['uploaddir'];
     $arr['final_file_name'] = strtolower($arr['final_filename'] . '.' . $arr['file_extension']);
     //'.jpg';
     echo self::_cropImg($arr);
     if ($arr['exit_on_end']) {
         exit;
     }
     $callback = $arr['on_end_callback'];
     $callback_path = $arr['on_end_callback_path'];
     if (file_exists($callback_path)) {
         require_once $callback_path;
         if (function_exists($callback)) {
             $callback();
         }
     }
 }
Beispiel #13
0
echo SITE_URL . 'courses/public-sector/';
?>
">Public Sector Courses</a></li>
                                            </ul>
                                        </li>
                                        <li id="menu-item-1398" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-1398"><a href="<?php 
echo SITE_URL . 'course-categories/';
?>
">Course Categories</a>
                                            <ul class="sub-menu">
                                                <?php 
$menuCatObj = new CourseCategory($dbObj);
foreach ($menuCatObj->fetchRaw("*", " 1=1 ", " name ASC ") as $menuCategory) {
    ?>
                                                <li id="menu-item-1399" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1399"><a href="<?php 
    echo SITE_URL . 'courses/category/' . $menuCategory['id'] . '/' . StringManipulator::slugify($menuCategory['name']) . '/';
    ?>
"><?php 
    echo $menuCategory['name'];
    ?>
</a></li>
                                                <?php 
}
?>
                                            </ul>
                                        </li>
                                    </ul>
                                </li>
                                <li id="menu-item-829" class="menu-item menu-item-type-post_type menu-item-object-page <?php 
echo $thisPage->active($_SERVER['REQUEST_URI'], 'member', 'current-menu-item  current_page_item');
?>
                                                                    </a>
                                                                </div>
                                                                <h4 class="ev-title">
                                                                    <a href="<?php 
    echo SITE_URL;
    ?>
category/<?php 
    echo $relatedCategoryObj->id . "/" . StringManipulator::slugify($relatedCategoryObj->name);
    ?>
/" class="related-ev-title main-color-1-hover"><?php 
    echo $relatedCategoryObj->name;
    ?>
</a>
                                                                </h4>
                                                                <div class="ev-start small-text" style="text-transform: none"><?php 
    echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($relatedCategoryObj->description))));
    ?>
</div>
                                                                <div class="clear"></div>
                                                            </div>
                                                            <?php 
}
?>
 
                                                        </div>
                                                   </div>
                                                </div>
                                            </div><!--/event-content-->
                                            
                                        </div><!--/single-event-detail-->																	
                                    </div>
    echo $category['name'];
    ?>
" class="main-color-1-hover"><?php 
    echo $category['name'];
    ?>
</a></h3>
                                                                                        <div class="shortcode-blog-excerpt"><?php 
    echo StringManipulator::trimStringToFullWord(250, trim(stripcslashes(strip_tags($category['description']))));
    ?>
</div>
                                                                                        <div class="item-meta">
                                                                                            <a class="btn btn-default btn-lighter" href="<?php 
    echo SITE_URL;
    ?>
category/<?php 
    echo $category['id'] . "/" . StringManipulator::slugify($category['name']);
    ?>
/" title="<?php 
    echo $category['name'];
    ?>
">DETAILS <i class="fa fa-angle-right"></i></a>
                                                                                            <a href="category?id=<?php 
    echo $category['id'];
    ?>
" class="main-color-1-hover" title="View comments"></a>
                                                                                        </div>
                                                                                    </div>
                                                                                </div>
                                                                            </div>
                                                                        </div><!--/post-item-->
                                                                    </div>
/" title="<?php 
        echo $course['name'];
        ?>
">
                                                                                    <h4><?php 
        echo $course['name'];
        ?>
</h4>
                                                                                    <span class="price yellow"> <?php 
        echo $course['currency'] . ' ' . number_format($course['amount'], 2);
        ?>
</span>
                                                                                    </a>
                                                                                    <div class="overlay-bottom">
                                                                                        <div><?php 
        echo StringManipulator::trimStringToFullWord(250, trim(stripcslashes(strip_tags($course['description']))));
        ?>
</div>
                                                                                    </div>
                                                                                </div>
                                                                            </div><!--/event-item-->
                                                                        </div>
                                                                    </div><!--/post-carousel-item-->
                                                                    <?php 
    }
    ?>
                                                                </div>
                                                            </div>
                                                        </div><!--/section-inner-->
                                                    </section><!--/u-post-carousel-->
                                                </div>
 /**
  * create the li element for ul
  */
 private function _showDay($cellNumber)
 {
     if ($this->currentDay == 0) {
         $firstDayOfTheWeek = date('N', strtotime($this->currentYear . '-' . $this->currentMonth . '-01'));
         if (intval($cellNumber) == intval($firstDayOfTheWeek)) {
             $this->currentDay = 1;
         }
     }
     if ($this->currentDay != 0 && $this->currentDay <= $this->daysInMonth) {
         $this->currentDate = date('Y-m-d', strtotime($this->currentYear . '-' . $this->currentMonth . '-' . $this->currentDay));
         $cellContent = $this->currentDay;
         $this->currentDay++;
     } else {
         $this->currentDate = null;
         $cellContent = null;
     }
     $now = new DateTime();
     $realToday = $now->format('Y-m-d');
     $styledVal = '';
     if ($this->currentDate == $realToday) {
         $styledVal = "text-decoration:underline;";
     }
     $thisReturnVal = '<li style="' . $styledVal . '" id="li-' . $this->currentDate . '" class="' . ($cellNumber % 7 == 1 ? ' start ' : ($cellNumber % 7 == 0 ? ' end ' : ' ')) . ($cellContent == null ? 'mask' : '') . '">' . $cellContent . '</li>';
     $calCourseObj = new Course(self::$dbObj);
     $calCourseToday = $calCourseObj->fetchRaw("*", " status = 1 AND start_date = '{$this->currentDate}' ", " id LIMIT 1");
     if (count($calCourseToday) > 0) {
         foreach ($calCourseToday as $calCourseTod) {
             $thisReturnVal = '<li style="' . $styledVal . '" id="li-' . $this->currentDate . '" class="' . ($cellNumber % 7 == 1 ? ' start ' : ($cellNumber % 7 == 0 ? ' end ' : ' ')) . ($cellContent == null ? 'mask' : '') . '"><a title="' . $calCourseTod['name'] . '" href="' . SITE_URL . 'course/' . $calCourseTod['id'] . '/' . StringManipulator::slugify($calCourseTod['name']) . '/' . '">' . $cellContent . '</a></li>';
         }
     }
     return $thisReturnVal;
 }
Beispiel #18
0
 /** Method that fetches sponsors from database for JQuery Data Table
  * @param string $column Column name of the data to be fetched
  * @param string $condition Additional condition e.g  sponsor_id > 9
  * @param string $sort column name to be used as sort parameter
  * @return JSON JSON encoded course sponsor details
  */
 public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
 {
     $sql = "SELECT {$column} FROM sponsor ORDER BY {$sort}";
     if (!empty($condition)) {
         $sql = "SELECT {$column} FROM sponsor WHERE {$condition} ORDER BY {$sort}";
     }
     if ($customSql != "") {
         $sql = $customSql;
     }
     $data = $this->dbObj->fetchAssoc($sql);
     $result = array();
     $fetSponsorStat = 'icon-check-empty';
     $fetSponsorRolCol = 'btn-warning';
     $fetSponsorRolTit = "Activate Sponsor";
     if (count($data) > 0) {
         foreach ($data as $r) {
             $fetSponsorStat = 'icon-check-empty';
             $fetSponsorRolCol = 'btn-warning';
             $fetSponsorRolTit = "Activate Sponsor";
             $multiActionBox = '<input type="checkbox" class="multi-action-box" data-id="' . $r['id'] . '" data-image="' . $r['image'] . '" data-logo="' . $r['logo'] . '" data-name="' . $r['name'] . '" data-status="' . $r['status'] . '"/>';
             if ($r['status'] == 1) {
                 $fetSponsorStat = 'icon-check';
                 $fetSponsorRolCol = 'btn-success';
                 $fetSponsorRolTit = "De-activate Sponsor";
             }
             $result[] = array(utf8_encode($multiActionBox), $r['id'], utf8_encode(' <button data-id="' . $r['id'] . '" data-logo="' . $r['logo'] . '" data-image="' . $r['image'] . '" data-name="' . $r['name'] . '"  data-website="' . $r['website'] . '" class="btn btn-danger btn-sm delete-sponsor" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button  data-id="' . $r['id'] . '"  data-image="' . $r['image'] . '" data-logo="' . $r['logo'] . '" data-name="' . $r['name'] . '" data-product="' . $r['product'] . '"  data-website="' . $r['website'] . '" class="btn btn-info btn-sm edit-sponsor"  title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTdescriptionholder">' . utf8_encode($r['description']) . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-status="' . $r['status'] . '"  class="btn ' . $fetSponsorRolCol . ' btn-sm activate-sponsor"  title="' . $fetSponsorRolTit . '"><i class="btn-icon-only ' . $fetSponsorStat . '"> </i></button>'), utf8_encode($r['name']), utf8_encode('<img src="../media/sponsor/' . utf8_encode($r['logo']) . '" width="40" height="30" alt="Pix">'), utf8_encode('<a href="' . $r['website'] . '" target="_blank">Visit Website</a>'), utf8_encode($r['date_added']), utf8_encode($r['product']), StringManipulator::trimStringToFullWord(60, strip_tags(utf8_encode($r['description']))), utf8_encode('<img src="../media/sponsor-image/' . utf8_encode($r['image']) . '" width="40" height="30" alt="Pix">'));
             //
         }
         $json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
     } else {
         $json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
     }
     $this->dbObj->close();
     //header('Content-type: application/json');
     return json_encode($json);
 }
if (filter_input(INPUT_POST, "delete-advert") !== NULL) {
    $advertToDel = new Advert();
    //Instantiate post class
    $advertToDel->id = filter_input(INPUT_POST, 'hidden-advert-id') ? mysqli_real_escape_string($dbObj->connection, filter_input(INPUT_POST, 'hidden-advert-id', FILTER_VALIDATE_INT)) : '';
    if (filter_input(INPUT_POST, 'hidden-advert-id') === "") {
        array_push($errorArr, "Illegal Operation.");
    }
    //If validated and not empty submit it to database
    if (count($errorArr) < 1) {
        $advertToDel->background = Advert::getSingle($dbObj, 'background', $advertToDel->id) ? MEDIA_FILES_PATH . Advert::getSingle($dbObj, 'background', $advertToDel->id) : '';
        $advertToDel->zoneOne = Advert::getSingle($dbObj, 'zone_one', $advertToDel->id) ? MEDIA_FILES_PATH . Advert::getSingle($dbObj, 'zone_one', $advertToDel->id) : '';
        $advertToDel->zoneOneAlt = Advert::getSingle($dbObj, 'zone_one_alt', $advertToDel->id) ? MEDIA_FILES_PATH . Advert::getSingle($dbObj, 'zone_one_alt', $advertToDel->id) : '';
        $advertToDel->zoneTwo = Advert::getSingle($dbObj, 'zone_two', $advertToDel->id) ? MEDIA_FILES_PATH . Advert::getSingle($dbObj, 'zone_two', $advertToDel->id) : '';
        $advertToDel->zoneTwoAlt = Advert::getSingle($dbObj, 'zone_two_alt', $advertToDel->id) ? MEDIA_FILES_PATH . Advert::getSingle($dbObj, 'zone_two_alt', $advertToDel->id) : '';
        $advertToDel->zoneThree = Advert::getSingle($dbObj, 'zone_three', $advertToDel->id) ? MEDIA_FILES_PATH . Advert::getSingle($dbObj, 'zone_three', $advertToDel->id) : '';
        if ($advertToDel->delete($dbObj) === 'success' && StringManipulator::arrayNotEmpty($advertToDel->background, $advertToDel->zoneOne, $advertToDel->zoneOneAlt, $advertToDel->zoneTwo, $advertToDel->zoneTwoAlt, $advertToDel->zoneThree)) {
            $postVars = array('background', 'zoneOne', 'zoneOneAlt', 'zoneTwo', 'zoneTwoAlt', 'zoneThree');
            foreach ($postVars as $postVar) {
                switch ($postVar) {
                    default:
                        if (file_exists($advertToDel->{$postVar})) {
                            unlink($advertToDel->{$postVar});
                        }
                        break;
                }
            }
            $msg = $thisPage->messageBox('Advert successfully deleted.', 'success');
        } else {
            $msg = $thisPage->messageBox('Advert deletion failed.', 'error');
        }
    } else {
?>
themes/education/skins/education/images/bg_over.png); background-repeat: repeat-x; background-position: center top; background-color:#1eaace;">
                <div class="content_wrap">
                    <div class="breadcrumbs">
                        <a class="breadcrumbs_item home" href="<?php 
echo SITE_URL;
?>
">Home</a><span class="breadcrumbs_delimiter"></span>
                        <?php 
if ($refName != 'home') {
    ?>
<a class="breadcrumbs_item home" href="<?php 
    echo $referer;
    ?>
"><?php 
    echo strip_tags(WebPage::getSingleByName($dbObj, 'title', $refName));
    ?>
</a><span class="breadcrumbs_delimiter"></span><?php 
}
?>
                        <span class="breadcrumbs_item current"><?php 
echo StringManipulator::trimStringToFullWord(20, explode(" - ", $thisPage->title)[0]);
?>
</span>							
                    </div>
                    <h2 class="page_title"><?php 
echo explode(" - ", $thisPage->title)[0];
?>
</h2>
                </div>
            </div>              <!-- /.page_top_breadcrumbs -->
                                                                <div class="ev-start small-text"><i class="fa fa-map-marker"></i> <?php 
    echo $eventObj->location;
    ?>
</div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="project-item-excerpt">
                                                        <div class="exerpt-text text-justify"><?php 
    echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($eventObj->description))));
    ?>
&hellip; <a href="<?php 
    echo SITE_URL;
    ?>
event/<?php 
    echo $eventObj->id . '/' . StringManipulator::slugify($eventObj->name);
    ?>
/" class="btn btn-danger btn-sm text-success" style="max-height:25px;padding:2px;border-color:transparent">More</a></div>
                                                    </div>
                                                </div><!--item-content-->
                                            </div>
                                        </div><!--col-md-3-->
                                        <?php 
}
?>
                                    </div>
                                </div>
                            </div><!--/content-->
                        </div><!--/row-->
                    </div><!--/content-pad-3x-->
                </div><!--/container-->
 // Form fields names
 $oldHeader = $_REQUEST['oldHeader'];
 $oldLogo = $_REQUEST['oldLogo'];
 //Validate the POST variables and add up to error message if empty
 foreach ($postVars as $postVar) {
     switch ($postVar) {
         case 'header':
             $newHeader = basename($_FILES["header"]["name"]) ? rand(100000, 1000000) . "_" . StringManipulator::slugify(filter_input(INPUT_POST, 'title')) . "." . pathinfo(basename($_FILES["header"]["name"]), PATHINFO_EXTENSION) : "";
             $contestObj->{$postVar} = $newHeader;
             if ($contestObj->{$postVar} == "") {
                 $contestObj->{$postVar} = $oldHeader;
             }
             $contestHeaderFil = $newHeader;
             break;
         case 'logo':
             $newLogo = basename($_FILES["logo"]["name"]) ? rand(100000, 1000000) . "_" . StringManipulator::slugify(filter_input(INPUT_POST, 'title')) . "." . pathinfo(basename($_FILES["logo"]["name"]), PATHINFO_EXTENSION) : "";
             $contestObj->{$postVar} = $newLogo;
             if ($contestObj->{$postVar} == "") {
                 $contestObj->{$postVar} = $oldLogo;
             }
             $contestLogoFil = $newLogo;
             break;
         case 'css':
             $contestObj->{$postVar} = filter_input(INPUT_POST, $postVar) ? mysqli_real_escape_string($dbObj->connection, filter_input(INPUT_POST, $postVar)) : '';
             break;
         default:
             $contestObj->{$postVar} = filter_input(INPUT_POST, $postVar) ? mysqli_real_escape_string($dbObj->connection, filter_input(INPUT_POST, $postVar)) : '';
             if ($contestObj->{$postVar} == "") {
                 array_push($errorArr, " {$postVar} ");
             }
             break;
                                                                    </a>
                                                                </div>
                                                                <h4 class="ev-title">
                                                                    <a href="<?php 
    echo SITE_URL;
    ?>
event/<?php 
    echo $otherEventObj->id . "/" . StringManipulator::slugify($otherEventObj->name);
    ?>
/" class="related-ev-title main-color-1-hover"><?php 
    echo $otherEventObj->name;
    ?>
</a>
                                                                </h4>
                                                                <div class="ev-start small-text" style="text-transform: none;text-align: justify"><?php 
    echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($otherEventObj->description))));
    ?>
</div>
                                                                <br/>
                                                                <div class="ev-start small-text"><i class="fa fa-calendar"></i> <?php 
    echo explode(' ', $otherEventObj->dateTime)[0];
    ?>
</div>
                                                                <div class="ev-start small-text"><i class="fa fa-clock-o"></i> <?php 
    echo explode(' ', $otherEventObj->dateTime)[1];
    ?>
</div>
                                                                <div class="ev-start small-text"><i class="fa fa-map-marker"></i> <?php 
    echo $otherEventObj->location;
    ?>
</div>
foreach ($memberObj->fetchRaw("*", " id = {$thisMemberId} ") as $member) {
    $memberData = array('id' => 'id', 'name' => 'name', 'picture' => 'picture', 'bio' => 'bio', 'website' => 'website', 'qualification' => 'qualification', 'field' => 'field', 'email' => 'email');
    foreach ($memberData as $key => $value) {
        switch ($key) {
            case 'picture':
                $memberObj->{$key} = MEDIA_FILES_PATH1 . 'tutor/' . $member[$value];
                break;
            default:
                $memberObj->{$key} = $member[$value];
                break;
        }
    }
}
//Override page-properties
$thisPage->title = StringManipulator::trimStringToFullWord(62, stripslashes(strip_tags($memberObj->name . " Profile - " . WEBSITE_AUTHOR)));
$thisPage->description = StringManipulator::trimStringToFullWord(150, trim(stripslashes(strip_tags($memberObj->bio))));
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
    <?php 
include 'includes/meta-tags.php';
?>
    <script type="text/javascript"> window._wpemojiSettings = { "baseUrl":"http:\/\/s.w.org\/images\/core\/emoji\/72x72\/","ext":".png","source":{"concatemoji":"http:\/\/tsigroups.com\/tsi-new1\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.3.1"}}; !function(a,b,c){function d(a){var c=b.createElement("canvas"),d=c.getContext&&c.getContext("2d");return d&&d.fillText?(d.textBaseline="top",d.font="600 32px Arial","flag"===a?(d.fillText(String.fromCharCode(55356,56812,55356,56807),0,0),c.toDataURL().length>3e3):(d.fillText(String.fromCharCode(55357,56835),0,0),0!==d.getImageData(16,16,1,1).data[0])):!1}function e(a){var c=b.createElement("script");c.src=a,c.type="text/javascript",b.getElementsByTagName("head")[0].appendChild(c)}var f,g;c.supports={simple:d("simple"),flag:d("flag")},c.DOMReady=!1,c.readyCallback=function(){c.DOMReady=!0},c.supports.simple&&c.supports.flag||(g=function(){c.readyCallback()},b.addEventListener?(b.addEventListener("DOMContentLoaded",g,!1),a.addEventListener("load",g,!1)):(a.attachEvent("onload",g),b.attachEvent("onreadystatechange",function(){"complete"===b.readyState&&c.readyCallback()})),f=c.source||{},f.concatemoji?e(f.concatemoji):f.wpemoji&&f.twemoji&&(e(f.twemoji),e(f.wpemoji)))}(window,document,window._wpemojiSettings);</script>
    <style type="text/css"> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 .07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } </style>
    <link rel='stylesheet' id='rs-plugin-settings-css'  href='plugins/revslider/public/assets/css/settings5bca.css?ver=5.0.4.1' type='text/css' media='all' />
    <style id='rs-plugin-settings-inline-css' type='text/css'>.tp-caption a{color:#ff7302;text-shadow:none;-webkit-transition:all 0.2s ease-out;-moz-transition:all 0.2s ease-out;-o-transition:all 0.2s ease-out;-ms-transition:all 0.2s ease-out}.tp-caption a:hover{color:#ffa902}</style>
    <link rel='stylesheet' id='wp-pagenavi-css'  href='<?php 
echo SITE_URL;
?>
plugins/wp-pagenavi/pagenavi-css44fd.css?ver=2.70' type='text/css' media='all' />
                                                    <a title="View Courses" href="<?php 
    echo SITE_URL . 'courses/category/' . $categoryObj->id . '/' . StringManipulator::slugify($categoryObj->name) . '/';
    ?>
" class="post_info_date"><?php 
    echo number_format(Course::getSingleCategoryCount($dbObj, $categoryObj->id));
    ?>
</a>
                                                </span>
                                            </div>
                                            <div class="post_descr">
                                                <p class="text-justify"><?php 
    echo StringManipulator::trimStringToFullWord(160, strip_tags($categoryObj->description));
    ?>
</p>
                                                <a title="View Courses" href="<?php 
    echo SITE_URL . 'courses/category/' . $categoryObj->id . '/' . StringManipulator::slugify($categoryObj->name) . '/';
    ?>
" class="sc_button sc_button_square sc_button_style_filled sc_button_bg_link sc_button_size_small">VIEW COURSES</a>					
                                            </div>
                                        </div>				<!-- /.post_content -->
                                    </article>	<!-- /.post_item -->
                                </div>						<!-- /.isotope_item -->
                                <?php 
}
?>
                            </div> <!-- /.isotope_wrap -->
                        </div> <!-- /div class="content" -->
                    </div> <!-- /div class="content_wrap" -->			
                </div>		<!-- /.page_content_wrap -->
			
		<?php 
    ?>
" class="attachment-thumb_80x80 wp-post-image" alt="<?php 
    echo $sideEvent['name'];
    ?>
" />
                                            <div class="thumbnail-hoverlay main-color-1-bg"></div>
                                            <div class="thumbnail-hoverlay-cross"></div>
                                    </div>
                            </a>
                        </div>
                        <div class="u-details item-content">
                            <h5><a href="<?php 
    echo SITE_URL;
    ?>
event/<?php 
    echo $sideEvent['id'] . '/' . StringManipulator::slugify($sideEvent['name']);
    ?>
/" title="<?php 
    echo $sideEvent['name'];
    ?>
" class="main-color-1-hover"><?php 
    echo $sideEvent['name'];
    ?>
</a></h5>
                            <span><?php 
    echo $sideEvent['date_time'];
    ?>
</span>
                        </div>
                        <div class="clearfix"></div>
                            
 /** Method that fetches tutors from database for JQuery Data Table
  * @param string $column Column name of the data to be fetched
  * @param string $condition Additional condition e.g tutor_id > 9
  * @param string $sort column name to be used as sort parameter
  * @return JSON JSON encoded tutor details
  */
 public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
 {
     $sql = "SELECT {$column} FROM {$this->tableName} ORDER BY {$sort}";
     if (!empty($condition)) {
         $sql = "SELECT {$column} FROM {$this->tableName} WHERE {$condition} ORDER BY {$sort}";
     }
     if ($customSql != "") {
         $sql = $customSql;
     }
     $data = $this->dbObj->fetchAssoc($sql);
     $result = array();
     $fetTutorStat = 'icon-check-empty';
     $fetTutorRolCol = 'btn-warning';
     $fetTutorRolTit = "Activate Tutor";
     if (count($data) > 0) {
         foreach ($data as $r) {
             $fetTutorStat = 'icon-check-empty';
             $fetTutorRolCol = 'btn-warning';
             $fetTutorRolTit = "Activate Tutor";
             if ($r['visible'] == 1) {
                 $fetTutorStat = 'icon-check';
                 $fetTutorRolCol = 'btn-success';
                 $fetTutorRolTit = "De-activate Tutor";
             }
             $result[] = array($r['id'], utf8_encode(' <button data-id="' . $r['id'] . '" data-picture="' . $r['picture'] . '" data-name="' . $r['name'] . '" class="btn btn-danger btn-small delete-tutor" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-qualification="' . $r['qualification'] . '" data-field="' . $r['field'] . '" data-email="' . $r['email'] . '" data-website="' . $r['website'] . '" data-picture="' . $r['picture'] . '" class="btn btn-info btn-small edit-tutor"  title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span id="JQDTbioholder" data-bio ="" class="hidden">' . $r['bio'] . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-visible="' . $r['visible'] . '"  class="btn ' . $fetTutorRolCol . ' btn-small activate-tutor"  title="' . $fetTutorRolTit . '"><i class="btn-icon-only ' . $fetTutorStat . '"> </i></button>'), utf8_encode('<img src="../media/tutor/' . utf8_encode($r['picture']) . '" style="width:60px; height:50px;" alt="Pix">'), utf8_encode($r['name']), StringManipulator::trimStringToFullWord(40, utf8_encode(stripslashes(strip_tags($r['qualification'])))), StringManipulator::trimStringToFullWord(40, utf8_encode(stripslashes(strip_tags($r['field'])))), StringManipulator::trimStringToFullWord(62, utf8_encode(stripslashes(strip_tags($r['bio'])))), utf8_encode($r['email']), utf8_encode($r['website']));
             //
         }
         $json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
     } else {
         $json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
     }
     $this->dbObj->close();
     //header('Content-type: application/json');
     return json_encode($json);
 }
Beispiel #28
0
 /** Method that fetches courses from database
  * @param string $column Column name of the data to be fetched
  * @param string $condition Additional condition e.g category_id > 9
  * @param string $sort column name to be used as sort parameter
  * @return JSON JSON encoded course details
  */
 public function fetch($column = "*", $condition = "", $sort = "id")
 {
     $sql = "SELECT {$column} FROM course ORDER BY {$sort}";
     if (!empty($condition)) {
         $sql = "SELECT {$column} FROM course WHERE {$condition} ORDER BY {$sort}";
     }
     $data = $this->dbObj->fetchAssoc($sql);
     $result = array();
     if (count($data) > 0) {
         foreach ($data as $r) {
             $result[] = array("id" => $r['id'], "name" => utf8_encode($r['name']), "image" => utf8_encode($r['image']), 'shortName' => utf8_encode($r['short_name']), 'category' => utf8_encode($r['category']), 'startDate' => utf8_encode($r['start_date']), 'endDate' => utf8_encode($r['end_date']), 'code' => utf8_encode($r['code']), 'description' => utf8_encode(StringManipulator::trimStringToFullWord(200, stripcslashes(strip_tags($r['description'])))), 'media' => utf8_encode($r['media']), 'currency' => utf8_encode($r['currency']), 'amount' => utf8_encode($r['amount']), 'cost' => utf8_encode($r['currency'] . number_format($r['amount'], 2)), 'status' => utf8_encode($r['status']), 'dateRegistered' => utf8_encode($r['date_registered']), 'categoryName' => utf8_encode(CourseCategory::getName($this->dbObj, $r['category'])));
         }
         $json = array("status" => 1, "info" => $result);
     } else {
         $json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection));
     }
     $this->dbObj->close();
     header('Content-type: application/json');
     return json_encode($json);
 }
Beispiel #29
0
 /** Method that fetches settings from database for JQuery Data Table
  * @param string $column Column value of the data to be fetched
  * @param string $condition Additional condition e.g  setting_name > 9
  * @param string $sort column value to be used as sort parameter
  * @return JSON JSON encoded course setting details
  */
 public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "name")
 {
     $sql = "SELECT {$column} FROM " . self::$tableName . " ORDER BY {$sort}";
     if (!empty($condition)) {
         $sql = "SELECT {$column} FROM " . self::$tableName . " WHERE {$condition} ORDER BY {$sort}";
     }
     if ($customSql != "") {
         $sql = $customSql;
     }
     $data = self::$dbObj->fetchAssoc($sql);
     $result = array();
     if (count($data) > 0) {
         foreach ($data as $r) {
             $deleteActionLink = '<button data-name="' . $r['name'] . '" class="btn btn-danger btn-sm delete-setting" title="Delete"><i class="btn-icon-only icon-trash"> </i> <span name="JQDTvalueholder" class="hidden">' . $r['value'] . '</span></button>';
             $multiActionBox = '<input type="checkbox" class="multi-action-box" data-name="' . $r['name'] . '" />';
             if ($r['name'] == "MAIN_ADMIN_EMAIL") {
                 $deleteActionLink = '';
                 $multiActionBox = '';
             }
             $result[] = array(utf8_encode($multiActionBox), utf8_encode($r['name']), utf8_encode(StringManipulator::trimStringToFullWord(90, stripcslashes(strip_tags($r['value'])))), utf8_encode(' <button data-name="' . $r['name'] . '" class="btn btn-info btn-sm edit-setting"  title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span id="JQDTvalueholder" class="hidden">' . $r['value'] . '</span> </button> ' . $deleteActionLink));
         }
         $json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
     } else {
         $json = array("status" => 2, "msg" => "Empty result. " . mysqli_error(self::$dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
     }
     self::$dbObj->close();
     header('Content-type: application/json');
     return json_encode($json);
 }
/">
                                                                        <img width="80" height="80" src="<?php 
    echo $relatedCourseObj->image;
    ?>
" class="attachment-thumb_80x80 wp-post-image" alt="<?php 
    echo $relatedCourseObj->name;
    ?>
" />
                                                                    </a>
                                                                </div>
                                                                <h4 class="ev-title">
                                                                    <a href="<?php 
    echo SITE_URL;
    ?>
course/<?php 
    echo $relatedCourseObj->id . "/" . StringManipulator::slugify($relatedCourseObj->name);
    ?>
/" class="related-ev-title main-color-1-hover"><?php 
    echo $relatedCourseObj->name;
    ?>
</a>
                                                                </h4>
                                                                <div class="ev-start small-text"><?php 
    echo $relatedCourseObj->startDate;
    ?>
</div>
                                                                <div class="clear"></div>
                                                            </div>
                                                            <?php 
}
?>