public function index(Request $request)
{

    if ($request) {
        $query     = trim($request->get('searchText'));


        $articulos = DB::table('articulo as a')
            ->join('categoria as c', 'a.idcategoria', '=', 'c.idcategoria')
            ->select('a.idarticulo', 'a.nombre', 'a.codigo', 'a.stock', 'c.nombre as categoria', 'a.descripcion', 'a.imagen', 'a.estado')
            ->where('a.nombre', 'LIKE', '%' . $query . '%')
            ->orwhere('a.codigo', 'LIKE', '%' . $query . '%')
            ->orderBy('a.idarticulo', 'desc')
            ->union(->select('ar.idarticulo', 'ar.nombre', 'ar.codigo', 'ar.stock', 'ca.nombre as categoria', 'ar.descripcion', 'ar.imagen', 'ar.estado')
            ->where('ar.nombre', 'LIKE', '%' . $query . '%')
            ->orwhere('ar.codigo', 'LIKE', '%' . $query . '%')
            ->orderBy('ar.idarticulo', 'desc'))

        $articulo2 = DB::connection('sqlsrv') and DB::table('articulo as ar')
        ->join('categoria as ca', 'ar.idcategoria', '=', 'ca.idcategoria')
        ->select('ar.idarticulo', 'ar.nombre', 'ar.codigo', 'ar.stock', 'ca.nombre as categoria', 'ar.descripcion', 'ar.imagen', 'ar.estado')
            ->where('ar.nombre', 'LIKE', '%' . $query . '%')
            ->orwhere('ar.codigo', 'LIKE', '%' . $query . '%')
            ->orderBy('ar.idarticulo', 'desc')
            ->paginate(7);

             return view('almacen.articulo.index', ["articulos" => $articulos, "searchText" => $query]);

    }

}

class Articulo extends Model

protected $connection = 'mysql';
protected $table      = 'articulo';
protected $primaryKey = 'idarticulo';

public $timestamps = false;

protected $fillable = [
    'idcategoria',
    'codigo',
    'nombre',
    'stock',
    'descripcion',
    'imagen',
    'estado',
];

protected $guarded = [

];}

DB_CONNECTION=sqlsrv
DB_HOST=127.0.0.1
DB_PORT=1433
DB_DATABASE=dbventas
DB_USERNAME=Angelo
DB_PASSWORD="Ad041095"

DB_CONNECTION2=mysql
DB_HOST2=127.0.0.1
DB_PORT2=3306
DB_DATABASE2=dbventaslaravel
DB_USERNAME2=root
DB_PASSWORD2=