تحسين برنامج الدردشة باستخدام PHP وMySQLi

04/03/2024

4 دقيقة واحدة

To create a chat program using PHP and MySQLi, you can follow these general steps:

Database Setup: Create a database to store chat messages and user information.
Login & Registration: Since you’ve already created a login & registration form, ensure it securely handles user authentication.
Chat Interface: Design a chat interface where users can send and receive messages. Use HTML, CSS, and JavaScript for the front-end.
PHP Backend: Use PHP for the server-side logic. This includes handling incoming messages, storing them in the database, and retrieving messages from the database.
AJAX for Real-Time Updates: Use AJAX to periodically fetch new messages without refreshing the entire page.

Here’s a basic example to get you started:

Database Table

sql
CREATE TABLE messages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sender_id INT,
    receiver_id INT,
    message TEXT,
    sent_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

HTML (chat interface)

html
html>
<html>
<head>
    <title>Chattitle>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js">script>
head>
<body>
    <div id="chat-box">
        
    div>
    <input type="text" id="message" placeholder="Type a message...">
    <button onclick="sendMessage()">Sendbutton>
    <script>
        function sendMessage() {
            var message = $("#message").val();
            $.post("send_message.php", {message: message}, function(data) {
                $("#message").val("");
            });
        }

        function getMessages() {
            $.get("get_messages.php", function(data) {
                $("#chat-box").html(data);
            });
        }

        setInterval(getMessages, 1000); // Fetch messages every 1 second
    script>
body>
html>

PHP (send_message.php)

php

session_start();

if (isset($_SESSION['user_id'])) {
    $mysqli = new mysqli("localhost", "username", "password", "database");

    if ($mysqli->connect_error) {
        die("Connection failed: " . $mysqli->connect_error);
    }

    $message = $mysqli->real_escape_string($_POST['message']);
    $sender_id = $_SESSION['user_id'];
    $receiver_id = 1; // Assuming receiver_id 1 is the admin or another user

    $query = "INSERT INTO messages (sender_id, receiver_id, message) VALUES ('$sender_id', '$receiver_id', '$message')";
    $mysqli->query($query);
    $mysqli->close();
}
?>

PHP (get_messages.php)

php

session_start();

if (isset($_SESSION['user_id'])) {
    $mysqli = new mysqli("localhost", "username", "password", "database");

    if ($mysqli->connect_error) {
        die("Connection failed: " . $mysqli->connect_error);
    }

    $receiver_id = $_SESSION['user_id'];
    $query = "SELECT * FROM messages WHERE receiver_id = '$receiver_id'";
    $result = $mysqli->query($query);

    while ($row = $result->fetch_assoc()) {
        echo $row['message'] . "
";
    }

    $mysqli->close();
}
?>

Replace "username", "password", and "database" with your MySQL credentials and database name. Also, ensure you sanitize user inputs and handle errors appropriately for production use.

Database Table

HTML (chat interface)

PHP (send_message.php)

PHP (get_messages.php)

المزيد من المعلومات

مقالات ذات صلة

تطبيق تحديد مواقع داخلية باستخدام الواي فاي

تحقيق تأثير تلاشي للشخصيات في Swift.

تنسيق النصوص في Python 3: أساليب وتقنيات فعّالة

تحسين تجربة البرمجة باستخدام IntelliJ IDEA