Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Mar 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post [Help]Form Updates Between Users

    I have a large form that I would like multiple users to be able to edit at the same time.

    Does anyone have any tips on how I can make one users' edit immediately be reflected in the form of another user in a separate browser?

    I was thinking about onBlur actions to update a MySQL database. A second onBlur on each form field to call a separate PHP script which would check that MySQL database for changes.

    This would be a LOT of talk between users and the MySQL database. In addition I'd probably have to add a second database check on a timer.

    Any tips?

  • #2
    Supreme Master coder! Philip M's Avatar
    Join Date
    Jun 2002
    Location
    London, England
    Posts
    18,314
    Thanks
    203
    Thanked 2,565 Times in 2,543 Posts
    Post this in the PHP forum. Javascript cannot communicate with the server.

    All advice is supplied packaged by intellectual weight, and not by volume. Contents may settle slightly in transit.

    All the code given in this post has been tested and is intended to address the question asked.
    Unless stated otherwise it is not just a demonstration.

  • #3
    The fat guy next door VIPStephan's Avatar
    Join Date
    Jan 2006
    Location
    Halle (Saale), Germany
    Posts
    8,930
    Thanks
    6
    Thanked 1,041 Times in 1,014 Posts
    Well, to me that rather sounds like an AJAX issue. That’s basically a webchat kind of functionality or something what modern webmail or collaboration web applications do.

  • #4
    Regular Coder
    Join Date
    Feb 2012
    Posts
    123
    Thanks
    19
    Thanked 3 Times in 3 Posts
    I would think it would be ajax myself. I'm not that experience, but I believe you could create the forms and then linking the forms submit to the database and calling it from the database to post the information that was in your form. Kind of like a chat that refreshes itself. A user posts, and it shows up. A user enters something in the form; it shows up. Ajax would be needed for that type of feature I believe.

    This way, it wouldn't matter who updated what...it would automatically update as the user entered the information into the form; no matter where they are located at.

    Like I said, I'm VERY new to a lot of this scripting, but I'm learning and hoping i"m correct here. I'm sure if I'm not, someone will come around and correct me Just trying to be helpful. Good luck

  • #5
    New to the CF scene
    Join Date
    Mar 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the thread move and for your ideas regarding AJAX. I'll start reading the AJAX forum for tips

    Once I get the data array from my MySQL database how do I use javascript to populate my fields from the array?
    Last edited by lahonda_99; 03-01-2012 at 08:06 PM.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •