Comparing Values

[John]

ok, well ive managed to build 2 little scripts, 1 that lists all the themes for a cms that are located in a certian directory, and another script that lists all the themes for a cms that have been added to a the database. however, what i want to do, is have a list that shows all the themes in the directory that have not been added to the database yet.


Lists all the themes in the themes folder:

PHP Code:

$dir = "../themes/";
if (is_dir($dir)) {
   if ($dh = opendir($dir)) {
       while (($file = readdir($dh)) !== false) {
            if(file_exists("../themes/$file/theme.php")){
           $themelist .= "$file ";
            }
       }
       closedir($dh);
   }
}
$themelist = explode(" ", $themelist);
sort($themelist);

for ($i=0; $i < sizeof($themelist); $i++) {
if($themelist[$i]!=""){

echo $themelist[$i] . "<br>";

}
} 


Lists all the themes that have been added to the database:

PHP Code:

$q = "SELECT * FROM nuke_theme_preview";
$result = mysql_query($q) or die ('Something is wrong with query: ' . $q . '<br>'. mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo $row['t_title'] . "<br>";
} 


What i want done is something that will list all the themes in the directory that are not in the database. I believe I have to use the IN ( ) MySQL construct, but i have no idea how to format the syntax. could someone give me a hand

Thank You.

[dirkfirst]

You can use array to do this

PHP Code:


// Create array here
$themelist = array("");

$dir = "../themes/"; 
if (is_dir($dir)) { 
   if ($dh = opendir($dir)) { 
       while (($file = readdir($dh)) !== false) { 
            if(file_exists("../themes/$file/theme.php")){ 

                 array_push($themelist, $file); // Add value to array

           } 
       } 
       closedir($dh); 
   } 
} 

$q = "SELECT * FROM nuke_theme_preview"; 
$result = mysql_query($q) or die ('Something is wrong with query: ' . $q . '<br>'. mysql_error()); 
while ($row = mysql_fetch_assoc($result)) 
{ 
     array_push($themelist, $row['t_title']); // Add value to array
} 


[size="3"][b]// Make the array only have unique values
$unqThemeList = array_unique($themelist);

// Cycle through the $unqThemeList array and print
...... 


[John]

was this suppose to be in the code?

[size="3"][b]

Edit: i removed that line and it kind of works, however it lists every values, both in the directory and in the database.
Array ( [0] => [1] => 3D-Fantasy [2] => Anagram [3] => DeepBlue [4] => ExtraLite [5] => Kaput [6] => Karate [7] => Milo [8] => NukeNews [9] => Odyssey [10] => Sand_Journey [11] => Slash [12] => SlashOcean [13] => Sunset [14] => Traditional )

In the database i have these themes 3D-Fantasy, Anagram, DeepBlue, ExtraLite, and Kaput.
In the directory i have these themes 3D-Fantasy, Anagram, DeepBlue, ExtraLite, Kaput, Karat, Milo, NukeNews, Odyssey, Sand_Journey, Slash, SlashOcean, Sunset, and Traditional. Therefor i want the array to output

Array ( [0] => [1] => Karat [2] => Milo [3] => NukeNews [4] => Odyssey [5] => Sand_Journey [6], Slash[7], SlashOcean[8], Sunset[9], Traditional )

Its probabley just a minor adjustment, ill see what i can do, but in the mean time ill post it for everyone elses branes to work on too

[John]

well after a few hours of deep thought i got it, thank you for pushing me in the right direction

Finished Code:

PHP Code:

include("config.php");
// Create array here

echo "<select name='t_title'>";
$themelist = array();
$dir = "../demo/themes/";
if (is_dir($dir)) {
   if ($dh = opendir($dir)) {
       while (($file = readdir($dh)) !== false) {
            if(file_exists("../demo/themes/$file/theme.php")){

                 array_push($themelist, $file); // Add value to array

           }
       }
       closedir($dh);
   }
}
$dbThemeList = array();
$q = "SELECT * FROM nuke_theme_preview";
$result = mysql_query($q) or die ('Something is wrong with query: ' . $q . '<br>'. mysql_error());
while ($row = mysql_fetch_assoc($result))
{
     array_push($dbThemeList, $row['t_title']); // Add value to array
}
$newThemes = array_filter($themelist, create_function('$elt', 'return !in_array($elt,' . var_export($dbThemeList, true) . ');'));


for ($i=0; $i < sizeof($themelist); $i++) {
if($newThemes[$i]!=""){

echo "<option value='" . $newThemes[$i] . "' name='t_title'>" . $newThemes[$i] . "</option>";
}
}
echo "</select>"; 


[Lop]

Nice work. I think you learn best when you figure out things this way.