PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > How-to Forum

Reply
 
Thread Tools
Old 05-08-2004, 04:14 PM   #1
pacotelic
Green Mole
 
Join Date: May 2004
Posts: 1
database format

This is a great tool that trumps anything we have seen with Xoops or PostNuke, two packages we had considered for our needs.

How are the search results stored in the MySQL database on the web server?

Because we do not have access to install pstotext on our web host, we need to be able to insert text that we have distilled from pdfs on our workstations to the searchable database, while linking them to their urls.

I see that you have several tables in the _phpdig db, and I would like to know how to add articles manually to this database without causing any insertion errors in other tables.

Which data is added to what table when a single url is indexed?

Alan Cunningham,
DryLandScope
pacotelic is offline   Reply With Quote
Old 05-09-2004, 03:34 PM   #2
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
Welcome to the forum, pacotelic. We're glad to have you here.

I started not to reply to this thread, but I didn't think anyone else would so here goes.

First of all, I did not develop any of the code for phpdig, so I'm not the world's most knowledgeable person regarding the inner workings of the code. However, I can tell you from having taken a cursory look at just how phpdig stores data in its index that it stores lookup data for individual URLs in the tables called spider, keywords and engine. If you browse those tables, you can get a sense of what most of the data is and what it's used for.

If you want an in-depth look at how they work together, you will probably want to look at admin/robot_functions.php, as that is where index data is written to. There's also a brief overview of how phpdig indexes here in the documentation.

Hope this helps.
vinyl-junkie is offline   Reply With Quote
Reply

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
upgrade a 1.8.3 database to 1.8.6 renehaentjens How-to Forum 6 01-06-2005 05:22 PM
Database records. Dave A The Mole Hole 3 12-17-2004 09:48 PM
work with the database? cherry1499 How-to Forum 4 09-18-2004 03:03 PM
Format modified date for search results jerrywin5 How-to Forum 1 03-23-2004 01:45 AM
database engine Yannick Mod Requests 0 02-09-2004 04:13 AM


All times are GMT -8. The time now is 08:13 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.