PHP view\cantor\model\DBCantor Examples

Example #1

File: cantor.insert.php Project: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cantor\model\DBCantor();
$fn = new controller\functions();
if (empty($_POST)) {
    exit;
}
$db->insertCantor($fn->prepareArrayDoublePointer($_POST, false));
// vai retornar a quantidade de linhas afetadas

Example #2

File: delete.cantor.php Project: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cantor\model\DBCantor();
if (empty($_POST)) {
    exit;
}
$file = $db->deleteCantor($_POST['id_user']);

Example #3

File: cantor.update.php Project: Joeverson/projetopweb

<?php

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

Example #4

File: add.cd.php Project: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cantor\model\DBCantor();
?>

<div class="row">
    <div class="col-md-12 urlForm" data-url="controller/cd.insert.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" 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" required="">
                        </div>
                    </div>
                </div>
                <div class="row">
                    <label for="textArea" class="col-lg-2 control-label">Descrição</label>
                    <div class="col-lg-10">
                        <textarea class="form-control" name="descricao" rows="3" id="textArea"></textarea>
                        <span class="help-block">Breve descrição sobre o cd </span>
                    </div>

Example #5

File: editar.cantor.php Project: Joeverson/projetopweb

<?php

require_once "../../../controller/autoload.inc";
$db = new view\cantor\model\DBCantor();
$user = $db->selectCdById($_POST['id'])[0];
?>
<div class="row">
    <form id="editCD">
        <div class="col-md-12 urlForm" data-url="controller/cantor.update.php">
            <fieldset>
                <div class="row">
                    <div class="">
                        <label for="inputEmail" class="col-lg-2 control-label">Nome do Cantor</label>
                        <div class="col-lg-10">
                            <input type="text" name='name' class="form-control" value="<?php 
echo $user['name'];
?>
"  id="inputEmail" placeholder="Nome do Cantor">
                        </div>
                    </div>
                </div>
            </fieldset>
            <input type="hidden" name="id_user" value="<?php 
echo $user['id_cantor'];
?>
"/>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal">Fechar</button>
                <button type="submit" class="btn btn-primary">Salvar</button>
            </div>
        </div>