Databases???

[spikus1969]

can someone out there help i need to put a database on my website,i dont know where to start can anyone give me some good programs to use to start my database

 

[blouis]

i use MySQL to make my databases. Are you running linux or windows? What kind of database are you wanting?

 

[spikus1969]

windows

i am using windows xp mate,the kind of database i need is hard to explain but what i need is one where somebody put there bike in the search box and then all items i sell show with there price

 

[adam_uk]

Re: windows

Originally posted by spikus1969
i am using windows xp mate,the kind of database i need is hard to explain but what i need is one where somebody put there bike in the search box and then all items i sell show with there price

he meant what operating system are you using on the server

u would need some kind of server side coding to query the database (asp,php etc) check ur host to make sure u have some kind of database as well (mysql, mssql, access even)

u will need these on ur host before u can do anything

 

[blouis]

So you want the database to take there string ( what kind of bike they have) and find a query of parts available for that particular bike?

 

[spikus1969]

database

yes if you look on other sites you will see what i mean

 

[adam_uk]

ok so lemme get this straight

say i entered bmx into a text box

the web page would then search the database for the term bmx and generate a page with the results related to bmx?

if so like i said earlier see what database/sss your host supports

 

[gwx]

Using dreamweaver's advanced server behavior feature, making database-driven professional sites has never been easier.

Dreamweaver's server behaviors enable you to add records, delete records, create recordsets, enable searching and much more without knowing a single bit about the structured query language ( SQL ).

Dreamweaver's inituitive interface would mean that even the newest in web design are able to effectively deliver content-driven webpages in no time.

Dreamweaver MX 2004 is YOUR answer to YOUR database problems. It supports all server scripting language and most database types. The server scripting languages include ColdFusion, PHP, ASP VB Script, ASP JScript. The databases supported range from Access, to Oracle SQL to MySQL.

Your operating system, Windows XP, enables you to set up Microsoft's extremely buggy IIS server, which processes ASP code. Although it is not recommended for mission critical use, it is recommended for noobs and dummies from all different backgrounds, with close to zero database experience.

If, however, you choose the PHP/MySQL combination, you are put into a world of unlimited possiblities; a world of open source; a world where users collaborate and help each other when problems arise; a world which is free of Microsoft and Oracle.

PHP/MySQL is the way to go.. Make the right choice and you'll never regret it. I would suggest you go with the PHP/MySQL database/scripting combo and utilise to the max dreamweaver's server behaviors. ( available in MX, UltraDev and MX 2004 ).

All the best to your future endeavours. Adios. Au revoir.

 

[spikus1969]

YES THATS CORRECT BUT I AM NEW TO THIS AND DONT KNOW WHERE TO START ALL THE DATA IS IN AN EXCEL FILE WITH THE MODEL OF BIKE AND THE PART THAT FITS

 

[Robvilla]

You may want to consider hiring someone to do that kind of work. Otherwise, you really have your work cut out for you.

You'll have to learn how to do server sided scripting. It'll have to be a language that your host supports, or you'll have to find a new host that supports the language you perfer. Common ones are PHP and ASP.

Then you've got to know how to work with databases using SQL and make sure your host allows access to one, there's several different types of those too, but PHP and MySQL go together like peanut butter and jelly, and many hosts have those.

Then you've got to get your spreadsheet data over to the database, perhaps there's an easy automated way to do that. Although if it's small enough you may want to consider hand re-entering the data, first making a relational database with different tables relating to one another in order to optimize and improve your queries.

And finally you've got to create the actual script that handles the search requests.

Hiring a professional who knows how to do it might in the long run make more sense then spending weeks (or even months if you have no prior scripting experience) learning this stuff.

 

[bobbi]

if you would like to learn how to make databases with mysql and you don't have the apache web server on your computer already, then go to this link, which is one of the tutorials on the forum and follow it to download apache, php, perl, and mysql on to your computer:

http://www.webdesigntalk.net/showthread.php?s=&threadid=342

after you do the first tutorial, if you click on the link below:

http://www.webdesigntalk.net/showthread.php?s=&threadid=1068

this tutorial is a beginners look into mysql and it also talks about how to create a database using MySql. I actually did this tutorial myself and it's very easy to understand. Yes this may seem like a lot of work, but in learning there is no easy way but to jump in an try it. I hope that this helps you out.

 

[CatsEyeDesigns]

don't want to discourage you, but...

If you want to publish a good looking, database driven website, and you don't know where to start, you need to hire a professional.

I really don't want you to get discouraged, but people spend years studying this stuff in college or on their own. Most professional looking, large websites were built by at least one developer who has read thousands of pages on graphic design, web design theory, web design software, database design, database programming, etc.

I could write 3 or 4 books on web design and programming if I were to actually write all the things I've learned over the years.

On the other hand, if you choose to do it yourself, expect development time to be a year minimum, and enjoy the learning. That's what I did. Doing it yourself can be very rewarding. It just takes time.