Hi guys,

 

I have basic website knowledge but nothing more so I'm a bit of a noob but what I'm trying to do is include a database within my website. I have the database ready in Excel (rather large 6000+ observations) and would like to add it to my website so not only is it displayed in an attractive manner but so the data can be sorted by clicking on each category switching from ascending to descending with each click.

 

Furthermore, I'm also trying to create another section where when a user clicks on a particular result there is a page dedicated to that observation, where the data is obviously more clear and has a picture of the observation next to it. I'm guessing that requires some kind of template interface?

 

I don't know how hard or easy this is to do because as I said I'm a bit of a rookie but any help would be much appreciated

 

This is the exact kind of thing I'm looking to do http://www.futwiz.co...=&min9=&traits=

 

Cheers,

Paul

I don't think getting your Excel file to an online database is hard.

Try googling it. ( I assumed you would use mySQL because that's one of the most popular database systems )

 

Getting the data on your site in a nice table is not really complicated.

Although you will need a good understanding of PHP or another server-side language,HTML,CSS and maybe some Javascript ...

 

Léon

Edited October 25, 201213 yr by Leonvv

Thanks for the reply Leon. I've got my excel database in CSV format onto phpMyAdmin but don't know where to go from there to get it displayed on the website. Also looking into the option of getting an Access database, along with forms, onto it if can't do the previous. It's at this point I realise I sound a complete rookie but even a website explaining it or the correct terminology to search for it would be great!

Thanks for the reply Leon. I've got my excel database in CSV format onto phpMyAdmin but don't know where to go from there to get it displayed on the website. Also looking into the option of getting an Access database, along with forms, onto it if can't do the previous. It's at this point I realise I sound a complete rookie but even a website explaining it or the correct terminology to search for it would be great!

 

Did you ever considered hiring somebody to do it for you ?

You have to learn PHP + mySQL,

and it will cost you weeks to learn enough to achieve what you want.

 

Léon

I've done CSV to MySQL before, it wasn't difficult, just fiddly.

 

You are indeed undertaking quite a large task for someone who doesn't know much about it.

 

Do you already have the 'observations' linked with a category? Like in the excel sheet, on the same row as the observation is there a category?

Wait are you saying people can rent your portfolio and pass it off as their own

For what you are trying to do you will need a decent understanding of both PHP and MYSQL for the database queries etc. For the design youll need basic HTML with CSS. So if you have those you are good to start with whatever you want to make. On a plus note learning, Javascript and Ajax is a great way to call those "Information calls on each link" without reloading your site. But its not needed for what your trying to make!

 

So if your a complete begginer start with the four basic ones: HTML, CSS, PHP and MySql

 

On a side note as a fellow forum lurker stated above, might be a lot easier for you to hire someone for your project than to actually start learning on the different types of code, unless of course if your making these projects to learn web programming.

 

 

Unless you already have one, you will also need a host that supports PHP and Databases.

Edited November 2, 201213 yr by Veler