fetch_assoc()) { header('Location: /studentfield/' . rawurlencode($row['seo_field']), true, 301); exit; } $redirect->free(); } } if ($degtypeSlug !== '' && !$hasStudentDegreeType) { header('Location: /studentdegreetype/' . rawurlencode($degtypeSlug), true, 301); exit; } if ($gradSlug !== '' && !$hasStudentGrad) { $targetGrad = (strcasecmp($gradSlug, 'Graduate') === 0) ? 'Graduate' : 'Under-Graduate'; header('Location: /studentgrad/' . rawurlencode($targetGrad), true, 301); exit; } $fieldDisplayName = $fieldSlug !== '' ? str_replace('-', ' ', $fieldSlug) : ''; $selectedState = trim($_POST['state'] ?? ''); $selectedDegreeTypeId = trim($_POST['degreetype'] ?? ''); $selectedDegreeNameId = trim($_POST['degreename'] ?? ''); $searchTerm = trim($_POST['search'] ?? ''); $prefetchedDegreeType = null; if ($degtypeSlug !== '') { $res = runPrepared( "SELECT degreetypeid, degreetype FROM amazonrds.collegedegreetypes WHERE seo_friendly = ? LIMIT 1", 's', [$degtypeSlug] ); if ($res instanceof mysqli_result) { $prefetchedDegreeType = $res->fetch_assoc() ?: null; $res->free(); } if ($prefetchedDegreeType) { $selectedDegreeTypeId = (string) $prefetchedDegreeType['degreetypeid']; } } $degTypeName = $prefetchedDegreeType['degreetype'] ?? ($degtypeSlug !== '' ? str_replace('-', ' ', $degtypeSlug) : ''); $prefetchedDegreeName = null; if ($fieldSlug !== '') { $res = runPrepared( "SELECT degreenameid, degreename FROM amazonrds.collegedegreenames WHERE seo_friendly = ? LIMIT 1", 's', [$fieldSlug] ); if ($res instanceof mysqli_result) { $prefetchedDegreeName = $res->fetch_assoc() ?: null; $res->free(); } if ($prefetchedDegreeName) { $selectedDegreeNameId = (string) $prefetchedDegreeName['degreenameid']; $fieldDisplayName = $prefetchedDegreeName['degreename']; } } // Title & meta $titleSegments = []; if ($gradSlug !== '') { $titleSegments[] = "{$gradSlug} Theater Colleges and Degrees"; } if ($fieldDisplayName !== '') { $titleSegments[] = "{$fieldDisplayName} Theater Degrees"; } if ($degTypeName !== '') { $titleSegments[] = "{$degTypeName} Theater Colleges and Degrees"; } $titleSuffix = 'Theater Colleges'; $title = (empty($titleSegments) ? '' : implode(' - ', $titleSegments) . ' - ') . $titleSuffix; if ($gradSlug !== '') { $meta_description = "{$gradSlug} Theater Colleges and {$gradSlug} Degree Information"; } elseif ($degTypeName !== '') { $meta_description = "{$degTypeName} Theater Colleges and {$degTypeName} Degree Information"; } elseif ($fieldDisplayName !== '') { $meta_description = "{$fieldDisplayName} Theater Colleges and {$fieldDisplayName} Degree Information"; } else { $meta_description = "What is the best college for musical theatre? The best university to get an MFA and more? Find out here! BroadwayWorld's comprehensive Student Center features a complete database of every University across the United States that offers performing arts programs."; } $extra_meta = ''; if ($fieldSlug !== '') { $actual_link = 'https://www.broadwayworld.com/studentfield/' . rawurlencode($fieldSlug); } elseif ($degtypeSlug !== '') { $actual_link = 'https://www.broadwayworld.com/studentdegreetype/' . rawurlencode($degtypeSlug); } else { $actual_link = 'https://www.broadwayworld.com/studentcenter-college-guide.php'; } // Form dropdown data $statesResult = doQuery('SELECT DISTINCT state FROM amazonrds.colleges ORDER BY state'); $states = []; if ($statesResult instanceof mysqli_result) { while ($row = $statesResult->fetch_assoc()) { if (isset($row['state']) && $row['state'] !== '') { $states[] = $row['state']; } } $statesResult->free(); } $degreeTypesResult = doQuery('SELECT degreetypeid, degreetype FROM amazonrds.collegedegreetypes ORDER BY degreetype'); $degreeTypes = []; if ($degreeTypesResult instanceof mysqli_result) { while ($row = $degreeTypesResult->fetch_assoc()) { $degreeTypes[] = $row; } $degreeTypesResult->free(); } $degreeNamesResult = doQuery('SELECT degreenameid, degreename FROM amazonrds.collegedegreenames ORDER BY degreename'); $degreeNames = []; if ($degreeNamesResult instanceof mysqli_result) { while ($row = $degreeNamesResult->fetch_assoc()) { $degreeNames[] = $row; } $degreeNamesResult->free(); } // College listing query $sql = <<fetch_assoc()) { $collegeRows[] = $row; } $collegeResult->free(); } $browseDegreeTypesResult = doQuery('SELECT degreetype, seo_friendly FROM amazonrds.collegedegreetypes ORDER BY degreetype'); $browseDegreeTypes = []; if ($browseDegreeTypesResult instanceof mysqli_result) { while ($row = $browseDegreeTypesResult->fetch_assoc()) { $browseDegreeTypes[] = $row; } $browseDegreeTypesResult->free(); } $browseDegreeNamesResult = doQuery('SELECT degreename, seo_friendly FROM amazonrds.collegedegreenames ORDER BY degreename'); $browseDegreeNames = []; if ($browseDegreeNamesResult instanceof mysqli_result) { while ($row = $browseDegreeNamesResult->fetch_assoc()) { $browseDegreeNames[] = $row; } $browseDegreeNamesResult->free(); } require_once 'tpl/headernew.php'; ?>

Degree Degree THEATER COLLEGE PROGRAM GUIDE


Home Scholarships Show Calendar Blogs News
University School City State


Browse By Degree Type: ' . htmlspecialchars($row['degreetype']) . ''; } echo implode(' | ', $degreeTypeLinks); ?>


Browse By Major: ' . htmlspecialchars($row['degreename']) . ''; } echo implode(' | ', $degreeNameLinks); ?>