[RESOLVED] String Replace trouble

[aaronfenker]

What I'm trying to do is draw a list of tables from a database, and then reinterpret the name of the table so that it is understandable to the user and display it, but I'm having trouble making it work.

mysql_select_db($database);

$query = "SHOW TABLES";

$result = mysql_query($query);
$rows = mysql_num_rows($result);

while($num = mysql_fetch_array($result)) {
$term[] = $num[0];
}

$number = count($term);

for ($i = 0; $i < $number; $i++) {
    echo $i . "<br />";
    if (strpbrk($term[$i], "1020")) {
        $list[$i] = str_replace("1020_", "Summer Semester '", $term[$i]);
        echo "test 1<br />";
    } elseif (strpbrk($term[$i], "1030")) {
        $list[$i] = str_replace("1030_", "Winter Short Term '", $term[$i]);
        echo "test 2<br />";
    } elseif (strpbrk($term[$i], "2020")) {
        $list[$i] = str_replace("2020_", "Winter Semester '", $term[$i]);
        echo "test 3<br />";
    } elseif (strpbrk($term[$i], "2030")) {
        $list[$i] = str_replace("2030_", "Spring Short Term '", $term[$i]);
        echo "test 4<br />";
    } elseif (strpbrk($term[$i], "3020")) {
        $list[$i] = str_replace("3020_", "Summer Short Term '", $term[$i]);
        echo "test 5<br />";
    } else {
        die("ERROR!  Please contact your web administrator!");
    }
    echo $list[$i] . "<br /><br />";
}

This outputs:

0
test 1
Summer Semester '07

1
test 1
1030_07

2
test 1
2020_08

3
test 1
2030_08

4
test 1
3020_08

I don't understand why the for loop isn't executing the other ifelse() statements.

[NogDog]

I don't think strpbrk does what you think it does. It returns a string from the supplied string starting at the first character that matches any of the characters supplied in the second arg.

What I'd probably do is something like:

$search = array(
   '1020_' => "Summer Semester '",
   '1030_' => "Winter Short Term '",
   '2020_' => "Winter Semester '",
   '2030_' => "Spring Short Term '",
   '3020_' => "Summer Short Term '"
);

for ($i = 0; $i < $number; $i++) {
   $list[$i] = str_replace(array_keys($search), $search, $term[$i]);
   // echo etc.
}