$adb = PearDatabase::getInstance();<\/p>\n\n\n\n
Exemplo de c\u00f3digo:<\/p>\n\n\n\n
$result = $adb->query('SELECT * FROM vtiger_leadstatus');\n \nwhile($row = $adb->fetchByAssoc($result)){\n $pick_val = $row[$fieldName];\n}\n \n$resultUsers = $adb->query('SELECT id FROM vtiger_users;');\n \nwhile ($userID = $adb->getSingleValue($resultUsers)) {\n echo $userID;\n}\n \n$resultUsers = $adb->query('SELECT id FROM vtiger_users;');\n$userID = $adb->getSingleValue($resultUsers);<\/code><\/pre>\n\n\n\nLista de fun\u00e7\u00f5es<\/h3>\n\n\n\n- bind<\/strong>($param, $value, $type = null) – adds parameters to a query http:\/\/php.net\/manual\/en\/pdostatement.bindvalue.php<\/a>;<\/li>
- checkError<\/strong>($message, $dieOn-Error = false) – logs errors;<\/li>
- columnMeta<\/strong>(&$result, $col) – information about a column in results;<\/li>
- completeTransaction()<\/strong> – transaction completed successfully;<\/li>
- concat<\/strong>($list) – creates concat value for mysql from an arry;<\/li>
- connect()<\/strong> – connects to the database;<\/li>
- delete<\/strong>($table, $where = ”, $params = []) – deletes data;<\/li>
- disconnect()<\/strong> – disconnects the database;<\/li>
- ErrorMsg()<\/strong> – error massage for a query http:\/\/php.net\/manual\/en\/pdostatement.errorinfo.php<\/a>;<\/li>
- execute<\/strong> – executes a query http:\/\/php.net\/manual\/en\/pdostatement.execute.php<\/a>;<\/li>
- fetch_array<\/strong>($result) – returns an associative array with all results http:\/\/php.net\/manual\/en\/pdostatement.fetch.php<\/a>;<\/li>
- fetchByAssoc<\/strong>(&$result, $rowNum = -1, $encode = true) – returns an associative array, first line by default or a line with a particular number;<\/li>
- flatten_array<\/strong>($input, $output = null) – flattens a multilevel array to one level;<\/li>
- formatDate<\/strong>($datetime, $strip_quotes = false) – not supported at the moment;<\/li>
- generateQuestionMarks<\/strong>($items) – creates a string with “?” and there are as many question marks as array elements, e.g. “?,?,?,?”;<\/li>
- getAffectedRowCount<\/strong>($result) – the amount of data for which a query was executed, for selects it’s the number of records and for updates it’s the amount of updated data http:\/\/php.net\/manual\/en\/pdostatement.rowcount.php<\/a>;<\/li>
- getColumnNames<\/strong>($tablename) – an array with column names;<\/li>
- getColumnsMeta<\/strong>($tablename) – an array with objects that contain detailed information about columns in an array;<\/li>
- getEmptyBlob<\/strong>() – a null sign;<\/li>
- getFieldsArray<\/strong>($result)- an array with columns from results http:\/\/php.net\/manual\/en\/pdostatement.getcolumnmeta.php<\/a>;<\/li>
- getFieldsDefinition<\/strong>($result) – an array with objects that contain detailed information about columns in an array;<\/li>
- getInstance<\/strong>() – creates a new PearDatabase instance;<\/li>
- getLastInsertID<\/strong>($seqname = ”) – id of the last insert http:\/\/php.net\/manual\/en\/pdo.lastinsertid.php<\/a>;<\/li>
- getOne<\/strong>($sql, $dieOn-Error = false, $msg = ”) – downloads single value from results;<\/li>
- getRowCount<\/strong>($result) – the number of records;<\/li>
- getSingleValue<\/strong> – downloads single value from results; http:\/\/php.net\/manual\/en\/pdostatement.fetchcolumn.php<\/a>;<\/li>
- getUniqueID<\/strong>($seqname) – downloads a subsequent ID for an array;<\/li>
- hasFailedTransaction<\/strong>() – is there an error in transaction?;<\/li>
- insert<\/strong>($table, $data) – adds data to the database (data – associative array);<\/li>
- isMySQL<\/strong>() – is it MySQL database?;<\/li>
- isOracle<\/strong>() – is it Oracle database?;<\/li>
- isPostgres<\/strong>() – is it Postgres database?;<\/li>
- log<\/strong>($message, $type = ‘info’) – saves database logs;<\/li>
- logSqlTime<\/strong>($startat, $endat, $sql, $params = false) – an advanced save of database logs (under development);<\/li>
- num_fields<\/strong>($result) – the number of columns in results http:\/\/php.net\/manual\/en\/pdostatement.columncount.php<\/a>;<\/li>
- num_rows<\/strong>($result) – the number of lines in results;<\/li>
- pquery<\/strong>($query, $params = [], $dieOn-Error = false, $msg = ”) – executes a query with parameters;<\/li>
- prepare<\/strong>($query) – executes a query http:\/\/php.net\/manual\/en\/pdo.prepare.php<\/a>;<\/li>
- println<\/strong>($msg) – saves database logs;<\/li>
- query<\/strong>($query, $dieOn-Error = false, $msg = ”) – executes a query without parameters http:\/\/php.net\/manual\/en\/pdo.query.php<\/a>;<\/li>
- query_result<\/strong>(&$result, $row, $col = 0) – downloads data;<\/li>
- query_result_raw<\/strong>(&$result, $row = 0) – downloads data;<\/li>
- query_result_rowdata<\/strong>($result, $row = 0) – downloads data;<\/li>
- raw_query_result_rowdata<\/strong>(&$result, $row = 0) – downloads data;<\/li>
- quote<\/strong>($input, $quote = true, $type = null) – protects value in sql query http:\/\/php.net\/manual\/en\/pdo.quote.php<\/a>;<\/li>
- requirePsSingleResult<\/strong>($sql, $params, $dieOn-Error = false, $msg = ”, $encode = true) – number of lines in results has to be equal to 1, otherwise it returns false; an option with parameters;<\/li>
- requireSingleResult<\/strong>($sql, $dieOn-Error = false, $msg = ”, $encode = true) – number of lines in results has to be equal to 1, otherwise it returns false; an option without parameters;<\/li>
- resetSettings<\/strong>($dbtype, $host, $dbname, $username, $passwd) – changes data to connect to the database, performing connect() is required afterwards<\/li>
- rollbackTransaction<\/strong>() – reverse changes performed in a transaction;<\/li>
- setAttribute<\/strong>(func_get_args()) – sets attributes for a database connection http:\/\/php.net\/manual\/en\/pdo.setattribute.php<\/a>;<\/li>
- setDatabaseHost<\/strong>($host) – saves host name;<\/li>
- setDatabaseName<\/strong>($dbname) – save database name;<\/li>
- setDatabaseType<\/strong>($type) – saves connection;<\/li>
- setDieOnError<\/strong>($bool) – sets whether a script should be stopped when an error appears;<\/li>
- setUserName<\/strong>($name) – saves host name;<\/li>
- setUserPassword<\/strong>($pass) – saves host name;<\/li>
- sql_escape_string<\/strong>($str) -protects values in sql query;<\/li>
- sqlExprDatalist<\/strong>($array) – creates a string (’44’,’66’,’777′) from a array with protected values;<\/li>
- startTransaction<\/strong>() – ends transaction;<\/li>
- updateBlob<\/strong>($table, $column, $val, $where) – updates data.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"
$adb = PearDatabase::getInstance(); Exemplo de c\u00f3digo: Lista de fun\u00e7\u00f5es bind($param, $value, $type = null) – adds parameters to a query http:\/\/php.net\/manual\/en\/pdostatement.bindvalue.php; checkError($message, $dieOn-Error = false) –…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":2,"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":214,"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/posts\/212\/revisions\/214"}],"wp:attachment":[{"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humanizati.com.br\/blog\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}