PluginWfMysql

Handle MySql.

Character Description i corresponding variable has type integer d corresponding variable has type double s corresponding variable has type string b corresponding variable is a blob and will be sent in packets

widget_test

  Widget setup
  
type: widget
data:
  plugin: wf/mysql
  method: test
  data:
    server: localhost
    database: openchart
    user_name: openchart
    password: 1234
    sql: 'select * from oc_layout where name = ''Home'';'

A widget to test your MySql database.

open

Get db object.

get_time_zone

runSql

Run a query and return result in an array. @param string $sql @param string $key_field (set to false to never render keys) @return array

execute

@param array $data @param array $params, array('rs' => array('name' => 'James')) @return boolean Example of array: $data = array( 'sql' => 'INSERT INTO people (id, pid, first_name, last_name, user_id) VALUES (?, ?, ?, ?, ?);', 'params' => array( array('type' => 's', 'value' => wfCrypt::getUid()), array('type' => 's', 'value' => '20030303-3322'), array('type' => 's', 'value' => "molly'=1"), array('type' => 's', 'value' => 'ostlund'), array('type' => 's', 'value' => $user->get('user_id')) ) );

getLastInsertId

Get last insert id.

getSqlScript

Get sql script where params are parsed. @return string

str_replace_first

Replace first find character.

getStmtAsArray

@return array

getStmtAsArrayOne

getStmt

@return type

transaction_start

transaction_end

getMany

getOne

get_sever_version

getSqlFromFile

Dependencies

Usage