[thelist] php add email to a mysql db

[Andrew Maynes]

this is what I had originally thought, I must be missing something.  The rest of
the code checks a couple of form fields and then emails the results to both the
site admin and the form filler.  I did have a problem with a conflict there but
that is sorted now as it was a mail problem.

Andrew

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele
Sent: Tuesday, August 13, 2002 02:55
To: thelist at lists.evolt.org
Subject: RE: [thelist] php add email to a mysql db


In this situation you could add the email to the database using another caller
of some kind, like
a pop-up window.

<form name="myForm" onsubmit="if(documnet.myForm.addToEmailList.checked)
window.open('addToEmailList.php?email='+document.myform.email.value">

I don't understand how adding the code to insert the email into database on the
next page in the
order will screw up the order code...you are simply adding an extra query to the
rest of the php
script.

Anyway, hth.

--- Andrew Maynes <andrew at uk-webdeveloper.co.uk> wrote:
> this is really useful and helped alot, however I had better run this by you.
>
> The form I am using already has an email field which I dont want to change,
> except to add a little tick box next to it.  This is the existing form element
> in form 1.
>
> <TR><TD>E-mail Address</TD><TD><input name="Email" size="30"></TD></TR>
>
>
> I have added some code into the form 2 but everything else doesn't work!  the
> form is being used as an order form so when the code is added the order info
> isn't being sent, which indicated the adding to a mailing list code is
disabling
> the other code?  Which doesn't seem logical!
>
> Andrew
>
>
> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele
> Sent: Monday, August 12, 2002 10:32
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] php add email to a mysql db
>
>
> Hey Andrew,
>
> Sure you can.
>
> Create a checkbox in the form:
>
> <input type="checkbox" name="addToList" value="yes">
>
> Then on the receiving page...
>
> if(isset($addToList) && $addToList == "yes"){
>    //assuming there's a form field called email
>    $throwItIn = mysql_query("insert into mylistofemails
> values('".$_POST['email']."');
> }
>
>
> --- Andrew Maynes <andrew at uk-webdeveloper.co.uk> wrote:
> > Hi all
> >
> > glad we are back online, is it just me or is everyoner getting 2-3 mails of
> the
> > same post?
> >
> > anyway here is the question, I have a form that I would like to get the
email
> > inserted into a MySQL db is this possible?  I mean possible to use the
> existing
> > form elements and adding a tick box sent me a weekly newsletter?
> >
> > Thank you
> >
> > Andrew
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02
> >
> > --
> > For unsubscribe and other options, including
> > the Tip Harvester and archive of thelist go to:
> > http://lists.evolt.org Workers of the Web, evolt !
>
>
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02