reqNormalQuery
reqNormalQuery
$mcp : \LinHUniX\Mcp\masterControlProgram
need for the call back.
__construct(\LinHUniX\Mcp\masterControlProgram $mcp, array $scopeCtl, array $scopeIn)
| \LinHUniX\Mcp\masterControlProgram | $mcp | |
| array | $scopeCtl | |
| array | $scopeIn |
moduleCore() : boolean|array
$scope array is var ["T"]: e = execute : exec query with boolean results ec = execute : exec query with boolean results and reset all cache f = firstRow : return only first row q = retrive array of all results c = return the count of the results s = return the sql information r = return sql and env d = search on cfg the data form another query p = puth data on the database (using setrow) "Q" is table g = get data on the database (using getrows) "Q" is table "S" is sort , "L" limit and "W" where cause other case return false; var ["Q"] = query var ["E"] = env or instance of specific database var ["V"] = contain the values that need to remplace on query scripts var ["S"] = stored in session var ["G"] = stored in globals var ["J"] = stored in Json Cache
query results
where()
This a fast where cause creator $scope["WhereFullString"] has the string with where clause (example) " pippo='pluto' " $scope["WhereArray"] has the array as key and value (example) " pippo='pluto' " $scope["WhereGet"] has the array as key and value (example) " pippo=$_GET['pluto'] " $scope["WherePost"] has the array as key and value (example) " pippo=$_POST['pluto'] " $scope["WhereSession"] has the array as key and value (example) " pippo=$SESSION['pluto'] " $scope["WhereDic"] has the array as key and value (example) " pippo=$cfg['pluto'] "