function __construct($u, $p, $e = null, $a = null)
 {
     $this->username = $u;
     $this->password = $p;
     $this->email = $e;
     $this->avatar_path = $a;
     $this->DB = DBconnection::getInstance();
 }
 public function __construct()
 {
     if (session_status() != 2) {
         session_start();
     }
     if (isset($_SESSION['user'])) {
         $this->DBconnection = DBconnection::getInstance();
     } else {
         die;
     }
 }
<?php

session_start();
require_once "dbconnection.class.php";
$DB = DBconnection::getInstance();
$query = "select ID from videos where Name='" . $_SESSION['curr_video'] . "'";
$q = $DB->db_pdo->prepare($query);
$q->execute();
$row = $q->fetch();
$id = $row["ID"];
$qq = "select Login,text,time from timespans join users on timespans.IDUser = users.ID where IDVideo = :id";
$q = $DB->db_pdo->prepare($qq);
$q->execute(array(':id' => $id));
while ($row = $q->fetch(PDO::FETCH_ASSOC)) {
    ?>
                        <div class="timespan_link_div">
                            <p id="timespan_user"><?php 
    echo $row['Login'];
    ?>
</p>
                            <p id="timespan_link_time"><?php 
    echo $row['time'];
    ?>
</p>
                            <p id="timespan_link_text"><?php 
    echo $row['text'];
    ?>
</p>
                        </div>
                    <?php 
}
Beispiel #4
0
 public function __construct()
 {
     $this->DBconnection = DBconnection::getInstance();
 }
<?php

session_start();
require_once "dbconnection.class.php";
$dbh = DBconnection::getInstance();
?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>SlyTube</title>
    <link rel="icon" href="favicon2.png" type="image/png">
    <link rel="stylesheet" href="stylesheets/style.css">
    <link rel="stylesheet" href="stylesheets/video-js.css">
    <link rel="stylesheet" href="stylesheets/upload.css">
    <script src="js/jquery-1.11.3.min.js"></script>
    <script src="js/video.js"></script>
    <script src="js/core.js"></script>
    <script src="js/upload.js"></script>
</head>
<body>
    <div class="wrap">
      <!--  HEADER -->
       <?php 
include "header.php";
?>
        
        <!-- SIDEBAR -->
        <?php