I have a hatchling account with Hostgator since the past 2 months. This is my first experience with a web host. I am on a learning curve and need to learn a few more things before I offer to make professional websites for anybody.
Sometime back, I had made a website using php, photoshop, html and css and have uploaded it to the server. My site is working fine.
Now I wanted to make a site containing a photogallery, where my photos will be stored in a database.
Actually, I have tried doing that on my local server and have a mysql database containing a few photos which I can see, when I call my php script on my local server. I tried making a dynamic photogallery where the client can upload or delete photos. I succeeded in having a database containing some pictures. I have written php scripts whereby I can upload or delete the photos myself.
Now, I wish to make a site incorporating what I have learnt and upload it to my webhost's server.
Normally, for uploading files to my web host's server, I go to my FTP client and after connecting the my host, I upload my files to the public_html folder.
What is the procedure for uploading files onto a MySQL database provided by the server?
I have a database containing the categories of pictures and some pictures in each category. I read in a book that if my web host provides PHP and MySQL, I would just need to use the empty database provided by my host and insert the photos into my web host's database.
What I want to do is this: I will create the database on my local server and upload photos there using the php page that I have made for uploading the photos. After I finish making all my pages (including my home page and all the other pages), I will have a working site on my local server. But what I need to know is that if I need to have the site running om my web host's server, will I have to use the database of my web host and do my work of uploading the photos all over again?
While working with databases, is it necessary to work directly with the web host's server instead of first doing the work on my local server, testing it and then uploading everything to my web host's server?
While naming my database, do I need to have a name given by my web host?