What's new

Ito phc robot patulong sa code sa isang kung code

L

loktoy

Eternal Poster
Joined
Oct 20, 2014
Posts
1,166
Solutions
2
Reaction
103
Points
496
Age
30
kasi kapag pinipindot ko yun title ng content napupunta sya sa replies.php ngaun lumalabas naman yun content nya kaso problima ko is yun mga comment o reply ay di lumalabas o walang ouput..

ito code ko

<?php
ob_start();
include "../partials/newnav.php";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Homepage</title>
<link rel= "stylesheet" href="../css/bootstrap.css">
<link rel= "stylesheet" href="../css/style.css">
<script src="../js/bootstrap.bundle.js"></script>
<script src="../js/style.js"></script>
<script src="../ajax/sweetalert2.all.min.js"></script>
<script src="../ajax/jquery-3.7.0.min.js"></script>

</head>
<body>
<div class="container col-md-6 text-center">
<br>
<h1>WELCOME To My Thread!</h1>

<br>

<br>
</div>
<?php
if(isset($_GET['id'])){
$id_comment = $_GET['id'];
// Query to fetch the specific content based on the comment_id
$content_query = mysqli_query($con, "SELECT * FROM post WHERE comment_id = '$id_comment'") or die(mysqli_error());
$content_row = mysqli_fetch_array($content_query);


?>
<h6><?php echo $content_row['comment']; ?></h6>
<?php
$post_query = mysqli_query($con, "SELECT *, UNIX_TIMESTAMP() - date_created AS TimeSpent FROM post LEFT JOIN registration on registration.user_id = post.user_id ORDER BY comment_id DESC limit 1 ") or die (mysqli_error());
while($post_row = mysqli_fetch_array($post_query)){
$id = $post_row['comment_id'];
$upid = $post_row['user_id'];
$posted_by = $post_row['username'];
?>
<br>
<form method="post">

<div class="container col-md-6">
Comment:<br>
<input type="hidden" name="id" value="<?php echo $id; ?>">
<textarea name="comment_content" class="form-control" rows="4" cols="50" style="" placeholder=".........Type your comment here........" required></textarea>
<div class="form-group mt-2">
<input class="w-25" type="submit" name="comment" value ="Reply" style="background-color:#0D52C7;">
</div>
</div>
</form>

</br>
<?php

if (isset($_POST['comment'])){
$comment_content = $_POST['comment_content'];
$post_id=$_POST['id'];

mysqli_query($con,"insert into comment (comment,date_posted,user_id,comment_id) values ('$comment_content','".strtotime(date("Y-m-d h:i:sa"))."','$user_id','$post_id')") or die (mysqli_error());
header('Location: comment.php');
exit();
ob_end_flush();
?>

<?php
$comment_query = mysqli_query($con, "SELECT *, UNIX_TIMESTAMP() - date_posted AS TimeSpent FROM comment INNER JOIN registration ON registration.user_id = comment.user_id WHERE comment.comment_id = '$id_comment' AND comment.post_id = '$post_id' ORDER BY date_posted DESC") or die(mysqli_error());
while ($comment_row=mysqli_fetch_array($comment_query)){
$comment_id = $comment_row['id'];
$comment_by = $comment_row['username'];
?>
<div class="container col-md-6 bg-body-tertiary border rounded-3">
Comment by: <a href="#" style= "margin-left:10px; text-decoration:none;"> <?php echo $comment_by; ?></a>
<div class="" style="font-size:12px;">
<?php
$days = floor($comment_row['TimeSpent'] / (60 * 60 * 24));
$remainder = $comment_row['TimeSpent'] % (60 * 60 * 24);
$hours = floor($remainder / (60 * 60));
$remainder = $remainder % (60 * 60);
$minutes = floor($remainder / 60);
$seconds = $remainder % 60;
if($days > 0)
echo date('F d, Y - H:i:sa', $comment_row['date_posted']);
elseif($days == 0 && $hours == 0 && $minutes == 0)
echo "A few seconds ago";
elseif($days == 0 && $hours == 0)
echo $minutes.' minutes ago';
?>
<img src ="../images/hour.png" alt = "My hour" style ="width:12px;">
</div>


<div class="mb-3">
<?php echo $comment_row['comment']; ?>
</div>
</div>

<br>

<?php
}}}}?>


<hr>

<?php
include "../partials/footer.php";
?>


</body>
</html>
 
Based on the code you provided, it seems that the issue lies in the placement of the closing bracket for the if (isset($_POST['comment'])) condition. You are closing the condition right after the header('Location: comment.php'); line, which causes the subsequent code to be outside the condition and not executed.

To fix this issue, you need to move the closing bracket } after the code block that displays the comments. Here's the modified code:

PHP: 
<?php
if(isset($_GET['id'])){
    $id_comment = $_GET['id'];
    // Query to fetch the specific content based on the comment_id
    $content_query = mysqli_query($con, "SELECT * FROM post WHERE comment_id = '$id_comment'") or die(mysqli_error());
    $content_row = mysqli_fetch_array($content_query);
    
    ?>
    <h6><?php echo $content_row['comment']; ?></h6>
    <?php
    $post_query = mysqli_query($con, "SELECT *, UNIX_TIMESTAMP() - date_created AS TimeSpent FROM post LEFT JOIN registration on registration.user_id = post.user_id ORDER BY comment_id DESC limit 1 ") or die (mysqli_error());
    while($post_row = mysqli_fetch_array($post_query)){
        $id = $post_row['comment_id'];
        $upid = $post_row['user_id'];
        $posted_by = $post_row['username'];
        ?>
        <br>
        <form method="post">
            <div class="container col-md-6">
                Comment:<br>
                <input type="hidden" name="id" value="<?php echo $id; ?>">
                <textarea name="comment_content" class="form-control" rows="4" cols="50" style="" placeholder=".........Type your comment here........" required></textarea>
                <div class="form-group mt-2">
                    <input class="w-25" type="submit" name="comment" value="Reply" style="background-color:#0D52C7;">
                </div>
            </div>
        </form>
        <br>
        <?php
        if (isset($_POST['comment'])){
            $comment_content = $_POST['comment_content'];
            $post_id=$_POST['id'];
            
            mysqli_query($con,"insert into comment (comment,date_posted,user_id,comment_id) values ('$comment_content','".strtotime(date("Y-m-d h:i:sa"))."','$user_id','$post_id')") or die (mysqli_error());
            header('Location: comment.php');
            exit();
            ob_end_flush();
        }
        ?>
        <?php 
        // Place the closing bracket here to ensure the code below is executed inside the condition
        $comment_query = mysqli_query($con, "SELECT *, UNIX_TIMESTAMP() - date_posted AS TimeSpent FROM comment INNER JOIN registration ON registration.user_id = comment.user_id WHERE comment.comment_id = '$id_comment' AND comment.post_id = '$post_id' ORDER BY date_posted DESC") or die(mysqli_error());
        while ($comment_row=mysqli_fetch_array($comment_query)){
            $comment_id = $comment_row['id'];
            $comment_by = $comment_row['username'];
            ?>
            <div class="container col-md-6 bg-body-tertiary border rounded-3">
                Comment by: <a href="#" style= "margin-left:10px; text-decoration:none;"> <?php echo $comment_by; ?></a>
                <div class="" style="font-size:12px;">
                    <?php               
                    $days = floor($comment_row['TimeSpent'] / (60 * 60 * 24));
                    $remainder = $comment_row['TimeSpent'] % (60 * 60 * 24);
                    $hours = floor($remainder / (60 * 60));
                    $remainder = $remainder % (60 * 60);
                    $minutes = floor($remainder / 60);
                    $seconds = $remainder % 60;
                    if($days > 0)
                        echo date('F d, Y - H:i:sa', $comment_row['date_posted']);
                    elseif($days == 0 && $hours == 0 && $minutes == 0)
                        echo "A few seconds ago";       
                    elseif($days == 0 && $hours == 0)
                        echo $minutes.' minutes ago';
                    ?>
                    <img src ="../images/hour.png" alt = "My hour" style ="width:12px;">
                </div>
                <div class="mb-3">
                    <?php echo $comment_row['comment']; ?>
                </div>
            </div>
            <br>
        <?php
        }
    }
}
?>

<hr>

<?php 
include "../partials/footer.php";
?>

With this modification, the code that displays the comments will be executed inside the if (isset($_POST['comment'])) condition, and the comments should be displayed properly.
 

Similar threads

Popular Tags

android api app arduino bot c c++ capstone capstone project code coding coding and programming css database developer development help how how to html in java javascript language laravel mag mysql need patulong php program programmer programming programming language project python question react script sql system thesis tutorial udemy vb.net visual basic web web development website with

About this Thread

  • 1
    Replies
  • 196
    Views
  • 2
    Participants
Last reply from:
🤖

New Topics

Popular On This Forum

Online statistics

Members online
282
Guests online
4,986
Total visitors
5,268
Back
Top