Results 1 to 3 of 3

Thread: populate mysql database

  1. #1
    Join Date
    Feb 2008
    Posts
    27

    Default populate mysql database

    I would like to use my Tectite formmail data output to populate a mySQL database preferably automatically.
    Can this be done, and if so how?
    Thanks in anticipation.
    Col

  2. #2
    Join Date
    Feb 2011
    Posts
    27

    Default Re: populate mysql database

    Just add something like this sql connection string just above the mail function in formmail


    $con = mysql_connect("Host","Username","Password");
    if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("slanderman", $con);
    $sql="INSERT INTO performer (firstname, lastname, email, performername1, performername2)
    VALUES
    ('$_POST[firstname]','$_POST[lastname]','$_POST[email]','$_POST[performername1]','$_POST[performername2]')";
    if (!mysql_query($sql,$con))
    {
    die('Error: ' . mysql_error());
    }
    mysql_close($con);

  3. #3
    Join Date
    Feb 2008
    Posts
    27

    Default Re: populate mysql database

    That's great, so where is this code inserted - is it in the formmail.php file or the htm input file?
    Can't quite see where the mail function referred to is located.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can't get checkbox to re-populate after missing fields error
    By Rwhite23 in forum HOWTO Guides and Tips
    Replies: 4
    Last Post: 11-Oct-2011, 03:02 PM
  2. Hook system and mysql database
    By onno in forum Community Support
    Replies: 14
    Last Post: 20-Sep-2010, 09:29 AM
  3. MySQL Database
    By Weineck in forum Community Support
    Replies: 8
    Last Post: 22-May-2009, 07:53 AM
  4. Mysql database
    By A77 in forum FormMail Subscription Support
    Replies: 11
    Last Post: 21-Apr-2008, 11:21 PM
  5. Inserting form info into MySQL database
    By MikeG in forum Community Support
    Replies: 6
    Last Post: 25-Jan-2007, 05:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

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