Getting Confused about uploading my db into server

[princeo]

I have designed a simple database in phpMyAdmin which I can view, but my problem now is, how do i upload it to my server and also how do i connect a search page to it so that a query can be initiated to get data from the db. I have been reading some tutorials but i get confused the more as most examples don't talk about using phpMyAdmin.

help needed please.

 

this is the structure:

 

ID | Name | Address | Registration |Date

 

[aschk]

Using PHPMyAdmin (which i'm assuming is running on your local machine), export (its an option) the whole database schema to a file, then on your server using the mysql command line tool, or PHPMyAdmin on the server import it.

 

e.g.

#> mysql -u @username -p @databasename < yourdatabasefile.sql

 

replace @username and @databasename with the respective parameters that you have.

[princeo]

Thnks for the help, I have uploaded the file to my server but there is still one issue remaining. I have an index.php page with a search on it, I want you to help me on how to connect to my db to get data to display on my page when someone enter a query. thanks in anticipation.

[aschk]

Start here: http://uk3.php.net/manual/en/ref.mysql.php

and check out #example 1

[princeo]

I have connected my database successfully but I want to be able to query it from a search box, I need a code to do this as every tutorial i have studied gets me confused the more. this is a newbie please.

 

this is the structure of the db

 

ID | Name | Address | Registration |Date

 

[aschk]

Again, check out the link i specified previously, that is as simple as it comes. Example #1 is perfect for you.