Output to MySQL DB

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • The Voivod
    #1

    Output to MySQL DB

    I have the requirements of getting a simple form to output to a db
    file. Currently I am using a form called ennyform and it outputs to a
    flat file. The person who want this wants it to be searchable and we
    expect to get anywhere from 50 - 300 forms submitted per day. I was
    reading that using php to MySQL was the correct way to get output into
    a MySQL database. I know this is not the only way but I am on a Linux
    platform and it is free. Is this overkill to set this up for a simple
    form? Should I continue using the flat file and import it into
    something. I am basically fishing for the most efficient way. I am
    only assuming PHP to MySQL is the best way. I would just like to know
    before I dive into the unknown. My next step would be to figure out
    how to set up a page to use PHP to output form fields. And of course I
    will have to create the DB.

    I hate to say this but yes I am clueless but I was hoping that this
    would be a short quik answer from somebody who done these things
    already. I just want to pointed in the right direction before I spend
    a lot of time with the wrong stuff. Currently I just read the text
    file, actually I don't even do that I just read the emails as they are
    sent. I rarely go in and look at the text file the form outputs to. I
    am going to have to though, very soon.

    Thanks A lot
    Tags: None
    • Jean-Baptiste Nizet
      #2
      Re: Output to MySQL DB

      The Voivod wrote:
      [color=blue]
      > I have the requirements of getting a simple form to output to a db
      > file. Currently I am using a form called ennyform and it outputs to a
      > flat file.[/color]

      What server-side technology/language do you use to output the form
      values to the flat file? Couldn't you use the same technology/language
      to output them to MySQL?

      The person who want this wants it to be searchable and we[color=blue]
      > expect to get anywhere from 50 - 300 forms submitted per day.[/color]

      Just FYI: this won't cause any problem, whatever technology you use. 300
      hits per day is a really small charge.

      I was[color=blue]
      > reading that using php to MySQL was the correct way to get output into
      > a MySQL database. I know this is not the only way but I am on a Linux
      > platform and it is free. Is this overkill to set this up for a simple
      > form?[/color]

      php is very quick and easy to install, as well as MySQL. You shouldn't
      have too many problems if you read the manuals at www.php.net.
      [color=blue]
      >Should I continue using the flat file and import it into
      > something.[/color]

      No. This would make things slower, and more difficult to implement.
      [color=blue]
      >I am basically fishing for the most efficient way.[/color]

      For such a small charge, use what you know best, i.e. the easiest
      solution for you.

      HTH.
      JB.
      [color=blue]
      >I am
      > only assuming PHP to MySQL is the best way. I would just like to know
      > before I dive into the unknown. My next step would be to figure out
      > how to set up a page to use PHP to output form fields. And of course I
      > will have to create the DB.
      >
      > I hate to say this but yes I am clueless but I was hoping that this
      > would be a short quik answer from somebody who done these things
      > already. I just want to pointed in the right direction before I spend
      > a lot of time with the wrong stuff. Currently I just read the text
      > file, actually I don't even do that I just read the emails as they are
      > sent. I rarely go in and look at the text file the form outputs to. I
      > am going to have to though, very soon.
      >
      > Thanks A lot[/color]

        Comment

        Previous template Next
        Working...