Answers

• poeziafree Posts: 35Questions: 11Answers: 0

  September 2021

  • SSD Class is my mistake, I meant SSP Class
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2021 Answer ✓

  Don't I need the SSD Class anymore? Or I should use the Editor Library in combination with the SSD Class?

  Correct. Editor's server-side PHP libraries will do the read operation that the SSP class would have done.

  If I don't need the SSD Class anymore, where can I see the detailed description of how to retrieve data from MySql tables through the editor library?

  In the documentation which is far more through for Editor that the SSP class. Specifically start here and then work on through the joins etc as you need. Obviously some parts won't be relevant if not using the editing features. For security make sure you have ->write(false) before the ->process(...) call, so nobody can submit a sneaky Ajax request to edit data! See this blog post for more info.

  Does it mean that I can be using the editor library for free including for the very purpose which was before served by the SSD Class?

  You can use the Editor PHP libraries for free. They are open source under the MIT license. The client-side Editor library carried a commercial license.

  Allan
• poeziafree Posts: 35Questions: 11Answers: 0

  September 2021

  Hi @allan

  Thank you very much!

  You can use the Editor PHP libraries for free. They are open source under the MIT license. The client-side Editor library carried a commercial license.

  In this case, can I use the trial version of Editor PHP Libraries?

  Next, do I still need to use all Editor Classes1 even if I will only be using the SearchBuilder? (I don't need Edit, Add New options)

  DataTables\Editor\Field,
  DataTables\Editor\Format,
  DataTables\Editor\Mjoin,
  DataTables\Editor\Options,
  DataTables\Editor\Upload,
  DataTables\Editor\Validate,
  DataTables\Editor\ValidateOptions`
  
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2021

  In this case, can I use the trial version of Editor PHP Libraries?

  There is no trial version of the PHP libraries. They are open source under the MIT license. You can use the PHP libraries that are in the Editor trial package if that is what you mean, or you can get them from github.

  Next, do I still need to use all Editor Classes1 even if I will only be using the SearchBuilder?

  No. You'll need the Editor and Field lines, since you still need to define the fields, but unlikely that you'll need to use any of the others.

  Allan
• poeziafree Posts: 35Questions: 11Answers: 0

  September 2021

  Hi, @allan

  Thank you very much. One more question, please.

  I am stuck with GROUP BY issue as it is not supported by the Editor. I have read your comments about VIEW but I don't really understand it. Is there any way round? Or any more vivid example?
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2021

  I've just added a reply to your other thread on this topic.

  Allan