How to forward approved submission through php and mysql?

  • Profile Image
    Imran
    Asked on March 31, 2018 at 06:21 AM

    Dears,

    Hello I want to create simple website. in website 3 user have been working. one is student, second is teacher and third is principle. when the student is a holiday, he fill the application form and submit to teacher not directly submited to principle. then teacher is checked the application and forward to principle. plz tell me how teacher forward application thorugh php and mysql. i just do not know forward. plz help me. tell me smiple method code or refrence link plz help me.

    Thanks



    This is a re-post of a comment on How to send Submissions to Your MySQL Database Using PHP

  • Profile Image
    Victoria_K
    Answered on March 31, 2018 at 09:12 AM

    Unfortunately, I am not sure if I understood your approval process. 

    Can you kindly clarify how the teacher is reviewing the submission? At submissions page? 

  • Profile Image
    Imran 
    Answered on April 07, 2018 at 11:37 PM

    ok tell you email address. i clarify to you via email. thanx.

  • Profile Image
    Kiran
    Answered on April 08, 2018 at 04:24 AM

    Please be noted that the guide that you are referencing is to send the form submission data to your MySQL database using PHP. If you want to notify the principal by the teacher for the submission of the student, please refer to the guide below:

    https://www.jotform.com/help/432-A-General-Approach-on-Building-an-Approval-Process-Workflow

    Let us know if that helps. If you are referring something different, please let us know. We will be happy to assist you further. 

  • Profile Image
    Kiran
    Answered on April 08, 2018 at 04:25 AM

    If you want us to send an email, you may send it to support@jotform.com so that one of our support team members can assist you.

    Thanks!

  • Profile Image
    Imran 
    Answered on April 08, 2018 at 11:56 PM

    you have said link.Its have been same working but some is different. In link 2 user have been working. customer A and mangerA. But in my website 3 user. 

    student: submit information.

    teacher : checked data. and forward to principle.

    prenciple: checked application and decide accept pr reject.

    my question is that how teacher data forward to prenciple through (forward button)?

    teacher click on forward button then data show to prenciple.

    student not directly submit application to prenciple.

    you see image and i hope you will be clarify.1523246181img.png 

  • Profile Image
    Scott
    Answered on April 09, 2018 at 05:59 AM

    Hey Imran,

    As far as I understood, your diagram defines these three steps below:

    Step 1 - Student fills the form and Teacher gets a notification email

    Step 2 - If the teacher approves, s/he edits the form as approved and a notification email is sent to the Principle; if the teacher denies the application than an autoresponder is sent to Student

    Step 3 - Principle checks the form and upon approval or denial, an Autoresponder is sent to the Student.

    If so, you can still manage this situation via the user guide that was shared by my colleague Kiran on his answer.

    You just need to adjust the email conditions in regards to who is the reviewer (teacher or the principle) and the status.

    Here is a form that may explain it to you little better. Please clone the form to your account and then examine the email templates and the conditions. (You can clone a form using this guide)

    Example form: https://form.jotform.com/80982788323974

  • Profile Image
    imran 
    Answered on April 10, 2018 at 11:57 PM

    my email account "imranrafique688@gmail.com" plz contact to me. thanx.

  • Profile Image
    Scott
    Answered on April 11, 2018 at 04:25 AM

    Hey Imran,

    Please send us an email on support@jotform.com regarding your inquiry.

    You may also consult to the API team for a more detailed technical help at api@jotform.com

    Cheers.