Database / PHP script help - GoFuckYourself.com

thatgirljudy · 03-01-2009, 03:17 PM

I've been making websites for 14 years and can edit a script like nobody's business. But I've never built one from the bottom up. I want to try learning and so I picked up a couple of teach yourself books but they are too advanced and a big part of each books deals with setting up a server, something I don't understand and don't need to understand because my host already has one.

I just want to learn the basics to start...basically I'd like to know how to create a simple database with categories and subcategories (I don't know the proper terms to use but for instance say I was doing a database of flowers and one flower category was rose, and another daffodil, then I also want there to be subcategories inside each like color, height, etc). And I want to know how to write the php/html that will pull the information out that I want.

Can anyone recommend a book or a website that has tutorials that can get me started? I know so much about editing the code that once I have this very basic start I should have no problem getting into the more complicated stuff. Right now I just don't understand how to set the database up.

Thanks.

Darkhorse · 03-01-2009, 07:26 PM

Have you looked around on www.hotscripts.com they have loads of tutorials and a decent forum there.

thatgirljudy · 03-01-2009, 08:26 PM

Quote:

Originally Posted by Darkhorse

Have you looked around on www.hotscripts.com they have loads of tutorials and a decent forum there.

I honestly didn't know they had anything other than just scripts. That's where I get all my scripts from but I've never poked around lol *blush*

Thanks!

chelis · 03-02-2009, 12:23 PM

Find the appserv project, look for it in any search engine. It's a package that automatically installs on your computer the apache server, the MySQL server and the phpMyAdmin with which you can create and manage databases very easily.

You don't need to have extense background, just the ABCs to create simple DBs.

Learn a little about the SQL Language, then if you know some php already, you're set.

Darkhorse · 03-02-2009, 10:54 PM

Quote:

Originally Posted by thatgirljudy

I honestly didn't know they had anything other than just scripts. That's where I get all my scripts from but I've never poked around lol *blush*

Thanks!

Ya i get lot of stuff from there to, I hate there new design/layout to confusing for me these days lol...

If your ever bored hit me on ICQ.

brandonstills · 03-03-2009, 11:48 AM

Have you checked out lynda.com? They have online video tutorials that are quite in depth and lengthy.

http://www.lynda.com/home/ViewCourses.aspx?lpk0=99

They are geared more towards the novice.

Zorgman · 03-05-2009, 04:51 AM

www.sitepoint.com has tons of tutorials online + books. Check Kevin Yank's books. I purchased his books back in 2000 and I learnt alot from it. Also try and download free script, rip them apart and put them back together, it's a learning process like anything.

Sands · 03-05-2009, 06:02 PM

Quote:

Originally Posted by thatgirljudy

I've been making websites for 14 years and can edit a script like nobody's business. But I've never built one from the bottom up. I want to try learning and so I picked up a couple of teach yourself books but they are too advanced and a big part of each books deals with setting up a server, something I don't understand and don't need to understand because my host already has one.

I just want to learn the basics to start...basically I'd like to know how to create a simple database with categories and subcategories (I don't know the proper terms to use but for instance say I was doing a database of flowers and one flower category was rose, and another daffodil, then I also want there to be subcategories inside each like color, height, etc). And I want to know how to write the php/html that will pull the information out that I want.

Can anyone recommend a book or a website that has tutorials that can get me started? I know so much about editing the code that once I have this very basic start I should have no problem getting into the more complicated stuff. Right now I just don't understand how to set the database up.

Thanks.

Hi Judy. First, I'd recommend that you download and install WAMPServer if you run Windows as your operating system. This will allow you to easily set up and maintain Apache, MySQL, and PHP locally. From then on, Google will be your best friend. Personally, I learned by setting a goal such as "I want to make a script that does..." and then I'd proceed to research the design patterns, functions, and whatever else was required to do so until I had a script that mirrored my original goals.

Good luck, and let us know if you need any help!

Glenn · 03-06-2009, 02:51 PM

Take a look at w3schools.com thaey got everything

zenman · 03-08-2009, 09:56 PM

Try to familiarize yourself with database normalization.

03-01-2009, 03:17 PM	#1
thatgirljudy Registered User Join Date: Feb 2009 Location: mtl Posts: 54	Database / PHP script help I've been making websites for 14 years and can edit a script like nobody's business. But I've never built one from the bottom up. I want to try learning and so I picked up a couple of teach yourself books but they are too advanced and a big part of each books deals with setting up a server, something I don't understand and don't need to understand because my host already has one. I just want to learn the basics to start...basically I'd like to know how to create a simple database with categories and subcategories (I don't know the proper terms to use but for instance say I was doing a database of flowers and one flower category was rose, and another daffodil, then I also want there to be subcategories inside each like color, height, etc). And I want to know how to write the php/html that will pull the information out that I want. Can anyone recommend a book or a website that has tutorials that can get me started? I know so much about editing the code that once I have this very basic start I should have no problem getting into the more complicated stuff. Right now I just don't understand how to set the database up. Thanks. __________________ icq 436-122-610 judy @ thatgirljudy com

03-02-2009, 12:23 PM	#4
chelis Confirmed User Industry Role: Join Date: Jan 2006 Location: Montevideo Posts: 620	Find the appserv project, look for it in any search engine. It's a package that automatically installs on your computer the apache server, the MySQL server and the phpMyAdmin with which you can create and manage databases very easily. You don't need to have extense background, just the ABCs to create simple DBs. Learn a little about the SQL Language, then if you know some php already, you're set. Last edited by chelis; 03-02-2009 at 12:25 PM..

03-03-2009, 11:48 AM	#6
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	Have you checked out lynda.com? They have online video tutorials that are quite in depth and lengthy. http://www.lynda.com/home/ViewCourses.aspx?lpk0=99 They are geared more towards the novice. __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

03-05-2009, 04:51 AM	#7
Zorgman Confirmed User Join Date: Aug 2002 Location: Sydney, Australia Posts: 6,103	www.sitepoint.com has tons of tutorials online + books. Check Kevin Yank's books. I purchased his books back in 2000 and I learnt alot from it. Also try and download free script, rip them apart and put them back together, it's a learning process like anything. __________________ ---

03-01-2009, 07:26 PM	#2
Darkhorse Horsing Around Industry Role: Join Date: Sep 2002 Location: AU Posts: 5,877	Have you looked around on www.hotscripts.com they have loads of tutorials and a decent forum there.

03-06-2009, 02:51 PM	#9
Glenn Registered User Industry Role: Join Date: Jan 2008 Posts: 12	Take a look at w3schools.com thaey got everything

03-08-2009, 09:56 PM	#10
zenman Registered User Join Date: Dec 2003 Posts: 5	Try to familiarize yourself with database normalization.