Home > Backend Development > PHP Tutorial > mysql-PHP,MySQL请问这两行代码有什么区别?

mysql-PHP,MySQL请问这两行代码有什么区别?

WBOY
Release: 2016-06-02 11:33:44
Original
1166 people have browsed it

mysqlphp

请问这两行代码有什么区别?我试了一下都可以运行成功。

<code> $query = "insert into books values (' ".$isbn." ', ' ".$author." ', ' ".$title." ', ' ".$price." ')";</code>
Copy after login
<code>$query = "insert into books values (' $isbn ', ' $author ', ' $title', ' $price ')";` </code>
Copy after login

完整代码from PHP和MySQL Web开发(原书第4版):

<code>             <title>TODO supply a title</title>        <meta charset="UTF-8">        <meta name="viewport" content="width=device-width, initial-scale=1.0">                <h1>Book-O-Rama Book Entry Result</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', '123', 'mydb');        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();        ?>    </code>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template