please help me publish my site using PHP & MySQL.

[benicio]

I now have completed my site using basic php/mysql
Thanks to all who helped me with those errors I got.

I use a ftp to publish my static website
but don't how with PHP & MySQL
and the securities.

Please guide me or post me a link for tutorials.

[Markus]

I'm sorry, mate, I don't quite understand.

Securities with what?

What problems are you having?

[nathj]

First of all you need a host that provides MySQL and PHP.

Create the MySQL database. Whatever you are using now to create the database should be able to perform a SQLDump to give you SQL code for creating the database complete with data if required. This script can then be used no your host to create the live database. Most hosts provide PHPMyAdmin for this sort of thing.

With the database in place it is likely that you will need to update your connection code with the new database name, server address etc.

Once that is in place you can load the files you have coded to the site using FTP or the hosts file manager. The host will give some guidance on where these files need to go.

That should be all you need to get your site from your local environment to your hosted domain.

The best place to seek help on this is probably the host company, I have experience with Network Solutions, Fasthosts and 1and1. They are all slightly different so your best bet is to contact the host or look for their help files/FAQ section.

Cheers
nathj