Skip to main content

Subscribe/Unsubscribe to a Mailing List

The following PHP scripts shows how to maintain a mailing list. the users are asked to subscribe/unsubscribe to a mailing list and the entire mails are stored in the database.

The user has to type his email id and his/her name and select the radio button subscribe/unsubscribe. Since one email ids are unique, the email id field is a primary key.

Database Queries:

create database dummy;

create table mail(id varchar(100) primary key, name varchar(100))

HTML Form:

<FORM method =post action=sub.php>

<CENTER>

<FONT FACE = “ALGERIAN” SIZE = 6><BR><BR><B><u>SUBSCRIBER / UNSUBSCRIBER </U></B></FONT><BR><BR><BR><BR>

<FONT SIZE = 4><B>Enter E-Mail ID:</B></FONT><INPUT TYPE = text NAME = eid><BR><BR>

<FONT SIZE = 4><B>Name:</B></FONT><INPUT TYPE = text NAME = ename><BR><BR>

<INPUT TYPE = “radio” name = “radio” value = “Radio1″ > Subscriber

<INPUT TYPE = “radio” name = “radio” value = “Radio2″ > Unsubscriber <BR><BR>

<INPUT TYPE = submit VALUE = submit>

<INPUT TYPE = reset VALUE = reset>

</CENTER>

</FORM>

<FORM method =post action=sub.php>

<CENTER>

<FONT FACE = “ALGERIAN” SIZE = 6><BR><BR><B><u>SUBSCRIBER / UNSUBSCRIBER </U></B></FONT><BR><BR><BR><BR>

<FONT SIZE = 4><B>Enter E-Mail ID:</B></FONT><INPUT TYPE = text NAME = eid><BR><BR>

<FONT SIZE = 4><B>Name:</B></FONT><INPUT TYPE = text NAME = ename><BR><BR>

<INPUT TYPE = “radio” name = “radio” value = “Radio1″ > Subscriber

<INPUT TYPE = “radio” name = “radio” value = “Radio2″ > Unsubscriber <BR><BR>

<INPUT TYPE = submit VALUE = submit>

<INPUT TYPE = reset VALUE = reset>

</CENTER>

</FORM>

// Sub.php

<?php

$u = $_POST['eid'];

$p1 = $_POST['ename'];

$p2 = $_POST['radio'];

$con=mysql_connect(”localhost”,”root”,”") or die(”DB connection Failed”);

$db=mysql_select_db(”dummy”,$con) or die(mysql_error());

$query1 = “select * from mail where id = ‘$u’ “;

$query2 = “insert into mail values(’$u’,'$p1′)”;

$query3 = “delete from mail where id = ‘$u’”;

if ($p2 == “Radio1″)

{

$r1 = mysql_query($query1) or die (”Query1 Failed”);

$num = mysql_num_rows($r1);

if ($num == 1)

{

echo “Hai!$u You are already subscribed”;

}

else

{

$r2 = mysql_query($query2) or die (”Insertion query Failed”);

echo “Hai!$u.Thanks for signing up”;

}

}

else if ($p2 == “Radio2″)

{

$r1 = mysql_query($query1) or die (”Query1 Failed”);

$num = mysql_num_rows($r1);

if ($num == 1)

{

$r3 = mysql_query($query3) or die (”Deletion query Failed”);

echo “Hai! $u ur unsubscribed”;

}

else

{

echo “Hai! $u couldnt find ur name in the list”;

}

}

mysql_close($con);

?>

Comments

Popular posts from this blog

Installation of NS2 (ns-2.35) in Ubuntu 20.04

Installation of NS2 (ns-2.35) in Ubuntu 20.04 LTS Step 1: Install the basic libraries like      $] sudo apt install build-essential autoconf automake libxmu-dev Step 2: install gcc-4.8 and g++-4.8 open the file using sudo mode $] sudo nano /etc/apt/sources.list Include the following line deb http://in.archive.ubuntu.com/ubuntu bionic main universe $] sudo apt update $] sudo apt install gcc-4.8 g++-4.8 Step 3:  Unzip the ns2 packages to home folder $] tar zxvf ns-allinone-2.35.tar.gz $] cd ns-allinone-2.35/ns-2.35 Modify the following make files. ~ns-2.35/Makefile.in Change @CC@ to gcc-4.8 change @CXX@ to g++-4.8 ~nam-1.15/Makefile.in ~xgraph-12.2/Makefile.in ~otcl-1.14/Makefile.in Change in all places  @CC@ to gcc-4.8 @CPP@ or @CXX@ to g++-4.8 open the file: ~ns-2.35/linkstate/ls.h Change at the Line no 137  void eraseAll() { erase(baseMap::begin(), baseMap::end()); } to This void eraseAll() { this->erase(baseMap::begin(), baseMap::end()); } All changes made Step 4: Open a new termi

Installing ns-3.34 in Ubuntu 20.04

This post shows how to install ns 3.34 in Ubuntu 20.04 LTS Prerequisites: Fresh installation of Ubuntu Version 20.04 LTS  ns3.34 can be downloaded from here Follow the video link for complete step by step instructions on the installation.  This version fixes the compilation issues of vanet-routing-compare.cc (bug in ns3.33)  Issue the following commands after opening a terminal  $ sudo apt update $ sudo apt install g++ python3 python3-dev python-dev pkg-config sqlite3 python3-setuptools git qt5-default gir1.2-goocanvas-2.0 python3-gi python3-gi-cairo python3-pygraphviz gir1.2-gtk-3.0 ipython3 openmpi-bin openmpi-common openmpi-doc libopenmpi-dev autoconf cvs bzr unrar openmpi-bin openmpi-common openmpi-doc libopenmpi-dev tcpdump wireshark libxml2 libxml2-dev Unzip or untar the ns-allinone-3.34.tar.bz2 in the home folder (in my case its /home/pradeepkumar) $ cd ns-allinone-3.34/ $ ./build.py --enable-examples --enable-tests  Once the installation is completed, you may get an output show

Installation of ns3 in Windows 10 and Windows 11 OS using WSL (Windows Subsystem for Linux)

This post shows how to install ns-3.33 in Windows 10 through WSL (Windows Subsystem for Linux) This posts works for Windows 11 also (I have tested it on a Windows 11 ISO and it works the Same way as mentioned in the following post.) This post will work for ns-3.3x version. Prerequisites : Install Windows Subsystem for Linux with GUI: Please refer the following video  System Information: OS used: Windows 10 and WSL (Ubuntu 20.04) GUI: XServer for Windows NS3 Version: ns-3.33 See the following complete video on how to install ns3 in Windows 10 Step 0 : Open XLaunch Step 1 :  Open WSL using PowerShell and open it as Administrator Command:/  wsl $ xfce4-session The GUI of Ubuntu Opens within Windows 10 OS. Step 2 : Download ns3 from nsnam.org website through Mozilla Firefox browser Step 3: Open a Terminal  $ sudo apt update $ sudo apt install build-essential autoconf automake libxmu-dev python3-pygraphviz cvs mercurial bzr git cmake p7zip-full python3-matplotlib python-tk python3-dev qt5-q