Text link does accidental dbl insert

daJunkCollector

Hey, I have a simple web app that requires the user to click a text link to add a section to the form. As you will see from the following code (PHP/mySQL), the link inserts a row into the database table. The problem is that, during testing, sometimes when I click the link, two rows are added instead of only one. I only want one row to be added. Could you please help me figure out my bug?

Expand|Select|Wrap|Line Numbers

 // Insert and delete actions for Education, Work Experiences, and References

        if($_GET['action']=="insertEdu" && $_GET['checkId'] == $_SESSION['usrId'] && !isset($_SESSION['keyEdu']))

        {
 
            $sqlInsertStatementEdu ="INSERT INTO edu5000 (eduId, eduUsrId, eduName, eduCity, eduState, eduStatus, eduStartDte, eduEndDte, eduDegree, eduMajor, eduMinor, eduExtra, eduLastChgUsr, eduLastChgDte) VALUES (NULL , '".$_SESSION['usrId']."', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '".$_SESSION['usrEmail']."', now())";            //PROBLEM! INSERTING MULTIPLE ROWS SOMETIMES, NEXT ADJUST edu fields, NEXT adjust work exp, NEXT references, NEXT non-textbox controls

            $resultEdu0   = mysql_query($sqlInsertStatementEdu); // Insert row into edu
 
            if (!$resultEdu0) {

                print('Sorry, database error.  Please try again later. If problem persists, contact administrator (reference error 2784)');

            } else {

                $_SESSION['keyEdu'] = mysql_insert_id(); //sets new edu entry session key to prevent multiple new rows

            }

        }

and the body work...

Expand|Select|Wrap|Line Numbers

 <div><a href="resume.php?action=insertEdu&checkId='.$_SESSION['usrId'].'">(+ add education entry)</a></div>unset($_SESSION["keyEdu"]);//END EDUCATION
 

daJunkCollector

http://support.mozilla.com/tiki-view...8945&forumId=1

dlite922

I think you need better design because every time the page executes (such as using the Back button) the page executes again (sending the value to DB once more)

If this is suppose to add dynamic fields, I would do it with Ajax.

If this is more resume Edition, I would do this:

With JavaScript I'd insert a set of fields (row) to my table (let's say the Education Section) and when the user is done editing the resume, clicking "Save" would write it to the DB.

Let me know what the use case is, I'm not sure at this point why you're doing what you're doing.

Dan

Text link does accidental dbl insert

re: Text link does accidental dbl insert

re: Text link does accidental dbl insert

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about