Learning PHP And MySQL

Nairaland Forum | Technology | Programming | Learning PHP And MySQL

Pages: (1)

Author

Topic: Learning PHP And MySQL (Read 690 views)

gbengaijot (m)

Learning PHP And MySQL

« on: January 19, 2006, 02:52 PM »

Hi guys, here i come with my wahala again. I just got a php/mysql for dummies book. i still don't understand some bits and pieces of it. it tells me to install apache webserver, sql and php. They are perfectly okay and all running. it saiz i have to configure the httpconf file which i did perfectly well. Where do i go from here?, do i need a already made website to be able to design a members only database?.does anyone have a starter tips for me?. please post them on here.

Seun (m)

Re: Learning PHP And MySQL

« #1 on: January 19, 2006, 07:55 PM »

What's your goal. You don't seem to have mentioned that!

gbengaijot (m)

Re: Learning PHP And MySQL

« #2 on: January 19, 2006, 10:46 PM »

My plan is to design a online internet music station(something like duduradio or radio palmwine). My main aim is a bit different from theirs really. I want the site to be more of like a place where young and upcoming artist who has a demo or a particular track can upload their work and they get a personal webpage where they can introduce themselves and their bands, where they've performed, e.t.c.

I havent bought a webspace yet, and the website design is in a formative stage. as i am using fireworks to desing its background and features at the moment.

@seun, layi( i crave your knowledge) and all other developers on nairaland can u please put me through. its only a pet project and nothing serious as i want to enhance my knowldege with examples of things have done, and i am doing it for a RCCG nxgn project.

oasis

Re: Learning PHP And MySQL

« #3 on: January 20, 2006, 01:17 AM »

Your first project is not trivial. You need something simpler to learn with.

If you still want to press forward with creating a music site, look at
http://www.ampache.org/

I've personally installed it, and it works great. You would have to install it yourself though, which is a part of the learning process. The installation involves creating database tables, creating users, and setting server-specific parameters. Your httpd.conf would also need modifying.

Let's know how it goes.

Ampache is not the only open source php music program, but I haven't used any other myself. Maybe somebody else can suggest others.

If you run into a stumbling block, http://www.ampache.org/forums/

Here is something I created with SMIL

http://www.rentvegas.net/real/

By the way, SMIL is another markup language like HTML. It's worth learning if you're into web multimedia stuff.

sbucareer (f)

Re: Learning PHP And MySQL

« #4 on: January 20, 2006, 03:18 AM »

My personal advice is to learn how to install apache server, php and mysql on your personal computer. Either Unix or Window or even Mac OS. If you can learn to do this believe me your battle is half won.

Install apache and configure it to work with php and here is php website
Download mysql, install and configure it. Here is a good tutorial for mysql

Finally, here is a little php and mysql tutorial:

1. PHP Tutorial
2. MYSQL Tutorial

For project, I will assume the above tasks is difficult at least for you level now. I would suggest learning as much as you can from the php and my sql links above and when you are more confident you can try this. Create a table in mysql called family, location and school.

Family attributes

family

firstname
lastname
age
height
sex
dob (date of birth)

location

country
state
zip code
phone

school
name
address
principal

Then normalise the table to at least 2nd normal form. If you are brave you can try 3rd normal form. And relate the tables, i.e. primary key and foreign keys.

Write a small HTML/PHP to access this database and provide information i.e.

I want to know Paul school and his location now? There are so many question you can ask this database. You can provide the question for us by putting HTML link, upon click would reveal the answer.

Need A Co-developer Programming A Converter For *.wma To *.mp3 - By Sbucareer Learning Visual Basic Page 2

Pages: (1)