Ad:

PHP Discussion Thread
Unsolved
Views: 505

Jul 14th, 2009

How do get email from database?

Expand Post »

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

Similar Threads

how to insert email into database in PHP
checkboxes to email and database in PHP
email=username in_form in PHP
email assigned to username on submit in MySQL

NoID

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

49 posts
since Jul 2009

Permalink

Jul 14th, 2009

Re: How do get email from database?

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?

Menster

Reputation Points: 49

Solved Threads: 22

Junior Poster

Offline

175 posts
since Jun 2009

Permalink

Jul 14th, 2009

Re: How do get email from database?

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

NoID

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

49 posts
since Jul 2009

Permalink

Jul 14th, 2009

Re: How do get email from database?

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>

Last edited by sikka_varun; Jul 14th, 2009 at 9:36 am. Reason: Changing $_SUBMIT to $_POST

sikka_varun

Reputation Points: 11

Solved Threads: 12

Junior Poster in Training

Offline

94 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Formula and syntax

Next Thread in PHP Forum Timeline: web crawler

DaniWeb Message

Cancel Changes

User Name
Password