Results 1 to 2 of 2
Thread: Website + Database = <3?
Mar 19, 2012, 01:46 #1
- Join Date
- Feb 2012
- 0 Post(s)
- 0 Thread(s)
Website + Database = <3?
As I was minding my own business, practicing my newly-acquired HTML/CSS skills, I was asked about database integration into a website. Now this put a dent on my newly-minted skills and got me confused.
1. How do you choose a web-host for your website and database needs? Is simple website + simple database = SIMPLE?
2. Is signing up for Wordpress.com more appropriate for such simple needs? But what if one just needs a one page with the website but the rest are for the database, do you still need Wordpress.com?
3. What if you just need an online database?No other pages really....what do you use?
I'm confused. I feel like I've just ask what to do when starting in web design all over again.
*newly-minted is now brutally-bruised...gah!
Mar 19, 2012, 11:38 #2
- Join Date
- Feb 2005
- Burlington, Canada
- 89 Post(s)
- 2 Thread(s)
Steps might be
- Find host that has your script and database environment working, let's say PHP and MySQL. You want to understand what data limits you may have as some hosting packages can be quite restrictive in the amount of data and the number of databases that you are allowed in your hosting package.
- Install a LAMP or WAMP stack on your local computer that will simulate the environment on your host. This way you can code and test locally.
- Design or Import your database into you WAMP/LAMP MySQL database.
- Use PHP to make a connection to your database, for this you can use MSQLi or PDO as a driver/layer for your database connection and queries.
- Integrate your php page (that has the database queries in it) into a my_page.php and start dressing it up using markup and CSS.
- When complete upload your my_page.php to your web host and you have to export your database (at least the structure, you may not want the test data) and then import it into your web hosts database. Typically your web host will have a control panel that includes PHPMyAdmin for doing this. So you would export you Db using PHPMyAdmin in your WAMP/LAMP stack and then import it using PHPMyAdmin on your host.