PAGINATION_DEFAULT_ROWS
PAGINATION_DEFAULT_ROWS
Class MyDB
easy Access to Mysql DB
Methods: insertRecord($tblName, $knownTblNameFields, $HtmlPostRecords)
init_db() : \MyDB
intialize DB
insertRecord( $tblName, $knownTblNameFields, $HtmlPostRecords) : \idOfnewRecord
$tblName | DB Table ' Auth ' |
|
$knownTblNameFields | Structure of $tblName |
|
$HtmlPostRecords | POST Array insert new record on $tblName from $_POST $HtmlPostRecords with structure $knownTblNameFields |
insertRecordUniqueField( $tblName, $knownTblNameFields, $HtmlPostRecords) : \idOfnewRecord
$tblName | ||
$knownTblNameFields | ||
$HtmlPostRecords | insert new record on $tblName from $_POST $HtmlPostRecords with structure $knownTblNameFields WHERE $HtmlPostRecords['name'] is UNIQUE Use for linked tables, foreign keys to primary, vice versa DB Design field must by UQ : |
_determineType(mixed $item) : string
This method is needed for prepared statements. They require the data type of the field to be bound with "i" s", etc.
This function takes the input, determines what type it is, and then updates the param_type.
mixed | $item | Input to determine the type. |
The joined parameter types.
_buildQuery(integer $numRows = NULL, array $tableData = NULL) : object
Abstraction method that will compile the WHERE statement, any passed update data, and the desired rows.
It then builds the SQL query.
integer | $numRows | The number of rows total to return. |
array | $tableData | Should contain an array of data for updating the database. |
Returns the $stmt object.