how to use solr with mysql and php?

i read about how i could use solr to search in my threads but i dont quite understand how it works and i cant find any articles explaining this for a total beginner.

could someone explain briefly how solr works and how it communicate with mysql and php?

-------------Problems Reply------------

First take a look at this tutorial.

With solr you will need to have an xml (or csv) document which will be pushed to solr (process is called updating; indexing is the process to make fields available for search). The format of xml is sth. like:

<field name="id">9885A004</field>
<field name="name">Canon PowerShot SD500</field>
<field name="category">camera</field>
<field name="features">3x optical zoom</field>
<field name="features">aluminum case</field>
<field name="weight">6.4</field>
<field name="price">329.95</field>

Look here for more details.

But in your case you could use a crawler (appropriated if different or external sources) to get different document formats recognized. Try to understand if Nutch could help here.

E.g. take a look at this presentation for an explanation about solr, lucene and nutch.

Category:php Views:0 Time:2009-12-12

Related post

  • Integrate solr with mySql 2011-05-17

    How can I integrate solr with mysql. I have deployed the solr server and all, so what I have to do next for performing search? --------------Solutions------------- Here is the ans First have to do a full import which will index all the data in the da

  • Use SOLR on Mysql relational database. Use SOLR for only product table 2010-02-03

    I am a bit confused as to where SOLR usage ends and where it begins. I use php with a relational mysql db for a shopping site where all tables are related to the product table joining the tables as theyre queried. Needless to say its too slow! e.g. C

  • Using Solr with MySQL 2011-01-05

    I was browsing some questions here concerning MySQL and faceted searches and I saw one response that suggested the use of Solr. In my MySQL database, I have many tables for products, suppliers, messages, users, etc - all interconnected. How would I u

  • Total Requests made to DataSource = 0 when using SOLR with MySQL 2012-02-04

    I followed the many tutorials on the web to get SOLR working with MySQL, but no matter which tutorial I follow, I always end up with "Total Requests made to DataSource = 0" in the fullimport command. I'm using an installation of Wordpress to test thi

  • approach integrate solr and mysql 2012-04-30

    I'm building a web application with php and mysql. Web application will have 3-4 big tables (milions of records per table) where it will extremely important that it must be possible perform a full text search on it for search a term in text field. I

  • Solr - Index MySQL Database 2011-03-25

    Is it possible index a complete database without mentioning the table names explicitly in the data-config.xml as new tables are added everyday and I cannot change the data-config.xml everyday to add new tables. --------------Solutions------------- Ha

  • Lucene or Solr for indexing MySQL db data, some of which cannot be made public 2011-12-28

    I have a MySQL database with a PHP front-end. I would like to implement a search function but I have a somewhat unique situation and need some advice before proceeding. My employer has a large collection of archival research materials. Some of the co

  • MySQL, MongoDB and Solr 2012-02-06

    I'm not so familiar with NoSQL databases, and I'm not quite aware of their potential, and I'm still learning. In meantime, I need to develop simple application with search capabilities. I've read a few posts about Solr, MongoDB and combination of the

  • SOLR - MYSQL - Query results 2012-04-23

    I'm working with SOLR and MySQL. This is my data-config.xml <dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/meishidb" user="root" password="root"/> <document> <entity name

  • SOLR getting started, little help 2010-01-17

    I have managed to install SOLR and run the admin interface... I have no clue on how to add indexes to SOLR... I have a virtual server (wampserver) and in the SOLR tutorial they are referring to a TERMINAL all the time... I guess they mean the LINUX t

  • "Should I use multiple indices in Solr?", and some other quick Q 2010-03-01

    Imagine a classifieds website, a very simple one where users don't have login details. I have this currently with MySql as a db. The db has several tables, because of the categories, but one main table for the classified itself. Total of 7 tables in

  • speed up a sql query to mysql? 2010-03-21

    in my mysql database i've got the geonames database, containing all countries, states and cities. i am using this to create a cascading menu so the user could select where he is from: country -> state -> county -> city. but the main problem

  • How does MyISAM scale compared to Solr for Django searching? 2010-06-30

    Imagine you have a web application written in Django and Python 2.65, and MySQL 5.1 is your database of choice. Now, imagine you will need to scale your app to handle searching 100's of thousands of document and potentially 100's of thousands of user

  • fulltext search with mysql FT or Sphinx 2011-01-23

    I have read many articles about Sphinx or Solr or MySQL FT. I have a table with over 1 milion products and need to make an fulltext search and get results under 1 second ... . Does anyone has any experience with those kind of fast search? As clint la

  • Few questions about Solr. Transactions and Realtime search 2012-02-16

    I have a heldesk application in PHP/MySQL. I want to implement realtime Full text search and I have shortlisted Solr. MySQL database will store all the data and data required for search will be imported for building Solr index. All Search requests wi

  • Solr RequestHandler init failure 2013-10-02

    I seem to be having problems getting solr up and running, I followed the guide here All went well, but now I'm trying to import data from mysql. To do this I have been following this guide

  • Deploying several Rails apps on a mixed (with PHP and other Ruby apps) environment 2011-04-05

    I have a Linode (Ubuntu 9.10, but upgrading not a problem) where I run a few PHP applications and had a Sinatra and Rails 2 app running. I tried to deploy some new Rails (3) apps but in doing so, broke nearly everything :). My requirements are simple

  • Any third party search engines (fulltext search and so on) work fine with InnoDB tables? 2011-08-03

    I know, that InnoDB tables do not support fulltext searches, yet. So I thought of using a third party search engine like solr, xapian or whoosh. Do those third party tools work equivalently fine with InnoDB tables as they work with MyIsam tables? I n

  • Schema considerations when moving from an RDBMS (MySQL) to Solr 2009-07-05

    Whilst testing a Solr install for a future MySQL -> Solr migration, it's immediately apparent that the "rules" for what constitutes a good data stucture, and by extension an efficient search, are very different in Solr when compared to an RDBMS li

Copyright (C), All Rights Reserved.

processed in 0.095 (s). 11 q(s)