Databases
StackOverflow2013
Postsdbo
POif page refresh again value added?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POif page refresh again value added?
    primarykey
    data
    text
    <p>I'm using the following form in a project. In this form the values are added properly when i submit. but after submit if i refresh the page the existing values are inserted again. i need after submit i refresh the page, the existing values are not added. Please help me.</p> <pre><code>`&lt;form name="form" method="post" action="&lt;?php $_SERVER['PHP_SELF'];?&gt;"&gt; &lt;table width="918" border="0"&gt; &lt;tr&gt; &lt;td width="222" height="300"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="686"&gt; &lt;table width="331" border="0"&gt; &lt;tr&gt; &lt;td height="30"&gt; &lt;?php error_reporting (E_ALL ^ E_NOTICE); include("config.php"); $class_section=$_POST['class_section']; if(isset($_POST['submit'])) { $sql=mysql_query("insert into section(section_id, class_section) values ('', '$class_section')",$conn); if($sql) { echo"&lt;p&gt;&lt;center&gt;&lt;b&gt;&lt;font color='green'&gt;Section Added Successfully!&lt;/font&gt;&lt;/b&gt;&lt;/center&gt;&lt;/p&gt;"; } else { echo"&lt;p&gt;&lt;center&gt;&lt;b&gt;&lt;font color='red'&gt;Section Add Failed!&lt;/font&gt;&lt;/b&gt;&lt;/center&gt;&lt;/p&gt;"; } } ?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;table width="331" border="0"&gt; &lt;tr&gt; &lt;td height="47"&gt;Class Section/Group&lt;/td&gt; &lt;td&gt;&lt;input name="class_section" type="text"/&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="33"&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="submit" name="submit" value="ADD" class="button"&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt;` </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsteve
    1. USboopathi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POif page refresh again value added?
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POif page refresh again value added?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POif page refresh again value added?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COFrom your code, no value is promoted to be inside the input element at all. Probably your browser adds the value again. Try to set the value in your form to nothing, like `value = ""`.
      singulars
      1. POif page refresh again value added?
      1. UShakre
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload