php类不工作的功能

Question

我遇到了一些奇怪的问题。使用我连接到 mysql 的类，连接成功但是当我调用函数时它不起作用。我使用我自己的错误处理程序，如果我在 php 中遇到此行的一些错误，它会使用 exit；我在调用函数之前使用了 echo 并且在页面没有被杀死之后(这意味着 php 工作成功)mysql 查询我也检查了它的工作但是当我使用 return 'some text' 时；它没有回来。有什么建议为什么功能不起作用？

我的类(class):

<?php
include('../config.php');
include('../chat_error_handler.php');

class Chat {
    private $mysqli;
    var $con;

    //Constructor open db conn
    function __construct() {
        $this->mysqli = new mysqli('localhost', 'root', '', 'test');
    }

    //destructor close db conn
    function __destruct() {
        $this->mysqli->close();
    }

    public function postNewMessage($user_name, $message, $color, $room_id) {
        $user_name = $this->mysqli->real_escape_string($user_name);
        $message = $this->mysqli->real_escape_string($message);
        $color = $this->mysqli->real_escape_string($color);
        $room_id = $this->mysqli->real_escape_string($room_id);
        $query = 'INSERT INTO chat (posted_on, account, message, color, room_id)' .
        ' VALUES (NOW(), "'.$user_name.'", "'.$message.'", "'.$color.'", "'. $room_id .'")';
        $result = $this->mysqli->query($query);
        return 'Pranesimas';
        $result->close();
    }

我的 php 用于调试:

<?php
include('core/chat.class.php');
include('chat_error_handler.php');
$chat = new Chat();
$message = 'testas';
echo $message.'<br/>';
$chat->postNewMessage('testing', $message, '#000000', 1);
echo '<br/>'.$message;
?>

Answer 1

public function postNewMessage($user_name, $message, $color, $room_id) {

    $user_name = $this->mysqli->real_escape_string($user_name);
    $message = $this->mysqli->real_escape_string($message);
    $color = $this->mysqli->real_escape_string($color);
    $room_id = $this->mysqli->real_escape_string($room_id);

    $query = 
       "INSERT INTO 
            chat ( posted_on, 
                   account, 
                   message, 
                   color, 
                   room_id )
        VALUES ( NOW(), 
                 '". $user_name ."', 
                 '". $message ."', 
                 '". $color ."', 
                 '". $room_id ."' )";

    $result = $this->mysqli->query($query);

    if ( $result ) {
        return 'Pranesimas'; 
    } else {
        return false;
    }
}