function url_photo($photoID) { $select_db = connect_MySQL(); $select_sql = "SELECT photoURL FROM photo WHERE photoID=:photoID"; $select_query = $select_db->prepare($select_sql); $select_query->bindValue(':photoID', $photoID); try { $select_query->execute(); } catch (PDOException $e) { $select_query = null; return $e->getMessage(); } return $select_query->fetchAll(PDO::FETCH_ASSOC); }
function delete_all($all, $id) { $delete_db = connect_MySQL(); $delete_id = $all . 'ID'; $delete_sql = "DELETE FROM {$all} WHERE {$delete_id}=:id"; $delete_query = $delete_db->prepare($delete_sql); $delete_query->bindValue(':id', $id); try { $delete_query->execute(); } catch (PDOException $e) { $delete_query = null; return $e->getMessage(); } return null; }