cshell_1987 Posted April 3, 2008 Share Posted April 3, 2008 If I am on the wrong forums, please point me in the right direction. I am a Computer Networking student at ITT Tech. We have a class project. I have volunteered for the database portion. All the project requires is a simple database from Access, but seeeing as this project spans 11 weeks, I would get bored after the first couple of weeks. I have heard of MYSQL before and I decided I was going to expereiment with this program. What I would like to do is: Create a database using MYSQL, then integrate the database onto our Apache web server using PHP. My only problem is I have no idea or guidance on how to do this, I have just been googling with little helpful results. Another classmate is setting up the Apache web server using Fedora Core 5 Linux. I just need to make the database and the code to move the database onto the website. I set up an apache web server several months ago in my introduction to Linux class but it's been a while, I'm using a different operating system for this, and there is no one present to answer my questions and guide me. *The OS on the Apache web server is Fedora Core 5. *The OS I am using to set up Apache, PHP, and MYSQL is Windows XP SP2 (my computer is set up to dual boot with Windows Vista and XP, I don't feel like adding a 3rd OS) *I have downloaded WAMPSERVER 2.0 as well as Workbench (GUI for MYSQL). *I would like to get the database running an a test Apache web server and then save the database file and php code to my flash drive, take it to school and move the data onto the Linux Apache web server and set up everything at school. This needs to be a simple web site, with a simple one table database that people viewing the website can view and perform queries. I finished creating my database by using workbench, then I discovered you can use the PHP my admin to create a database through your browser, oh well. I have been trying to find tutorials to help walk me through setting up Apache, and using PHP code to get the database onto the web server. I haven't made very much progress, most tutorials assume I know something that I do not. Any help would be appreciated. Thank you very much for your time and patience. Quote Link to comment https://forums.phpfreaks.com/topic/99384-i-need-help-getting-my-sql-database-onto-my-apache-web-server/ Share on other sites More sharing options...
trq Posted April 3, 2008 Share Posted April 3, 2008 Im sorry, but in all that I don't actually see a question. What exactly are you stuck with again? Quote Link to comment https://forums.phpfreaks.com/topic/99384-i-need-help-getting-my-sql-database-onto-my-apache-web-server/#findComment-508527 Share on other sites More sharing options...
cshell_1987 Posted April 3, 2008 Author Share Posted April 3, 2008 I need guidance in setting up Apache on a Windows OS, setting up the database in PHP my admin, and getting the database onto the website where people viewing can see the table and perform queries. Quote Link to comment https://forums.phpfreaks.com/topic/99384-i-need-help-getting-my-sql-database-onto-my-apache-web-server/#findComment-508630 Share on other sites More sharing options...
cooldude832 Posted April 3, 2008 Share Posted April 3, 2008 here is a guide to end all guides Click Me!!! Quote Link to comment https://forums.phpfreaks.com/topic/99384-i-need-help-getting-my-sql-database-onto-my-apache-web-server/#findComment-508639 Share on other sites More sharing options...
craygo Posted April 3, 2008 Share Posted April 3, 2008 Well what you want really can't be done through a forum site. Way to many variables and would be a hell of a lot of posting. I don't use apache but I do run IIS, PHP, MySQL and XP SP2 on my development box. If you need some guidance, other than the apache, I can help you out. I'd rather talk in AIM my screen name is craygo69. Good luck Ray PS your link is messed up cooldude Quote Link to comment https://forums.phpfreaks.com/topic/99384-i-need-help-getting-my-sql-database-onto-my-apache-web-server/#findComment-508641 Share on other sites More sharing options...
wildteen88 Posted April 3, 2008 Share Posted April 3, 2008 *The OS I am using to set up Apache, PHP, and MYSQL is Windows XP SP2 (my computer is set up to dual boot with Windows Vista and XP, I don't feel like adding a 3rd OS) *I have downloaded WAMPSERVER 2.0 as well as Workbench (GUI for MYSQL). If you have download WAMPServer 2, just run the installer to install the AMP stack (Apache, MySQL and PHP). WAMP will setup AMP for you, it also comes with phpMyAdmin too. You will not need to configure anything. You save all your web files (html/php/image/css files etc) in C:\wamp\www you access these files by opening your browser and going to http://localhost to run your php scripts. For transferring your database you can go into phpMyAdmin and export any database you like to a dump file. This dump file will contain all the data in your database tables. Then on your other site you login to phpMyAdmin and create an empty database, when the new database is created simply click the Import tab at the top of the page to import your database dump file. Your database tables will be created and populated with your data. There are many tutorials for using MySQL with PHP, one such site is http://www.php-mysql-tutorial.com/ also techs you how to install the AMP stack manually on Windows. Quote Link to comment https://forums.phpfreaks.com/topic/99384-i-need-help-getting-my-sql-database-onto-my-apache-web-server/#findComment-508806 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.