PHP view\cd\model\DBCd примеры использования

Пример #1

Файл: xml.php Проект: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cd\model\DBCd();
$fn = new controller\functions();
//var_dump($db->selectCdByIdJoin($_GET['id']));
$fn->xmlDownload($db->selectCdByIdJoin($_GET['id'])[0]);

Пример #2

Файл: cd.update.php Проект: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cd\model\DBCd();
$fn = new controller\functions();
if (empty($_POST)) {
    exit;
}
var_dump($_FILES);
//var_dump($fn->prepareArrayDoublePointer($_POST, false));
$user = $_POST['id_user'];
unset($_POST['id_user']);
//exit;
if (empty($_FILES['img']['name'])) {
    var_dump($db->updateCD($fn->prepareArrayDoublePointer($_POST, false), $user));
    // vai retornar a quantidade de linhas afetadas
} else {
    if (move_uploaded_file($_FILES['img']['tmp_name'], '../img/cd/' . $_FILES['img']['name'])) {
        $_POST['img'] = $_FILES['img']['name'];
        var_dump($db->updateCD($fn->prepareArrayDoublePointer($_POST, false), $user));
        // vai retornar a quantidade de linhas afetadas
    }
}

Пример #3

Файл: editar.cd.php Проект: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cd\model\DBCd();
$user = $db->selectCdById($_POST['id'])[0];
$db = new view\cantor\model\DBCantor();
?>
<div class="row">
    <form id="editCD">
        <div class="col-md-12 urlForm" data-url="controller/cd.update.php">
            <fieldset>
                <div class="row">
                    <div class="">
                        <label for="inputEmail" class="col-lg-2 control-label">Titulo do CD</label>
                        <div class="col-lg-10">
                            <input type="text" name='title' class="form-control" value="<?php 
echo $user['title'];
?>
"  id="inputEmail" placeholder="Titulo do cd">
                        </div>
                    </div>
                </div>
                <div class="row">
                    <div class="">
                        <label for="inputData" class="col-lg-2 control-label">Data do CD</label>
                        <div class="col-lg-10">
                            <input type="date" name="date" class="form-control" id="inputData" value="<?php 
echo $user['date'];
?>
">
                        </div>

Пример #4

Файл: delete.cd.php Проект: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cd\model\DBCd();
if (empty($_POST)) {
    exit;
}
$file = $db->deleteDC($_POST['id_user']);
unlink("../img/cd/" . $file);

Пример #5

Файл: cd.insert.php Проект: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cd\model\DBCd();
$fn = new controller\functions();
if (empty($_POST)) {
    exit;
}
var_dump($_FILES);
//var_dump($fn->prepareArrayDoublePointer($_POST, false));
//exit;
if (empty($_FILES['img']['name'])) {
    var_dump($db->insertCD($fn->prepareArrayDoublePointer($_POST, false)));
    // vai retornar a quantidade de linhas afetadas
} else {
    if (move_uploaded_file($_FILES['img']['tmp_name'], '../img/cd/' . $_FILES['img']['name'])) {
        $_POST['img'] = $_FILES['img']['name'];
        var_dump($db->insertCD($fn->prepareArrayDoublePointer($_POST, false)));
        // vai retornar a quantidade de linhas afetadas
    }
}

Пример #6

Файл: index.php Проект: Joeverson/projetopweb

<?php

require_once "../../controller/autoload.inc";
include "../add-on/header.php";
$db = new view\cd\model\DBCd();
?>
    <div class="container">
        <div class="row">
            <div class="col-md-8 col-md-offset-2">
                <div class="panel panel-default">
                    <div class="panel-body">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="col-md-2">
                                    <a href="../dashboard/index.php" class="btn btn-default btn-fab btn-raised mdi-navigation-arrow-back"></a>
                                </div>
                                <div class="col-md-8">
                                    <h1 class="text-center text-capitalize">CD</h1>
                                </div>
                                <div class="col-md-2">
                                    <a href="javascript:void(0)" class="btn btn-success btn-fab btn-raised mdi-content-add fn" data-title="Criando CD..." data-url="pages/add.cd.php" data-toggle="modal" data-target="#myModal"></a>
                                </div>
                            </div>
                        </div>
                        <div class="row margin-top-60">
                            <div class="col-md-12">
                                <div class="list-group">
                                    <!-- inicio de modelo -->
                                    <?php 
foreach ($db->getAll() as $k) {
    ?>