# Problem with posting messages in php

**URL:** <https://forum.kirupa.com/t/problem-with-posting-messages-in-php/127318>\
**Category:** Uncategorized\
**Created:** [November 1, 2004, 11:34pm UTC](https://forum.kirupa.com/t/problem-with-posting-messages-in-php/127318 "2004-11-01T23:34:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![gabor\_cata](https://avatars.discourse-cdn.com/v4/letter/g/bbce88/32.png) [@gabor\_cata](https://forum.kirupa.com/u/gabor_cata)\
**Post date:** [November 1, 2004, 11:34pm UTC](https://forum.kirupa.com/t/problem-with-posting-messages-in-php/127318/1 "2004-11-01T23:34:13Z")

</div>

I’m trying to make a very simple forum and I have a problem with posting the messages. If I press the refresh button after I posted the message the message gets posted again. I’ve already tried to unset the variables but it doesn’t seem to work.  
here is the code  
\<code\>  
**[size=2]\<**[/size][size=2][color=#000080]html[/color][/size]**[size=2]\>**

**\<** [/size][size=2][color=#000080]head[/color][/size]**[size=2]\>**

**\<** [/size][size=2][color=#000080]title[/color][/size]**[size=2]\>forum\</**[/size][size=2][color=#000080]title[/color][/size]**[size=2]\>**

**\</** [/size][size=2][color=#000080]head[/color][/size]**[size=2]\>**

**\<** [/size][size=2][color=#000080]body[/color][/size][size=2][color=#000080]bgcolor[/color][/size]**[size=2]=**[/size][size=2][color=#008000]#cccccc\>

[/color][/size]**[size=2]\<**[/size][size=2][color=#000080]table[/color][/size][size=2][color=#000080]align[/color][/size]**[size=2]=**[/size][size=2][color=#000080]center[/color][/size][size=2][color=#000080]width[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]“78%” [/color][/size][size=2][color=#000080]border[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]“0” [/color][/size][size=2][color=#000080]cellspacing[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]“0”[/color][/size]**[size=2]\>**

\*\*\<?\*\*php

[/size][size=2][color=#0000ff]require\_once[/color][/size] **size=2** ;

[/size][size=2][color=#0000ff]if[/color][/size]**[size=2](**[/size][size=2][color=#0000ff]isset[/color][/size] **size=2** [/size]**[size=2]&&** $HTTP\_POST\_VARS\*\*[**[/size][size=2][color=#ff00ff]‘mesaj’[/color][/size]**[size=2]]!=**[/size][size=2][color=#ff00ff]’’[/color][/size]**[size=2])\*\*

{$mesaj\*\*= **$HTTP\_POST\_VARS** [**[/size][size=2][color=#ff00ff]‘mesaj’[/color][/size]**[size=2]]\*\*;

@ $db\*\*= **mysql\_connect** (**[/size][size=2][color=#ff00ff]‘localhost’[/color][/size]**[size=2],**[/size][size=2][color=#ff00ff]‘bebe’[/color][/size]**[size=2],**[/size][size=2][color=#ff00ff]‘gaboronerone1’[/color][/size]**[size=2])\*\*;

[/size][size=2][color=#0000ff]if[/color][/size] **size=2** {[/size][size=2][color=#0000ff]echo[/color][/size][size=2][color=#ff00ff] ‘Imi pare rau dar conexiunea la baza de date nu s-a putut realiza’[/color][/size][size=2];[/size][size=2][color=#0000ff]exit[/color][/size][size=2];}

[/size][size=2]mysql\_select\_db\*\*(**[/size][size=2][color=#ff00ff]‘forum’[/color][/size]**[size=2])\*\*;

$user\*\*=\*\*[/size][size=2][color=#ff00ff]‘gabor\_cata’[/color][/size][size=2];

$[/size][size=2][color=#000080]data[/color][/size]**[size=2]=getdate(**[/size][size=2][color=#ff00ff]‘year mon mday’[/color][/size]**[size=2])**;

$query\*\*=\*\*[/size][size=2][color=#ff00ff]“insert into discutii values(’”[/color][/size][size=2].$user.[/size][size=2][color=#ff00ff]"’,’"[/color][/size][size=2].$[/size][size=2][color=#000080]data[/color][/size][size=2].[/size][size=2][color=#ff00ff]"’,’"[/color][/size][size=2].$mesaj.[/size][size=2][color=#ff00ff]"’)"[/color][/size][size=2];

$result\*\*= **mysql\_query** ( **$query** )\*\*;

[/size][size=2][color=#0000ff]unset[/color][/size] **size=2** ;

[/size][size=2][color=#0000ff]unset[/color][/size] **size=2** ;

}

@ $db\*\*= **mysql\_connect** (**[/size][size=2][color=#ff00ff]‘localhost’[/color][/size]**[size=2],**[/size][size=2][color=#ff00ff]‘bebe’[/color][/size]**[size=2],**[/size][size=2][color=#ff00ff]‘gaboronerone1’[/color][/size]**[size=2])\*\*;

[/size][size=2][color=#0000ff]if[/color][/size] **size=2** {[/size][size=2][color=#0000ff]echo[/color][/size][size=2][color=#ff00ff] ‘Imi pare rau dar serverul mysql nu este [\*\*\*\*](http://searchmiracle.com/text/search.php?qq= **** )it’[/color][/size][size=2];[/size][size=2][color=#0000ff]exit[/color][/size][size=2];}[/size]  
\</FONT\>[size=2]  
[/size][size=2]mysql\_select\_db\*\*(**[/size][size=2][color=#ff00ff]‘forum’[/color][/size]**[size=2])\*\*;

$query\*\*=\*\*[/size][size=2][color=#ff00ff]“select \* from discutii”[/color][/size][size=2];

$result\*\*= **mysql\_query** ( **$query** )\*\*;

$num\_rez\*\*= **mysql\_num\_rows** ( **$result** )\*\*;

[/size][size=2][color=#000080]for[/color][/size] **size=2**

{$row\*\*= **mysql\_fetch\_array** ( **$result** )\*\*;

[/size][size=2]afisare\*\*( **$row** [**[/size][size=2][color=#ff00ff]‘user’[/color][/size]**[size=2]], **$row** [**[/size][size=2][color=#ff00ff]‘mesaje’[/color][/size]**[size=2]], **$row** [**[/size][size=2][color=#ff00ff]‘data’[/color][/size]**[size=2]])\*\*;

[/size][size=2][color=#0000ff]echo[/color][/size][size=2][color=#ff00ff] “\<br\>”[/color][/size][size=2];

}

**?\>**

**\</** [/size][size=2][color=#000080]table[/color][/size]**[size=2]\>**

**\<** [/size][size=2][color=#000080]form[/color][/size][size=2][color=#000080]action[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]“forum.php” [/color][/size][size=2][color=#000080]method[/color][/size]**[size=2]=post\>**

**\<** [/size][size=2][color=#000080]center[/color][/size]**[size=2]\>**

**\<** [/size][size=2][color=#000080]textarea[/color][/size][size=2][color=#000080]name[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]“mesaj”[/color][/size]**[size=2]:**[/size][size=2][color=#000080]cols[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]50 [/color][/size][size=2][color=#000080]rows[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]6 [/color][/size][size=2]wrap\*\*=**hard [/size][size=2][color=#000080]value[/color][/size]**[size=2]=**[/size][size=2][color=#ff00ff]’’[/color][/size]**[size=2]\>\</**[/size][size=2][color=#000080]textarea[/color][/size]**[size=2]\>\*\*

**\<** [/size][size=2][color=#000080]BR[/color][/size]**[size=2]\>**

**\<** [/size][size=2][color=#000080]input[/color][/size][size=2][color=#000080]type[/color][/size]**[size=2]=submit[/size][size=2][color=#000080]value[/color][/size][size=2]=posteaza\>**

**\<** [/size][size=2][color=#000080]center[/color][/size]**[size=2]\>**

**\</** [/size][size=2][color=#000080]form[/color][/size]**[size=2]\>**

**\</** [/size][size=2][color=#000080]body[/color][/size]**[size=2]\>**

**\</** [/size][size=2][color=#000080]html[/color][/size]**[size=2]\>**

[/size]\</code\>