query无法访问我的数据库

hrirmatl  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(449)

我目前正在为学校开发一个cms系统,在这个系统中所有的信息都来自一个表单,我遇到了一个问题。突然间,我的“插入帖子”功能不起作用了,我不知道为什么。我将在本文下面提供所有必要的代码。提前感谢您的帮助!:)
conn.php(用于连接数据库)

<?php
session_start();

if(!isset($_SESSION["loggedin"]))
{
    $_SESSION["loggedin"] = "false";
}

    $servername = "localhost";
    $username = "root";
    $password = "";
    $database = "cms";

    define('BASE_URL', 'http://localhost/cms');

$conn = new mysqli($servername, $username, $password, $database);

if($conn->connect_error) 
{
    die("Error: " . $conn->connect_error);
}

newpost.php(用于将文章插入数据库)

<?php

require 'conn.php';

if($_SESSION["loggedin"] == "true"){}

else 
{
    header('Location: ' . BASE_URL . '/login.php');
}

if(isset($_POST['save'])){

            $title = $_POST['title'];
            $description = $_POST['description'];
            $text = $_POST['text'];
            $course = $_POST['course'];

            $insert = $conn->prepare("
                INSERT INTO posts (title, description, text, course)
                VALUES (:title, :description, :text, :course)
            ");

            $insert->execute([
                'title' => $title, 'description' => $description, 'text' => $text, 'course' => $course 
            ]);

            header('Location: ' . BASE_URL . '/list.php');  
}
?>

<div class="page">

<h1>Add project</h1>
<form method="POST" action="list.php"> 
<label id="first">Title:</label><br/>
<input type="text" name="title"><br/>

<label id="first">Description:</label><br/>
<textarea rows="5" cols="75" type="text" name="description"></textarea><br/>

<label id="first">Body:</label><br/>
<textarea rows="10" cols="75" type="text" name="text"></textarea><br/>

<label id="first">Vak (DED/SCO/UXU/PTM):</label><br/>
<select name="course">
    <option value="DED">DED</option>
    <option value="SCO">SCO</option>
    <option value="UXU">UXU</option>
    <option value="PTM">PTM</option>
</select><br/>
<button type="submit" name="save">Opslaan</button>
</form>

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题