2. Mass Email Website Newsletter Bulk Batch Send Tutorial PHP MySQL

Source: http://www.developphp.com/video/PHP#M...
Learn how to use free open source technologies to create mass email newsletter blast marketing software from scratch. Use for your personal website or any client sites. This is a base system you can expand.

---

Closed Caption:

hello
what part 2 of creating a PHP and mysql
newsletter and bulk email blast tutorial
and what we did in part one was
listening to me blab a whole bunch and
just Yammer on about the logic and the
flow of the application and how
everything is going to work in part to
hear we're going to get our hands dirty
so let's go ahead and get our hands
dirty so here we are in PHP myadmin for
my existing database and if you guys
don't have a database setup already that
you're working with and connected to
already then you can go to develop PHP
which says mysqli course here and what
you want to do is click let's see
creating a mysql database on your web
host and you go through all of that
stuff make sure you read everything
really good even all the links that it
sends you to and you will be able to set
up in mysql database and connect to it
and then you'll be at the place where i
am and out so what I am inside of my
existing database i'm just going to add
another table for the newsletter because
it really doesn't require a whole
database just a little table so if you
have one that's already existing go
ahead and use that and just add a table
to it if you don't have a database setup
mysql database setup go to that link i
just showed you develop HP and follow
all that stuff very closely or you can
have your hosting provider help you out
if you're feeling lost call them and
tell them you want to set up a mysql
database and just having tons of
problems
alright let's go to
number fields here so we're going to
create a new table on the database minus
called mr. magic Adam this is the one I
used for my custom CMS tutorial system
where i showed how to build something
like joomla wordpress so that's why you
see modules and pages their new table
going in is called newsletter and that's
going to have let's say think any one
two three four five fields
let's go and then it's going to list all
the fields out for you designate what
they are first one is ID so let's make
that ID to let me type ID
the second one is going to be named
third one email is where the email is
going to be stored in that field and the
daytime that the person signed up for
your newsletter and received which is
going to be enumerated field so let's go
ahead and make that bill you see how
they all save our chart here we're going
to make that once a teen um i'm going to
give it some default values single quote
0 single quote comma single quote one
single quote so we have to default
values in there 0 and 1 and they're
separated by a comma and they're both
raptor with single quotes and that's how
it tells you how to set it up down here
so it's very easy now you go daytime
field you're going to make that daytime
find the daytime type and set it to
daytime type and the email bar chart 255
is good for char 255 name as well
and finally the ID field that's going to
be integer type so select int and then
go over here to extra auto increment and
then slide on over to primary so you
highlight the or select the radio button
there for the primary field so you have
primary auto-increment integer type ID
and everything is ready to go we're not
going to have any default values for
well let's put a default 0 in the
received field and that's it
now press save don't press go because
it'll add another field and say but what
you want to do is press save it will
create that table for you now with that
table created let's click on that
newsletter look at a real good
ok we have an ID field so each person
this is going to auto increment each
person that comes in to be subscribe to
our newsletter is going to have a unique
ID that's going to auto increment so the
first guys number one second guy number
two third guys number three so on and so
forth and but they won't be aware of
that number then their name email and
the daytime that they subscribe and
whether they have received the latest
email campaign the newsletter the latest
newsletter or not and i might add
another field here to this if we require
it but you'll see me do what I won't
leave anything out
and so that's pretty much all you need
for storage and the only reason why it
took me so long is because i was
explaining what all these fields are and
how to set them i could have done that
in 20 seconds and been done so that's
not bad time you in their 30 seconds to
a minute and you got your storage
mechanism set
ok
ok now that we created our MySQL
database we have to be sure we connect
to it before we start coding out any
kind of applications we got to make sure
we're connected to that bad boy so it's
going to Dreamweaver and these files are
going to be available with the tutorial
and we can download and get to the files
and set it up the way you need for your
system so what you'll do is you go in
here and you get this connect to MySQL
dot PHP file and you change these
borderlines the DB host the DB username
DB pass and dbname you can get all of
that information I can't help you with
that exact information and nobody can
accept your hosting account
administration the people who own your
hosting account and yourself if I was on
your server i could get the information
no problem because I know where to go
and get it where to look
if you don't you gotta ask ok but if you
look around you can probably find it
visit the help files and search for
mysql connection info or whatever
something like that anyways this is your
connect file now i'm going to open a
file called my school quick test that I
have I'm gonna put this all on the
server just to be sure that i'm
connected to my database so I'm going to
ftp everything into a folder called
newsletter so save my site is on the
root directory inside of that root
directory i'm going to have a folder
called newsletter that's going to hold
this whole application pretty much so
I'm going to ftp folder called
newsletter which I have right here my
dad up you can see right here there is
newsletter and inside of it i have
connect to mysql my my school quick test
and my index while on the index file is
going to be the form for gathering their
information
ok you'll just want to disregard this
index file for now and one was just
described are connected mysql which you
saw in full and mysql quick test which
also saw
simple is quick test and there's connect
to mysql and we're using the mysql
family of functions and not the new and
improved mysql I family of functions in
order for this tutorial to be more
Universal or more users but this works
in PHP 5 mph before university don't
worry about it
ok so let's go to add these to the the
web server and test
okay here i am at my life server online
i'm going to go to that directory
newsletter and yeah this is forbidden
i'm going to go to the file inside of it
called MySQL quick test that PHP you see
their success in database connection
happy coding so everything is good and I
have all that I need to connect to my
database my storage apparatus
okay now with our database set and our
storage apparatus ready we are ready to
move on in this first section here and
we just finished create a mysql database
table and connect to it i'm sure that's
working so now we'll move on to create a
forum for gathering their names and
email addresses and write a script to
send their info to the mysql database
I'm going to combine these two into one
little file which is going to be a
smarter way to work i think and help you
with clutter you can combine both of
these things into one file the form and
the parsing mechanism ever handling
everything 11 file and we're going to be
covering that file and creating it in
pot 3 so stay tuned and make sure you
guys comment and rate this video hi you
want to see me continue or else I feel
like nobody has any interest in learning
this type of thing any further and just
move on to something better
ok so you guys give me some feedback
okay bye