Jump to content


Photo

Search/Import into MySQL


  • Please log in to reply
2 replies to this topic

#1 simonaut

simonaut
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 11 April 2006 - 03:01 AM

Hello, I have these large class lists and I want to be about to either just search the suckers or I would really like to import all the information and insert it into MySQL then it can be searched. I am trying to building a class schedule creator so students can select which classes they would like it pulls the time of the available one's and such. This is for a student site so we can't get access to the DB with the info on it!
HERE IS THE LINK: [a href=\"http://www.myuah.com/content/schedules/sprg2006.html\" target=\"_blank\"]http://www.myuah.com/content/schedules/sprg2006.html[/a]

~Simon

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 11 April 2006 - 09:11 AM

If you have Excel on your machine you can import this datasheet and use fixed width and then once imported you can export as CSV and then import straight to the database!
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 simonaut

simonaut
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 12 April 2006 - 09:03 PM

This data changes daily is there anyway to have php do it so that once a day I can run the script and it would update everything?
~Simon




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users