Database driven site

RobertFoster

hi,

I'm looking for a tutorial/book that'd help me get a database-driven site up and going. Something simple with the ability to add, edit and delete content through forms (a simple user interface). I'm pretty OK with PHP and I'm fine with HTML but I've very little experience of mySQL (or tieing PHP and mySQL together)

Does anybody know a good online tutorial for this, or perhaps a book you found useful?

Thanks.

damnyanks

Well if you arent able to do it in any language I would reccomend Coldfusion simply because of the easy learning curve. If you wanted to get a bit advanced look into Asp.Net . It is the newest thing its quite good (Better if you have Visual Studio.Net :rolleyes:)


If you want a free mathod of learning use the internet of course Check out www.hotscripts.com download some basic scripts and try to figure out whats going on.

Check with google as well for tutorials in whatever language you do decide to go with.

www.amazon.com browse through the books there , any decent book will have chapters devoted to making database scripts etc.

RobertFoster

Thanks. I'd be looking for the free internet tutorials as I don't make money off my sites, so therefore i don't have any

JJSolutions

I found http://www.w3schools.com usefull it explains all the asp objects and it now has asp.net. It also hs tutorials for most elements of web development

b3t4

Best laid out php manual I've seen yet......

Go here
http://www.php.net/manual/en/

Then go here for all the functions available for mySQL.
http://www.php.net/manual/en/ref.mysql.php

Then buy "PHP in easy steps". Explains the whole tying together of PHP and MySQL very well. Costs around €15.

Hope that helps,
A.

Eurorunner

pm sent

decob

Originally posted by RobertFoster
hi,

I'm looking for a tutorial/book that'd help me get a database-driven site up and going. Something simple with the ability to add, edit and delete content through forms (a simple user interface). I'm pretty OK with PHP and I'm fine with HTML but I've very little experience of mySQL (or tieing PHP and mySQL together)

Does anybody know a good online tutorial for this, or perhaps a book you found useful?

Thanks.

the best book i've found for php/mysql was:
Build Your Own Database Driven Website Using PHP & MySQL by kevin Yank.. tho i think you can only get it from there or amazon.com

in terms of sites, sitepoint.com is ok, devarticles.com is a very good resource site

damnyanks

I've been a member of sitepoint for a long time and there forums are quite good. However in the past 6 months or so the site has become very commercial. Its not like boards where they want a community it has now stepped up to a business site, perhaps that is something to remember when looking around

Webmonkey

Yep , i wud recommend php/mysql as u can get lots of free scripts

Figment

www.3dbuzz.com have some video tutorials on php/mysql available to download.
I havnt thried them but their ones on 3d max are excellent.

jesus_thats_gre

www.webthang.co.uk

jahras

http://hotwired.lycos.com/webmonkey/99/21/index2a.html

This is a good guide to how to use php and mysql together.
Just remember if you are using a recent version of PHP you will need to enable register globals or put in a line like $variable=$_POST before you can use each HTTP variable.

fizzy

i would *highly* recommend the book "php and mysql web development, 2nd ed" http://www.amazon.co.uk/exec/obidos/ASIN/067232525X/ref=sr_aps_books_1_2/202-1520824-8335818

there's lots of free stuff on the net too but i found that in the case of getting my head round database driven stuff that nothing came close to this book.

some books are references full of functions, others are baby step here's how you write a while loop books but every so often you find a book like this full of real world examples that you can get your teeth into and tweak. it explains everything very well and there is a thick portion of the book taking you through various case projects including a shopping cart and a content management system.

most books i can take or leave, but this one i love!

RobertFoster

thanks for your help everyone, I'll be sure to check out those sites and books.

Webmonkey

Originally posted by fizzy
i would *highly* recommend the book "php and mysql web development, 2nd ed" http://www.amazon.co.uk/exec/obidos/ASIN/067232525X/ref=sr_aps_books_1_2/202-1520824-8335818

there's lots of free stuff on the net too but i found that in the case of getting my head round database driven stuff that nothing came close to this book.

some books are references full of functions, others are baby step here's how you write a while loop books but every so often you find a book like this full of real world examples that you can get your teeth into and tweak. it explains everything very well and there is a thick portion of the book taking you through various case projects including a shopping cart and a content management system.

most books i can take or leave, but this one i love!

Great! i'm buying it - Really want my hands on this book. Sitepoint forums www.sitepoint.com - also a great resource

exiot

A great website is: PHP Freaks, they offer great tutorials on php & mysql. They run you through all the commands in the scripts, its a great way to learn the basics of the languages.