What's new

Bat nawala display

L

loktoy

Eternal Poster
Joined
Oct 20, 2014
Posts
1,168
Solutions
2
Reaction
103
Points
497
Age
30
bat wala po output nun mga reply o comment...

ito po 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, there are a few things that could be causing the issue with the output. Here are some possible causes and solutions:

1. Database Connection: Make sure you have established a connection to your database before executing any queries. You can use the mysqli_connect() function to connect to your database. For example:

Code: 
$con = mysqli_connect("localhost", "username", "password", "database_name");

if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

Replace "localhost", "username", "password", and "database_name" with your actual database credentials.

2. Query Execution: Check if your query is executing successfully and returning the expected results. You can use mysqli_query() to execute your query and mysqli_num_rows() to check if any rows were returned. For example:

Code: 
$content_query = mysqli_query($con, "SELECT * FROM post WHERE comment_id = '$id_comment'") or die(mysqli_error());

if (mysqli_num_rows($content_query) > 0) {
    // Code to display the content
} else {
    // Code to handle when no content is found
}

3. Closing Tags: Make sure you have closed all the PHP tags properly. In your code, the closing PHP tag ?> is missing at the end. Add ?> at the end of your code before the closing </html> tag.

After checking these points, if you are still not getting any output or getting unexpected output, please provide more information about the issue and any error messages you are encountering.
 
🤖 said:
Based on the code you provided, there are a few things that could be causing the issue with the output. Here are some possible causes and solutions:

1. Database Connection: Make sure you have established a connection to your database before executing any queries. You can use the mysqli_connect() function to connect to your database. For example:

Code: 
$con = mysqli_connect("localhost", "username", "password", "database_name");

if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

Replace "localhost", "username", "password", and "database_name" with your actual database credentials.

2. Query Execution: Check if your query is executing successfully and returning the expected results. You can use mysqli_query() to execute your query and mysqli_num_rows() to check if any rows were returned. For example:

Code: 
$content_query = mysqli_query($con, "SELECT * FROM post WHERE comment_id = '$id_comment'") or die(mysqli_error());

if (mysqli_num_rows($content_query) > 0) {
    // Code to display the content
} else {
    // Code to handle when no content is found
}

3. Closing Tags: Make sure you have closed all the PHP tags properly. In your code, the closing PHP tag ?> is missing at the end. Add ?> at the end of your code before the closing </html> tag.

After checking these points, if you are still not getting any output or getting unexpected output, please provide more information about the issue and any error messages you are encountering.
Click to expand...
wala pa rin
 
loktoy said:
wala pa rin
Click to expand...
I apologize for the confusion. Upon reviewing your code again, there are a few additional suggestions to consider:

1. Check if the required PHP files are included correctly: Make sure that the file paths specified in the include statements are correct. Double-check the paths and ensure that the files you are including (newnav.php, footer.php) exist in the specified locations.

2. Verify the connection to the database: Make sure the $con variable is properly defined and initialized before executing any queries. Check that the database credentials are correct and that the connection is established successfully.

3. Validate the $_GET parameter: Before using the $_GET['id'] parameter in your query, validate and sanitize the input to prevent any potential security vulnerabilities. You can use functions like intval() or mysqli_real_escape_string() to sanitize the input.

4. Check for errors during query execution: After executing each query, check if there are any errors using mysqli_error($con). If there are any errors, it will help identify the issue.

5. Ensure that the closing PHP tag is present: Add ?> at the end of your code, before the closing </html> tag, to ensure that all PHP code is properly closed.

If you have followed these suggestions and are still not getting any output or encountering errors, please provide any error messages that you receive, as they will help in troubleshooting the issue further.
 

Similar threads

Popular Tags

android api app arduino bot c c++ capstone capstone project code coding coding and programming css database developer development error help how 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

  • 3
    Replies
  • 303
    Views
  • 2
    Participants
Last reply from:
🤖

New Topics

Popular On This Forum

Online statistics

Members online
322
Guests online
4,757
Total visitors
5,079
Back
Top