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.

I'm so sorry man because I'm a newbie myself. So what is the replacement of session register?

First you need to register your session ( means login ) then you can enter a page. Example : This is my login.php and you will be redirected to the dashboard.php <?php $host="localhost"; // Host name $username="root"; // Mysql username $password="root"; // Mysql password $db_name="gb"; // Database name $tbl_name="users"; // 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"); // username and password sent from form $username=$_POST['username']; $password=$_POST['pwd']; // To protect MySQL injection (more detail about MySQL injection) $username = stripslashes($username); $pwd = stripslashes($password); $username = mysql_real_escape_string($username); $pwd = mysql_real_escape_string($password); $sql="SELECT * FROM $tbl_name WHERE username='$username' and pwd='$password'"; $result = mysql_query($sql); // Mysql_num_row is counting table row $count = mysql_num_rows($result); // If result matched $username and $pwd, table row must be 1 row if($count==1){ session_start(); session_register("username"); session_register("pwd"); header("location:dashboard.php"); } else { echo "Wrong Username or Password"; } ?> If you try to go to dashboard.php without login you will be redirected to the login page. <?php //start the session session_start(); //check to make sure the session variable is registered if(isset($_SESSION['username'])) { print("You're an admin. Do whatever you want ! "); } else { header( "Location:login.html" ); } ?>

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>

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.

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 !

Hi guys I'm a not a professional PHP developer just start learning this language for about a month. Thanks Note : Nice forum there.