Question about a simple c simple message board

You can create a database table too.

create table message

mid int identity(1,1) primary key,mtitle nvarchar(50) not null, - message subject.

mread varchar(10), whether to read or not.

Isn't that already stored?

When logging in, for example, A logs in to the system, check whether there is a message with mto as a in the message table, and display the old and new messages according to whether the mread is true and false (other values can be set). o(∩_o...

You can use the database here, you can put the message into the database, add the sender and the receiver, so that the receiver can read it, and you can also look up the history of the message.

I'll write one for you to see.

There is an advantage to utilizing the method of dom insertion. Although you are required to use JS and HTML to implement it here. without interacting with each other. But the results are interactive. You can make a message board that updates dynamically without refreshing.

It's useless to give you a paragraph**.

So a little bit more **.

If you really want to learn from the Imperial Servant, go for it.

There is also a lot of information on the article.

Is it **? Isn't it QQ's?

1.Life is like a journey, you need to climb, I hope you continue to work hard, I believe that your strength is very high, may your life be brilliant and beautiful, and may you have a great journey on the road of life!

2.Open the title page of the heart and leave the most simple words; Open the floodgates of memory and treasure the most beautiful moments. There are not too many flowery words, but every sentence is my mantra, may we dance together for the ideal, until a hundred years later, there was such a good saying in history:

In the north of China, there is a pair of good friends, they promised. This is what my classmate once wrote to me).

The first hint is a syntax error, and the program cannot be executed successfully;

The second is that due to the unquoted nature of $post[content], the program executes successfully, but not properly. ($post is equivalent to an array"content"is a key. The unquoted program will consider the key to be constant, and will report an error:

Undefined constants are used). So it's best to put them all in quotation marks.

There will be no more mistakes in changing the sql statement to the following:

sql = "insert into message(id,user,title,content,lastdate) values('','$_post[\'name\']','$_post[\'title\']','$_post[\'content\']',now())";

Changed to [.]'name\'] is the effect of quoting the name in it, and as for the backslash, it is an escape character. Because $post is in'', the single quotes in it need to be escaped to indicate that they are simple single quote characters, not quotation marks that contain strings.

It's fine without quotation marks, but it's best to put them all together.

Your problem above is not in quotation marks, but in that now(), which is used in php with time().

It is recommended that you filter the values from post or get.

e.g. $name = htmlspiels($ post[name]);

Then when writing the database, just use the variable $name, which is very convenient.