private static function setup_database() { if (!self::$_db_loaded) { $host = CMS\Libraries\Config::get('db_host'); $database = CMS\Libraries\Config::get('db_database'); $username = CMS\Libraries\Config::get('db_username'); $password = CMS\Libraries\Config::get('db_password'); CMS\Libraries\ORM::configure("mysql:host={$host};dbname={$database}"); CMS\Libraries\ORM::configure('username', $username); CMS\Libraries\ORM::configure('password', $password); self::$_db_loaded = true; // At this point we are not in love with our ORM so use the Cloudmanic database // library which we included via composer. (TODO: We should get rid of the ORM above at // some point). Cloudmanic\Database\DB::connection($host, $username, $password, $database); } }
<?php ini_set('display_errors', 1); error_reporting(E_ALL); require 'vendor/autoload.php'; // Static version Cloudmanic\Database\DB::connection('HOSTNAME HERE', 'USERNAME HERE', 'PASS HERE', 'DATABASE HERE'); Cloudmanic\Database\DB::set_table('Users'); $query = array('UsersFirstName' => 'Lady', 'UsersLastName' => 'Gaga'); $id = Cloudmanic\Database\DB::insert($query); echo '<pre>' . print_r($id, TRUE) . '</pre>'; // Instance version $db = new Cloudmanic\Database\Instance('HOSTNAME HERE', 'USERNAME HERE', 'PASS HERE', 'DATABASE HERE'); $db->set_table('Users'); $query = array('UsersFirstName' => 'Katie', 'UsersLastName' => 'Perry'); $id = $db->insert($query); echo '<pre>' . print_r($id, TRUE) . '</pre>';
<?php $d = array(); Cloudmanic\Database\DB::set_select('DISTINCT ' . $field['LookAhead_Column']); foreach (Cloudmanic\Database\DB::set_table($field['LookAhead_Table'])->get() as $key2 => $row2) { if (!empty($row2[$field['LookAhead_Column']])) { $d[] = $row2[$field['LookAhead_Column']]; } } $array = json_encode($d); ?> <input type="text" data-provide="typeahead" name="<?php echo $row->name; ?> " value="<?php echo set_value($row->name, element($row->name, $data, '')); ?> " data-source='<?php echo $array; ?> ' />
<?php ini_set('display_errors', 1); error_reporting(E_ALL); require 'vendor/autoload.php'; // Static version. Cloudmanic\Database\DB::connection('HOSTNAME HERE', 'USERNAME HERE', 'PASS HERE', 'DATABASE HERE'); Cloudmanic\Database\DB::set_table('Users')->get(); $d = Cloudmanic\Database\DB::get(); echo '<pre>' . print_r($d, TRUE) . '</pre>'; // Instance version $db = new Cloudmanic\Database\Instance('HOSTNAME HERE', 'USERNAME HERE', 'PASS HERE', 'DATABASE HERE'); $db->set_table('Users')->get(); echo '<pre>' . print_r($d, TRUE) . '</pre>';