// 通过PHP从数据库获取商品数据导入到solr搜索引擎
$sql = " SELECT * FROM " . $ecs->table('goods') . " WHERE user_id =2334 limit 10";
$data = $db->getAll($sql);
//循环整理数据,这里可以根据你的实际情况addField
foreach ($data as $key => $value) {
$doc = new SolrInputDocument();
$doc->addField('goodId', $value['goods_id']);
$doc->addField('goods_name', $value['goods_name']."20190909");
$doc->addField('goods_number', $value['goods_number']);
$doc->addField('goods_sn', $value['goods_sn']);
$doc->addField('cat_name', "其他");
$doc->addField('brand_name', "测试店铺1");
$doc->addField('shop_price', $value['shop_price']);
$doc->addField('rz_shopName', '测试店铺1');
$doc->addField('id',$value['goods_id']);//当索引文档中主键id值存在时,会更新原文档,不存在则会添加文档。我这里商品id是唯一的,所以这样使用
$response = $client->addDocument($doc);
}
//提交
$client->commit();
可以搜索到刚刚从数据库导入的商品