Mysql query, two times?

Posted on 16th Feb 2014 07:03 pm by admin

Hello to all,

I'm new to php coding and i like it alot. I need help with some noob stuff.

1. Having problem with mysql query after submiting HTML form. It's allways execuding two times, that way i have two identical data in table which i do not wont.

HTML code:
Code: [Select]<form name="kluboviForm" method="post" action="kluboviAction.php">
<input name="predsjednik" type="text"/>
<input name="email" type="text"/>
<input name="kontakt" type="text"/>
<input name="sjedisteKluba" type="text"/>
<input name="imeKluba" type="text"/>
<input type="Submit"/>
</form>
PHP code (kluboviAction.php):
Code: [Select]<?php
mysql_connect(localhost,root,'');
mysql_select_db(ljestvica) or die( "Unable to select database");
mysql_query("INSERT INTO klubovi VALUES ('','a','b','c','d','e')");
mysql_close();
?>
After execuding the submit button on form i get this error in google chrome:

Error 101 (net::ERR_CONNECTION_RESET): Unknown error.

But the query is execudet and table is filed with two identical informations.

2. Is there a way to put php function inside action form? I wont to execude php function after someone submits the form. I wont to delete kluboviAction.php file and use function to put the information in to database without the need to use second file. If there is anothere way to do that please let me know.

3. How to redirect URL after execuding submit button to not show message above?

Any help would be appreciated.

Thanks

Your Answer:

Login to answer

Other forums

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

Reading Most Recent CSV File in Directory
I thought I had wrapped this project up, but found out that the program I use to FTP a csv file to m

PHP IMAGE UPLOAD SCRIPT
Hi for the last week i have been looking for scripts that will upload a photo to a certain folder wh

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
ldap connection 
We are using ldap to get user information from the domain controller. It was working before. Recentl
How to change Time Zone 
HI
I want to change the time zone of the server to another country.How can do that?

Thanks
same querie, or a new one?? 
Hi guys,

I'm still working on this drop down list.  I've got the actual drop down list to wor
Product categories for registration 
Dear all,



We are going live with the Supplier registered next week. At standard, the 'sel
Merger of 6 sister companies under one flagship company after go live 
Dear Experts,

I need one help regarding Merger of sister companies of same group. currently we