| [6] | 1 | <?php |
|---|
| 2 | |
|---|
| 3 | class data_search extends data |
|---|
| 4 | { |
|---|
| 5 | |
|---|
| 6 | function search($match) |
|---|
| 7 | { $results = array |
|---|
| 8 | ( "has_results" => false, |
|---|
| 9 | "match" => $match, |
|---|
| 10 | "artistes" => array(), |
|---|
| 11 | "downloads" => array(), |
|---|
| 12 | "albums" => array() |
|---|
| 13 | ); |
|---|
| 14 | try |
|---|
| 15 | { if($match) |
|---|
| 16 | { $sql = |
|---|
| 17 | "SELECT id, nom, style, image" |
|---|
| 18 | ." FROM #--artistes" |
|---|
| 19 | ." WHERE nom LIKE ".$this->eq("%".$match."%") |
|---|
| 20 | ." OR style LIKE ".$this->eq("%".$match."%"); |
|---|
| 21 | $rst = $this->sql->query($sql); |
|---|
| 22 | while($v_rst = $this->sql->fetch_assoc($rst)) $results["artistes"][$v_rst["id"]] = $v_rst; |
|---|
| 23 | $this->sql->free_result($rst); |
|---|
| 24 | |
|---|
| 25 | $sql = |
|---|
| 26 | "SELECT #--downloads.*" |
|---|
| 27 | .", #--downloads.id as id_download" |
|---|
| 28 | .", #--downloads.nom as titre" |
|---|
| 29 | .", #--downloads.date_creation as date_created" |
|---|
| 30 | .", #--artistes.id as id_artiste" |
|---|
| 31 | .", #--artistes.nom as auteur" |
|---|
| 32 | .", #--licences.nom as licence" |
|---|
| 33 | .", #--licences.lien as licence_url" |
|---|
| 34 | ." FROM #--artistes" |
|---|
| 35 | .", #--downloads" |
|---|
| 36 | .", #--licences" |
|---|
| 37 | ." WHERE #--downloads.id_artiste=#--artistes.id" |
|---|
| 38 | ." AND #--downloads.id_licence=#--licences.id" |
|---|
| 39 | ." AND actif=1" |
|---|
| 40 | ." AND #--downloads.nom LIKE ".$this->eq("%".$match."%"); |
|---|
| 41 | $rst = $this->sql->query($sql); |
|---|
| 42 | while($v_rst = $this->sql->fetch_assoc($rst)) |
|---|
| 43 | { $results["downloads"][$v_rst["id"]] = $v_rst; |
|---|
| 44 | $results["downloads"][$v_rst["id"]]["urls"] = array(); |
|---|
| 45 | $u_sql = |
|---|
| 46 | "SELECT #--download_urls.*, #--formats.nom as format" |
|---|
| 47 | ." FROM #--download_urls, #--formats" |
|---|
| 48 | ." WHERE id_download=".$v_rst["id"] |
|---|
| 49 | ." AND #--download_urls.id_format=#--formats.id"; |
|---|
| 50 | $u_rst = $this->sql->query($u_sql); |
|---|
| 51 | while($v_u_rst = $this->sql->fetch_assoc($u_rst)) |
|---|
| 52 | { $results["downloads"][$v_rst["id"]]["urls"][$v_u_rst["id"]] = $v_u_rst; |
|---|
| 53 | if($v_u_rst["format"] === "mp3") |
|---|
| 54 | { $results["downloads"][$v_rst["id"]]["mp3_id_url"] = $v_u_rst["id"]; |
|---|
| 55 | $results["downloads"][$v_rst["id"]]["mp3_url"] = $v_u_rst["url"]; |
|---|
| 56 | } |
|---|
| 57 | } |
|---|
| 58 | $this->sql->free_result($u_rst); |
|---|
| 59 | } |
|---|
| 60 | $this->sql->free_result($rst); |
|---|
| 61 | |
|---|
| 62 | $results["has_results"] = |
|---|
| 63 | $results["artistes"] |
|---|
| 64 | || $results["downloads"] |
|---|
| 65 | || $results["albums"]; |
|---|
| 66 | } |
|---|
| 67 | } |
|---|
| 68 | catch(Exception $_e) { $results = false; } |
|---|
| 69 | return $results; |
|---|
| 70 | } |
|---|
| 71 | |
|---|
| 72 | } |
|---|
| 73 | |
|---|
| 74 | ?> |
|---|
