🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
Pages: 1
- » How-To and Troubleshooting
- » syntax of Piwigo search engine OR transmission of sql statements
#1 2020-05-22 12:28:01
- naponline
- Member
- 2014-10-14
- 21
syntax of Piwigo search engine OR transmission of sql statements
Hello,
I got very good hints from the Piwigo community and started to implement links on my major site by using tag search links for direct access into my Piwigo site.
As I'm quite familiar with sql statements - even more complicated over several tables - I want to ask whether it is possible to "call" the Piwigo search engine with a complete sql statement or the transmission of the resulting image id's?
An alternative could be to "rebuild" the syntax of the search parameters that are stored in the search-table - in this case I would need a description of this syntax.
Thank you ... and please keep going on with the wonderful Piwigo solution :-)
Greetings from Berlin
Markus Stein
Piwigo version: 2.10.2
PHP version: 7.3.17
MySQL version: 5.5.62
Piwigo URL: http://uniformenportal.de
Offline
#2 2020-05-22 20:29:26
- erAck
- Only trying to help
- 2015-09-06
- 2026
Re: syntax of Piwigo search engine OR transmission of sql statements
Not sure if it suits, but sounds like you could use the Piwigo web API if you are able to process the output somehow, see http://uniformenportal.de/tools/ws.htm
For example pwg.tags.getImages
Running Piwigo at https://erack.net/gallery/
Offline
#3 2020-05-27 10:01:12
- naponline
- Member
- 2014-10-14
- 21
Re: syntax of Piwigo search engine OR transmission of sql statements
Thank you for your reply ... I'm not so familiar with web-services but these tools look interesting, so I'll dig into this field :-)
Greetings from Berlin
Markus Stein
Offline
#4 2021-02-02 23:24:10
- naponline
- Member
- 2014-10-14
- 21
Re: syntax of Piwigo search engine OR transmission of sql statements
As I've to learn the PHP 7.x plus mySQLi connections I also started the solution I wanted to have with the direct search ... I also added the opportunity to search for time periods; another question I've given in this forum - now a text field is compared to the "lowest" year (-tag) and the "highest" year (tag).
The result is at http://www.napoleon-online.de/armeen_un … portal.php ... but the tools were of good help as I checked the syntax of the file system :-) - the thumbnails bear the direct link to my Piwigo implementation.
So, although it is not included directly in Piwigo itself it is quite helpful.
Greetings from Berlin
Markus Stein
Offline
#5 2021-02-03 00:00:04
- erAck
- Only trying to help
- 2015-09-06
- 2026
Re: syntax of Piwigo search engine OR transmission of sql statements
Well, appears to work, nice!
Running Piwigo at https://erack.net/gallery/
Offline
Pages: 1
- » How-To and Troubleshooting
- » syntax of Piwigo search engine OR transmission of sql statements