Example #1
0
echo DOMAIN;
?>
/design/bootstrap.min.css">

</head>


 
		<body>
 <?php 
include '../incl/navbar.php';
?>
<table class="table">

<?php 
$db_connection = Database::getDb();
$sql = " select * from puffer_fish.pu_categories\t  \n\t\t\t\t WHERE category_name = '" . mysqli_real_escape_string($db_connection, $cat) . "'  order by category_id";
var_dump($sql);
$result = mysqli_query($db_connection, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>";
    echo '<td>';
    echo '<a href="category.php?cat=' . $row['category_name'] . '">' . $row['category_name'] . "'s </a> parent is ";
    echo $row['parent_name'] == NULL ? ' root ' : $row['parent_name'];
    echo '</td>';
    echo "</tr>";
}
?>

</table>
Example #2
0
<?php

// Include database class
include 'database.class.php';
$database = new Database();
$conn = $database->getDb();
// Include functions class
include 'functions.class.php';
$functions = new Functions();
if ($_POST['action'] == "createTable") {
    // form for svae submitted, save the html code of table in database
    echo $functions->createTable($conn, $_POST['tblName'], $_POST['html']);
} else {
    if (!empty($_POST['edit-html'])) {
        echo $functions->updateTable($conn, $_POST['table-name'], $_POST['edit-html']);
    } else {
        if ($_POST['action'] == "checkTable" || $_POST['action'] == "getCode") {
            echo $functions->checkTableCode($_POST['tblName'], $conn);
        } else {
            if ($_POST['action'] == "getNames") {
                echo $functions->getNames($conn);
            } else {
                if ($_POST['action'] == "getVotes") {
                    echo $functions->getVotes($conn, $_POST['tblName']);
                } else {
                    if ($_POST['action'] == "updateVotes") {
                        $functions->updateVotes($conn, $_POST['vote'], $_POST['tableName'], $_POST['tableRow']);
                    } else {
                        if ($_POST['action'] == "wilson") {
                            echo $functions->wilsonScore($_POST['tblName'], $conn);
                        }
 /**
  * 
  * @param Database $query
  */
 protected function _search(&$query)
 {
     $db = $query->getDb();
     $search = false;
     $buscar = $this->_request->getParam("search");
     if (!empty($buscar["value"])) {
         $cond = "(";
         $or = "";
         foreach ($this->_data['columns'] as $val) {
             if (count($val) > 0) {
                 if (!empty($val["search"]) and $val["search"]["active"]) {
                     if (!empty($val["search"]["searchable_cond"])) {
                         if (isset($val["search"]["searchable_value"])) {
                             $valor = str_replace("?", $buscar["value"], $val["search"]["searchable_value"]);
                         } else {
                             $valor = $buscar["value"];
                         }
                         $cond .= $or . str_replace("?", $db->escape($valor), $val["search"]["searchable_cond"]);
                         $or = " OR ";
                         $search = true;
                     }
                 }
             }
         }
         $cond .= ") ";
     }
     if ($search) {
         $query->addWhere($cond);
     }
 }
 public static function addUserFile($filePath, $fileName)
 {
     $filePath = strip_tags($filePath);
     $fileName = strip_tags($fileName);
     $db = Database::getDb()->connect();
     if ($query = $db->prepare('
           INSERT INTO
             files
             (user_id, file_path, file_name, date_created)
           VALUES
             (?,?,?,?)')) {
         $query->bind_param('ssss', Session::get('user_id'), $filePath, $fileName, date('Y-m-d H:i:s'));
         if ($query->execute()) {
             return true;
         }
     }
     return false;
 }
Example #5
0
<?php

require_once "class/Database.php";
$db = Database::getDb();
$sql = $db->query("SELECT * FROM instruments");
$results = $sql->fetchAll();
echo json_encode($results);
Example #6
0
 public function __construct()
 {
     $this->db = Database::getDb();
 }
Example #7
0
 public static function checkBookmark($file_id)
 {
     $db = Database::getDb()->connect();
     $stmt = 'SELECT user_id FROM bookmarks WHERE file_id = ? LIMIT 1';
     if ($query = $db->prepare($stmt)) {
         $query->bind_param('s', $file_id);
         $query->execute();
         $query->store_result();
         if ($query->num_rows == 0) {
             return true;
         }
     }
     return false;
 }
Example #8
0
// include constants
require_once "../constants.php";
require_once "../functions.php";
require_once "../dbConfig.php";
//$_SESSION['SYSTEM_ENTRY'] = USCIC_SMS;
$loaded = dbConfig::load("../conf.php");
require_once "../config.php";
require_once "../object.php";
require_once "../component.php";
require_once "../setting.php";
require_once "../survey.php";
/* check for 'javascript enabled' indicator */
isJavascriptEnabled();
/* set path */
setPath();
/* database */
require_once 'database.php';
$db = new Database();
if ($db->getDb() == null) {
    //no connection with DB.. Errormessage!
    exit;
}
ini_set('xdebug.max_nesting_level', 2000);
ini_set("error_reporting", "ALL");
if (loadvar('ajaxr') != '') {
    $params = getAjaxParamsPost(loadvar('ajaxr'));
}
require_once 'surveyajax.php';
$ajax = new SurveyAjax($params);
$ajax->getPage(loadvar('p'));
exit;
Example #9
0
 public static function getCurrentUser()
 {
     $db = Database::getDb()->connect();
     if ($query = $db->prepare("SELECT\n                  username,\n                  firstname,\n                  lastname,\n                  email\n                FROM\n                  users\n                WHERE\n                  id = ? LIMIT 1")) {
         $query->bind_param('s', Session::get('user_id'));
         $query->execute();
         return self::getAssocArrayFromSql($query);
     }
     return false;
 }
Example #10
0
 private static function rememberMe($user_id)
 {
     $random_token = hash('sha256', openssl_random_pseudo_bytes(16));
     $db = Database::getDb()->connect();
     if ($query = $db->prepare("UPDATE\n                users\n            SET\n              remember_me_token = ?\n            WHERE\n              id = ?\n            LIMIT 1\n        ")) {
         $query->bind_param('ss', $random_token, $user_id);
         $query->execute();
         if ($query->errno) {
             Session::add(Message::get('LOGIN_FAILED'), Message::get('DB_ERROR'));
         }
     } else {
         Session::add(Message::get('LOGIN_FAILED'), Message::get('DB_ERROR'));
         return;
     }
     $cookie_string = $user_id . ':' . $random_token;
     $cookie_string = $cookie_string . ':' . hash('sha256', $cookie_string);
     setcookie('remember_me', $cookie_string, time() + Config::get('COOKIE_EXPIRE'), Config::get('COOKIE_PATH'));
 }