passing parameters at [sqlreport…]

  • Resolved ronando51

    (@ronando51)


    7 years, 10 months ago

    Hi Eli, i am happy using your plugin, but i am in trouble about pass parameter to make selection in variable mode.
    i try explain:
    in a page two input-field ” date from ” “date to” (typed by user)

    and in the sane page i paste [sqlreport name=”elenco”]

    this is sql make report:
    “select post_date as data,
    post_content as contenuto
    from avwp_posts where post_type = “flamingo_inbound”
    and date(post_date) between date(‘2017-01-01’) and date(‘2017-01-04’)
    order by data desc;”

    my goal is substitute the field “date from” and “date to” in sql.

    i read topic in forum but unfortunately i am still in problem.
    Could you help?

    Thanks Fernando

Viewing 1 replies (of 1 total)
  • Plugin Author Eli

    (@scheeeli)

    try this:

    select post_date as data, post_content as contenuto
    from avwp_posts where post_type = ‘flamingo_inbound’
    and date(post_date) between date(‘<?php $_GET[date_from]; ?>’) and date(‘<?php $_GET[date_to]; ?>’)
    order by data desc;

    then you must pass those values in your URL like this:
    /path-to-page/?date_from=2017-01-01&date_to=2017-01-04

Viewing 1 replies (of 1 total)
  • The topic ‘passing parameters at [sqlreport…]’ is closed to new replies.