コード例 #1
0
    public function RenderPage()
    {
        require_once "/Classes/databaseHandler.class.php";
        $Database = new Database();
        print '
        <title>Run2Day - Bannerbeheer</title>
        <h1>Bannerbeheer</h1>
        <table class="table">
                            <tr>
                                <th>Toegevoegd aan</th>
                                <th>Bestandsnaam</th>
                                <th>Banner tekst</th>
                                <th>Verwijderen</th>
                            </tr> ';
        $Database->query('SELECT ID, fileName, fk_wedstrijdID, text  FROM afbeeldingen');
        $result = $Database->resultset();
        foreach ($result as $key) {
            $Database->query('SELECT name  FROM wedstrijden WHERE wedstrijdID=?');
            $Database->bind(1, $key['fk_wedstrijdID']);
            $wedstrijd = $Database->single();
            print '<tr><td>' . $wedstrijd['name'] . ' </td>';
            print '<td>' . $key['fileName'] . ' </td>';
            print '<td>' . $key['text'] . ' </td>';
            print ' <td><a class="fa fa-trash-o"  href="?dashboard&deletebanner=' . $key['ID'] . '"</td></tr>';
        }
        print '
            </table>


   <div class="col-md-4">
   <h3>Banner afbeelding toevoegen</h3>
   <form action="../Classes/submitWedstrijd.php" method="POST"  enctype="multipart/form-data">

      <label for="usr">Banner toevoegen aan:</label>
      <select class="form-control" name="wedstrijd" id="wedstrijd">';
        $Database->query('SELECT name, wedstrijdID FROM wedstrijden');
        $result = $Database->resultset();
        foreach ($result as $key) {
            print '  <option> ' . $key['name'] . '</option>';
        }
        print '
</select>

    <div class="form-group">
      <label for="usr">Banner tekst:</label>
      <input type="text" class="form-control" id="name" name="name" required>
    </div>

      <div class="form-group">
      <label for="usr">Afbeelding:</label>
        <input type="file" name="file" id="file">
            </div>
           <input type="submit" value="Opslaan">
    <br><br>
  </form>
   </div>
</div>
</div> ';
    }
コード例 #2
0
ファイル: TextSummary.php プロジェクト: TEJATJ/textsummary
 public function mainP()
 {
     $sen = 0;
     $db = new Database();
     foreach ($this->sentences as $sentence) {
         $highest = 0;
         $words = array();
         $words = explode(" ", $sentence);
         foreach ($words as $word) {
             if (!in_array(strtolower($word), $this->stopwords)) {
                 //Fetching the meaning definition of the senses From the WordNet
                 $db->query("SELECT * from words where lemma like :word");
                 $db->bind("word", $word);
                 $wordid = $db->single()->wordid;
                 $db->query("SELECT * from senses where wordid like :wordid");
                 $db->bind("wordid", $wordid);
                 $resulta2 = $db->resultset();
                 foreach ($resulta2 as $row) {
                     $synsetid = $row->synsetid;
                     $sample2[] = $synsetid;
                     $title = $row->wordid . " " . $row->senseid;
                 }
                 $db->query("select * from synsets where synsetid like :sample");
                 $db->bind("sample", $sample2[0]);
                 $resulta3 = $db->resultset();
                 unset($sample2[0]);
                 for ($i = 0; $i < count($sample2) + 1; $i++) {
                     ${result_A . $i} = $sample2[$i];
                     ${lexdomains_var . $i} = $lexdomains[$i];
                     $db->query("select * from synsets where synsetid like :sample");
                     $db->bind("sample", ${result_A . $i});
                     ${result . $i} = $db->resultset();
                     foreach (${result . $i} as $row) {
                         ${pos . $i} = $row->pos;
                         if (${pos . $i} == "s") {
                             ${pos . $i} = "satellite adj";
                         }
                         $def = $row->definition;
                         $def = preg_replace('/[^a-zA-Z0-9_ -]/s', '', $def);
                         $definition = array();
                         $definition = explode(" ", $def);
                         $frequency = $this->frequency($definition);
                         if ($frequency > $highest) {
                             $highest = $frequency;
                         }
                     }
                 }
                 $sample2 = array();
             }
         }
         $this->frequencies[] = $highest;
         $this->sentence_count[] = $sen;
         $sen++;
     }
 }
コード例 #3
0
ファイル: db_helper.php プロジェクト: jprichter/Forum
function userPostCount($user_id)
{
    $db = new Database();
    //topic count
    $db->query("SELECT * FROM topics\n\t\t\t\tWHERE user_id = :user_id\n\t\t\t\t");
    $db->bind(":user_id", $user_id);
    $rows = $db->resultset();
    $topic_count = $db->rowCount();
    //reply count
    $db->query("SELECT * FROM replies\n\t\t\t\tWHERE user_id = :user_id\n\t\t\t\t");
    $db->bind(":user_id", $user_id);
    $rows = $db->resultset();
    $reply_count = $db->rowCount();
    return $topic_count + $reply_count;
}
コード例 #4
0
function getByMuseum($museum_id, $today)
{
    global $api_response;
    global $api_response_code;
    try {
        $database = new Database();
        $database->query("SELECT * FROM exhibitions_info WHERE end_date >= :today AND museum_id = :museum_id ORDER BY start_date ASC");
        $database->bind(':today', $today);
        $database->bind(':museum_id', $museum_id);
        $rows = array();
        $rows = $database->resultset();
        $database = null;
        if ($rows == null) {
            //not found any exhibitions return error
            $api_response = $api_response_code[5];
        } else {
            $api_response = $api_response_code[1];
        }
        return $rows;
    } catch (PDOException $e) {
        $database = null;
        $api_response = $api_response_code[0];
        //die( "Query failed: " . $e->getMessage() );
        return null;
    }
}
コード例 #5
0
ファイル: model.Tiendas.php プロジェクト: hugodom/Multiplaza
 public function fetchBySearch($search)
 {
     $dbh = new Database();
     $data = $dbh->query('SELECT * FROM tiendas WHERE tienda_nombre LIKE "%' . $search . '%"');
     $data = $dbh->resultset();
     return $data;
 }
コード例 #6
0
ファイル: model.Noticias.php プロジェクト: hugodom/Multiplaza
 public function fetchAllByPortada()
 {
     $dbh = new Database();
     $data = $dbh->query('SELECT * FROM noticias WHERE noticia_portada = 1 LIMIT 3');
     $data = $dbh->resultset();
     return $data;
 }
コード例 #7
0
ファイル: model.Cine.php プロジェクト: hugodom/Multiplaza
 public function fetchAllNonPremieres()
 {
     $dbh = new Database();
     $data = $dbh->query('SELECT * FROM cine WHERE cine_estreno = 0 AND cine_activado = 1');
     $data = $dbh->resultset();
     return $data;
 }
コード例 #8
0
 public function GetConfigProcess()
 {
     parent::query('SELECT * FROM dd_config');
     parent::execute();
     $dataset = parent::resultset();
     return $dataset;
 }
コード例 #9
0
 public function ListDistrictProcess($param)
 {
     parent::query('SELECT * FROM dy_location_district WHERE ds_city_id = :city_id ORDER BY ds_id ASC');
     parent::bind(':city_id', $param['city_id']);
     parent::execute();
     return parent::resultset();
 }
コード例 #10
0
 public function ListConfigProcess($group)
 {
     parent::query('SELECT * FROM dd_config WHERE cf_group = :group');
     parent::bind(':group', $group);
     parent::execute();
     $dataset = parent::resultset();
     return $dataset;
 }
コード例 #11
0
ファイル: Post.php プロジェクト: GojkoC/Simple_Blog
 /**
  * Get Post Comments
  *
  * @param int $post_id
  * @return mixed
  */
 public function getComments($post_id)
 {
     $this->db->query("SELECT comments.*, posts.id FROM comments\n\t        INNER JOIN posts\n\t        ON comments.post_id = posts.id\n\t        WHERE comments.post_id = :post_id\n\t\t\tORDER BY time ASC");
     $this->db->bind(':post_id', $post_id);
     //Assign Result Set
     $results = $this->db->resultset();
     return $results;
 }
コード例 #12
0
ファイル: db_helper.php プロジェクト: GojkoC/Simple_Blog
function commentsCount($post_id)
{
    $db = new Database();
    $db->query("SELECT * FROM comments WHERE post_id = :post_id");
    $db->bind(':post_id', $post_id);
    $rows = $db->resultset();
    return $db->rowCount();
}
コード例 #13
0
 public function printHTML()
 {
     require_once "/Classes/databaseHandler.class.php";
     $Database = new Database();
     $Database->query('SELECT wedstrijdID, name, date, location  FROM wedstrijden');
     $this->wedstrijden = $Database->resultset();
     $this->RenderPage();
 }
コード例 #14
0
 public function EditProductProcess($param)
 {
     parent::query('SELECT * FROM dd_product');
     parent::execute();
     parent::execute();
     $dataset = parent::resultset();
     return $dataset;
 }
コード例 #15
0
ファイル: tag.model.php プロジェクト: jimmy18dev/dailypoint
 public function PlaceToTagCheckingProcess($param)
 {
     parent::query('SELECT tg_id tag_id,tg_keyword tag_keyword,tg_text tag_text,tg_create_time tag_create_time,(SELECT pt_id FROM dy_place_to_tag WHERE pt_place_id = :place_id AND pt_tag_id = tg_id) tag_checking FROM dy_tag WHERE 1 ORDER BY tg_create_time DESC');
     parent::bind(':place_id', $param['place_id']);
     parent::execute();
     $dataset = parent::resultset();
     return $dataset;
 }
コード例 #16
0
 public function ListSubPhotoProcess($param)
 {
     parent::query('SELECT * FROM dd_image WHERE im_product_id = :product_id AND im_type = "normal"');
     parent::bind(':product_id', $param['product_id']);
     parent::execute();
     $dataset = parent::resultset();
     return $dataset;
 }
コード例 #17
0
ファイル: player.php プロジェクト: WouterDoornbos/Run2Day
    public function printHTML()
    {
        require_once "/Classes/databaseHandler.class.php";
        $Database = new Database();
        $this->ZoekTijd();
        if ($this->Naam == "Naam") {
            echo "Startnummer of naam is niet gevonden.";
            header("Location: ?error&code=1");
        } else {
            $Database->query('SELECT wedstrijdID FROM wedstrijden WHERE name=?');
            $Database->bind(1, $_GET['wedstrijd']);
            $ID = $Database->single();
            $Database->query('SELECT camName, videoID  FROM cams WHERE fk_wedstrijdID=?');
            $Database->bind(1, $ID['wedstrijdID']);
            $result = $Database->resultset();
            foreach ($result as $key) {
                print '
    <title>' . "Run2Day video - " . $this->Naam . " - " . $this->Wedstrijdnaam . '</title>
    <link href="css/bootstrap.css" rel="stylesheet">

                <h1 class="text-center">  <i class="fa fa-video-camera"></i> ';
                echo $key['camName'];
                print '</h1>

                <div class="container">
                <div class="col-md-8 col-md-offset-2">
                <div class="embed-responsive embed-responsive-16by9">
                <iframe class="embed-responsive-item" src="https://player.vimeo.com/video/';
                echo $key['videoID'];
                print '?autoplay=true#t=';
                echo $this->VideoTijd;
                print '" frameborder="0"  webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
                </div>

                </div></div>

                ';
            }
            print '
    <h1 class=text-center>' . $this->Startnummer . ' - ' . $this->Naam;
            if ($this->Geslacht == "M") {
                echo ' <i class="fa fa-male"></i>';
            }
            if ($this->Geslacht == "V") {
                echo ' <i class="fa fa-female"></i>';
            }
            print '
    </h1>
<p class=text-center>' . $this->Woonplaats . ' <br> ' . $this->Wedstrijdnaam . '</p>
  <div class="centered text-center">
<p><a class="btn btn-primary btn-lg" href="?search" role="button">Zoek een andere video</a></p>
<div class="fb-share-button" data-href="http://hardlopen.wouterd.nl?player&wedstrijd=' . $_GET['wedstrijd'] . '&naam=' . $_GET['naam'] . '&startnummer=' . $_GET['startnummer'] . '" data-layout="box_count"></div>
</div>
<br>

';
        }
    }
コード例 #18
0
ファイル: db_helper.php プロジェクト: naytunchen/survey_form
function getChoicesByQuestion($question_id)
{
    $db = new Database();
    $db->query('SELECT * FROM choices WHERE question_id = :question_id');
    $db->query(':question_id', $question_id);
    // Assign Rows
    $rows = $db->resultset();
    return $rows;
}
コード例 #19
0
 public function ListAmphurProcess($param)
 {
     echo 'province_id: ' . $param['province_id'];
     parent::query('SELECT * FROM th_amphur WHERE amphur_province_id = :province_id AND amphur_postcode != "00000"');
     parent::bind(':province_id', $param['province_id']);
     parent::execute();
     $dataset = parent::resultset();
     return $dataset;
 }
コード例 #20
0
    public function ListCategoryProcess($param)
    {
        parent::query('SELECT ca_id category_id,ca_title category_name,ca_root,ca_parent_first,ca_parent_second,ca_create_time,ca_update_time,ca_type,ca_status,(SELECT COUNT(pl_id) FROM dy_place WHERE pl_category_id = ca_id AND (pl_status = "registered" OR pl_status = "approved")) total_place 
			FROM dy_category 
			WHERE 1');
        parent::execute();
        $dataset = parent::resultset();
        return $dataset;
    }
コード例 #21
0
 public function ListBankProcess($param)
 {
     parent::query('SELECT * FROM dd_bank');
     parent::execute();
     $dataset = parent::resultset();
     foreach ($dataset as $k => $var) {
         $dataset[$k]['bk_account_number_format'] = parent::BankNumberFormat($var['bk_account_number']);
     }
     return $dataset;
 }
コード例 #22
0
ファイル: site.model.php プロジェクト: jimmy18dev/dailypoint
 public function ListKeywordProcess($param)
 {
     parent::query('SELECT * FROM dy_keyword WHERE kw_total > 0 ORDER BY kw_total DESC LIMIT 100');
     parent::execute();
     $dataset = parent::resultset();
     foreach ($dataset as $k => $var) {
         $dataset[$k]['kw_create_time_facebook_format'] = parent::date_facebookformat($var['kw_create_time']);
         $dataset[$k]['kw_update_time_facebook_format'] = parent::date_facebookformat($var['kw_update_time']);
     }
     return $dataset;
 }
コード例 #23
0
ファイル: adminhome.php プロジェクト: WouterDoornbos/Run2Day
 public function renderSearch()
 {
     require_once "/Classes/databaseHandler.class.php";
     $Database = new Database();
     $Database->query('SELECT fileName, name, date  FROM wedstrijden');
     $resultSet = $Database->single();
     print '
     </div >
         <div id = "clickTable" class="container" >
         <table id = "myTable" class="table" >
          <thead>
         <tr>
         <th> Startnr <i class="fa fa-sort" ></i></th>
         <th> Wedstrijd <i class="fa fa-sort" ></i></th>
         <th> Naam <i class="fa fa-sort" ></i></th>
         <th> Woonplaats <i class="fa fa-sort" ></i></th>
         <th> Geboortedatum <i class="fa fa-sort" ></i></th>
         <th> Geslacht</th >
         <th> Netto tijd <i class="fa fa-sort" ></i></th>
         <th> Onderdeel <i class="fa fa-sort" ></i> </th>
         <th> Beeld</th>
         </tr></thead ><tbody> ';
     $Database->query('SELECT * FROM tijden WHERE Naam LIKE ?');
     if (!isset($_GET['show'])) {
         $Database->bind(1, "%" . $_POST['naam'] . "%");
         $result = $Database->resultset();
         if (empty($result)) {
             echo "Deelnemer niet gevonden.";
         }
         foreach ($result as $data) {
             $Database->query('SELECT fileName, name, date  FROM wedstrijden WHERE wedstrijdID=?');
             $Database->bind(1, $data['fk_wedstrijdID']);
             $resultSet = $Database->single();
             print ' <tr><td> ' . $data['Startnummer'] . ' </td> ';
             print '<td> ' . $resultSet['name'] . ' </td> ';
             print '<td> ' . $data['Naam'] . ' </td> ';
             print '<td> ' . $data['Woonplaats'] . ' </td> ';
             print '<td> ' . $data['Geboortedatum'] . ' </td> ';
             echo "<td>";
             if ($data['Geslacht'] == "V") {
                 echo ' <i class="fa fa-female" ></i> ';
             } else {
                 echo '<i class="fa fa-male" ></i> ';
             }
             echo "</td>";
             print '<td> ' . $data['NettoTijd'] . ' </td> ';
             print '<td> ' . $data['Onderdeel'] . ' </td> ';
             print "<td><a class='fa fa-line-chart' href='?statistieken&startnummer=" . $data['Startnummer'] . "&eventid=" . $data['fk_wedstrijdID'] . "'></a>";
             print " <a class='fa fa-video-camera' href='?newplayer&wedstrijd=" . $resultSet['name'] . "&naam=& startnummer=" . $data['Startnummer'] . "'></a>";
             print " <a class='fa fa-camera' </a> ";
             print " <a class='fa fa-certificate' target='_blank' href='https://uitslagensoftware.nl/certificaat_3.php?event_id=2015083000294&S= " . $data['Startnummer'] . "'></a></td></tr>";
         }
     }
 }
コード例 #24
0
ファイル: DBHelper.php プロジェクト: jwren4170/angular_movies
    function userPostCount($user_id)
    {
        $db = new Database();
        $db->query('SELECT * FROM topics
				WHERE user_id = :user_id
				');
        $db->bind(':user_id', $user_id);
        //Assign Rows
        $rows = $db->resultset();
        //Get Count
        $topic_count = $db->rowCount();
        $db->query('SELECT * FROM replies
				WHERE user_id = :user_id
				');
        $db->bind(':user_id', $user_id);
        //Assign Rows
        $rows = $db->resultset();
        //Get Count
        $reply_count = $db->rowCount();
        return $topic_count + $reply_count;
    }
コード例 #25
0
function topicCount($category_id)
{
    if ($category_id == null) {
        $topicCount = new Topic();
        return $topicCount->getTotalTopics();
    } else {
        $db = new Database();
        $db->query("SELECT * FROM topics WHERE category_id = :category_id");
        $db->bind(':category_id', $category_id);
        $row = $db->resultset();
        $count = $db->rowCount();
        return $count;
    }
}
コード例 #26
0
ファイル: index.php プロジェクト: Zilus/cms
function getUsersId($user_id)
{
    $database = new Database();
    $sql = "SELECT * FROM mytable WHERE ID=:user_id";
    $database->query($sql);
    $database->bind(':user_id', $user_id);
    if ($rows = $database->resultset()) {
        foreach ($rows as &$row) {
            echo '{"users": ' . json_encode($row) . '}';
        }
    } else {
        echo json_encode(array("status" => false, "message" => "El usuario con ID {$user_id} no existe"));
    }
}
コード例 #27
0
    public function ListItemsInOrderProcess($param)
    {
        parent::query('SELECT odt_id,odt_order_id order_id,odt_amount product_amount,product.pd_id product_id,product.pd_title product_title,product.pd_description product_description,product.pd_price product_price,product.pd_type product_type,p_image.im_id product_image_id,p_image.im_filename product_image_filename,parent.pd_id parent_id,parent.pd_title parent_title,parent.pd_description parent_description,parent_image.im_id parent_image_id,parent_image.im_filename parent_image_filename 
			FROM dd_order_detail 
			LEFT JOIN dd_product AS product ON odt_product_id = pd_id 
			LEFT JOIN dd_product AS parent ON product.pd_parent = parent.pd_id 
			LEFT JOIN dd_image AS p_image ON product.pd_id = p_image.im_product_id AND (im_type = "cover") 
			LEFT JOIN dd_image AS parent_image ON parent.pd_id = parent_image.im_product_id
			WHERE odt_order_id = :order_id');
        parent::bind(':order_id', $param['order_id']);
        parent::execute();
        $dataset = parent::resultset();
        return $dataset;
    }
 /**
  * Research by subject, min. date, and optionnally category and contact name
  * Returns a list of documents
  */
 public function searchDocuments($searchDocumentsParams)
 {
     $db = new Database();
     // LEFT JOIN: the doc may not have been linked to a sender or addressee yet
     // COALESCE: if the category_id IS NULL replace it with an empty string
     $sql = "SELECT r.res_id, r.subject, r.doc_date, m.category_id as category, " . "m.exp_contact_id, m.dest_contact_id, m.exp_user_id, " . "m.dest_user_id " . "FROM res_letterbox as r " . "LEFT JOIN mlb_coll_ext as m ON r.res_id = m.res_id " . "WHERE UPPER(r.subject) LIKE UPPER(:subject) AND " . "r.doc_date >= to_date(:mindocdate, 'YYYY-MM-DD') " . "AND COALESCE(m.category_id, '') like :category " . "ORDER BY r.doc_date DESC;";
     /*********************
     	Note : in the version 1.5.1 the following lines must be adapted:
     	the "query" method has been modified and the "bind" method has been deleted
     	*********************/
     $db->query($sql);
     // prepared request
     $db->bind(":subject", "%{$searchDocumentsParams->subject}%");
     // the date is managed as a string
     $db->bind(':mindocdate', $searchDocumentsParams->min_doc_date);
     if (isset($searchDocumentsParams->category) && !is_null($searchDocumentsParams->category) && $searchDocumentsParams->category != "") {
         $db->bind(":category", $searchDocumentsParams->category);
     } else {
         // match all the categories (even NULL)
         $db->bind(":category", "%");
     }
     $res = $db->resultset();
     // array of objects OR null
     // add the information about the contact (sender or addressee)
     $final_res = array();
     foreach ($res as $current) {
         if (!is_null($current['exp_contact_id']) || !is_null($current['dest_contact_id'])) {
             $this->get_external_contact($db, $current);
         } else {
             if (!is_null($current['exp_user_id']) || !is_null($current['dest_user_id'])) {
                 $this->get_internal_contact($db, $current);
             } else {
                 $current['contact'] = '';
             }
         }
         // remove the unused data
         unset($current['exp_contact_id']);
         unset($current['dest_contact_id']);
         unset($current['exp_user_id']);
         unset($current['dest_user_id']);
         array_push($final_res, $current);
     }
     // if the user wants to search by contact name we filter the data
     return $this->filter_by_contact($final_res, $searchDocumentsParams->contact);
 }
コード例 #29
0
    public function ListNotificationProcess($param)
    {
        parent::query('SELECT ac_id activity_id,me_id activity_owner_id,me_fname activity_owner_fname,me_name activity_owner_name,ac_action activity_action,ac_create_time activity_create_time,ac_to_comment_id activity_comment_id,cm_message activity_comment_message,po_id activity_post_id,po_text activity_post_text,ac_status activity_status 
			FROM dy_activity 
			LEFT JOIN dy_post ON ac_to_post_id = po_id 
			LEFT JOIN dy_member ON ac_member_id = me_id 
			LEFT JOIN dy_comment ON ac_to_comment_id = cm_id 
			WHERE (ac_action = "new_comment" OR ac_action = "thanks_post") AND (po_member_id = :member_id) AND (ac_member_id != :member_id) 
			ORDER BY ac_create_time DESC');
        parent::bind(':member_id', $param['member_id']);
        parent::execute();
        $dataset = parent::resultset();
        foreach ($dataset as $k => $var) {
            // $dataset[$k]['comment_message'] = htmlspecialchars($var['comment_message']);
            $dataset[$k]['activity_create_time_facebook_format'] = parent::date_facebookformat($var['activity_create_time']);
            $dataset[$k]['activity_update_time_facebook_format'] = parent::date_facebookformat($var['activity_update_time']);
        }
        return $dataset;
    }
コード例 #30
0
ファイル: photo.model.php プロジェクト: jimmy18dev/dailypoint
 public function ListPhotoProcess($param)
 {
     $q['select'] = 'SELECT * ';
     $q['from'] = 'FROM dy_image ';
     $q['where'] = 'WHERE 1 = 1 ';
     $q['order'] = 'ORDER BY im_create_time DESC ';
     $q['limit'] = 'LIMIT ' . $param['start'] . ',' . $param['total'];
     if (isset($param['member_id'])) {
         $q['where'] = 'WHERE (im_member_id = :member_id) ';
     }
     if (isset($param['place_id'])) {
         $q['where'] = 'WHERE (im_place_id = :place_id) ';
     }
     $queryProcess = $q['select'] . $q['from'] . $q['where'] . $q['order'] . $q['limit'];
     parent::query($queryProcess);
     if (isset($param['member_id'])) {
         parent::bind(':member_id', $param['member_id']);
     }
     if (isset($param['place_id'])) {
         parent::bind(':place_id', $param['place_id']);
     }
     parent::execute();
     return parent::resultset();
 }