ravinderk /
Give
| @@ 124-136 (lines=13) @@ | ||
| 121 | * |
|
| 122 | * @return object |
|
| 123 | */ |
|
| 124 | public function get_by( $column, $row_id ) { |
|
| 125 | /* @var WPDB $wpdb */ |
|
| 126 | global $wpdb; |
|
| 127 | ||
| 128 | // Bailout. |
|
| 129 | if ( empty( $column ) || empty( $row_id ) ) { |
|
| 130 | return null; |
|
| 131 | } |
|
| 132 | ||
| 133 | $column = esc_sql( $column ); |
|
| 134 | ||
| 135 | return $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $this->table_name WHERE $column = %s LIMIT 1;", $row_id ) ); |
|
| 136 | } |
|
| 137 | ||
| 138 | /** |
|
| 139 | * Retrieve a specific column's value by the primary key |
|
| @@ 149-161 (lines=13) @@ | ||
| 146 | * |
|
| 147 | * @return string Column value. |
|
| 148 | */ |
|
| 149 | public function get_column( $column, $row_id ) { |
|
| 150 | /* @var WPDB $wpdb */ |
|
| 151 | global $wpdb; |
|
| 152 | ||
| 153 | // Bailout. |
|
| 154 | if ( empty( $column ) || empty( $row_id ) ) { |
|
| 155 | return null; |
|
| 156 | } |
|
| 157 | ||
| 158 | $column = esc_sql( $column ); |
|
| 159 | ||
| 160 | return $wpdb->get_var( $wpdb->prepare( "SELECT $column FROM $this->table_name WHERE $this->primary_key = %s LIMIT 1;", $row_id ) ); |
|
| 161 | } |
|
| 162 | ||
| 163 | /** |
|
| 164 | * Retrieve a specific column's value by the the specified column / value |
|
