
Untitled
By: a guest on
Apr 25th, 2012 | syntax:
None | size: 1.23 KB | hits: 5 | expires: Never
Multidimensinal array handing in PHP
aid (albumid) | sid (songid) | rid (artistid)
_________________|____________________|___________________
5001 | track-a | a
5002 | track-a | c
5001 | track-a | a:b
5001 | track-a | b
5001 | track-a | b:c
5001 | track-b | b
5001 | track-b | b:a
$track is array of track
$artist is array of artist (for artist combination array value may have ":", I have taken it as string.)
//SELECT QUERY FOR ALBUM
if (mysql_num_rows($sql) != 0) {
while ($row = mysql_fetch_assoc($sql)) {
$album_array[] = array( $row["sid"], $row["rid"]);
}
for ($z = 0; $z < count($track); $z++) {
if( in_array($track["z"],$album_array[0]) && empty(array_diff(explode(":",$album_array[1]), explode(":",$artist["z"]) )) ){
echo 'true';
} else {
echo 'false';
}
}
} else {
//SIMPLE INSERT CODE HERE
}
track-a | a
track-a | b
track-a | b:a
track-a | a:c
-TRUE
-TRUE
-TRUE
-FALSE
$track["z"] and $artist["z"]
$track[$z] and $artist[$z]