Php Export mysql data to csv file :- Part 1

So finally after importing data it's time to export data from mysql and insert it to csv file.Stay tuned to get more awesome tuts

Playlist Link :- http://www.youtube.com/playlist?list=...

---

Closed Caption:

hey welcome back guys collectively 2.com
and as a promise i will be showing you
how to explore data from mysql database
and inserted to a CSV file so what we're
going to do out here inside the folder
we had like.we created last time that
we'll see us we are going to create one
more photo and then i'm going to explode
ok and out here i will create a new fuck
a limit to index 2.php and they will
create a new folder that would be
uploads so this would be the folder
where we will be saving our CSV files so
very quickly i'm going to open this fall
with my text editor where some HTML
markup and they're out here we would be
creating a farm metal post action would
be index dot PHP and guys you don't need
any NC type because this channel we are
not uploading any false
ok so you don't need that I'll do i'm
going to create a submit button and it's
maybe supplement the world you would be
something or whatever you guys want
ok so what we're going to do once we
will click this particular bottom we're
going to run a query will run the
functions that will go ahead and that
will get everything from this particular
database event not this one that was CS
we ok it will get everything from this
particular table and it will inserted to
our CSV file in the same way in the same
pattern so what we're going to do for
data as we have to write some PHP or on
the top but before that i will run this
while I want to explode over here we
have our something
so as always unless it if is set Donald
host submit that after some it was an
ass but then go ahead and do everything
otherwise they will consider anything
very first ten guys are we want is we
have to create a file
ok so what I want to do is I want to
create a file out here the file would be
in our uploads folder
ok after that I want to run a function
that would be start to find this will
give us a current you next time
so the reason I'm doing this it will
make your like it will make every
following me
let's see if I'm are making a phone that
right now it will have a different name
if I will make it after one second it
will have a different day
ok so that's the reason I'm using the
time function so i want to say start to
time after that i can say Y and G to get
the current time again . sign because
this is a function and now we have to
find this . so the spring would be . csb
ok so first echoed it out is a echo
filing will give you over wheel
what exactly are doing come back
refreshed the page that submit that says
upload / cos we it's not creating any
time for now that we got what okay we
have to say now do it again
so I got it k so it says upload / 17 if
i'll refresh again see it has a
different name because it was after nine
second of the two seconds after again to
us against again one second
so every time you plan to calculate the
current time and then it's garnished
make a fault with that made ok now we
are able to make a file we are not going
to call it out we would be using it but
to before that we have to work or tea
there that query will be to get
everything from arm is to balance so i
wanna same is true of Corey select all
from test
I believe that song like a reading from
parents or die mysql error but two guys
before we will select anything we will
have to make a connection on the top so
what I'm going to do i will grab the
connection to be made on you have you so
i'll copy everything from the top BB
issue so right now we will get
everything from our database and we will
get it in the form of associated so on
10 will be Elias tool which and
associate Emery nice if you want you can
use our way but once you're dealing with
files i would recommend you try to go
been associated parties though the boats
are almost similar if you want to read
more about them you can go to php.net so
what I'm doing is I'm getting everything
from here and form of an associate amore
so next thing we can do again a coat
daughter well it will show you our way
that's to give you guys
that's right so that means we are able
to get everything in the final four ring
be because now the tanks will get a bit
complicated but don't worry we're gonna
make it
you know really really small one more
thing we have to do is we will have to
open our file up here i wanna c FP and
the function of open to open any file
the file we want to open that would be
the filename we created out here and
after that how we are going to open the
file we want to open it in a right mom
so that we can actually write to the
file if you remember last time we used
our for the green after that we have to
create a couple of our vehicles so the
one that looks ok the first we'll be
able would be say separator okay that
would be equal to nothing for now the
second variable would be comma that
would be equal to nothing for now the
reason we are creating these variables
so that we can use them later in order
to get the result and to insert it to
our database
ok and guys then we will have to run a
for each statement in order to get
everything from this around right now .
a row is equal to NR way it will have to
get the actual value of for the fields
and for that we will have to run a for
each tape so what I'm going to do is
once for each daughter grow that is RA
as a daughter named and get it
well you okay that's a very simple and
very basic four weeks change if you guys
have no knowledge about these for each
then i would say it will go over your
mind otherwise our I think it's quite
simple
so if i will echo dollar name we will
get some value from my database then I'm
gonna do a break tag as well again go
ahead refresh
see we got ID we got the first name
we got the last name and we got the
email so if you will come out here its
ID first name last name and even and
guys in order to pull up these actual
values instead of you know printing out
the name you can print out the value so
you can say well you go ahead refresh
its s9 name last name email
ok so pull up the very first so the name
will give us the heading and the value
will give us the actual value but very
first we want the headings to be
inserted to our CSV far