html - Why doesn't my PHP Code work? -
i trying create whichever row click on, brings in new page called reply.php, happening is showing content , subject newest one, not 1 click on. suggestions? thanks!
messages.php
<html> <head> <link href='http://fonts.googleapis.com/css?family=lato' rel='stylesheet' type='text/css'> <link rel="stylesheet" href="styling/basic.css" /> <?php require ("config.php"); session_start(); $username = $_session['uname']; $userid = mysql_query("select `id` `users` `uname` = '$username'")or die (mysql_error()); $id2=mysql_fetch_row($userid); $userid=$id2[0]; $userlevel = mysql_query("select `rank` `users` `uname` = '$username'")or die (mysql_error()); $level=mysql_fetch_row($userlevel); $userlevel=$level[0]; ?> </head> <body> <br /> <ul id="navmenu"> <li><a href="home.php">home</a></li> <li><a href="messages.php">messages</a></li> <li><a href="#">friends</a></li> <li><a href="#">settings</a><span class="darrow">▼</span> <ul class="sub1"> <li><a href="#">account</a></li> <li><a href="#">profile</a> <li><a href="logout.php">logout</a></li> </ul> </li> <li><a href="#">$<?php $query = mysql_query("select * users `uname` = '$username'"); while($row=mysql_fetch_array($query)){ echo $row['money']; } ?></a></li> </ul> <br /> <div class="page"> <h1>messages</h1><br /> <?php if ($_session['uname']) { } else { ?><script type="text/javascript">document.location = "login.php";</script><?php } ?> <ul id="tabs"> <li><a href="#">inbox</a></li> <li style="float: right;"><a href="create_message.php">new message</a></li> </ul> <table style="width:100%;"> <tr> <form action='delete_message.php' method='post'> <td><input type='checkbox' name='selectall'><input type='submit' name='deleteinbox' value='delete' class='button'></td> </tr> <tr> <td><u><b>from</b></u></th> <td><u><b>subject</b></u></th> <td style="text-align: right;"><u><b>date</b></u></th> </tr> </table> <?php $query = mysql_query("select * private_messages to_user = '$username'"); $numrows = mysql_num_rows($query); if($numrows != 0){ while ($row = mysql_fetch_assoc($query)){ $msg_id = $row['id']; $msg_to_user = $row['to_user']; $msg_to_id = $row['to_id']; $msg_from_user = $row['from_user']; $msg_from_id = $row['from_id']; $msg_subject = $row['subject']; $msg_content = $row['content']; $msg_date = $row['date']; $msg_from_delete = $row['from_delete']; $msg_to_delete = $row['to_delete']; echo "$to_delete"; if(!$msg_from_delete){ echo "<div id='messages'>"; $messagefrom = "<div id='leftside'><input type='checkbox' name='cb$msg_id' value='$msg_id'/> <a href='home.php?id=$msg_from_user' target='_blank'>$msg_from_user</a>"; echo ($messagefrom."</div>"); $messagedate = "<div id='rightside'>".$msg_date."</div>"; echo ($messagedate.""); $messagesubject = "<div id='center'> <div id='toggle'><a href='reply.php?$msg_id'>".$msg_subject."</a></span> </div>"; echo ($messagesubject.""); echo "<div style='clear: both'></div>"; echo "</div>"; $num += 1; } } if($num == 0){ echo "<p style='text-align:center'>you have no messages in inbox!</p>"; } echo "</form>"; } else { echo "<p style='text-align:center'>you have no messages in inbox!</p>"; } ?> </div> </body> </html> reply.php
<html> <head> <link href='http://fonts.googleapis.com/css?family=lato' rel='stylesheet' type='text/css'> <link rel="stylesheet" href="styling/basic.css" /> <?php require('config.php'); session_start(); $username = $_session['uname']; $userid = mysql_query("select `id` `users` `uname` = '$username'")or die (mysql_error()); $id2=mysql_fetch_row($userid); $userid=$id2[0]; $userlevel = mysql_query("select `rank` `users` `uname` = '$username'")or die (mysql_error()); $level=mysql_fetch_row($userlevel); $userlevel=$level[0]; $query = mysql_query("select * private_messages to_user='$username'"); while ($row = mysql_fetch_assoc($query)){ $msg_id = $row['id']; } $query = mysql_query("select * private_messages to_user = '$username' , id='$msg_id'"); $numrows = mysql_num_rows($query); if($numrows != 0){ while ($row = mysql_fetch_assoc($query)){ $msg_id = $row['id']; $msg_to_user = $row['to_user']; $msg_to_id = $row['to_id']; $msg_from_user = $row['from_user']; $msg_from_id = $row['from_id']; $msg_subject = $row['subject']; $msg_content = $row['content']; $msg_date = $row['date']; } } ?> </head> <body> <br /> <ul id="navmenu"> <li><a href="home.php">home</a></li> <li><a href="messages.php">messages</a></li> <li><a href="#">friends</a></li> <li><a href="#">settings</a><span class="darrow">▼</span> <ul class="sub1"> <li><a href="#">account</a></li> <li><a href="#">profile</a> <li><a href="logout.php">logout</a></li> </ul> </li> <li><a href="#">$<?php $query = mysql_query("select * users `uname` = '$username'"); while($row=mysql_fetch_array($query)){ echo $row['money']; } ?></a></li> </ul> <br /> <div class="page"> <h1>messages</h1><br /> <p>message <b><i><?php echo $msg_from_user; ?></i></b>:</p> <p><textarea rows="10" readonly style="width: 50%; resize:none;"><?php echo $msg_content; ?></textarea></p> <b>response:</b> <form action="reply.php" method="post"> <br />subject: <br /> <input type='text' name='replysubject' style='width: 50%;' value="re: <?php echo ($msg_subject); ?>" readonly></input> <textarea rows="10" name="replycontent" style="width: 50%; resize:none;"></textarea><br/> <input type="submit" name="replybutton" class="button"/> </form> <?php if ($_post['replybutton']){ $subject = $_post['replysubject']; $content = $_post['replycontent']; ?> <?php if ($subject && $content){ $date = date("m d, y"); $query = mysql_query("select * private_messages content = '$content' , date = '$date'"); $numrows = mysql_num_rows($query); if ($numrows == 0){ $query2 = mysql_query("select * private_messages id='$msg_id' , to_user='$username'"); $numrows2 = mysql_num_rows($query2); if ($numrows2 == 1){ $row = mysql_fetch_assoc($query); $to_id = $row['from_id']; $to_user = $row['from_user']; mysql_query("insert private_messages values ('', '$msg_from_user', '$msg_from_id', '$msg_to_user', '$msg_to_id', '$subject', '$content', '$date')"); echo "your reply has been sent successfully! <a href='messages.php'>inbox</a>"; } else echo "no message sent. error has occured."; } else echo "you can not resend same message."; } else { echo "you did not supply subject and/or message respond with."; } } else echo "you must type response send message!"; ?> </div> </body> </html> i have database corresponding info sets. ideas? give thanks you!
hi while there lot in code utilize work primarally problem
$query = mysql_query("select * private_messages to_user='$username'"); while ($row = mysql_fetch_assoc($query)){ $msg_id = $row['id']; } see overwriting $msg_id each pass of loop, there no other query conditions username, imagine record highest id, or set newest record.
php html mysql database
No comments:
Post a Comment