【个人学习之路】PHP和MySQL实现上传图书信息

最新推荐文章于 2022-10-21 11:47:45 发布

原创最新推荐文章于 2022-10-21 11:47:45 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

MySQL 专栏收录该内容

4 篇文章

订阅专栏

一个用于录入新书信息的系统，包括ISBN、作者、书名和价格，并将信息保存到数据库中。

Book-O-Rama - New Book Entry

ISBN
Author
Title
Price

<html>
<head>
  <title>Book-O-Rama Book Entry Results</title>
</head>
<body>
<h1>Book-O-Rama Book Entry Results</h1>
<?php
  // create short variable names
  $isbn=$_POST['isbn'];
  $author=$_POST['author'];
  $title=$_POST['title']; 
  $price=$_POST['price'];
  //
  if (!$isbn || !$author || !$title || !$price) {
     echo "You have not entered all the required details.<br />"
          ."Please go back and try again.";
     exit;
  }

  if (!get_magic_quotes_gpc()) {
    $isbn = addslashes($isbn);
    $author = addslashes($author);
    $title = addslashes($title);
    $price = doubleval($price);
  }
 
  @ $db = new mysqli('localhost', 'root', '', 'books'); 

  if (mysqli_connect_errno()) {
     echo "Error: Could not connect to database.  Please try again later.";
     exit;
  }

  $query = "insert into books values
            ('".$isbn."', '".$author."', '".$title."', '".$price."')";
  $result = $db->query($query);

  if ($result) {
      echo  $db->affected_rows." book inserted into database.";
  } else {
  	  echo "An error has occurred.  The item was not added.";
  }

  $db->close();
?>
</body>
</html>