0

PHP trying to connect to MySQL database! but the code doesn't work.

Here is the code, when I put the code in a PHP file, the display shows actually the code I wrote.

I am stuck, please help!

<?php // sqltest.php
  require_once '../../htdocs/login.php';
  $conn = new mysqli($hn, $un, $pw, $db);
  if ($conn->connect_error) die($conn->connect_error);

  if (isset($_POST['delete']) && isset($_POST['isbn']))
  {
    $isbn   = get_post($conn, 'isbn');
    $query  = "DELETE FROM classics WHERE isbn='$isbn'";
    $result = $conn->query($query);
    if (!$result) echo "DELETE failed: $query<br>" .
      $conn->error . "<br><br>";
  }

  if (isset($_POST['author'])   &&
      isset($_POST['title'])    &&
      isset($_POST['category']) &&
      isset($_POST['year'])     &&
      isset($_POST['isbn']))
  {
    $author   = get_post($conn, 'author');
    $title    = get_post($conn, 'title');
    $category = get_post($conn, 'category');
    $year     = get_post($conn, 'year');
    $isbn     = get_post($conn, 'isbn');
    $query    = "INSERT INTO classics VALUES" .
      "('$author', '$title', '$category', '$year', '$isbn')";
    $result   = $conn->query($query);

    if (!$result) echo "INSERT failed: $query<br>" .
      $conn->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 = $conn->query($query);
  if (!$result) die ("Database access failed: " . $conn->error);

  $rows = $result->num_rows;

  for ($j = 0 ; $j < $rows ; ++$j)
  {
    $result->data_seek($j);
    $row = $result->fetch_array(MYSQLI_NUM);

    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;
  }

  $result->close();
  $conn->close();

  function get_post($conn, $var)
  {
    return $conn->real_escape_string($_POST[$var]);
  }
?>

enter image description here I am reading this book called Learning PHP, MySQL, & JavaScript 4th Edition By Robin Nixon, but when I write the exact code, it doesn't show like in the book but I get that like in the photo. I am trying to connect MySQL with PHP, using xampp. I created also the php.login file. I wrote my username and password, and saved it in the same directory with this code! please help

MLavoie
  • 8,799
  • 39
  • 36
  • 51
ardi hajrizaj
  • 3
  • 4
  • 1
    Do you have PHP installed on your machine/server? Btw, that's a `.html` file you're viewing, might want to rename it to `.php` – brombeer Mar 14 '18 at 10:00
  • 5
    After looking to your picture I saw that you saved your file with `index.html` . change it to `index.php` and it will start working – Serving Quarantine period Mar 14 '18 at 10:01
  • [This answer](https://stackoverflow.com/a/11312349/3441504) to another question will explain your problem. As others before me mentioned here: it's because your file type `.html` – kscherrer Mar 14 '18 at 10:05
  • i saved it as .php, but when i run with dreamweaver in chrome live preview, i get that, i want to see this code working! – ardi hajrizaj Mar 14 '18 at 10:26
  • If above solution doesnot help then there may be something wrong with your configuration, check [this answer](https://stackoverflow.com/questions/5121495/php-code-is-not-being-executed-instead-code-shows-on-the-page) to another question similar to your question. – Sushank Pokharel Mar 14 '18 at 10:40
  • You need to use the `.php` extension (not `.html`) for the file name and make sure your webserver knows how to handle it. – axiac Mar 14 '18 at 11:40
  • you need to run it via Apache server with PHP installed so that the PHP engine can execute the code, Dreamweaver cannot do that. In fact I'd have thought Dreamweaver was generally not the best IDE to use for actual programming rather than web design. Visual Studio Code or a dedicated PHP IDE would be much more useful. – ADyson Mar 14 '18 at 11:42
  • You can check the hostname,username, password and database coming or not. – itsme Mar 14 '18 at 11:45
  • @itsme look at the screenshot, we're stuck a long way before that. The code is not even executing. – ADyson Mar 14 '18 at 12:14

0 Answers0