Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 25th, 2012  |  syntax: None  |  size: 1.23 KB  |  hits: 5  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Multidimensinal array handing in PHP
  2. aid (albumid)    |    sid (songid)    |    rid (artistid)
  3. _________________|____________________|___________________
  4.  
  5. 5001             |    track-a         |    a    
  6. 5002             |    track-a         |    c    
  7. 5001             |    track-a         |    a:b
  8. 5001             |    track-a         |    b
  9. 5001             |    track-a         |    b:c
  10. 5001             |    track-b         |    b
  11. 5001             |    track-b         |    b:a
  12.        
  13. $track is array of track
  14. $artist is array of artist (for artist combination array value may have ":", I have taken it as string.)
  15. //SELECT QUERY FOR ALBUM
  16. if (mysql_num_rows($sql) != 0) {
  17.         while ($row = mysql_fetch_assoc($sql)) {
  18.             $album_array[] = array( $row["sid"], $row["rid"]);
  19.         }
  20.     for ($z = 0; $z < count($track); $z++) {
  21.     if( in_array($track["z"],$album_array[0]) && empty(array_diff(explode(":",$album_array[1]), explode(":",$artist["z"]) )) ){
  22.        echo 'true';
  23.     } else {
  24.        echo 'false';    
  25.     }
  26. }
  27.  
  28. } else {
  29.  //SIMPLE INSERT CODE HERE
  30. }
  31.        
  32. track-a    |    a
  33.   track-a    |    b
  34.   track-a    |    b:a
  35.   track-a    |    a:c
  36.        
  37. -TRUE
  38. -TRUE
  39. -TRUE
  40. -FALSE
  41.        
  42. $track["z"] and $artist["z"]
  43.        
  44. $track[$z] and $artist[$z]