ravinderk /
Give
| @@ 137-149 (lines=13) @@ | ||
| 134 | * |
|
| 135 | * @return object |
|
| 136 | */ |
|
| 137 | public function get_by( $column, $row_id ) { |
|
| 138 | /* @var WPDB $wpdb */ |
|
| 139 | global $wpdb; |
|
| 140 | ||
| 141 | // Bailout. |
|
| 142 | if ( empty( $column ) || empty( $row_id ) ) { |
|
| 143 | return null; |
|
| 144 | } |
|
| 145 | ||
| 146 | $column = esc_sql( $column ); |
|
| 147 | ||
| 148 | return $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $this->table_name WHERE $column = %s LIMIT 1;", $row_id ) ); |
|
| 149 | } |
|
| 150 | ||
| 151 | /** |
|
| 152 | * Retrieve all rows by a specific column / value |
|
| @@ 162-174 (lines=13) @@ | ||
| 159 | * |
|
| 160 | * @return array |
|
| 161 | */ |
|
| 162 | public function get_results_by( $column, $row_id ) { |
|
| 163 | /* @var WPDB $wpdb */ |
|
| 164 | global $wpdb; |
|
| 165 | ||
| 166 | // Bailout. |
|
| 167 | if ( empty( $column ) || empty( $row_id ) ) { |
|
| 168 | return null; |
|
| 169 | } |
|
| 170 | ||
| 171 | $column = esc_sql( $column ); |
|
| 172 | ||
| 173 | return $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $this->table_name WHERE $column = %s;", $row_id ) ); |
|
| 174 | } |
|
| 175 | ||
| 176 | /** |
|
| 177 | * Retrieve a specific column's value by the primary key |
|
| @@ 187-199 (lines=13) @@ | ||
| 184 | * |
|
| 185 | * @return string Column value. |
|
| 186 | */ |
|
| 187 | public function get_column( $column, $row_id ) { |
|
| 188 | /* @var WPDB $wpdb */ |
|
| 189 | global $wpdb; |
|
| 190 | ||
| 191 | // Bailout. |
|
| 192 | if ( empty( $column ) || empty( $row_id ) ) { |
|
| 193 | return null; |
|
| 194 | } |
|
| 195 | ||
| 196 | $column = esc_sql( $column ); |
|
| 197 | ||
| 198 | return $wpdb->get_var( $wpdb->prepare( "SELECT $column FROM $this->table_name WHERE $this->primary_key = %s LIMIT 1;", $row_id ) ); |
|
| 199 | } |
|
| 200 | ||
| 201 | /** |
|
| 202 | * Retrieve a specific column's value by the the specified column / value |
|
