downing1988 2017-08-20 05:25
浏览 30
已采纳

PHP无法与MySQL连接

This code is supposed to get the information from a simple HTML form and post in into a MySQL database:

<html>

<head>
<title>Cadastro de Cinema</title>
<head>

<body>
<?php
$host = "localhost";
$user = "root";
$pass = "";
$banco = "cinema";
$con = @mysqli_connect($host, $user, $pass, $db) or die(mysql_error());

?>

<?php

$email= isset($_POST['email']) ? $_POST['email'] : '';
$senha= isset($_POST['senha']) ? $_POST['senha'] : '';
$nome= isset($_POST['nome']) ? $_POST['nome'] : '';
$rua= isset($_POST['rua']) ? $_POST['rua'] : '';
$bairro= isset($_POST['bairro']) ? $_POST['bairro'] : '';
$numero= isset($_POST['numero']) ? $_POST['numero'] : '';
$cidade= isset($_POST['cidade']) ? $_POST['cidade'] : '';
$sql = mysqli_query($con, "INSERT INTO cinema(email, senha, nome, rua, bairro, numero, cidade)
VALUES ('$email', '$senha', '$nome', '$rua', '$bairro', '$numero', '$cidade')");

echo "OK";
?>
</body>

</html>

When I test it, I get the "OK" echo, but the info is not in the mySQL database. What could it be?

</div>
  • 写回答

2条回答 默认 最新

  • doumi9661 2017-08-20 05:51
    关注

    It would be better if you submit your database here. So, we can check if the table/data type is supported by this query or not. Please try this:

    <html>

<head>
<title>Cadastro de Cinema</title>
<head>

<body>
<?php
$host = "localhost";
$user = "root";
$pass = "";
$banco = "cinema";
$con = @mysqli_connect($host, $user, $pass, $banco) or die("Could not connect to database. " . mysqli_connect_error());
?>

<?php

$email= isset($_POST['email']) ? $_POST['email'] : '';
$senha= isset($_POST['senha']) ? $_POST['senha'] : '';
$nome= isset($_POST['nome']) ? $_POST['nome'] : '';
$rua= isset($_POST['rua']) ? $_POST['rua'] : '';
$bairro= isset($_POST['bairro']) ? $_POST['bairro'] : '';
$numero= isset($_POST['numero']) ? $_POST['numero'] : '';
$cidade= isset($_POST['cidade']) ? $_POST['cidade'] : '';
$sql = mysqli_query($con, "INSERT INTO cinema(email, senha, nome, rua, bairro, numero, cidade)
VALUES ('$email', '$senha', '$nome', '$rua', '$bairro', '$numero', '$cidade')");

echo "OK";
?>
</body>

</html>

    Simple Database Table I Used:

    CREATE TABLE `cinema` (
  `email` varchar(50) NOT NULL,
  `senha` varchar(50) NOT NULL,
  `nome` varchar(50) NOT NULL,
  `rua` varchar(50) NOT NULL,
  `bairro` varchar(50) NOT NULL,
  `numero` varchar(50) NOT NULL,
  `cidade` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    Thank you

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 软件供应链安全是跟可靠性有关还是跟安全性有关？
  • ¥15 电脑蓝屏logfilessrtsrttrail问题
  • ¥20 关于wordpress建站遇到的问题！(语言-php)（相关搜索：云服务器）
  • ¥15 【求职】怎么找到一个周围人素质都很高不会欺负他人，并且未来月薪能够达到一万以上（技术岗）的工作？希望可以收到写有具体，可靠，已经实践过了的路径的回答？
  • ¥15 Java+vue部署版本反编译
  • ¥100 对反编译和ai熟悉的开发者。
  • ¥15 带序列特征的多输出预测模型
  • ¥15 Python 如何安装 distutils模块
  • ¥15 关于#网络#的问题：网络是从楼上引一根网线下来，接了2台傻瓜交换机，也更换了ip还是不行
  • ¥15 资源泄露软件闪退怎么解决？