case "--database":
            $db = $_SERVER["argv"][++$i];
            break;
        case "--name":
            $pname = $_SERVER["argv"][++$i];
            break;
        default:
            help();
            exit(5);
        case "-h":
            help();
            exit(0);
            break;
    }
}
switch ($result = getProc($servername, $username, $password, $db, $pname)) {
    case 0:
        echo "There is something error!\n";
        break;
    case 1:
        echo "The PROC/FUNC dose not exit!\n";
        break;
    default:
        $query = "\nDROP FUNCTION IF EXISTS " . $pname . ";\n";
        $query .= "\nDELIMITER ;; \n CREATE " . $result['type'] . " " . $result['specific_name'] . " (" . $result['param_list'] . ") RETURNS " . $result['returns'] . "\n";
        $query .= $result['is_deterministic'] == 'YES' ? "    DETERMINISTIC\n" : "    NOT DETERMINISTIC\n";
        $query .= "    " . $result['language'] . " SECURITY INVOKER\n";
        $query .= $result['body_utf8'] . ";\n;;\nDELIMITER ;\n";
        echo $query;
        break;
}
Example #2
0
                            ?>
</td>
          <td rowspan="1"><?php 
                            echo $key_4;
                            ?>
</td>
          <td rowspan="1"><?php 
                            echo $value_3['bruto_tilpums'];
                            ?>
</td>
          <td rowspan="1"><?php 
                            echo $value_4;
                            ?>
</td>
          <td rowspan="1"><?php 
                            echo getProc($value_3['bruto_tilpums'], $value_4);
                            ?>
</td>
        </tr>
               <?php 
                        }
                        ?>
              <?php 
                    }
                    ?>
            <?php 
                }
                ?>
          <?php 
            }
            ?>