Get instance with PDO connection parameters and wiev functions

Sql Functions
FileSQL string

OrganizationTree
/** * This is a demo function using AdventureWorks2012 database * @SalariedFlag bit * @OrganizationLevel int */ SELECT e.JobTitle ,e.OrganizationLevel ,p.FirstName ,p.MiddleName ,p.LastName FROM employee e INNER JOIN person p ON e.BusinessEntityID = p.BusinessEntityID WHERE e.SalariedFlag = ? AND e.OrganizationLevel >= ? ORDER BY e.BusinessEntityID ,e.OrganizationLevel

Visitors
SELECT * FROM counter ORDER BY id DESC LIMIT 1000;

Wiev procedures

Sql Procedures
FileSQL string

error
/** * This is a demo procedure using AdventureWorks2012 database * return with error code * */ SEL0 from FROM HumanResources.Employee;

noerror
/** * This is a demo procedure using AdventureWorks2012 database * return without error code * @params id int */ DROP TABLE IF EXISTS test; CREATE TABLE IF NOT EXISTS test SELECT * FROM Employee WHERE BusinessEntityID > ? AND BusinessEntityID < ?;

Run process: error

Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SEL0 from FROM HumanResources.Employee' at line 6 )

Run process: noerror

Array ( [0] => 00000 [1] => [2] => )

Run function OrganizationTree and create HTML table

JobTitleOrganizationLevelFirstNameMiddleNameLastName
Chief Executive Officer0KenJSánchez
Vice President of Engineering1TerriLeeDuffy
Engineering Manager2RobertoTamburello
Design Engineer3GailAErickson
Design Engineer3JossefHldberg
Research and Development Manager3DylanAMiller
Research and Development Engineer4DianeLMargheim
Research and Development Engineer4GigiNMatthew
Research and Development Manager4MichaelRaheem
Senior Design Engineer3MichaelISullivan