/    Sign up×
Community /Pin to ProfileBookmark

Updating Database from Web Form and Email – PHP and Dreamweaver

Copy linkTweet thisAlerts:
Sep 15.2007

I am currently developing a pre-populated survey, whereby the respondents receive an email and can either click on a link to an update web page or update their details in the email and post them from there.

I have two problems at the moment:

  • 1.

    When trying to submit changes from a web page, I am encountering a problem whereby my data comes from a number of tables. In Dreamweaver I have set up two Update Record server behaviours, but only one of them actually works. I am also getting the error “Warning: Cannot modify header information – headers already sent in /home/schools/public_html/testform.php on line 81”.
    Is what I’m doing possible or have I just bodged the coding somewhere…?

  • 2.

    Before I start, I know all of the reasons that email forms are a bad idea, but at the end of the day what the boss wants the boss gets! I am not that brave. ?
    How would I go about getting the submit button to work from an email? I would probably get away with having the results emailed back, but even then, if you change the details before clicking ‘Reply’ they don’t show in the reply email, and once you click ‘Reply’ you can’t edit the form fields.
    Am I missing something here…?

    • Many thanks in advance for any advice anyone can give…

    Cheers

    G

    to post a comment
    PHP

    2 Comments(s) ↴

    Copy linkTweet thisAlerts:
    @flannSep 16.2007 — well, you're Warning cannot modify header information means that headers have already been output and then you're trying to modify them such as with a header ("Location: new_page.php") statement. Are you getting an error? if so, what is it?
    Copy linkTweet thisAlerts:
    @GrayZoneauthorSep 17.2007 — I have now sorted that error out, but it doesn't appear to be linked to why it doesn't work. It will still only update one table.

    I have tried putting the information for each table on seperate forms, each with their own Update Behaviour, and that doesn't work either.

    Any help would be greatly appreciated.

    Cheers

    G
    ×

    Success!

    Help @GrayZone spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.18,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...