?php 
$db = mysql_connect('localhost','root','Ctrip07185419') or die('can not connect to mysql');
mysql_select_db('moviesite',$db) or die(mysql_error($db));
mysql_query('set names gbk',$db);
if(isset($_GET['action'])  $_GET['action'] == 'edit') 
{
    $query = 'SELECT movie_name,movie_type,movie_year,movie_leadactor,movie_director FROM movie WHERE movie_id='.$_GET['id'];
    //echo $query;
    $result = mysql_query($query , $db) or die(mysql_error($db));
    extract(mysql_fetch_assoc($result));
}
else
{
    $movie_name='';
    $movie_type=0;
    $movie_year=date('Y');
    $movie_leadactor=0;
    $movie_director=0;
}
?>
html>
    head>
        title>?php echo ucfirst($_GET['action']);?> Movie/title>
        style type="text/css">/style>
    /head>
    body> 
        form action="commit.php?action=?php echo $_GET['action'];?>type=movie" method="post"> 
            table>
                tr>
                    td>Movie Name/td>
                    td>input type="text" name="movie_name" value="?php echo $movie_name;?>"/>/td>
                /tr>
                tr>
                    td>Movie Type/td>
                    td>select name="movie_type" id="">
                    ?php 
                        $query = 'select movietype_id,movietype_label from movietype order by movietype_label';
                        $result = mysql_query($query , $db) or die(mysql_error($db));
                        while($row = mysql_fetch_assoc($result))
                        {
                            if($row['movietype_id'] == $movie_type)
                            {
                                echo 'option value="'.$row["movietype_id"].'" selected="selected">'.$row["movietype_label"].'/option>';
                            }
                            else
                            {
                                echo 'option value="'.$row["movietype_id"].'">'.$row["movietype_label"].'/option>';
                            }
                        }
                    ?>
                    /select>/td>
                /tr>
                tr>
                    td>Movie Year/td>
                    td>select name="movie_year" id="">
                    ?php 
                        for($yr = date('Y');$yr>1970;$yr--)
                        {
                            if($yr == $movie_year)
                            {
                                echo 'option value="'.$yr.'" selected="selected">'.$yr.'/option>';
                            }
                            else
                            {
                                echo 'option value="'.$yr.'">'.$yr.'/option>';
                            }
                        }
                    ?>
                    /select>/td>
                /tr>
                tr>
                    td>Lead actor/td>
                    td>select name="movie_leadactor" id="">
                    ?php 
                        $query = 'select people_id,people_fullname from people where people_isactor = 1 order by people_fullname';
                        $result = mysql_query($query,$db) or die(mysql_error($db));
                        while($row = mysql_fetch_assoc($result))
                        {
                            if($row["people_id"] == $movie_leadactor)
                            {
                                echo 'option value="'.$row["people_id"].'" selected="selected">'.$row["people_fullname"].'/option>';
                            }
                            else
                            {
                                echo 'option value="'.$row["people_id"].'">'.$row["people_fullname"].'/option>';
                            }
                            
                        }
                    ?>
                    /select>/td>
                /tr>
                tr>
                    td>Director/td>
                    td>select name="movie_director" id="">
                    ?php
                        $query = 'select * from people where people_isdirector=1 order by people_fullname';
                        $result = mysql_query($query , $db) or die(mysql_error($db));
                        while($row = mysql_fetch_assoc($result))
                        {
                            if($row['people_id'] == $movie_director)
                            {
                                echo 'option value="'.$row['people_id'].'" selected="selected">'.$row["people_fullname"].'/option>';
                            }
                            else
                            {
                                echo 'option value="'.$row['people_id'].'">'.$row["people_fullname"].'/option>';
                            }
                        }
                    ?>
                    /select>/td>
                /tr>
                tr>
                    td colspan="2" style="text-align:center">
                        ?php 
                        if('edit' == $_GET['action'])
                        {
                            echo 'input type="hidden" value="'.$_GET["id"].'" name="movie_id"/>';
                        }
                        ?>
                        input type="submit" name="submit" value="?php echo ucfirst($_GET['action']);?>"/>
                    /td>
                /tr>
            /table>
        /form>
    /body>
/html>