database format

pacotelic · 05-08-2004, 05:14 PM

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

vinyl-junkie · 05-09-2004, 04:34 PM

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.

05-08-2004, 05: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

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 06:22 PM
Database records.	Dave A	The Mole Hole	3	12-17-2004 10:48 PM
work with the database?	cherry1499	How-to Forum	4	09-18-2004 04:03 PM
Format modified date for search results	jerrywin5	How-to Forum	1	03-23-2004 02:45 AM
database engine	Yannick	Mod Requests	0	02-09-2004 05:13 AM

05-09-2004, 04: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.