代码之家 › 专栏 › 技术社区 › suresh

在表中插入值在PHP中不工作,使用

pdo php

suresh · 技术社区 · 6 年前

我正试图在表中插入值,我不知道到底发生了什么,它不起作用,我也看不到任何错误。

我不知道我在哪里犯了错误,有人能帮我吗?

这是我的代码:

数据库.php

    <?php
$host = 'localhost';
$db   = 'pes';
$user = 'root';
$pass = '';
$charset = 'utf8';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
    \PDO::ATTR_ERRMODE            => \PDO::ERRMODE_EXCEPTION,
    \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
    \PDO::ATTR_EMULATE_PREPARES   => false,
];
$pdo = new \PDO($dsn, $user, $pass, $opt);
?>

内容处理.php

   <?php

class ContentProcess {
    /* Properties */
    private $conn;

    /* Get database access */
    public function __construct(\PDO $pdo) {
        $this->conn = $pdo;
    }

    function ContentProcess() {
        global $session;
        if (isset($_POST['createnewcontent'])) {
            $this->createnewcontent();
        } 
      }


     public function createnewcontent()
    {
        $description = $_POST['description'];
        $typeofpage = $_POST['typeofpage'];
        $time = time();
        $q = "INSERT INTO content VALUES ('', '$description', '$typeofpage', '1', '$time', '1', '$time')";
        $this->conn->query($q);
        header("Location:content.php");
    }

    function getcontentdescription() {
         return $this->conn->query("SELECT description FROM content")->fetchAll();
    }

}

表单代码:

content.php文件

<?php 
include("include/header.php");
include("include/database.php");
include 'contentprocess.php';
?>
    <div class="modal fade" id="createGroup" tabindex="-1" role="dialog" aria-labelledby="createGroup" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content" id="modal-content">
            <form action="contentprocess.php" id="user-groups-create" class="form-horizontal" method="post">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                    <h4 class="modal-title" id="myModalLabel">Create a New Content</h4>
                </div>
                <div class="modal-body" id="modal-body">                                   
                    <div class="form-group">
                        <label class="col-sm-4 control-label">Description: </label>
                        <div class="col-md-8">
                            <input type="text" id="description" name="description" class="form-control" placeholder="Description" />
                        </div>
                    </div>
                    <div class="form-group">
                        <label  class="col-sm-4 control-label">Content Type: </label>
                        <div class="col-md-8">
                            <select class="form-control" name="typeofpage">
                                            <option value="2" selected="selected">Text</option>
                                            <option value="1">Image</option>
                                            <option value="4">Video</option>
                                            <option value="7">Audio</option>

                           </select>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <input type="hidden" name="createnewcontent" value="1">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    <button type="submit" name="submit"  class="btn btn-primary">Create Content</button>
                </div>

            </form>
        </div>
    </div>
</div>

有人能帮我一下我犯了什么错误吗

1 回复 | 直到 6 年前

Vishnu Jayan 6 年前

<?php 
include("include/header.php");
include("include/database.php");
require_once('contentprocess.php');
$contentProcess = new ContentProcess();
if(isset($_POST['submit'])){
    $contentProcess->createnewcontent();
}
?>
    <div class="modal fade" id="createGroup" tabindex="-1" role="dialog" aria-labelledby="createGroup" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content" id="modal-content">
            <form action="" id="user-groups-create" class="form-horizontal" method="post">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                    <h4 class="modal-title" id="myModalLabel">Create a New Content</h4>
                </div>
                <div class="modal-body" id="modal-body">                                   
                    <div class="form-group">
                        <label class="col-sm-4 control-label">Description: </label>
                        <div class="col-md-8">
                            <input type="text" id="description" name="description" class="form-control" placeholder="Description" />
                        </div>
                    </div>
                    <div class="form-group">
                        <label  class="col-sm-4 control-label">Content Type: </label>
                        <div class="col-md-8">
                            <select class="form-control" name="typeofpage">
                                            <option value="2" selected="selected">Text</option>
                                            <option value="1">Image</option>
                                            <option value="4">Video</option>
                                            <option value="7">Audio</option>

                           </select>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <input type="hidden" name="createnewcontent" value="1">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    <button type="submit" name="submit"  class="btn btn-primary">Create Content</button>
                </div>

            </form>
        </div>
    </div>
</div>

<?php
class Database{
    function __construct(){
        //config
        $this->host = 'localhost';
        $this->db = 'pes';
        $this->user = 'root';
        $this->pass = '';
        $this->charset = 'utf8';
        
        //connection
        try{
            $this->db = new PDO("mysql:host=$this->host;dbname=$this->db;charset=$this->charset", $this->user, $this->pass);
            return $this->db;
        }
        catch(PDOException $e){
            echo "Connection failed: " . $e->getMessage();
        }
    }

    public function query($q){
        return $this->db->query($q);
    }
}
?>

<?php 
require_once './include/database.php';

class ContentProcess {
    private $conn;

    function __construct() {
        $this->conn = new Database();
    }

    
     public function createnewcontent()
    {
        $description = $_POST['description'];
        $typeofpage = $_POST['typeofpage'];
        $time = time();
        $q = "INSERT INTO content(column1, column2,...) VALUES ('', '$description', '$typeofpage', '1', '$time', '1', '$time')"; // use this instead of $q = "INSERT INTO content VALUES ('', '$description', '$typeofpage', '1', '$time', '1', '$time')";
        $this->conn->query($q);
        header("Location:content.php");
    }

    function getcontentdescription() {
        return $this->conn->query("SELECT description FROM content")->fetchAll();
    }

}