DaniWeb Forum Index > Web Development > PHP

How do get email from database?

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2009

Posts: 39

Reputation: NoID is an unknown quantity at this point

Solved Threads: 0

NoID

Offline

Light Poster

How do get email from database?

Jul 14th, 2009

Hello Guys,

I would like to know if its possible or not, where i can have a text box which when i enter the ID and press submit it gets the email matching that ID. and sends an email, please note that i know how to send email, i just dont know how to get data and send it can someone please give me an example on how i would do this. THank you

Have a good day

•

Join Date: Jun 2009

Posts: 172

Reputation: Menster is an unknown quantity at this point

Solved Threads: 22

Menster

Offline

Junior Poster

Re: How do get email from database?

Jul 14th, 2009

I'm not sure what you need: the HTML form, the SQL statement or the PHP to run it? or do you just want to pass?

$me = new Person();
if (isset($_COOKIE)){
$me->eat($_COOKIE);
} else { $me->starve(); }

•

Join Date: Jul 2009

Posts: 39

Reputation: NoID is an unknown quantity at this point

Solved Threads: 0

NoID

Offline

Light Poster

Re: How do get email from database?

Jul 14th, 2009

Hello,

I have a form when everytime i fill, it gives a unique id for example

name
surename
address
postcode
email@email.com
ID: 4

name
surename
address
postcode
email1@email.com
ID: 5

name
surename
address
postcode
email2@email.com
ID: 6

I then want a text box on say page called email.php

is like this

----------------
5 |
--------------- submit

when i click on submit, it goes to server and finds the email for record 5 and sends an email.

I hope that makes sense, thank you

have a good day

•

Join Date: Dec 2008

Posts: 94

Reputation: sikka_varun is an unknown quantity at this point

Solved Threads: 11

sikka_varun sikka_varun is offline

Offline

Junior Poster in Training

Re: How do get email from database?

Jul 14th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
 
if($_POST['submit'] == "Send Email")
{
    $sql = "Select * from tablename where id=".$_POST['id'];
    $res = mysql_query($sql);
    $data = mysql_fetch_array($res);
 
    $to_email = $data['email'];
 
    //Send mail here
    // mail($to_email,$subject,$msg);
}
 
?>
<form name="frmEmail" action="" method="post">
<input type="text" name="id" id="id" />
<input type="submit" name="submit" id="submit" value="Send Email" />
</form>
<?php

if($_POST['submit'] == "Send Email")
{
    $sql = "Select * from tablename where id=".$_POST['id'];
    $res = mysql_query($sql);
    $data = mysql_fetch_array($res);

    $to_email = $data['email'];

    //Send mail here
    // mail($to_email,$subject,$msg);
}

?>
<form name="frmEmail" action="" method="post">
<input type="text" name="id" id="id" />
<input type="submit" name="submit" id="submit" value="Send Email" />
</form>