首页 \ 问答 \ 如何在观看消息旁边创建收件箱(how to creae inbox next to viewing message)

如何在观看消息旁边创建收件箱(how to creae inbox next to viewing message)

 我刚刚创建了一个消息系统，但我想显示正在查看的消息旁边的收件箱，如facebook消息系统，但我可以让它在彼此旁边工作，我必须通过链接这样做，所以收件箱被查看index.php并查看你必须去的信息index.php？hash = VAULE我如何让他们并排工作，因为facebook确实如此 
 

<?php
if(isset($_GET['hash']) && !empty($_GET['hash'])){
$hash = $_GET['hash'];
$message_query= mysql_query("SELECT from_id, message FROM messages WHERE group_hash='$hash'");
while($run_message = mysql_fetch_array($message_query)){
    $from_id = $run_message['from_id'];
    $message = $run_message['message'];
        $staff_query = mysql_query("SELECT staff_username FROM staff_users WHERE id='$from_id'");
        $run_staff = mysql_fetch_array($staff_query);
        $from_staff = $run_staff['staff_username'];
            echo "<p><b>$from_staff</b><br/>$message</p>";
}
?>
<br/>
<form method='POST'>
<?php
if(isset($_POST['message']) && !empty($_POST['message'])){
        $new_message = $_POST['message'];
        mysql_query("INSERT INTO messages VALUES('','$hash','$my_id','$new_message')");
        header('location: index.php?hash='.$hash);
  }
  ?>
<div class="message_box">
Enter Message : <br/>
<textarea name='message' placeholder="Write a reply" rows='6' cols="60"></textarea>
<br/>
<input type='submit' name="smb" value="Reply"/>
</form>
</div>
<?php
}else{
$get_con = mysql_query("SELECT hash, staff_one, staff_two FROM messages_hash WHERE staff_one='$my_id' OR staff_two='$my_id'");
while($run_con = mysql_fetch_array($get_con)){
    $hash = $run_con['hash'];
    $staff_one = $run_con['staff_one'];
    $staff_two = $run_con['staff_two'];
    if($staff_one == $my_id){
        $select_id = $staff_two;
    }else{
        $select_id = $staff_one;
    }
    $staff_get = mysql_query("SELECT staff_username FROM staff_users WHERE id='$select_id'");
    $run_staff = mysql_fetch_array($staff_get);
    $select_staff = $run_staff['staff_username'];
    echo "<p><a href='index.php?hash=$hash'>$select_staff</a></p>";
}
}
?>


i have just created a message system but i would like to show the inbox next to the message being viewed like facebook messaging system does but i can get it to work next to each other i have to do it though links so the inbox is viewed on index.php and to view message you have to go to index.php?hash=VAULE how do i get them to work side by side as facebook does 
 

<?php
if(isset($_GET['hash']) && !empty($_GET['hash'])){
$hash = $_GET['hash'];
$message_query= mysql_query("SELECT from_id, message FROM messages WHERE group_hash='$hash'");
while($run_message = mysql_fetch_array($message_query)){
    $from_id = $run_message['from_id'];
    $message = $run_message['message'];
        $staff_query = mysql_query("SELECT staff_username FROM staff_users WHERE id='$from_id'");
        $run_staff = mysql_fetch_array($staff_query);
        $from_staff = $run_staff['staff_username'];
            echo "<p><b>$from_staff</b><br/>$message</p>";
}
?>
<br/>
<form method='POST'>
<?php
if(isset($_POST['message']) && !empty($_POST['message'])){
        $new_message = $_POST['message'];
        mysql_query("INSERT INTO messages VALUES('','$hash','$my_id','$new_message')");
        header('location: index.php?hash='.$hash);
  }
  ?>
<div class="message_box">
Enter Message : <br/>
<textarea name='message' placeholder="Write a reply" rows='6' cols="60"></textarea>
<br/>
<input type='submit' name="smb" value="Reply"/>
</form>
</div>
<?php
}else{
$get_con = mysql_query("SELECT hash, staff_one, staff_two FROM messages_hash WHERE staff_one='$my_id' OR staff_two='$my_id'");
while($run_con = mysql_fetch_array($get_con)){
    $hash = $run_con['hash'];
    $staff_one = $run_con['staff_one'];
    $staff_two = $run_con['staff_two'];
    if($staff_one == $my_id){
        $select_id = $staff_two;
    }else{
        $select_id = $staff_one;
    }
    $staff_get = mysql_query("SELECT staff_username FROM staff_users WHERE id='$select_id'");
    $run_staff = mysql_fetch_array($staff_get);
    $select_staff = $run_staff['staff_username'];
    echo "<p><a href='index.php?hash=$hash'>$select_staff</a></p>";
}
}
?>


原文：https://stackoverflow.com/questions/29457474
更新时间：2023-07-08 06:07

最满意答案

    @Override
    public void delete(List<Integer> ids) {
        String sql = "update user set deleted=1 where user_id = ?";
        jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {

           @Override
           public void setValues(PreparedStatement ps, int i) throws SQLException {
              Integer userId = ids.get(i);
              ps.setLong(1, userId );          
           }

           @Override
           public int getBatchSize() {
              return ids.size();
           }
        });
    }


    @Override
    public void delete(List<Integer> ids) {
        String sql = "update user set deleted=1 where user_id = ?";
        jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {

           @Override
           public void setValues(PreparedStatement ps, int i) throws SQLException {
              Integer userId = ids.get(i);
              ps.setLong(1, userId );          
           }

           @Override
           public int getBatchSize() {
              return ids.size();
           }
        });
    }

相关问答

更多

相关文章

更多
  • Storm - Guaranteeing message processing
  • JAVAMAIL问题,高手...,来来来
  • JMS&MQ系列之简单示例
  • 如何在微信的自定义菜单上实现“历史消息”功能？
  • 微信公众平台开发(102) 模版消息
  • ACTIVEMQ Topic消息 生产者 发布消息后 消费者收不到消息
  • log4j 核心API Logger的相关方法
  • java微信接口之五—消息分组群发
  • RabbitMQ 消息确认方式
  • 微信公众帐号开发教程第10篇-解析接口中的消息创建时间CreateTime

    • 最新问答

    更多
  • h2元素推动其他h2和div。(h2 element pushing other h2 and div down. two divs, two headers, and they're wrapped within a parent div)
  • 创建一个功能(Create a function)
  • 我投了份简历，是电脑编程方面的学徒，面试时说要培训三个月，前面
  • PDO语句不显示获取的结果(PDOstatement not displaying fetched results)
  • Qt冻结循环的原因？(Qt freezing cause of the loop?)
  • TableView重复youtube-api结果(TableView Repeating youtube-api result)
  • 如何使用自由职业者帐户登录我的php网站？(How can I login into my php website using freelancer account? [closed])
  • SQL Server 2014版本支持的最大数据库数(Maximum number of databases supported by SQL Server 2014 editions)
  • 我如何获得DynamicJasper 3.1.2（或更高版本）的Maven仓库？(How do I get the maven repository for DynamicJasper 3.1.2 (or higher)?)
  • 以编程方式创建UITableView(Creating a UITableView Programmatically)
  • 如何打破按钮上的生命周期循环(How to break do-while loop on button)
  • C＃使用EF访问MVC上的部分类的自定义属性(C# access custom attributes of a partial class on MVC with EF)
  • 如何获得facebook app的publish_stream权限？(How to get publish_stream permissions for facebook app?)
  • 如何防止调用冗余函数的postgres视图(how to prevent postgres views calling redundant functions)
  • Sql Server在欧洲获取当前日期时间(Sql Server get current date time in Europe)
  • 设置kotlin扩展名(Setting a kotlin extension)
  • 如何并排放置两个元件？(How to position two elements side by side?)
  • 如何在vim中启用python3？(How to enable python3 in vim?)
  • 在MySQL和/或多列中使用多个表用于Rails应用程序(Using multiple tables in MySQL and/or multiple columns for a Rails application)
  • 如何隐藏谷歌地图上的登录按钮？(How to hide the Sign in button from Google maps?)
  • Mysql左连接旋转90°表(Mysql Left join rotate 90° table)
  • dedecms如何安装？
  • 在哪儿学计算机最好?
  • 学php哪个的书 最好,本人菜鸟
  • 触摸时不要突出显示表格视图行(Do not highlight table view row when touched)
  • 如何覆盖错误堆栈getter(How to override Error stack getter)
  • 带有ImageMagick和许多图像的GIF动画(GIF animation with ImageMagick and many images)
  • USSD INTERFACE - > java web应用程序通信(USSD INTERFACE -> java web app communication)
  • 电脑高中毕业学习去哪里培训
  • 正则表达式验证SMTP响应(Regex to validate SMTP Responses)

    • Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号

    本站部分内容来源于互联网，仅供学习和参考使用，请莫用于商业用途。如有侵犯你的版权，请联系我们(neng862121861#163.com)，本站将尽快处理。谢谢合作！