ganyan po kasi nangyayari kapg ganyan yung comment anng ilalagay kapg normal nmn na text lng hindi paano po coding nyan?ito lng prob.ko
View attachment 285657View attachment 285658
----------------------------------------
content.php code bellow:
----------------------------------------
<?php
session_start();
if (isset($_SESSION['username'])&&$_SESSION['username']!=""){
}
else
{
header("Location:../index.php");
}
$username=$_SESSION['username'];
$userid = $_SESSION['user_Id'];
?>
<html>
<head>
<title></title>
<!--Custom CSS-->
<link rel="stylesheet" type="text/css" href="../css/global.css">
<!--Bootstrap CSS-->
<link rel="stylesheet" type="text/css" href="../css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="../css/bootstrap.min.css">
<link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
<!--Script-->
<script src="../js/jquery.js"></script>
<script src="../js/jquery.min.js"></script>
<script src="../js/bootstrap.js"></script>
<script src="../js/bootstrap.min.js"></script>
</head>
<body>
<!-- Navigation -->
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header page-scroll">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand page-scroll" href="home.php"></a>
</div>
<div class="navbar-header">
<a class="navbar-brand" href="home.php">PROGRAMMING FORUM</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse">
<ul class="nav navbar-nav navbar-left">
<li><a href="#quest"> Post a Question</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<ul class="nav navbar-nav navbar-right">
<li><a href="#" ><span class="glyphicon glyphicon-user"></span> <?php echo $username;?></a></li>
<li ><a href="logout.php"><span class="glyphicon glyphicon-log-out"></span> Logout</a></li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container-fluid -->
</nav>
<div class="container" style="margin:5% auto;">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#"><font color="#1E8EC7"><h4>Just comment or reply to feedback .....And no spam or sale here!</h4></a></font>
</div>
</div>
<hr>
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="panel-title">Programming</h3>
</div>
<div class="panel-body">
<?php
include "../functions/db.php";
$id = htmlentities($_GET['post_id']);
$sql = mysql_query("SELECT * from tblpost as tp join category as c on tp.cat_id=c.cat_id where tp.post_Id='$id' ");
if($sql==true){
while($row=mysql_fetch_assoc($sql)){
extract($row);
if($user_Id==009){
echo "<label>Topic Title: </label> ".$title."<br>";
echo "<label>Topic Category: </label> ".$category."<br>";
echo "<label>Posted By: </label> Admin_jonel#15","<br>";
echo "<label>Date time posted: </label> ".$datetime,"<br>";
echo "<label>Admin Post: </label>".$Comment."<br>","<br>";
echo "<p class='well'>".$content."</p>";
}
else{
$sel = mysql_query("SELECT * from tbluser where user_Id='$user_Id' ");
while($row=mysql_fetch_assoc($sel)){
extract($row);
echo "<label>Topic Title: </label> ".$title."<br>";
echo "<label>Topic Category: </label> ".$category."<br>";
echo "<label>Date time posted: </label> ".$datetime;
echo "<p class='well'>".$content."</p>";
echo '<label>Posted By: </label>'.$fname.' '.$lname;
}
}
}
}
?>
<label><font color="#DE0945">Member reply:</label></font>
<br>
<hr></hr>
<div id="comments">
<?php
$postid= htmlentities($_GET['post_id']);
$sql = mysql_query("SELECT * from tblcomment as c join tbluser as u on c.user_Id=u.user_Id where post_Id='$postid' order by datetime");
$num = mysql_num_rows($sql);
if($num>0){
while($row=mysql_fetch_assoc($sql)){
echo "<label>Comment by: </label> ".strip_tags($row['fname'])." ".strip_tags($row['lname'])."<br>";
echo '<label class="pull-right">'.$row['datetime'].'</label>';
echo "<p class='well main-content'>".strip_tags($row['comment'])."</p>";
}
}
?>
</div>
</div>
</div>
<hr>
<div class="col-sm-5 col-md-5 sidebar">
<h3><font color="#C0C90E">Comment:</h3></font>
<form method="POST">
<textarea style="resize: none;" cols="30" rows="3" class="form-control" placeholder="Comment here.." id="commenttxt"></textarea><br>
<input type="hidden" id="postid" value="<?php echo $_GET['post_id']; ?>">
<input type="hidden" id="userid" value="<?php echo $_SESSION['user_Id']; ?>">
<input type="submit" id="save" class="btn btn-info pull-right" value="Comment">
<br><br>
</form>
</div>
</div>
<div class="my-quest" id="quest">
<div>
<form method="POST" action="question-function.php">
<label>Category</label>
<select name="category" class="form-control">
<option></option>
<option value="Programming">Programming</option>
<option value="Multimedia">Multimedia</option>
<option value="Computer Networking">Computer Networking</option>
</select>
<label>Topic Title</label>
<input type="text" class="form-control" placeholder="Input your title here" name="title"required>
<label>Content</label>
<textarea style="resize: none;" cols="30" rows="3" name="content"class="form-control" required >
</textarea>
<br>
<input type="submit" class="btn btn-info pull-right" value="Post">
</form><br>
<hr>
<a href="" class="pull-right">Close</a>
</div>
</div>
</body>
<script>
$("#save").click(function(){
var postid = $("#postid").val();
var userid = $("#userid").val();
var comment = $("#commenttxt").val();
var datastring = 'postid=' + postid + '&userid=' + userid + '&comment=' + comment;
if(!comment){
alert("Please enter some text comment");
}
else{
$.ajax({
type:"POST",
url: "../functions/addcomment.php",
data: datastring,
cache: false,
success: function(result){
document.getElementById("commenttxt").value=' ';
$("#comments").append(result);
}
});
}
return false;
})
</script>
</html>
View attachment 285657View attachment 285658
----------------------------------------
content.php code bellow:
----------------------------------------
<?php
session_start();
if (isset($_SESSION['username'])&&$_SESSION['username']!=""){
}
else
{
header("Location:../index.php");
}
$username=$_SESSION['username'];
$userid = $_SESSION['user_Id'];
?>
<html>
<head>
<title></title>
<!--Custom CSS-->
<link rel="stylesheet" type="text/css" href="../css/global.css">
<!--Bootstrap CSS-->
<link rel="stylesheet" type="text/css" href="../css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="../css/bootstrap.min.css">
<link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
<!--Script-->
<script src="../js/jquery.js"></script>
<script src="../js/jquery.min.js"></script>
<script src="../js/bootstrap.js"></script>
<script src="../js/bootstrap.min.js"></script>
</head>
<body>
<!-- Navigation -->
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header page-scroll">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand page-scroll" href="home.php"></a>
</div>
<div class="navbar-header">
<a class="navbar-brand" href="home.php">PROGRAMMING FORUM</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse">
<ul class="nav navbar-nav navbar-left">
<li><a href="#quest"> Post a Question</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<ul class="nav navbar-nav navbar-right">
<li><a href="#" ><span class="glyphicon glyphicon-user"></span> <?php echo $username;?></a></li>
<li ><a href="logout.php"><span class="glyphicon glyphicon-log-out"></span> Logout</a></li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container-fluid -->
</nav>
<div class="container" style="margin:5% auto;">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#"><font color="#1E8EC7"><h4>Just comment or reply to feedback .....And no spam or sale here!</h4></a></font>
</div>
</div>
<hr>
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="panel-title">Programming</h3>
</div>
<div class="panel-body">
<?php
include "../functions/db.php";
$id = htmlentities($_GET['post_id']);
$sql = mysql_query("SELECT * from tblpost as tp join category as c on tp.cat_id=c.cat_id where tp.post_Id='$id' ");
if($sql==true){
while($row=mysql_fetch_assoc($sql)){
extract($row);
if($user_Id==009){
echo "<label>Topic Title: </label> ".$title."<br>";
echo "<label>Topic Category: </label> ".$category."<br>";
echo "<label>Posted By: </label> Admin_jonel#15","<br>";
echo "<label>Date time posted: </label> ".$datetime,"<br>";
echo "<label>Admin Post: </label>".$Comment."<br>","<br>";
echo "<p class='well'>".$content."</p>";
}
else{
$sel = mysql_query("SELECT * from tbluser where user_Id='$user_Id' ");
while($row=mysql_fetch_assoc($sel)){
extract($row);
echo "<label>Topic Title: </label> ".$title."<br>";
echo "<label>Topic Category: </label> ".$category."<br>";
echo "<label>Date time posted: </label> ".$datetime;
echo "<p class='well'>".$content."</p>";
echo '<label>Posted By: </label>'.$fname.' '.$lname;
}
}
}
}
?>
<label><font color="#DE0945">Member reply:</label></font>
<br>
<hr></hr>
<div id="comments">
<?php
$postid= htmlentities($_GET['post_id']);
$sql = mysql_query("SELECT * from tblcomment as c join tbluser as u on c.user_Id=u.user_Id where post_Id='$postid' order by datetime");
$num = mysql_num_rows($sql);
if($num>0){
while($row=mysql_fetch_assoc($sql)){
echo "<label>Comment by: </label> ".strip_tags($row['fname'])." ".strip_tags($row['lname'])."<br>";
echo '<label class="pull-right">'.$row['datetime'].'</label>';
echo "<p class='well main-content'>".strip_tags($row['comment'])."</p>";
}
}
?>
</div>
</div>
</div>
<hr>
<div class="col-sm-5 col-md-5 sidebar">
<h3><font color="#C0C90E">Comment:</h3></font>
<form method="POST">
<textarea style="resize: none;" cols="30" rows="3" class="form-control" placeholder="Comment here.." id="commenttxt"></textarea><br>
<input type="hidden" id="postid" value="<?php echo $_GET['post_id']; ?>">
<input type="hidden" id="userid" value="<?php echo $_SESSION['user_Id']; ?>">
<input type="submit" id="save" class="btn btn-info pull-right" value="Comment">
<br><br>
</form>
</div>
</div>
<div class="my-quest" id="quest">
<div>
<form method="POST" action="question-function.php">
<label>Category</label>
<select name="category" class="form-control">
<option></option>
<option value="Programming">Programming</option>
<option value="Multimedia">Multimedia</option>
<option value="Computer Networking">Computer Networking</option>
</select>
<label>Topic Title</label>
<input type="text" class="form-control" placeholder="Input your title here" name="title"required>
<label>Content</label>
<textarea style="resize: none;" cols="30" rows="3" name="content"class="form-control" required >
</textarea>
<br>
<input type="submit" class="btn btn-info pull-right" value="Post">
</form><br>
<hr>
<a href="" class="pull-right">Close</a>
</div>
</div>
</body>
<script>
$("#save").click(function(){
var postid = $("#postid").val();
var userid = $("#userid").val();
var comment = $("#commenttxt").val();
var datastring = 'postid=' + postid + '&userid=' + userid + '&comment=' + comment;
if(!comment){
alert("Please enter some text comment");
}
else{
$.ajax({
type:"POST",
url: "../functions/addcomment.php",
data: datastring,
cache: false,
success: function(result){
document.getElementById("commenttxt").value=' ';
$("#comments").append(result);
}
});
}
return false;
})
</script>
</html>
