Online PHP editor | refs for OA7fB

<?php //============================================= MY_MESSAGES.PHP //----------------------------------------------------------- include ("includes/header.php"); ?> <h2>My Unread Messages:</h2><p /> <? //-------------- SPACE -- Grab the messages for the logged in user $grab_messages = $dbh->prepare("SELECT * FROM pvt_messages WHERE user_to=:user && opened='no' && deleted='no'"); $grab_messages->bindValue(':user', $user, PDO::PARAM_STR); $grab_messages->execute(); $numrows = $grab_messages->fetch(PDO::FETCH_ASSOC); //-------------- SPACE if ($numrows != 0) { while ($get_msg = $grab_messages->fetch(PDO::FETCH_ASSOC)){ echo "--".$id = $get_msg['id']; $user_from = $get_msg['user_from']; $user_to = $get_msg['user_to']; $msg_title = $get_msg['msg_title']; $msg_body = $get_msg['msg_body']; $date = $get_msg['date']; $opened = $get_msg['opened']; $deleted = $get_msg['deleted']; ?> <script language="javascript"> function toggle<? echo $id; ?>() { var ele = document.getElementById("toggleText<? echo $id; ?>"); var text = document.getElementById("displayText<? echo $id; ?>"); if (ele.style.display == "block") { ele.style.display = "none"; } else { ele.style.display = "block"; } } </script> <? if (strlen($msg_title) > 50) { $msg_title = substr($msg_title, 0, 50)." ..."; } else $msg_title = $msg_title; if (strlen($msg_body) > 150) { $msg_body = substr($msg_body, 0, 150)." ..."; } else $msg_body = $msg_body; if (@$_POST['setopened_' . $id . '']) { //-------------- SPACE -- Update the private messages table $setopened_query = $dbh->prepare("UPDATE pvt_messages SET opened='yes' WHERE id=:id"); $setopened_query->bindValue(':id', $id, PDO::PARAM_STR); $setopened_query->execute(); } echo " <form method='POST' action='my_messages.php' name='$msg_title'> <b><a href='$user_from'>$user_from</a></b> <input type='button' name='openmsg' value='$msg_title' onClick='javascript:toggle$id()'> <input type='submit' name='setopened_$id' value=\"I've Read This\"> </form> <div id='toggleText$id' style='display: none;'> <br />$msg_body </div> <hr /><br /> "; } } else { echo "You haven't read any messages yet."; } ?>