ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Adding members by writing directly to the MySQL database - advisable?

March 15, 2012 7:00am

Subscribe [3]
  • #1 / Mar 15, 2012 7:00am

    warrenkeith

    29 posts

    Hi there,

    I’m looking to integrate a current and active EE (2.4) site with an iOS app. The app will have a member registration form on it which will ideally create a member in EE.

    Does anyone have an experience with this? If someone else (certainly not me) was able to pass the necessary form details to a script, is it possible / feasible / advisable to write member data straight into the database?

    I’m using Solspace ‘User’ if that impacts at all.

    Any advice appreciated!

  • #2 / Mar 15, 2012 12:01pm

    Enviromed

    375 posts

    Check out nsm config bootstrap on ee-garage.com Good luck.

  • #3 / Mar 15, 2012 12:14pm

    warrenkeith

    29 posts

    Hi, thanks for your time but I’m not sure how it’s relevant to creating members by directly editing the database?

  • #4 / Mar 15, 2012 1:16pm

    Enviromed

    375 posts

    1.  Writing directly to the mssql DB is discouraged because you lose technical support from Ellis and a lot of technical support help from the community.  If you compare the db in ee 1x and ee 2x [codeigniter], you can also see how writing directly to the db becomes dicey when there are major version changes.

    2.  Unsure if your stated goal is to enable integration of desktop & mobile functionality, which includes members, which the config bootstrap helps accomplish. 

    3.  If you are writing an app then your post needs to go to the developer’s forum.

    Good luck!

  • #5 / Mar 15, 2012 5:18pm

    the3mus1can

    426 posts

    It is not bad to write directly to the db as long as you know that updates might break your addon and adjustments might be necessary.  I would take a look at https://github.com/crescendo/freemember - specifically the _member_register function.  This could be adapted to suit your needs. It would best to expose a simple JSON or XML API (depends on what you are using in the iOS app) for the member registration.

  • #6 / Mar 16, 2012 1:00pm

    warrenkeith

    29 posts

    Many thanks for pointing me in the right direction with these. I’m not personally developing the app, it’s another developer, but they’re looking to register members and post information directly into the database. It makes me a little nervous but I don’t think there’s a way around it! I’ll post back to let you know how I get on…

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases