Perch Search

Ok, so I'm guessing I would then need to hook an elasticsearch server to Perch? Is there any straightforward way of hooking all database operations in perch that you know of?

(Failing that, I could just have a cron job regularly index the perch database, creating an elastic search database to be searched, just wondered if there was a simpler way)

Ah, now that sounds like a good place to start!

I'll see if I can find said event (if you know what it's called or where it's defined, that may help too).

Thanks!

Thanks Drew,

I've got together something that works, using the index tables of the database, and it seems perfectly fast enough (not tested on a large index, but thankfully this is for a fairly small website).

Regards,

Hi Matthew,

Sorry to use this thread but seemed the only way to contact you. I found this old forum post of yours where you say you managed to allow members to upload images and handle those images using some custom code:

https://forum.grabaperch.com/forum/11-18-2015-members-app-upload-fileimage

I was wondering if you'd be kind enough to share the code that you came up with for this, if you still have it?

Thanks in advance for any help you may be able to offer.

Hi Stephen,

Unfortunately, I can't share the code directly - as my client wouldn't allow this. However, I can share the concept of what I did:

• Images are uploaded using a typical HTML input field, but when saved, they are given a name that matches the username of the current logged in user.

So, for example: Step 1) An HTML upload allows image upload

<form action="/upload.php" method="POST">
     <input id="logo" name="logo" type="file" required="required" />
</form

Step 2) Once the form is submitted, the upload.php page should contain something like:

if(isset($_FILES['logo'])){
     $userHash = sha1(perch_member_get('email') . $salt);
     move_uploaded_file($_FILES["logo"]["tmp_name"], $_SERVER['DOCUMENT_ROOT'] . "/logos/" . $userHash . ".png");
     //Image processing code, e.g. using ghostscript or imagick
}

Now, this is quite a simple version of the concept I went with (maybe worth fully assessing the security of this, particularly if logos access should be sensitive).

Thanks Matthew. Did you have this as part of the member sign up form or a separate form after they had signed up?

Hi Stephen,

Both actually. In my setup, users COULD provide a logo, but didn't have to.

I then had an area to upload (or replace existing) logo on the users settings page (as for this example, a logo was required to use the system fully).

Regards,