how can i create a database for a website?

I would like to create a website extacly like the followingL
http://www.williamnelhams.com/site/go/search?sales=true  i do not know alot for creating databases and only good with static sites. how can i deploy search feature, to be ablet to add properties etc , can i copy this site and make my own changes? thanks
brokenwindowAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

psimationCommented:
You won't be able to "copy" that site.
DB functionality, especially in PHP happens with serverside code and you will not see that in the resulting HTML in your browser.

What you are asking is not a simple "cut&paste" job.

If you don';t know how to
a) create a DB and tables
b) write the code to connect and query a DB's tables
c) write the code to display and handle other functions you require

Then you will need to do some reading, and lots of it.

You need a good understanding of PHP first and foremost, and then also some basics on working with mysql, and lastly you need to know some SQL ( the query language you use to "talk" to the DB to insert/retreive/edit/delete entries in a table)

Go here:

www.computer-books.us/php en download the PHP5 Power Programming e-book and follow those examples.

It may already be a bit too advanced for you - no malice intended in that coment.

I started learning PHP and MySQL on www.webmonkey.com - they used to have very nice examples of starting off with php and mysql.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jtdebeerCommented:
If you want to get a result without breaking bones and learning how to develop a website, I suggest using some content management systems like Joomla, DotNetNuke, Ekron, osCommerce or so.
0
brokenwindowAuthor Commented:
isnt there any wizard type database program. like before websites were created with pure html, then applications wrote it for you etc
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Cornelia YoderArtistCommented:
brokenwindow, you need to know how to program.  Then you need to know a programming language (such as PHP).  Then you need to know how to design a database and normalize it.  Then you need to know a database query language such as MySQL.  Then you need to know how to set up a webpage.  Then you need to know a webpage screen language such as HTML.  Then you need to know how to make them all work together.

This is what Computer Science majors learn in college.  There is no magic or wizard way to do this, it's a career.

If you want to take it seriously, then you can either take some programming courses, or learn on your own from some good books as suggested above.  But there is no magic way, sorry.
0
psimationCommented:
There are some "Wizards" , but it depends on your perception of a "Wizard"...

The majority of Wizards are there to make remedial programming tasks a bit more "easy", but you still need to know your language/code.

Dreamweaver, for instance, has some DB "tools" that create forms and db connections for you, Zend studio and other IDE's like PHPEd also offers some "shortcuts" and in the extreme, like jtdebeer mentioned, you could look at platforms such as Joomla etc, BUT, in all cases, functionality are limited, and in the case of Joomla, you are constrained with whatever the platform has built-in, or extensions available for the platform.

The moment you encounter something that is not available or meets your exact needs, you will be back here asking the same question in different words.
0
nanharbisonCommented:
The best book I have seen on this is the Sitepoint, Build Your Own Database Driven Website by Kevin Yank. You can probably download a chapter for free to see if you want to buy it.
If you are going to create websites, eventually you are going to have to learn stuff like this to make sites more interactive.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.