VACI

<?php
/**
 * Created by PhpStorm.
 * User: gorgi
 * Date: 07-Nov-16
 * Time: 22:56
 */
//phpinfo();
/*$host="praktikum.finki.ukim.mk";
$dbime="praktikum131203";
$user="131203";
$pass="Lozinka131203";

try{
    $connection = new PDO("mysql:host=$host;dbname=$dbime", $user, $pass);
    $sql='
    -- -----------------------------------------------------
-- Table `news`.`news`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `news` ;

CREATE TABLE IF NOT EXISTS `news` (
  `news_id` INT NOT NULL AUTO_INCREMENT,
  `date` DATETIME NOT NULL,
  `news_title` VARCHAR(45) NOT NULL,
  `full_text` TEXT NOT NULL,
  PRIMARY KEY (`news_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `news`.`comments`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `comments` ;

CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` INT NOT NULL AUTO_INCREMENT,
  `news_id` INT NOT NULL,
  `author` VARCHAR(45) NOT NULL,
  `comment` TINYTEXT NOT NULL,
  `approved` TINYINT(1) NULL DEFAULT 0,
  PRIMARY KEY (`comment_id`),
  INDEX `nid_idx` (`news_id` ASC),
  CONSTRAINT `news_id`
    FOREIGN KEY (`news_id`)
    REFERENCES `news` (`news_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

    ';
    $q=$connection->query($sql);
    $q->setFetchMode(PDO::FETCH_ASSOC);

}
catch (PDOException $e){
    die("Cloud not connect to server".$e->getMessage());
}*/

echo "<table style='border: solid 1px black;'>";
echo "<tr><th>Id</th><th>Firstname</th><th>Lastname</th></tr>";

class TableRows extends RecursiveIteratorIterator {
    function __construct($it) {
        parent::__construct($it, self::LEAVES_ONLY);
    }

    function current() {
        return "<td style='width:150px;border:1px solid black;'>" . parent::current(). "</td>";
    }

    function beginChildren() {
        echo "<tr>";
    }

    function endChildren() {
        echo "</tr>" . "\n";
    }
}

$host="localhost";

$root="root";
$root_password="";

try {
    $conn = new PDO("mysql:host=$host", $root, $root_password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "CREATE DATABASE IF NOT EXISTS TEST";    //kreiranje na databasa TEST dokolku ne postoi
    $conn->exec($sql);
    echo "uspesno kreiranje na baza test <br/>";

}
catch (PDOException $er){
    echo "neuspeshno kreiranje na baza test <br/> ".$er->getMessage();
}


$conn = null;
try{
    //VO KONEKCIJATA SE DODAVA dbname NA PRETHODNO KREIRANATA TABELA
    $conn=new PDO("mysql:host=$host;dbname=TEST",$root,$root_password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    //KREIRANJE NA TABELA TEST DOKOLKU NE POSTOI
    $sql="CREATE TABLE IF NOT EXISTS Test2Tabela(
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    ime VARCHAR(30) NOT NULL,
    prezime VARCHAR(30) NOT NULL)";
    $conn->exec($sql);
    echo "uspesno kreiranje na Test2Tabela <br/>";

}
catch (PDOException $e){
    echo "Neuspesno kreiranje na Test2Tabela <br/> ".$e->getMessage();
}

$conn = null;

try{
    //VO KONEKCIJATA SE DODAVA dbname NA PRETHODNO KREIRANATA TABELA
    $conn=new PDO("mysql:host=$host;dbname=TEST",$root,$root_password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    //DODAVANJE NA ELEMENTI VO TABELATA , NE VNESUVAME PRIMARY KEY BIDEJKI E SETIRAN NA INT I IMA AUTOINCREMMENT
    //AKO IMA AUTOINCREMENT PRIMARY KEY IMA NEKOJA ZAEBANCIJA DOKOLKU PRAVIME UPDATE VO SPECIFICEN RED :(
    $sql = "INSERT INTO Test2Tabela (ime, prezime)
    VALUES ('Filip', 'Gjorgievski')";
    $conn->exec($sql);
    echo "Uspesno kreiranje nov zapis<br/>";

}
catch (PDOException $e){
    echo "Neuspesno kreiranje na nov zapis <br/> ".$e->getMessage();
}

$conn = null;
try{
    $conn=new PDO("mysql:host=$host;dbname=TEST",$root,$root_password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT id, ime, prezime FROM Test2Tabela");
    $stmt->execute();
    //GI ZEMA SITE ELEMENTI OD TABELATA
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    //KREIRA TABELA ZA DA NAPRAVI HTML ELEMENT OD TIP TABLE
    foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
        echo $v;
    }
}
catch (PDOException $e){
    echo "Neuspesna selekcija from Test2TABLE <br/>" .$e->getMessage();
}
$conn=null;
echo "</table>";
?>