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

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is

Help with php code
Hello, can anyone tell me why this php word trap fails to work,
and the trigger words get blow r

Displaying different page content, depending on the logged in user.
Hi all, I am new to ASP.net (and web development in general), and have a question about how I can di

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

Collecting AOL Search Terms
I am attempting to collect AOL search terms. I know the code is correct (it works for google, bing,