Approve script

[stynx]

I need help in coding an approve script. I still can't figure out myself how can I approve a comment through my comment page. Example :

 

John comments on my page and I can choose whether I can approve his comment or not.

 

Please help me. Thanks ! 

[revraz]

Create a field in your table, call it something like 'approved', enter a 1 if approved, 0 if isn't, you can then query based on 0 to see what needs to be approved, once set to 1, show it.

[stynx]

Well I'm a newbie in PHP can you show me some rough example on it? so I can develop my skills on it. Thanks mate.

[revraz]

All depends really on how much you already know.  I would suggest doing some Mysql/PHP tutorials to get familiar with the process.

[stynx]

I have create a script which a table that contains checkbox to delete the MYSQL row by row. I'm going to edit it and change it for the edit row but now I still can't delete the row.

 

My script :

 

<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="gb"; // Database name
$tbl_name="test_mysql"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="kotakSaya" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><?php echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['email']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?php
// Check if delete button active, start this
if(isset($_POST['delete'])){

$ids = $_POST['kotakSaya'];

print_r($ids);

if(empty($ids)) {

	echo("Xda checkbox ditanda.");

} 

else 

{

	foreach($ids as $id => $value) {
            $sql = "DELETE FROM $tbl_name WHERE id='$value'";
            $result = mysql_query($sql);
        }

echo "siap delete.";

}

}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table> 

[PFMaBiSmAd]

I have create a script which a table that contains checkbox to delete the MYSQL row by row. I'm going to edit it and change it for the edit row but now I still can't delete the row.

 

^^^ What does that have to do with this thread about approving a comment?

[stynx]

I does make sense mate. I can only change the delete mysql query command with edit mysql query command.

 

Edit mysql query command is for approve comments page.