dimaslanjaka / universal-framework

src/DB/backup.php

<?php

namespace DB;

use PDO;

This use statement conflicts with another class in this namespace, DB\PDO. Consider defining an alias.

class backup
{
  /**
   * \DB\pdo instance.
   *
   * @var \DB\pdo
   */
  private $pdo;

  public function __construct(pdo $pdo)
  {
    $this->pdo = $pdo;

It seems like $pdo of type PDO is incompatible with the declared type DB\pdo of property $pdo.

  }

  public function backup()
  {
    $DBH = $this->pdo->pdo();
    $show = $DBH->query('SHOW TABLES');
    $tables = [];
    while ($row = $show->fetch(PDO::FETCH_NUM)) {
      $tables[] = $row[0];
    }
    $table_creation = '';
    foreach ($tables as $table) {
      $result = $DBH->query("SELECT * FROM $table");
      $num_fields = $result->columnCount();

The assignment to $num_fields is dead and can be removed.

      $num_rows = $result->rowCount();

The assignment to $num_rows is dead and can be removed.

      $pstm2 = $DBH->query("SHOW CREATE TABLE $table");
      $row2 = $pstm2->fetch(PDO::FETCH_NUM);
      $ifnotexists = str_replace('CREATE TABLE', 'CREATE TABLE IF NOT EXISTS', $row2[1]);
      $table_creation .= "\n\n" . $ifnotexists . ";\n\n";
    }
    header('Content-Type: application/json');
    echo $table_creation;
    exit;

Using exit here is not recommended.

  }
}