求大神帮忙看看哪里出错了。
我想实现用户之间的通信，思想是建立一个消息表，然后把收件人用户名、发件人用户名、消息等放进去，然后谁想看发给自己的消息就去消息表中查找收件人是自己的记录。现在做到发消息这一块儿了，发完消息我发现数据库消息表中并没有记录，应该是没有正确插入表中，大神帮忙看看是哪里错了，我也是刚接触PHP的，以前上课学的东西都是基础的，运用到实践中总是出很多问题。
下面附上相关的代码（其中sqltable是用户表，sqltable2是消息表，user_name是用户表中存储用户名的，s_name是消息表中存储发件人的，r_name是消息表中收件人）
config.php
<?php <br />//常规参数设置<br /><br />$servername="localhost"; //主机名<br />$sqlservername="root"; //mysql数据库用户名<br />$sqlserverpws="lmy"; //mysql数据库密码<br /><br />$sqlname="lmy"; //数据库名<br />$sqltable="user"; //username表名<br />$sqltable2="message";<br /><br />$admin_name="lmy"; //管理员用户名<br />$admin_pws="lmy"; //管理员密码<br />?>
message.php
<?php<br /><br />session_start(); //一定要的<br />if($_SESSION["name"]==""){<br />echo "<script>location.href='index.php';</script>";<br />exit;<br />}<br />//上面的要验证过滤的<br />?><br /><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><br /><html><br /><head><br /><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><br /><title>给管理员发信</title><br /></head><br /><br /><body><center><br /> <form name="form1" method="post" action="message_cl.php"><table width="68%" height="304" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000"><br /> <tr align="center" bgcolor="#CCCCCC"><br /> <td colspan="2">发信(message.php)||<a href="index.php">返回</a></td><br /> </tr><br /> <tr bgcolor="#CCCCCC"><br /> <td align="right">收件人：</td><br /> <td align="left"><input name="r_name" type="text" id="r_name"></td><br /> </tr><br /> <tr bgcolor="#CCCCCC"><br /> <td align="right">消息内容：</td><br /> <td align="left"><input name="content" type="text" id="content" size="40"></td><br /> </tr><br /> <tr align="center" bgcolor="#CCCCCC"><br /> <td colspan="2"><input type="submit" name="Submit" value="发送"> <br /> <input type="reset" name="Submit" value="重置"></td><br /> </tr><br /> </table><br /> </form><br /></center><br /></body><br /></html><br />message_cl.php
<?php <br />session_start(); //一定要的<br />if($_SESSION["name"]==""){<br />echo "<script>location.href='index.php';</script>";<br />exit;<br />$_SESSION["name"]=$row[user_name];<br />//这里是SESSION来验证用户的合法性<br />}<br />include("config.php"); //参数页面提取过来<br /><br />if(empty($_POST["r_name"])){<br />echo ("<script type='text/javascript'> alert('请填写收件人！');history.go(-1);</script>");<br />exit;<br />}<br />if(empty($_POST["content"])){<br />echo ("<script type='text/javascript'> alert('请填写消息内容！');history.go(-1);</script>");<br />exit;<br />}<br /><br />$s_name=$_SESSION["name"];<br />$r_names=$_POST["r_name"];<br />$content=$_POST["content"];<br />$add_time=date("Y-m-d");<br />$is_open="no";<br /><br />$db=mysql_connect($servername,$sqlservername,$sqlserverpws);<br /><br />mysql_select_db($sqlname,$db) ;<br />$sql="select * from $sqltable where user_name='$s_name'";<br />$result=mysql_fetch_row(mysql_query($sql));<br /><br />if(!$result){<br />echo ("<script type='text/javascript'> alert('无效的收件人！');history.go(-1);</script>");<br />}<br />else{<br />$sql="insert into $sqltable2(s_name,r_name,content,add_time,is_open) values('$s_name','$r_name','$content','$add_time','$is_open') ";<br />mysql_query($sql);<br /><br />echo ("<script type='text/javascript'> alert('发送成功');location.href='index.php';</script>");<br />}<br />?>------解决思路----------------------
哈哈，把分给我吧，已经远程协助解决。就是sql表里没有is_open字段而php又要插入is_open字段值，还有就是sql语句拼装问题
What data can be stored in a PHP session?May 02, 2025 am 12:17 AMPHPsessionscanstorestrings,numbers,arrays,andobjects.1.Strings:textdatalikeusernames.2.Numbers:integersorfloatsforcounters.3.Arrays:listslikeshoppingcarts.4.Objects:complexstructuresthatareserialized.
How do you start a PHP session?May 02, 2025 am 12:16 AMTostartaPHPsession,usesession_start()atthescript'sbeginning.1)Placeitbeforeanyoutputtosetthesessioncookie.2)Usesessionsforuserdatalikeloginstatusorshoppingcarts.3)RegeneratesessionIDstopreventfixationattacks.4)Considerusingadatabaseforsessionstoragei
What is session regeneration, and how does it improve security?May 02, 2025 am 12:15 AMSession regeneration refers to generating a new session ID and invalidating the old ID when the user performs sensitive operations in case of session fixed attacks. The implementation steps include: 1. Detect sensitive operations, 2. Generate new session ID, 3. Destroy old session ID, 4. Update user-side session information.
What are some performance considerations when using PHP sessions?May 02, 2025 am 12:11 AMPHP sessions have a significant impact on application performance. Optimization methods include: 1. Use a database to store session data to improve response speed; 2. Reduce the use of session data and only store necessary information; 3. Use a non-blocking session processor to improve concurrency capabilities; 4. Adjust the session expiration time to balance user experience and server burden; 5. Use persistent sessions to reduce the number of data read and write times.
How do PHP sessions differ from cookies?May 02, 2025 am 12:03 AMPHPsessionsareserver-side,whilecookiesareclient-side.1)Sessionsstoredataontheserver,aremoresecure,andhandlelargerdata.2)Cookiesstoredataontheclient,arelesssecure,andlimitedinsize.Usesessionsforsensitivedataandcookiesfornon-sensitive,client-sidedata.
How does PHP identify a user's session?May 01, 2025 am 12:23 AMPHPidentifiesauser'ssessionusingsessioncookiesandsessionIDs.1)Whensession_start()iscalled,PHPgeneratesauniquesessionIDstoredinacookienamedPHPSESSIDontheuser'sbrowser.2)ThisIDallowsPHPtoretrievesessiondatafromtheserver.
What are some best practices for securing PHP sessions?May 01, 2025 am 12:22 AMThe security of PHP sessions can be achieved through the following measures: 1. Use session_regenerate_id() to regenerate the session ID when the user logs in or is an important operation. 2. Encrypt the transmission session ID through the HTTPS protocol. 3. Use session_save_path() to specify the secure directory to store session data and set permissions correctly.
Where are PHP session files stored by default?May 01, 2025 am 12:15 AMPHPsessionfilesarestoredinthedirectoryspecifiedbysession.save_path,typically/tmponUnix-likesystemsorC:\Windows\TemponWindows.Tocustomizethis:1)Usesession_save_path()tosetacustomdirectory,ensuringit'swritable;2)Verifythecustomdirectoryexistsandiswrita
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
SublimeText3 Chinese version
Chinese version, very easy to use
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
SublimeText3 English version
Recommended: Win version, supports code prompts!
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
