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 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
  • ¥50 STM32单片机传感器读取错误
  • ¥50 power BI 从Mysql服务器导入数据，但连接进去后显示表无数据
  • ¥15 (关键词-阻抗匹配，HFSS，RFID标签天线)