Building Dynamic Websites With MySQL And PHP

You option at this time is to create the database from your control panel's MySQL Account Maintenance  or use phpmyadmin to do same.

Using your control panel's MySQL Account Maintenance will provide you with the connection string that you can cut and paste to your program:


$dbh=mysql_connect ("localhost", "username", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("databasename");

Once you have your database and connecting string, all you need are the insert, select, update and delete calls and you are set to go.

Since you don't know enough of php yet, it will futile to ask you to write the mysql code and upload to your hosting, this is also an option.

Visit:
http://www.freewebmasterhelp.com/tutorials/insert
or
http://www.webmonkey.com/programming/php/tutorials/tutorial4.html



Good luck!


Godwin

Well we just told him the phase one of his problems,he might still have doom set ahead of him
@damseremie ,
well if that works, lets hope it does, you "might" have to either create a replica user you have locally with the one online and set a global privilege to the user.

from my understanding, you know how to use PhpMyAdmin not Myphpadmin (since its yours, it sure wont work ) so like prodgalson said do the export thingy
Since you used dreamweaver, yyou'dalso have to edit a .php file in your siteroot/Connections/ folder ,


you sshouldsee somfin similar to this

1 <?php
2 # FileName="Connection_php_mysql.htm"
3 # Type="MYSQL"
4 # HTTP="true"
5 $hostname_examguide = "localhost";
6 $database_examguide = "examguide";
7 $username_examguide = "timmy";
8 $password_examguide = "abstract";
9 $examguide = mysql_pconnect($hostname_examguide, $username_examguide, $password_examguide) or  trigger_error(mysql_error(),E_USER_ERROR);
?>


you might have to edit line 5 (but not always, most likely that remains the same value and if u used 127.0.0.1 locally, change it to localhost online)
but certainly your line 6,7 and 8 most be well monitored else yuld be setting for doom, i just pray your client is the gentle type else na yawa for you,

anyways like i said lets know the kind of admin panel your host support, then i could give a precise help.

The last message was actually from me . i mistakenly used someone else;s account who was already logged in. So here it is again


Thanks u all . Am yet to try it but i will and ill make sure i let u know what went RIGHT, (Or wrong).  and to timmy yes i meant PhpMyAdmin not myphpadmin as i wrote earilier (well u got me).
prodgalson:  ill finish work on the site in the next 3 or 4 days so that ill put your solution to test.
Thanks again.
timmy Could u tell me exctly what details u need about my admin panel so that i can send them,  (again remember am an amateur so bear with my questions if they seem foolish)

Hi,
I want to create a form that can be viewed and filled online and the content of the form will reside in a database but i don't know where to start from i do know however, that i would use mysql and php. So please can anybody out there help me.

thanks