AGCP Code

<?php
include("functions.php");
switch ($_GET['page']) {
	case "list":
$link = mysql_connect("$mysqlhost", "$mysqluser", "$mysqlpass")
    or die('Could not connect: ' . mysql_error());
mysql_select_db("$mysqldb") or die('Could not select database');
$query = 'SELECT name FROM encoders ORDER BY `name` ASC ';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

echo "<form action=\"\">\n<select name=\"encoder\">\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    foreach ($line as $col_value) {
        echo "\t\t<option value=\"$col_value\">$col_value</option>\n";
    }
}
echo "</select>\n</form>\n";

mysql_free_result($result);
mysql_close($link);
break;

case "add":
if (isset($_POST['name'])) {
$encname = $_POST['name'];
$nameinfile = $_POST['nfile'];
$link = mysql_connect("$mysqlhost", "$mysqluser", "$mysqlpass")
    or die('Could not connect: ' . mysql_error());
mysql_select_db('anime') or die('Could not select database');
$query = "INSERT INTO `encoders` (`id`, `name`, `name_in_file`) VALUES (NULL, '$encname', '$nameinfile');";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "$encname successfully added with $nameinfile";
break;
} else {
include("encoder.html");
break;
}
}
?>