Login   Register  
PHP Classes
elePHPant
Icontem

File: index.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Andras Toth  >  SQL Proc Func  >  index.php  >  Download  
File: index.php
Role: Example script
Content type: text/plain
Description: Example script
Class: SQL Proc Func
Run stored procedures and queries read from files
Author: By
Last change: repair View expressions
Date: 2 months ago
Size: 4,129 bytes
 

Contents

Class file image Download
<!doctype html>
    <html>
    <head>
        <title>SqlProcFunc</title>
           <link href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css" rel="stylesheet">
        <style type="text/css">

        .panel-footer {
            display: inline-table;
            width: 100%;
            }
        .panel-body td{

            white-space: pre-wrap;
            }
        .container{
            margin-top: 20px;
            width: 100%;
        }
    </style>
    </head>
    <body>
        <div class="container">
        <div class="panel panel-info">
              <div class="panel-heading">
                <h3>Get instance with PDO connection parameters and view functions</h3>
              </div>
              <div class="panel-body">
                    <?php
                    
                        
require_once('SqlFuncProc.php');
                        
//$func = SqlFuncProc::getInstance("mysql:host=YOURSERVER;dbname=AdventureWorks2012;charset=utf8", yourname, yourpass);
                        
$func SqlFuncProc::getInstance("sqlsrv:Server=YOURSERVER;Database=AdventureWorks2012"nullnull);
                        echo 
$func->viewFunc(''"table table-bordered");
                    
?>    
             </div>
             <div class="panel-footer">
<code id="codeNoerror" name="code"><pre>
&lt;?php
    require_once('SqlFuncProc.php');
    // get instance with PDO connection data
    //$func = SqlFuncProc::getInstance("mysql:host=YOURSERVER;dbname=AdventureWorks2012;charset=utf8", yourname, yourpass);
    $func = SqlFuncProc::getInstance("sqlsrv:Server=YOURSERVER;Database=AdventureWorks2012", null, null);
    // Functions list from folder with parameters : viewFunc($name = "", $class="")
    // $name: chars from filename, $class: table class
    echo $func->viewFunc("", "table table-bordered");
?&gt;
</pre></code>                 
             </div>
        </div>
        <div class="panel panel-info">
              <div class="panel-heading">
                <h3>View procedures</h3>
              </div>
              <div class="panel-body">
                    <?php
                        
echo $func->viewProc(''"table table-bordered");
                    
?>    
             </div>
             <div class="panel-footer">
<code id="codeNoerror" name="code"><pre>
&lt;?php
    // Processes list from folder with parameters : viewFunc($name = "", $class="")
    // $name: chars from filename, $class: table class
    echo $func->viewProc("", "table table-bordered");
?&gt;
</pre></code>                 
             </div>
        </div>
        <div class="panel panel-danger">
              <div class="panel-heading">
              <h3>Run process: error</h3>
              </div>
              <div class="panel-body">
                    <?php
                    $data 
$func->runProc('error');
                    
print_r($data);
                    
?>    
             </div>
             <div class="panel-footer">
<code id="codeNoerror" name="code"><pre>
&lt;?php
    //Run error proc runProc($proc, $params = array(), $force = false);
    //$proc: process name, $params: parameter array
    $data = $func->runProc('error');
    print_r($data);
?&gt;
</pre></code>                 
             </div>
        </div>
        <div class="panel panel-success">
              <div class="panel-heading">
              <h3>Run process: noerror</h3>
              </div>
              <div class="panel-body">
                    <?php
                    $data 
$func->runProc('noerror', array(50));
                    
print_r($data);
                    
?>    
             </div>
             <div class="panel-footer">
<code id="codeNoerror" name="code"><pre>
&lt;?php
    //Run noerror proc runProc($proc, $params = array(), $force = false);
    //$proc: process name, $params: parameter array
    $data = $func->runProc('noerror', array(50));
    print_r($data);
?&gt;
</pre></code>                     
             </div>
        </div>
        <div class="panel panel-primary">
              <div class="panel-heading">
                <h3>Run function OrganizationTree and create HTML table</h3>
              </div>
              <div class="panel-body">
                    <?php
                        $data 
$func->runFunc("OrganizationTree",array(1,0), 10);
                        
$data $func->getHTMLtable($data"""table table-striped"true);
                        echo 
$data;
                    
?>    
             </div>
             <div class="panel-footer">

<code id="codeNoerror" name="code"><pre>
&lt;?php
    //Run OrganizationTree func: runFunc($proc, $params = array(), $limit = false) 
    //$proc: process name, $params: parameter array, $limit : returned rows count
    //return  array()
      $data = $func->runFunc("OrganizationTree",array(1,0), 10);
      //Create HTML table from array: getHTMLtable($array = array(), $id = "", $class = "", $head = true) 
      echo $func->getHTMLtable($data, "", "table table-striped", true);
?&gt;
</pre></code>             
             </div>
            </div>
        </div>
    </body>
    </html>