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.

Insert statements required to create a weblog entry.

June 16, 2009 1:18pm

Subscribe [2]
  • #1 / Jun 16, 2009 1:18pm

    aimbot

    36 posts

    Ive been checking out the EE DB on how it stores weblog entries because my solution requires (or at least i think it does) a user to be created once they fill out a form, and then automatically inserts the information that the user just created into a weblog entry. Basically because i want to user to be able to create their user account and enter a weblog entry on the same page seamlessly. Has anyone identified what inserts are needed to correctly enter a weblog entry through direct sql? Or is there a php function that I can use to do that?

    Just to re-iterate what my thoughts were a user creates a questionaire about the kind of work they need done. The users account is created based on the email they give us (this part is done), then their information about the project is inserted into a weblog to foster a place for both of us to discuss their project. Thanks for any thoughts on the subject.

  • #2 / Jun 17, 2009 6:15pm

    PhireGuys

    525 posts

    Here’s an idea…

    Why not create a SAEF form and then load it up in your browser, view source and get all the info it has.

    Then what you do is create your page that has this and the user’s info.

    When they click submit, send all the info to your custom PHP page to do some processing.  First step, is to send with cURL the login information to the EE page that processes user registration.  Then his account should be made.

    Then, on the same page, use another cURL request to pass the info to the EE page to process a SAEF submit.  Pass in all the info the user gave to that.

    This is just an idea and I don’t know exactly if or how to make it work.  You’d need to log the user in automatically after the registration so that the next request would be as a logged in user though.

    Otherwise, I don’t have any clue.  This is very technical.  Hope you can find some solution.

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

ExpressionEngine News!

#eecms, #events, #releases