Author Topic: Add Different Functions To One Of The Examples  (Read 3084 times)

JimmyJazz

  • Newbie
  • *
  • Posts: 3
    • View Profile
Add Different Functions To One Of The Examples
« on: August 31, 2017, 07:15:33 pm »
First post after trying the evaluation version and I'm impressed so far, I've already loaded a few of the examples onto my server and I just did a c&p of the Collapsible Grouping onto my server and I like it.

However, I'm at the stage where I want to marry many of the different functionalities together and I'm just wondering how to add different functions to one of the examples, say Collapsible Grouping?

Start with one; Collapsible Grouping has cell editing, how do I add the ability to save so after refresh the browser the new value is still there?

Currently the data is coded into the javascript I placed into the html, I am assuming this will have to be placed into a database (mysql?) so when it is edited the change gets hard coded to the database?

Is this assumption correct?

Maybe someone could give me a pointer on how to do this or give an example I can copy?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5791
    • View Profile
Re: Add Different Functions To One Of The Examples
« Reply #1 on: August 31, 2017, 11:28:25 pm »
There are couple of examples on editing and saving it on remote server.

https://paramquery.com/pro/demos under the section "Inline editing"

In the examples ( remote scripts are in PHP tab, ASP.NET, java tabs ), data is fetched from mysql database, but saved in sessions. If you have working knowledge of mysql, you would be able to replace the session storage with mysql database.

JimmyJazz

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Add Different Functions To One Of The Examples
« Reply #2 on: September 01, 2017, 02:50:18 pm »
Wow, this looks technical, my skills compose of html and css editing but I'll have a go at this because I have a need for a product like ParamQuery.

Googling around I found this tutorial;

http://culttt.com/2013/02/04/how-to-save-php-sessions-to-a-database/

Is this the exact solution I need???

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5791
    • View Profile
Re: Add Different Functions To One Of The Examples
« Reply #3 on: September 01, 2017, 10:04:44 pm »
No that tutorial says saving php session to a database which is not required for these example.

This is the flow of data in the examples.

MySql -> php script ->  pqgrid -> post data -> php script -> save in session

What you actually need is

MySql -> php script ->  pqgrid -> post data -> php script -> save in MySql

JimmyJazz

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Add Different Functions To One Of The Examples
« Reply #4 on: September 02, 2017, 08:43:23 am »
I see, so it's just the code for the last part that is required:

-> save in MySql

do you have an example for this?