Skip to main content

Admin panel of a Q & A Forum



In a Q & A Forum, when a user posts a question, it should be sent to the administrator for approval in case it contains inappropriate content. After approval it should be removed from this pending approval page and other users should be able to see the question afterwards.

To enable this, we should maintain an approval column in our database table of records and for each record approval should be set to false by default.

In the Pending approvals page only the records with approval=false should be displayed. Below is the MySQL statement for retrieval,

$sql="SELECT * FROM topics WHERE approval=false";

To know which post was approved we should embed the post_id to the URL. And the relevant post should be updated as approval=true.

Below is the complete code.

<?php
$sql="SELECT * FROM topics WHERE approval=false";

$query=mysqli_query($conn,$sql);
echo '<form name="approve" method="post"><table id="results_cat">';
while($row=mysqli_fetch_array($query))
{
echo '<tr style="border:#B7B7B7 1px solid; "><td><h4 style="color:#659EC7">'.$row['topic_subject'].'</h4><br>'.$row['topic_desc'].'</td><td><a href="'.$_SERVER['PHP_SELF'].'?TopicId='.$row['topic_id'].'"><img src="./Images/approve.png"></a></td></tr>';
}

echo '</table></form>';

if(isset($_GET['TopicId'])) //to get the value from the URL
{
$status=$_GET['TopicId'];
$sql2="Update topics set approval=1 where topic_id='$status'";
$query2=mysqli_query($conn,$sql2);

echo '<script>window.location.href ="admin-panel.php";</script>'; //to refresh the page

}
?>

And when retrieving the posts for users to see, only posts with approval=true should be retrieved. Below is a sample MySQL statement to do so.

$sql5="SELECT * FROM topics,users WHERE user_id=topic_by and topics.approval=true";


                        

Comments

Popular posts from this blog

Fixing 'java RMI - ConnectException: Operation timed out' in WSO2 Enterprise Integrator 6.4

If you ever come across the below exception when running WSO2 Enterprise Integrator 6.4, here is the fix. This error occurs when you have multiple IP addresses from different networks configured in your etc/hosts as below. 10.xxx.x.xxx localhost 192.xxx.x.xxx localhost So simply, removing the unnecessary one and leaving the one of the network that you are currently connected to should resolve this issue. 10.xxx.x.xxx localhost

Calculator using PHP

This Calculator model will take inputs from the Number 1 and Number 2 fields and when the user clicks on the relevant operator the result will be displayed in the Results field. For log10(), to radian, to degree, sin, cos, tan operations only require one input. Hence, the user is instructed to input the values to the 1st field only. First, before proceeding with the calculation, we need to obtain the values from the text boxes. For that we should include all the form elements inside a form. The result is directed to the same page. Therefore we will use the form action as $_SERVER['PHP_SELF'] and the method as post. Next, we can obtain the values in the text boxes.       $_POST[' form_element_name '] will give you the value of the respective element. We can write the php code as follows (in the <head>) to obtain the value from Number 1 and Number 2 fields.       <?php              $num1=...