Tag: query

Agile Toolkit PHP

Agile Toolkit Database Digest

Connecting to Database Agile Toolkit API has a function dbConnect() which will automatically read DB configuration from your configuration file and initialize connection. When connection is created, the connection object is accessible through through $api->db property. If you wish, you can create connections to other databases by calling: $dsn=array(‘mysql:host=localhost;dbname=testdb’, $username, $password, $options); $mydb=$this->add(‘DB’)->connect($dsn); . Creating […]

Mysql

Mysql Set Query Digest

Replace: UPDATE tablename SET tablefield = replace(tablefield,”findstring”,”replacestring”); UPDATE tablename SET column1 = “text1″ WHERE¬† column2 =”text2”;