Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: dhar20040217

Message # 1019032:
Date: 02/23/04 19:31
By: Pablo Almunia
Subject: More easy with MySQL FullText

This is a alternative way:

=== TABLE ===

CREATE TABLE `pages` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(100) NOT NULL default '',
`text` mediumtext NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `text` (`text`)
) TYPE=MyISAM;

=== INDEX HTML FILE ====

$cText = strip_tags( file_get_contents($cURL) );

mysql_query("INSERT INTO pages ( url, text ) VALUES ( '". $cUrl ."', '". $cText ."')

=== QUERY ===

mysql_query( "SELECT url, SUBSTRING( TRIM( text ), 1, 200 ) as abstract FROM pages WHERE MATCH(text) AGAINST ('" . $cQuery . "')" );


This is a very easy FullText of HTML file with PHP.

Previous Message | Next Message


Comments:
카/드/돌려막기로/망가지신분/꼭 보세요!이혜진12/05/04 00:00
카,드,연,체,자/예.정.자 대,출 100-1000만원이다현12/03/04 00:16
신.용.불.량/카.드.연.체/대.출/혼자/해.결하는/방.법김현서12/02/04 20:22
대'출'거'절'시'100%되'게'하'는'방'법한경욱11/29/04 11:58
신.용.불.량.자/당일500/대.출.비.법이희진11/21/04 20:40
신.용불.량자가 알아야할 정.보 대.공.개 이다진11/20/04 07:13
신.용.불.량.자/당일500/대.출.비.법이희진11/20/04 05:54
We already haveAndrew Rodland03/23/04 15:23
RE: More easy with MySQL FullTextArmand Turpel02/26/04 03:39
More easy with MySQL FullTextPablo Almunia02/23/04 19:31
Keytable with fixed rows lengthArmand Turpel02/18/04 04:40
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.