CSS site with backend ASP database

Gilbretto

Gilbretto

Gilbretto

Associate
Joined
24 Nov 2007
Posts
888
Location
Leeds
Hello, I have been given a task, and i have no idea how to complete it so i am running here for some quality advice.

I have to build a website to incorporate the following:

• An ASP backend database
• CSS formatted pages
• On demand streamed video clips

I really have no idea where to start?

Any chance of some helpful advice?

I have built a few websites before using Dreamweaver, and i have basic HTML skills. I have never used CSS before but i understand the basic principles but not how to impliment it to a web page (coding ect..), but ASP is a foreign language to me - know nothing.

Any idea's on where, how to start this?

EDIT;

Ok, I've knocked up a very basic, rough design. So i think i want a neat & polished version of something like this;

WebsiteIdea.png


I need the search (filter) options to lead to works of art by narrowing down options. Artist, size, method ect... Or the choice of selecting to view all. All the images of paintings will be in the database, and using the search options, will narrow down what is displayed on the results page. If that makes sense?

Problem is i have no idea how to achieve this. :s

Any tips would be great.

Thanks again.
 
Last edited:
wush said:
Is this for work? How much time do you have?!
Click to expand...

I have untill the 30th. It's a favour to my Dad as well as a possible uni project (depending on how it goes). Luckily i'm a fast learner, so when i get the hang of it it should be no problem. (fingers crossed.)
 
Last edited:
Classic ASP is very old now, so I would recommend ASP.NET.

ASP itself isn't a database - it's a server-side scripting language. It can interact with a number of different database technologies, the most popular being MS SQL and Access, but it can also easily connect to MySQL too. If you're wanting to get something up and running quickly, I would take a look at using an Access database. That said, Access does not scale well at all and performance can leave a lot to be desired on a larger system.

If you're flexible, it may be an idea to look at using PHP and MySQL instead. Which are very powerful, scalable technologies from the start - and they're free to use and get started with.
 
Is this for work or a uni project?

What you have to-do is no simple task especially if you only have basic html skills :S
 
I don't think there's anything wrong with learning classic ASP first if you're new to it. It's easier than ASP.net in my opinion.

I would start by looking up the RecordSet object (often referred to in code as ObjRS) and learn how to open and close database connections (scan code for ObjConn references).

In the real-world you would always use MSSQL for your database, but if this is for a project you might be able to get away with using MS Access, which would be easier but has drawbacks for real world use.

Rgds
 
adamph said:
Is this for work or a uni project?

What you have to-do is no simple task especially if you only have basic html skills :S
Click to expand...

This is for my dads business, but i may well be using it as part of a uni project if it is any good.

I work with computers all day every day, especially adobe Fireworks, Illustrator, Premier and had a fair bit of use with Dreamweaver. Although using Dreamweaver doesn't make me an expert in html. I could build a website using Dreamweaver without any problems. But scripting in html in notepad, i would struggle somewhat. If you see what i mean?

Anyway, i more than capable of using & learning when it comes to things like this.

Just need to be pointed in the right direction and i am usually ok.

Thanks to all for the help so far, i'm sure i will be back asking for more tips advice.

Cheers,

Gil.
 
radderfire said:
I would recommend PHP over ASP/ASP.net, there is a lot more help and free scripts available online.

Rgds
Click to expand...

this, I am probably the worst on the HTML forums in terms of skill but still code PHP reasonably well

I find that PHP is fast becoming much easier than any other kind of language

I would seriously consider PHP for

• An ASP backend database
• CSS formatted pages
• On demand streamed video clips
 
Interesting thread.

Don't want to "hijack" it from the OP of course, but I have a possible client that I've been speaking with recently who going by his description of what he wants to achieve with his website, is looking for something very similar.
 
The other thing with PHP is that there are sites where you can outsource the project and get the thing done by crack Czech or Russian coders at minimal cost :cool:. The hard part with this is finding the really good coders, and avoiding the ones that are going to take your money and do a rubbish job of it :rolleyes:. However, it can be done, but it's finding the right people that's the hard bit.

PM me if you want a link to some of the outsourcing sites I'm referring to.

Rgds
 
radderfire said:
The other thing with PHP is that there are sites where you can outsource the project and get the thing done by crack Czech or Russian coders at minimal cost :cool:. The hard part with this is finding the really good coders, and avoiding the ones that are going to take your money and do a rubbish job of it :rolleyes:. However, it can be done, but it's finding the right people that's the hard bit.

PM me if you want a link to some of the outsourcing sites I'm referring to.

Rgds
Click to expand...

Thanks, but i really am keen to learn how to do this myself.

Draeger said:
Interesting thread.

Don't want to "hijack" it from the OP of course, but I have a possible client that I've been speaking with recently who going by his description of what he wants to achieve with his website, is looking for something very similar.
Click to expand...

Feel free to tag along and ask any questions. I'm happy to share this thread with anyone.

I will be jumping head first into this project in a few days time.

php sounds like the way forward, using a MSSQL database. Does that sound sensible to everyone?

Can CSS be implimented if i use php?

Please excuse my ignorance.

And thanks again to all for the help and advice so far.
 
radderfire said:
I would recommend PHP over ASP/ASP.net, there is a lot more help and free scripts available online.

Rgds
Click to expand...

In all honesty, what he needs to achieve could be done using the two links posted previously. Definately go with a mssql or mysql database though, access is just a pain the ass tbh :)
 
Gilbretto said:
Thanks, but i really am keen to learn how to do this myself.



Feel free to tag along and ask any questions. I'm happy to share this thread with anyone.

I will be jumping head first into this project in a few days time.

php sounds like the way forward, using a MSSQL database. Does that sound sensible to everyone?

Can CSS be implimented if i use php?

Please excuse my ignorance.

And thanks again to all for the help and advice so far.
Click to expand...

css can be used whatever language you use. Just look up how to insert, edit delete and select data from a database and it'll be fairly intuitive thereafter. If you're using classic asp be aware of security issues, as unlike PHP it doesnt really have built in functions to clean input (although someone posted a pretty good custom function for asp on here a while back).
 
Gilbretto said:
Thanks, but i really am keen to learn how to do this myself.
php sounds like the way forward, using a MSSQL database. Does that sound sensible to everyone?

Can CSS be implimented if i use php?
Click to expand...

You really want to be using MySQL with PHP - it's free and does an excellent job. There are also free tools like MySQL Query Browser and phpMyAdmin.

Yes, you can use PHP with CSS.

First of all, I would find some decent UK linux hosting for hosting a small site with a MySQL database. FYI I use Clook.net who are a little on the expensive side but are very clued up.

Then I would head over to phpfreaks.com and join the forums to ask for help and take a look at some PHP Tutorials.

Rgds
 
asp.net is also free. Visual studio express (free IDE) and SQL server 2008 express (free DB).

http://www.microsoft.com/Express/

I have coded in ASP, ASP.NET, and PHP. any will get the job done. I would argue that it really doesnt matter what language you use as there is plenty of help out there for any route you choose.

I would however say learning a programming language, SQL and CSS in less than 15 days is pretty difficult task.
 
You must log in or register to reply here.
Back
Top Bottom