integrated mailing list?

121212

Hey, I have this user managment script installed on my site called the AR Memberscript. I just wanted to know is it possible to have a mailing list integrated with the member script so that a member can click like a "Join Mailing List" button and all the emails from the members can be stored in a file or soemthing like that?

rbblue8

sure!

but i need some questions answered first..

where are the members email address kept? in a mysql table? if not... make one! call it email_list

then do something like this.

$there_email=$_POST['email']; //This is the field name where the user enters there email

$query=("INSERT into email_list $there_email");
$result=mysql_query=($query, $db);//where $db is the connection to the email database.

then when you sent to email the email. just make the mail command pull the to field of your message from the mysql server.

However.. if you users email address is all rdy stored in a mysql database and you just want them to click a buttion and not have to enter any thing else...

then do something like this.

make the link something special. Like the href take something like this
addme.php?d=add_my_email

//your addme.php file

$user=$_SESSION['username'];
if($_GET['d']==add_my_email)
{
$Get=("Select email from users where username='$user'");
$get_query=mysql_query=($get, $db); //where $db is the database connector
$get_result=mysql_fetch_assoc($get_query);

$there_email=$get_result[0];

$add=("INSERT into email_list '$email'");
$add_query=mysql_query($add, $db) //where $db is the databse connector
echo 'Sucess!  rbblue8 does rock!';

that code is with not knowing your setup. if this is not what you looking for.. please repost with your script so i may fine toon it for ya. 🙂 and please remember your php script tages.

121212

hey THANKS ALOT... I only have 30 minutes for today till I go to sleep. Il try this first thing after school tomorow and see if it works.

121212

Sorry for double posting.. but for
$get_query=mysql_query=($get, $db); //where $db is the database connector
Where do I enter the DB stuff?

rbblue8

try this.

$host='server name or ip address here';
$username='the account used to access the database here';
$password='the pass for the above account here';
$database='the name of the database of which all data is stored (NOT TABLE NAMES) here';

$db=mysql_connect($host, $username, $password);
$select=mysql_select_db($database, $db);

it's a VERY good idea to keep a file that holds ONLY your mysql info, and just include it in every page that needs mysql in by doing:

include 'mysql.php'; //or what the file name of the file that holds the mysql info.

also once you are doing using the mysql server for that page.. please remember that you should close your connection to the server by doing:

mysql_close_db($db); //where $db is the name of the connector to the database.

rbblue8

121212 wrote:
hey THANKS ALOT... I only have 30 minutes for today till I go to sleep. Il try this first thing after school tomorow and see if it works.

what are you doing up @ 1:30 in the am?

god i wish i was young agagin.

121212

rbblue8 wrote:
what are you doing up @ 1:30 in the am?

god i wish i was young agagin.

Err it wasnt even after 11:00 PM that time. We just live in different time zones probably.

121212

Ok I am a bit lost here lol. Ok so far I have an addme.php and a mysql.php files. What should be in both files exactly.

ale1981

You might also want to check if the email address already exists in the database before you enter it!

121212

Ya but please help me with wat to do with thsoe php scripting you gave me?

rbblue8

121212 wrote:
Ya but please help me with wat to do with thsoe php scripting you gave me?

please post what you have so far.

if nothing.. let us know

121212

i got nothing lol

rbblue8

rbblue8 wrote:
try this.
$host='server name or ip address here';
$username='the account used to access the database here';
$password='the pass for the above account here';
$database='the name of the database of which all data is stored (NOT TABLE NAMES) here';

$db=mysql_connect($host, $username, $password);
$select=mysql_select_db($database, $db);
it's a VERY good idea to keep a file that holds ONLY your mysql info, and just include it in every page that needs mysql in by doing:
include 'mysql.php'; //or what the file name of the file that holds the mysql info.
also once you are doing using the mysql server for that page.. please remember that you should close your connection to the server by doing:
mysql_close_db($db); //where $db is the name of the connector to the database.

this will handle this.

your mysql file should like

$db_svr='the hostname of the mysql server...  if hosted on the same computer as webserver..  then it would be local host';
$db_user='the user name for the database';
$db_pass='the password for the username';
$db_base='the name of the database';

$db=mysql_connect($db_svr, $db_user, $db_pass);
if(!$db)
  {
   echo'Problem connecting to database ' .mysql_error()';
  };
mysql_select_db=($db_base, $db);

then you need to figure out where your email address are stored.
I have all rdy given you code on what your mysql query should like it above.

that's as far as i'm going to go with 'holding your hand' on this one. I have 100% given you what you your mysql.php file should look like two times and also given your the query to go into the database to get the email address.

good luck.