public function get_mapped_domain($blog_id) { $domain_mapping_table_name = $this->add_prefix('domain_mapping'); try { $data = $this->dbconnection->query("SELECT * FROM `{$domain_mapping_table_name}` WHERE `blog_id`={$blog_id}"); } catch (PDOException $e) { script_die("Unable to get '{$this->name}' domain mapping data.", "SELECT * FROM `{$domain_mapping_table_name}` WHERE `blog_id`={$blog_id}", $e->getMessage()); } if ($data->rowCount() > 0) { $row = $data->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT); return $row['domain']; } return NULL; }
public function get_table_row_list($table_name, $row_count, $limit = 1000) { $offset = $row_count * $limit; try { $data = $this->dbconnection->query("SELECT * FROM `{$table_name}` LIMIT {$limit} OFFSET {$offset}"); } catch (PDOException $e) { script_die("Unable to get '{$this->name}' '{$table_name}' data.", "SELECT * FROM `{$table_name}` LIMIT {$limit} OFFSET {$offset}", $e->getMessage()); } if ($data->rowCount() > 0) { return $data->fetchAll(PDO::FETCH_ASSOC); } return NULL; }
public function get_table_primary_key($dbname, $table_name) { $column_name = NULL; $select_sql = "SELECT `COLUMN_NAME` FROM `information_schema`.`COLUMNS` WHERE (`TABLE_SCHEMA`='{$dbname}') AND (`TABLE_NAME`='{$table_name}') AND (`COLUMN_KEY`='PRI')"; try { $primary_key = $this->dbconnection->query($select_sql); $column_name = $primary_key->fetchColumn(0); } catch (PDOException $e) { script_die('Unable to retrieve the primary key for table "' . $table_name . '".', "SELECT `COLUMN_NAME` FROM `COLUMNS` WHERE (`TABLE_SCHEMA`='{$dbname}') AND (`TABLE_NAME`='{$table_name}') AND (`COLUMN_KEY`='PRI')", $e->getMessage()); } return $column_name; }
public function insert($row, $name, $dbname, $table_name) { $columns = $this->db->escape_fields($row, $dbname, $table_name); try { $this->dbconnection->query("INSERT INTO {$table_name} (`" . implode('`,`', array_keys($columns)) . "`) VALUES (" . implode(',', $columns) . ");"); } catch (PDOException $e) { script_die("Unable to insert `{$this->name}`.`{$name}` row.", "INSERT INTO {$table_name} (`" . implode('`,`', array_keys($columns)) . "`) VALUES (" . implode(',', $columns) . ");", $e->getMessage()); } }