Scripts
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsWeb Site ManagementScripts

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 30th, 2006, 05:03 AM
pokervis pokervis is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2006
Posts: 4 pokervis User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 59 m 12 sec
Reputation Power: 0
Script for implementing parts of html into database

Hello there!

I'm kinda new to database building, and Im having a problem which I can't seem to figure out myself. I'm having several 100 html files (or basic text, if you like), which are similar in nature. Now, I'd like to implement parts of these files in one database. Say the files have the following layout:

<html>
blabla
<title>here goes title</html>
<description>the desc goes here</description>
blabla
<body>
a block of text
a block of text
a block of text
</body>
bladibla

So, the fields I want to have implemented are those parts which are in between the brackets of htmlcode (eg. "here goes title"). Moreover, some of the fields are not one-liners, but include several lines and paragraphs (say "a block of text, etc").

Now, the main problem is to find a decent program or script to do this in batch mode. Does anyone have a clue on how to approach this problem? A script might be the best solution, still i don't know whether it is possible for such a task. I favor working with a program, but I haven't found a suitable one. The eventual database will be SQLbased, however, any database is fine for now.

I've been looking at php-scripts on this forum, and php sounds like a decent choice for this task. Still, the batch-issue and the multiple-line issue are a bit too hard for a beginner like me.

Best regards, and thanks in advance for your insights on this issue.

Rob

Reply With Quote
  #2  
Old October 30th, 2006, 06:35 AM
jharnois's Avatar
jharnois jharnois is offline
mod_dev_shed
Dev Shed God 19th Plane (14000 - 14499 posts)
 
Join Date: Sep 2002
Location: Atlanta, GA
Posts: 14,441 jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 1 Week 2 Days 14 h 1 m 38 sec
Reputation Power: 812
Welcome to Dev Shed.

So you're looking for a pre-built script that will extract all the text from several hundred HTML files and put it into a database? It also sounds like you want each HTML item to be a separate field?

I don't think you'll find something that will give you exactly what you want, but maybe you can find an open source app that you can modify a bit. However, if the tasks you need done are outside your skill set, I doubt you'd be able to modify an open source app.

You might try searching for a file indexer / search script type of thing. Your needs are along those lines.
__________________
# Jeremy

Explain your problem instead of asking how to do what you decided was the solution.

Reply With Quote
Reply

Viewing: Dev Shed ForumsWeb Site ManagementScripts > Script for implementing parts of html into database


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway
Stay green...Green IT