Jump to content

Archived

This topic is now archived and is closed to further replies.

bradkenyon

[SOLVED] storing email address into table

Recommended Posts

This is probably extremely easy, but I'll appreciate any help.

I have created a two column table, "id" and "address".

I want to a input box someone can type in their email address, and when they hit the submit button, it will be stored into the table "email_test".

<input type="text" name="address"> <input type="submit">

Now what?

Thanks in advance for reading this.

Share this post


Link to post
Share on other sites
you first need to connect to the database....

which can look like this

[code]
<?php
    $usr = "username";
    $pwd = "password";
    $db = "database name";
    $host = "localhost";

    $cid = mysql_connect($host,$usr,$pwd);
    mysql_select_db($db);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }

?>

[/code]

Then need to the form and this code...you might have to tweak it a bit

[code]
<?php
  
    # back on to this page (POST METHOD)
    if ($REQUEST_METHOD=="POST") {
        
        $SQL = " INSERT INTO email_test ";
        $SQL = $SQL . " (address, ) VALUES ";
        $SQL = $SQL . " ('$address') ";
                
        #execute SQL statement
        $result = mysql_db_query($db,"$SQL",$cid);
        
        # check for error
        if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    }
        
     echo ("<P><B>Your Request Was Submitted Successfully!!!</B></P>\n");

    }
    mysql_close($cid);
?>
[/code]

should get you started.....

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.