Post and Comment Function in PHP/MySQL

Submitted by alpha_luna on Thursday, June 9, 2016 - 12:55.

If you are looking for on how to create Post and Comment Function using PHP/MySQL then you are at the right place. This program created in PHP/MySQL to show how to use this post and comment function with timestamp or time ago. It will display the time posted by the user.

Account Information

Username: admin
Password: admin

Username: user
Password: user

Database Information

Database Name: post_comment

Creating two form field, one for the Registration Form and one for the Log In Form as in the image below. Result - Registration and Log In Form

Here's the source code of the image above:

<form id="login_form"  method="post" style="float:left;">
        <h2>Please Login</h2>
                <input type="text"  id="username" name="username" placeholder="Enter your User Name" required autofocus="autofocus"><br /><br />
                <input type="password" id="password" name="password" placeholder="Enter your Password" required><br /><br />
                <button name="login" type="submit">Sign in</button>
</form>
<form method="POST" action="signup.php" id="signup" style="float:right;">
        <h2>Register here</h2>
                <input type="text" name="username" Placeholder="Enter your User Name"><br /><br />
                <input type="password" name="password" Placeholder="Enter your Password"><br /><br />
                <input type="text" name="firstname" Placeholder="Enter your First Name"><br /><br />
                <input type="text" name="lastname" Placeholder="Enter your Last Name"><br /><br /><br />
                <button name="save" type="submit">Save</button>
</form>

Creating post box for the user where they can post something shown in the image below. Result - Post Box

Here's the source code of the image above:

<h2>WELCOME!</h2>
        <b>
                <?php echo $member_row['firstname']." ".$member_row['lastname']; ?>
        </b>
        <a href="logout.php"><button>Log Out</button></a>
 
<form method="post"> 
        <textarea name="post_content" rows="7" cols="64" placeholder="Say something . . . . ." required autofocus="autofocus"></textarea>
        <br>
        <button name="post">&nbsp;POST</button>
        <br>
        <hr>
</form>

After creating the post box, we are going to create the comment box. The comment box now looks like this. Result - Comment Box

Here's the source code of the image above:

<form method="post" style="background:azure; border:1px solid blue; padding:10px;">
        <br>
        <input type="hidden" name="id" value="<?php echo $id; ?>">
        <textarea name="comment_content" rows="2" cols="44" placeholder="Write a comment . . . . ." required></textarea>
        <br>
        <input type="submit" class="comment_button" name="comment">
</form>

Here's the source code for the Sign Up Form and Log In Form.

For Sign Up Form

<?php
include ('dbconn.php');
 
$username = $_POST['username'];
$password = $_POST['password'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
mysql_query("insert into user (username, password, firstname, lastname) values ('$username', '$password', '$firstname', '$lastname')");
?>
                        <script>
        alert('Successfully Signed Up! You can now Log in your Account');
        window.location = 'index.php';
</script>

For Log In Form

<?php
include ('dbconn.php');
 
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
$query = mysql_query("SELECT * FROM user WHERE username='$username' AND password='$password'") or die(mysql_error());
$count = mysql_num_rows($query);
$row = mysql_fetch_array($query);
 
if ($count > 0)
        {
        $_SESSION['id'] = $row['user_id'];
        echo 'true';
        }
  else
        {
        echo 'false';
        }
 
?>

The output looks like this. Result - Output

Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Post and Comment Function in PHP/MySQL

Account Information

Database Information

For Sign Up Form

For Log In Form

Comments

question

tahnks

Add new comment