Announcement

Collapse
No announcement yet.

Stored Procedures in Button Level

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored Procedures in Button Level

    Hi Friends,

    How to call the stored procedure in Buttons. For Eg: Button Name: CHECK_BTN . Button Type: PHP

    Eg:

    Stored Procedure Name: call_simplePro();

    Please give me the right syntax and give example ...

  • #2
    You mean a mysql stored procedure or an oracle stored procedure or.... well you get the point...
    That is pretty standard php (mysql): http://www.php.net/manual/en/mysqli....procedures.php
    (oracle): http://www.oracle.com/technetwork/ar...ps-095636.html etc.. use your friendly neighbourhood google...

    Comment


    • #3
      Hi ,

      I am using MYSQL Stored Procedure.. Give me a example of my problem

      Comment


      • #4
        Did I not I thought I gave you links.. Here is another one...
        http://dev.mysql.com/doc/refman/5.0/en/call.html
        Just do a CALL statement with the proper parameters for you mysql procedure..


        $mysqli = new mysqli("example.com", "user", "password", "database");
        $mysqli->query("CALL call_simplePro()");
        If you can do a statement in your mysql workbench (or commandline) you can basically do the same in php....

        Comment

        Working...
        X