The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

2 Pages V  1 2 >  
Reply to this topicStart new topic
> Database files on the net
hunsnowy
post Aug 12 2010, 02:58 AM
Post #1


Novice
**

Group: Members
Posts: 21
Joined: 7-August 10
Member No.: 12,451



Hi there Everyone! There are many sites, which have things like "today is XXX's birthday", or "today happened in history: XXX".

If we presume that this is done by php and MySQL, I was wondering where do they get the mysql database files from. Is there a site where these sort of database file can be downloaded? How should I search for it/them?

Thank you in advance
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Aug 12 2010, 10:42 AM
Post #2


🌟Computer says no🌟
********

Group: WDG Moderators
Posts: 20,716
Joined: 9-August 06
Member No.: 6



MySQL itself must be provided by your host. What you should look for is rather scripts that enter this kind of data in the database and and provide a way to display it on your page. Maybe you can't find exactly what you want, but maybe something that you could make minor changes to.

I saw at least one birthday script here, I don't know if it's any good and you would have to find and enter a list of birthdays yourself.
http://www.hotscripts.com/category/php/scr...rams/date-time/
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
hunsnowy
post Aug 12 2010, 01:16 PM
Post #3


Novice
**

Group: Members
Posts: 21
Joined: 7-August 10
Member No.: 12,451



My baaad... I was not understandable, sorry! smile.gif I did not mean the scripts nor the mysql queries.

I ment the database file itself. The file which contains data. Table or whatever. Because I do not know who was born, when, so I would need a table where one column displays the date of birth and the other the name of the famous person. And the rows contain the persons.
I mean is there such a place on the net where I can find data tables about famous dates, birthdays or something like that.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Darin McGrew
post Aug 12 2010, 01:43 PM
Post #4


WDG Member
********

Group: Root Admin
Posts: 8,365
Joined: 4-August 06
From: Mountain View, CA
Member No.: 3



You could build one yourself from public sources, for example:
http://en.wikipedia.org/wiki/January_1
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
hunsnowy
post Aug 12 2010, 02:39 PM
Post #5


Novice
**

Group: Members
Posts: 21
Joined: 7-August 10
Member No.: 12,451



Yes, you are right. But I hoped that somebody already did it before me and shared it on the internet. smile.gif
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Aug 12 2010, 04:56 PM
Post #6


🌟Computer says no🌟
********

Group: WDG Moderators
Posts: 20,716
Joined: 9-August 06
Member No.: 6



Maybe they did but you'd have to search for it. Would depend on what kind of people you want to be included also.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
hunsnowy
post Aug 13 2010, 01:35 AM
Post #7


Novice
**

Group: Members
Posts: 21
Joined: 7-August 10
Member No.: 12,451



Hi Pandy! It does not really matter! I was just wondering which keywords should I use in google search...
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Frederiek
post Aug 13 2010, 03:58 AM
Post #8


Programming Fanatic
********

Group: Members
Posts: 5,146
Joined: 23-August 06
From: Europe
Member No.: 9



How about "celebrity birthdays"?
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
hunsnowy
post Aug 13 2010, 06:14 AM
Post #9


Novice
**

Group: Members
Posts: 21
Joined: 7-August 10
Member No.: 12,451



smile.gif Frederiek. I need tables... not sites! If I look for the wrods you mentioned I will get plenty of sites which are _using_ the tables I am looking for....and _sharing_ them.

I was hoping that there is a site which shares these tables...

Anyway, thank you for the ideas!
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Christian J
post Aug 13 2010, 06:39 AM
Post #10


.
********

Group: WDG Moderators
Posts: 9,630
Joined: 10-August 06
Member No.: 7



Try searching for spreadsheets, excel or csv files.

But as long as you have some kind of list of names/birthdates you should be able to enter them in a DB relatively easily (after some cleaning up with a text editor). For example, you might use the PHP explode() function to make an array of them, then loop through that array while running an INSERT query in each loop.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Aug 13 2010, 11:00 AM
Post #11


🌟Computer says no🌟
********

Group: WDG Moderators
Posts: 20,716
Joined: 9-August 06
Member No.: 6



Or use a ready-made birthday script that is bound to have a form for the purpose.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Frederiek
post Aug 13 2010, 11:29 AM
Post #12


Programming Fanatic
********

Group: Members
Posts: 5,146
Joined: 23-August 06
From: Europe
Member No.: 9



Or, from those sites, you could copy the data in the tables and recreate your own DB with it (if you know how), as Christian more or less already suggested. That way, you can choose any people you specifically want.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Brian Chandler
post Aug 13 2010, 12:33 PM
Post #13


Jocular coder
********

Group: Members
Posts: 2,460
Joined: 31-August 06
Member No.: 43



QUOTE(pandy @ Aug 14 2010, 01:00 AM) *

Or use a ready-made birthday script that is bound to have a form for the purpose.


Uh, no. The "form" will be for manually entering the information -- the whole point is that the OP wants to find a ready-made collection of data -- it is then a trivial _programming_ job to convert this into the contents of a database, in whatever format you want. Equally, generating the particular html snippets you need is another trivial _programming_ job. All these suggestions of "modern computing" (the view that a computer enables you to do something by hand, just more neatly) are irrelevant as far as I can see.

Apart from the extremely low probability of finding a spreadsheet lying around on the web, it's the wrong answer anyway. Ideally XML is the way to represent *structured data* of this type.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Brian Chandler
post Aug 13 2010, 12:43 PM
Post #14


Jocular coder
********

Group: Members
Posts: 2,460
Joined: 31-August 06
Member No.: 43



To OP:

Sorry, I don't have any precise suggestions. But (it seems to me) just about all the answers you have received have been addressing the wrong issues.

One issue is that if you find an (advert-laden) site showing lots of birthdays (e.g. with the search Frederiek suggested (How about "celebrity birthdays"?), you can be sure that the "owners" of the information claim they "own" it. You need to make sure you are looking for collections made by people who like you regard a list of birthdays as just something everyone is reasonably entitled to know (as they are, of course). Look on Wikipedia -- I couldn't find birthday lists as such, but I think there are "February birthdays". You really need to do some research to find other people who want the same sort of information, and amazingly you will no doubt find them (eventually; or when the group of people finally forms). You might even end up contributing something by putting together a mechanism for collecting birthdays.

I think it is very frustrating that it can still be very hard sometimes to find obvious information, which will all eventually become everyone's. But look at the speed at which this has happened already for "standard encyclopedic articles" (Wikipedia) or maps (openstreetmap.org), out-of-copyright music scores (imslp.org), and so on. Given that the widespread availability of printed matter took hundreds of years from Gutenberg's introduction of movable type from China, we ought to be patient after only 15.

HTH

PS: You could also poke around Wikimedia and Creative Commons...
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Aug 13 2010, 02:38 PM
Post #15


🌟Computer says no🌟
********

Group: WDG Moderators
Posts: 20,716
Joined: 9-August 06
Member No.: 6



QUOTE(Brian Chandler @ Aug 13 2010, 07:33 PM) *

Uh, no. The "form" will be for manually entering the information --


Which is helpful if you aren't able to do do it yourself.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Brian Chandler
post Aug 13 2010, 02:49 PM
Post #16


Jocular coder
********

Group: Members
Posts: 2,460
Joined: 31-August 06
Member No.: 43



QUOTE(pandy @ Aug 14 2010, 04:38 AM) *

QUOTE(Brian Chandler @ Aug 13 2010, 07:33 PM) *

Uh, no. The "form" will be for manually entering the information --


Which is helpful if you aren't able to do do it yourself.


No it isn't. If you aren't capable of doing trivial programming tasks, it would be vastly more efficient to pay someone who is. You keep trying to solve the wrong problem.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
hunsnowy
post Aug 14 2010, 12:23 PM
Post #17


Novice
**

Group: Members
Posts: 21
Joined: 7-August 10
Member No.: 12,451



Thank you Everyone for the answers. Actually (as I wrote previously) I was hoping to find a site where these lists/tables are shared. Eventually a wast amount of sites (besides wikipedia, I've seen them on many even very small, private or hobby webpages) are using these tables. I found them on very basic webpages where it was clear for me that the owner of the webpage had no clue about html/css/php programming..so he must have gotten even the php scripts from someone.
Anyway... the point is that I've seen these scripts on many-many different type of sites, I thought that they surely did not make their own tables one by one, they must have gotten these tables from somewhere.... And as Brian mentioned these are not confidential data, I hoped that there is a site which makes these tables available for anyone who wants to use them...

As I did not find any page, probably the solution lies in Brian's suggestion to contact these sites/groups/persons and maybe somehow I can get it from them..

Once more...thank you for the suggestions and have a nice weekend all!

This post has been edited by hunsnowy: Aug 14 2010, 12:24 PM
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
to6oy
post Apr 9 2011, 08:02 AM
Post #18





Group: Members
Posts: 3
Joined: 9-April 11
Member No.: 14,302



if someone can help me do this thing i'l be very appreciated


Attached thumbnail(s)
Attached Image
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
to6oy
post Apr 9 2011, 08:02 AM
Post #19





Group: Members
Posts: 3
Joined: 9-April 11
Member No.: 14,302



man i'm working all day and i have i just can't get it
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
to6oy
post Apr 9 2011, 08:03 AM
Post #20





Group: Members
Posts: 3
Joined: 9-April 11
Member No.: 14,302



please help
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

2 Pages V  1 2 >
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 28th March 2024 - 11:01 AM