source blog
{
type = xmlpipe2
xmlpipe_command = /usr/bin/php /home/abbas/sphinx/makeindex.php
xmlpipe_field = title
xmlpipe_field = content
xmlpipe_attr_uint = author_id
xmlpipe_attr_timestamp = publish_date
xmlpipe_attr_multi = category_id
}
index posts
{
source = blog
path = /usr/local/sphinx/var/data/blog-xmlpipe2
docinfo = extern
charset_type = utf-8
}
indexer
{
mem_limit = 32M
}

<?php
// Database connection credentials
$dsn ='mysql:dbname=myblog;host=localhost';
$user = 'root';
$pass = '';
// Instantiate the PDO (PHP 5 specific) class
try {
$dbh = new PDO($dsn, $user, $pass);
} catch (PDOException $e){
echo'Connection failed: '.$e->getMessage();
}
// We will use PHP's inbuilt...