Database access failed (Table does not exist)?

Question

PHP

Faced the problem of working with databases using php. Everything seems to be correct in the code. Checked 5 times.
Calling the page with the form gives an error that it cannot find the table, although it exists. If you use other databases (not test), it gives an error that it cannot connect to the database.

login.php file

<?php
  $db_hostname = 'localhost';
  $db_database = 'test';
  $db_username = 'root';
  $db_password = '';
?>

sqltest.php file

<?php
  require_once 'login.php';
  $db_server = mysql_connect($db_hostname, $db_username, $db_password);

  if (!$db_server) die ("Невозможно подключиться к MYSQL: " . mysql_error());

  mysql_select_db ($db_database, $db_server)
    or die("Невозможно выбрать БД: " . mysql_error());

  if (isset ($_POST['delete']) && isset($_POST['isbn']))
  {
    $isbn = get_post('isbn');
    $query = "DELETE FROM classics WHERE isbn = '$isbn'";

    if (!mysql_query($query, $db_server))
      echo "Сбой при удалении данных: $query<br>" . 
      mysql_error() . "<br><br>";
  }

  if (isset ($_POST['author']) &&
      isset ($_POST['title']) &&
      isset ($_POST['category']) &&
      isset ($_POST['year']) &&
      isset ($_POST['isbn']))
  {
    $author = get_post('author');
    $title = get_post('title');
    $category = get_post('category');
    $year = get_post('year');
    $isbn = get_post('isbn');

    $query = "INSERT INTO classics VALUES" .
    "('$author', '$title', '$category', '$year', '$isbn')";

    if (!mysql_query($query, $db_server))
      echo "Сбой при вставке данных: $query<br>" .
      mysql_error() . "<br><br>";
  }

  echo <<<_END
  <form action = "sqltest.php" method = "post"><pre>
    Author <input type = "text" name = "author">
     Title <input type = "text" name = "title">
  Category <input type = "text" name = "category">
      Year <input type = "text" name = "year">
      ISBN <input type = "text" name = "isbn">
     <input type = "submit" value = "ADD RECORD">
  </pre></form>
_END;

  $query = "SELECT * FROM classics";
  $result = mysql_query($query);

  if(!$result) die ("Сбой при доступе к БД: " . mysql_error());
  $rows = mysql_num_rows($result);

  for($j = 0; $j < $rows; ++$j)
  {
    $row = mysql_fetch_row($result);
    echo <<<_END
  <pre>
  Author   $row[0]
   Title    $row[1]
  Category $row[2]
    Year     $row[3]
    ISBN     $row[4]
  </pre>
  <form action = "sqltest.php" method = "post">
  <input type = "hidden" name = "delete" value = "yes">
  <input type = "hidden" name = "isbn" value = "$row[4]">
  <input type = "submit" value = "DELETE RECORD"></form>
_END;
  }

  mysql_close($db_server);

  function get_post($var)
  {
    return mysql_real_escape_string($_POST[$var]);
  }
?>

Please help me understand

Answer 1

Are you sure you have root without a password? And do you have all the necessary rights?

Answer 2

Users

Answer 3

Hah! Your user does not have rights to work with this database!!!

Answer 4

bbf = abf[1]['attachments']
You have a list in abf. Which element with index 1 is a dictionary with the necessary data