Step1: Getting Started
At this point you finished creating the database and form and you want to upload it to your web site. Start up wamp5, Left click and select phpMyAdmin. In the phpMyAdmin window you should see the database you created on the left hand side. Click to Select it.
You should see the options above, click on Export. In this window leave the defaults, Scroll down to the bottom of the page and you will see the "Save as File" text.
Click on the Check box next to "Save as File" and click on the GO button. This will allow you to download the sql file. To view the file after you download it open it with notepad, or Dreamweaver. If you are using Dreamweaver i suggest you open the file with it.
Step2: Creating the database on the web
Your web package should have a section that allows you to create a SQL database. Create a database using the exact name and password you using in wamp5. Database Name, Database Login, and Password should be the same. If its not you will get an error. Also Open the connection folder in dreamweaver, this is a folder that was automatically created when you set the database up. Open this folder and you should see a php file. Open the file, and switch to Code View, the $hostname_tut_db = "localhost"; you will have to change the localhost to where ever on your server the database is located. You can email your hosting company and ask for the address where your database is hosted.
Step3: Uploading the Database
After you created the database, login to the database through phpMyAdmin. Click Import and browse to the sql file you saved before. Make sure you have the localhost saved and close the database file if you have it open. After that hit go and this will upload the database. You can now upload the search form and connection folder. If you can make the connection folder on the same level as your index page.
Finished:
If you have any question or comment about this tutorial, feel free to post a message on the forum.
This Tutorial was Created By Mark
© 2005 pixeldigest.com. All Rights Reserved. |
