Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

Website Design Forum


You are currently viewing our Website Design Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
How do I add a database?
Old 04-17-2005, 12:01 PM How do I add a database?
Junior Talker

Posts: 3
Trades: 0
I currently am very comfortable with frontpage. We want to create a site that will allow readers to search a data base based on maybe 3-6 different criteria (give or take).

My preference would be to create the site myself, hiring someone more technical than me for writing the code for the data base & search. Is there a way to do that and tie it in with frontpage?

If not, what would be the best way to do this? Is dreamweaver something that would work better?

What would I look for in a programmer? What languages are necessary? Would I be able to maintain the database myself without knowing code?

Thanks!
gran is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 04-17-2005, 01:03 PM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,381
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Your choice of language will be determined more by your host and what they support rather than the programmer. Database maintenance could/should be something that can be written as an admin control panel, depending of course on what you needed to do as maintenance.
What to look for in a programmer? being one myself so therefore never hired one, It's a odd question to answer so I won't.

Personally speaking trying to integrate DB functions into a site designed in frontpage is the worst thing possible, with all the garbage code it churns out it takes longer to pick through it than it does to start from scratch and write clean code. DW isn't always much better depending on how it is set up.
The simplest way to achieve integration into another design (IMO) would be to have the code written as modules and reusable functions which you call onto the page wherever you need the data output.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 04-17-2005, 07:44 PM
Minaki's Avatar
Defies a Status

Posts: 1,626
Location: Guildford, UK
Trades: 0
You don't need to choose your programmer based on what your host supports. You can always switch hosts (unless of course you're tied into a contract)

If you're looking for a programmer, ask to see examples of their previous work and see if it's up to your standard. Also see how much they charge. Find a few and do some comparisons maybe.

Might be an idea to check out http://www.rentacoder.com/
__________________
Minaki Serinde MCP
"Wow, Linux is nearly on-par with Windows ME!"

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
Minaki is offline
Reply With Quote
View Public Profile Visit Minaki's homepage!
 
Old 04-17-2005, 10:50 PM
Junior Talker

Posts: 3
Trades: 0
Thanks Minaki for the info.

Thanks chrishirst. you mentioned: "Database maintenance could/should be something that can be written as an admin control panel, depending of course on what you needed to do as maintenance." I am unfamiliar with the term admin control panel." Could you explain that? As for the maintenance, we would continually need to add, delete and alter records.

The main reason I wish to integrate the database/search into frontpage is that I know how to use frontpage. Although I used to teach mainframe computer languages years ago, I do not want to have to learn a computer language. I also don't want to have to pay someone to create and maintain the web pages. I'm more of a graphic artist/marketing/writing person. I like to be able to create, alter and add to my websites as the businesses change. That's why I'm hoping it's possible for me to use frontpage or another user friendly program and just hire someone to do the code related to the database and search. Given all that, do you have any other thoughts?

Thanks!
gran is offline
Reply With Quote
View Public Profile
 
Old 04-18-2005, 03:27 AM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,381
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Minaki,
Granted switching hosts is always an option, However providing the host can provide server-side scripting and/or database facilities there should be no need to, and you would choose the language and programmer based on that.

gran,
An admin control panel would be a section of the site (say sitename.com/admin/ ) that would be password protected and give the administrator access to the functions that were required. These would be written by your programmer to allow you to do the everyday tasks without needing to get directly into the database.
Basically what you are looking at is a limited (to your needs) CMS (Content Management System). Any decent programmer should be capable of creating one and providing you with the code sections that you would include in your pages. The Google site search box (bottom of this page) is one example. You download a code snippet from Google and place it on your site.
The same can be done with your system, The programmer builds the backend code and provides you with page snippets such as an input and criteria selection form and a page that displays the output. You then integrate these into your site using includes
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 04-18-2005, 03:56 AM
Minaki's Avatar
Defies a Status

Posts: 1,626
Location: Guildford, UK
Trades: 0
Quote:
Granted switching hosts is always an option, However providing the host can provide server-side scripting and/or database facilities there should be no need to, and you would choose the language and programmer based on that.
Not if you had a prefered technology. If I was in that position and I found my host only supported PHP, I'd ditch it and switch to a host that supports ASP.NET. At work our current web server runs Linux/PHP. They didn't hire me cos I can work with PHP... I use ASP.NET.
__________________
Minaki Serinde MCP
"Wow, Linux is nearly on-par with Windows ME!"

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
Minaki is offline
Reply With Quote
View Public Profile Visit Minaki's homepage!
 
Old 04-18-2005, 05:02 AM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,381
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Agreed. I prefer to use ASP, never seem to get the time to learn .net, and PHP though I do use it, is really written by a committee and shows it in some of the function naming. Add to that you can never be sure until you start which version the host is running and unless you've been caught out before it's not always the first question you ask.
And there are often good reasons why they can't or won't change hosts/servers. dedicated servers, SSL Certs, existing technology etc.

The customer is always right
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 04-18-2005, 09:42 AM
Junior Talker

Posts: 3
Trades: 0
chrishirst - thanks for the clear explanation. One question. How is it put in? Is it a function on the top bar, is it html I would have to add...?
gran is offline
Reply With Quote
View Public Profile
 
Old 04-18-2005, 10:28 AM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,381
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
No idea how to insert includes with the FP WYSIWYG. Used it once for about 1/2 a day, got hacked off with it rewriting my code, never tried it since

But using includes in code is simple enough. Or of course you could copy and paste if its only a few pages.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to How do I add a database?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.29014 seconds with 12 queries