Welcome to Dream.In.Code
Getting Help is Easy!

Join 132,602 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 945 people online right now. Registration is fast and FREE... Join Now!




Question about DBs for a website

 
Reply to this topicStart new topic

Question about DBs for a website

TrueDego
post 12 Jul, 2008 - 05:12 PM
Post #1


New D.I.C Head

*
Joined: 3 Nov, 2007
Posts: 10


My Contributions


Ok, I am currently making a webpage, but now I need some help. I know I need to make some databases to store all of my info and users info when I get up and moving. How would I do that? Does PHP handle that? I know sql would. I am completely clueless with this. I dont want to use Rails. I just want to make simple pages (think Craigslist) and start with something easy and if needed upgrade to a more advanced system. Can anyone help?
User is offlineProfile CardPM

Go to the top of the page

Addiction2Code
post 12 Jul, 2008 - 05:23 PM
Post #2


New D.I.C Head

*
Joined: 19 Dec, 2006
Posts: 39


My Contributions


I personally use php. Using php allows you to execute mysql inside your code. I would learn php and sql before attempting to make a db interactive site with users, I made may mistakes on my first few sites that were very hard to fix and could have been avoided if I knew what I was doing to begin with. You may use almost any other scripting language if your hosting provider supports it, but php is the most widely used language for this sort of thing.
User is offlineProfile CardPM

Go to the top of the page

TrueDego
post 12 Jul, 2008 - 05:28 PM
Post #3


New D.I.C Head

*
Joined: 3 Nov, 2007
Posts: 10


My Contributions


QUOTE(Addiction2Code @ 12 Jul, 2008 - 06:23 PM) *

I personally use php. Using php allows you to execute mysql inside your code. I would learn php and sql before attempting to make a db interactive site with users, I made may mistakes on my first few sites that were very hard to fix and could have been avoided if I knew what I was doing to begin with. You may use almost any other scripting language if your hosting provider supports it, but php is the most widely used language for this sort of thing.


So how hard is PHP and SQL to learn? Is it a large learning curve or is it relatively easy to learn? Also, do you have any good books or free sights that I can use to lean them?
User is offlineProfile CardPM

Go to the top of the page

Martyr2
post 12 Jul, 2008 - 05:40 PM
Post #4


Programming Theoretician

Group Icon
Joined: 18 Apr, 2007
Posts: 5,062



Thanked 175 times

Expert In: C/C++, Java, VB, VB.NET, C#, PHP, Web Development, HTML & CSS, Javascript

My Contributions


The learning curve is not too bad. The idea is that you install database software on a server machine. Or you get a webhost that has a database for you to use (most host providers have a database like mysql). Then using PHP you can login to the database, fetch data and display it on the page. Here are some links to help you get familiar with PHP and mysql for your sql code...

PHP Tutorial Introduction - HTML Goodies

PHP Manual - Must read and great reference!

MySQL functions in PHP - PHP.NET

So the idea is that your user requests a page from the web server, the web server executes some PHP code which logs into the database, queries it for information, the database returns the information to PHP, PHP manipulates it and puts it on a page, then gives it back to the user in the form of a HTML page.

If you go to the bookstore you can find books that often link PHP and MySQL together into one book. Find one for beginners and you are ready to rock and roll.

One great book I like for beginners of PHP is the "PHP: Your Visual Blueprint for Creating Open Source Server-side content"

PHP: Your Visual Blueprint book - Amazon.com

It is a simple book and will get you started with PHP including setting up your own server (or it might be easier for you to just get a PHP web host... then are thousands out there on the web).

Hope this all helps and good luck. If you have any questions as you learn, be sure to ask us here on Dream In Code in the PHP forum and we can certainly help explain things to you.

smile.gif
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/23/08 02:10AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month