PHP Database::outtname Examples

Example #1

File: update.php Project: htmaxxt/htmaxxt

<?php

include 'connect.php';
if (isset($_POST['save'])) {
    $pdo = Database::connect();
    $utf = 'SET CHARACTER SET "utf8"';
    $pdo->query($utf);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "UPDATE " . Database::outtname() . " SET title = :title, author = :author, pub_year = :year, pages = :pages WHERE id = :id";
    $query = $pdo->prepare($sql);
    $query->execute(array(':title' => $_POST['title'], ':author' => $_POST['author'], ':year' => $_POST['year'], ':pages' => $_POST['pages'], ':id' => $_POST['id']));
    Database::disconnect();
    header("Location: index.php");
}

Example #2

File: index.php Project: htmaxxt/htmaxxt

    </div>
    <table id="myTable" class="tablesorter">
      <thead>
        <tr>
          <th></th>
          <th>Название книги</th>
          <th>Автор книги</th>
          <th>Год публикации</th>
          <th>Кол-во страниц</th>
        </tr>
      </thead>
      <tbody>
        <?php 
include 'connect.php';
$pdo = Database::connect();
$sql = 'SELECT * FROM ' . Database::outtname() . ' ORDER BY title ASC';
$utf = 'SET CHARACTER SET "utf8"';
$pdo->query($utf);
foreach ($pdo->query($sql) as $row) {
    ?>
        <tr>
          <td><input type="checkbox" name="chk[]" class="chk" value="<?php 
    echo $row['id'];
    ?>
"/></td>
          <td> <?php 
    echo $row['title'];
    ?>
 </td>
          <td> <?php 
    echo $row['author'];

Example #3

File: add.php Project: htmaxxt/htmaxxt

            <script> alert("Можно добавить не больше 10 книг за один сеанс!"); </script> <?php 
        } else {
            ?>
 
            <script> alert("Вы не указали количество книг, которые хотите добавить!"); </script> <?php 
        }
    }
}
include 'connect.php';
if (isset($_POST['create'])) {
    $num = $_POST['num_rec'];
    $pdo = Database::connect();
    $utf = 'SET CHARACTER SET "utf8"';
    $pdo->query($utf);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO " . Database::outtname() . "(title, author, pub_year, pages) VALUES(:title, :author, :year, :pages)";
    $query = $pdo->prepare($sql);
    $title = $_POST['title'];
    $author = $_POST['author'];
    $year = $_POST['year'];
    $pages = $_POST['pages'];
    for ($i = 0; $i < $num; $i++) {
        $query->execute(array(':title' => $title[$i], ':author' => $author[$i], ':year' => $year[$i], ':pages' => $pages[$i]));
    }
    Database::disconnect();
    header("Location: index.php");
}
?>
 
  </form>
</body>

Example #4

File: edit.php Project: htmaxxt/htmaxxt

    </table>
    <table class="tablesorter">
      <thead>
        <tr>
          <th>Название книги:</th>
          <th>Автор книги:</th>
          <th>Год публикации:</th>
          <th>Количество страниц:</th>
        </tr>
      </thead>
      <tbody>
        <?php 
$id = $_REQUEST['id'];
include 'connect.php';
$pdo = Database::connect();
$sql = "SELECT * FROM " . Database::outtname() . " WHERE id = :id";
$utf = 'SET CHARACTER SET "utf8"';
$pdo->query($utf);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = $pdo->prepare($sql);
$query->execute(array(':id' => $id));
$data = $query->fetch(PDO::FETCH_ASSOC);
?>
        <tr>
          <td>
            <input type="hidden" name="id" value="<?php 
echo $data['id'];
?>
" />
            <input type="text" name="title" value="<?php 
echo $data['title'];

Example #5

File: delete.php Project: htmaxxt/htmaxxt

        </script>
        <?php 
    } else {
        ?>
        <script>
            alert("Для завершения операции как минимум одна книга должна быть отмечена");
            window.location.href="index.php";
        </script>
        <?php 
    }
} else {
    if (isset($_REQUEST['id'])) {
        $id = $_REQUEST['id'];
        $pdo = Database::connect();
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $sql = "DELETE FROM " . Database::outtname() . " WHERE id = :id";
        $query = $pdo->prepare($sql);
        $query->execute(array(':id' => $id));
        Database::disconnect();
        ?>
    <script>
        alert("Книга удалена из библиотеки!");
        window.location.href="index.php";
    </script>
    <?php 
    } else {
        ?>
    <script>
        alert("Ошибка! Параметры удаления не заданы, попробуйте снова!");
        window.location.href="index.php";
    </script>