yarek37 Posted November 23, 2014 Share Posted November 23, 2014 I want to create a website with basically a table of information in it and I'm not sure how to. I would like it to look like the yclist. I'm quite a newbie but I want to learn to do it myself. So I have this huge list of information, kind of a directory, with name, website, city and country as the info for each line and I have it in Access and Excel. I more or less understand how to create a basic table website with tr and td... but my list is 5000 items long. I'm sure there must be a way to gather that information and directly show it on the website without having to go one by one. If someone could be nice enough to tell me if it's better with Ajax or Mysql or any help at all... That's it for now... thanks! Link to comment Share on other sites More sharing options...
niche Posted November 23, 2014 Share Posted November 23, 2014 The short answer is simple copy the page source. Edit to taste. Voila! Instant clone. The longer answer is learn how to code so you can make those edits. starting with a html tutorial like: http://www.w3schools.com/html/default.asp Link to comment Share on other sites More sharing options...
Ingolme Posted November 23, 2014 Share Posted November 23, 2014 This is probably done with a database. But HTML and CSS are obviously used to display the data. Learn HTML here: http://www.w3schools.com/html/default.asp Learn CSS: http://www.w3schools.com/css/default.asp SQL is used to manage databases, while PHP is usually used as an interface between the user and the database. SQL: http://www.w3schools.com/sql/default.asp PHP: http://www.w3schools.com/php/default.asp Link to comment Share on other sites More sharing options...
yarek37 Posted November 24, 2014 Author Share Posted November 24, 2014 Thanks! Just to be sure, HTML is for the displayed information and CSS is for the style right? And as for the database, I've been looking into it a little bit since yesterday and I see that the website I linked is using AJAX. Looking into the tutorials I see both AJAX and SQL quite similar. What is the difference, or which one is easier? Link to comment Share on other sites More sharing options...
Ingolme Posted November 24, 2014 Share Posted November 24, 2014 HTML is what you use to show content, while CSS is used to change its appearance. AJAX and SQL are unrelated. AJAX is a Javascript API that lets you request data from a server without reloading the page. SQL is a language used to query databases. Some people use AJAX to ask the server to perform a query using SQL. The server needs a programming language to respond to the AJAX request and use SQL to query the database. Usually people use PHP for that, but there are other languages. None of this is easy to learn. It takes time and dedication. Link to comment Share on other sites More sharing options...
yarek37 Posted November 24, 2014 Author Share Posted November 24, 2014 It's a little bit confusing for me, but I'll give it a try... How can I convert my Excel or Access file into a SQL? Link to comment Share on other sites More sharing options...
yarek37 Posted November 24, 2014 Author Share Posted November 24, 2014 What is the difference between requesting a database from SQL and writing the table directly in html? Link to comment Share on other sites More sharing options...
Ingolme Posted November 24, 2014 Share Posted November 24, 2014 When you store content in a real database you can show a limited amount of records that match a certain search criteria, change the order of them and easily add and remove them. Link to comment Share on other sites More sharing options...
yarek37 Posted November 24, 2014 Author Share Posted November 24, 2014 Thanks Ingolme, you are helping me a lot. Link to comment Share on other sites More sharing options...
niche Posted November 24, 2014 Share Posted November 24, 2014 RE: post #6, load data: http://dev.mysql.com/doc/refman/5.0/en/load-data.html Link to comment Share on other sites More sharing options...
yarek37 Posted November 25, 2014 Author Share Posted November 25, 2014 Thanks Niche... it looks a little bit too difficult though. Link to comment Share on other sites More sharing options...
niche Posted November 25, 2014 Share Posted November 25, 2014 It easy. Here's an example that makes it as easy as it can be:http://stackoverflow.com/questions/13579810/how-to-import-data-from-text-file-to-mysql-database Link to comment Share on other sites More sharing options...
yarek37 Posted November 27, 2014 Author Share Posted November 27, 2014 It's still too complicated for me... maybe in the future. But I managed well so far with html, css and javascript. I found a program that turns my data information into an html table. My doubt now is what would be the advantage of having the table with sql/php instead of directly type the info in html... Link to comment Share on other sites More sharing options...
Jonathanks Posted November 28, 2014 Share Posted November 28, 2014 Having your table data with sql and php reduces your workload. You enter it once and you can retrieve it easily at anytime from any page. You can manipulate it easily too. Just MHO. Let the gurus speak. Link to comment Share on other sites More sharing options...
yarek37 Posted November 28, 2014 Author Share Posted November 28, 2014 Ok, I guess in my case (it's a one page website) it's not all that important but I see the point. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now