Untitled

<?php if(isset($_POST['submit'])){
    $name= $_POST['placename'];
    $description=$_POST['description'];
    $type=$_POST['place_type'];
    $add=$_POST['address'];
    $website=$_POST['website'];
    $city=$_POST['city'];
    if(strlen($name)!=0 && strlen($description)!=0 && $type!='choose' && strlen($website)!=0 && strlen($city)!=0){
        $lines=file('/home/bti320_153b17/secret/topsecret.txt');
        $host=trim($lines[0]);
        $user=trim($lines[1]);
        $password=trim($lines[2]);
        $database=trim($lines[3]);
        $connection = mysql_connect($host, $user, $password) or die("Opening connection failed"). mysql_error($connection);
        $selectdv = mysql_select_db($database, $connection) or die("Select db fail");
        /*if(!$connection){
            die("connection failed: ". mysqli_connect_error());
        }*/
        $sql="INSERT INTO place (placeName ,description, address, website, city, type) VALUES ('$name','$description', '$add', '$website', '$city', '$type')";
        $query = mysql_query($sql, $connection) or die("Insert fail").mysql_error($connection);
        //mysqli_close();
        header("Location: http://zenit.senecac.on.ca/~bti320_153b17/lab3/viewPlaces.php");
        exit();
    }
}
?>
<html>
<head>
    <link rel="stylesheet" type="text/css" href="addPlace.css">
</head>
<body>
<h2>Towards A Place Recommendation System</h2>
<p>Click <a href="http://zenit.senecac.on.ca/~bti320_153b17/lab3/viewPlaces.php">here</a> to go to the table</p>
<form action="addPlace.php" method="post">
    <label>Place Name</label> <input type="text" name="placename" value="<?php fill('placename')?>"><label><?php error('placename')?></label>
    <label>Description</label> <textarea name="description" rows="4" cols="20" placeholder="Enter text here..."><?php fill('description')?></textarea><label><?php error('description')?></label>
    <label>Type </label>
    <select name="place_type" required>
        <option name="choose" value="" disabled selected <?php if (!isset($_POST)) echo "disabled SELECTED"; ?>>--Choose one--</option>
        <option name="park" value="park"<?php if(isset($_POST['place_type']) && $_POST['place_type']=="park"){ echo "selected";}?>>park</option>
        <option name="zoo" value="zoo"<?php if(isset($_POST['place_type']) && $_POST['place_type']=="zoo"){ echo "selected";}?>>zoo</option>
        <option name="airport" value="airport"<?php if(isset($_POST['place_type']) && $_POST['place_type']=="airport"){ echo "selected";}?>>airport</option>
    </select>
    <label>Address</label> <input type="text" name="address" value="<?php fill('address') ?>"><label><?php error('address')?></label>
    <label>Website</label> <input type="text" name="website" value="<?php fill('website')?>"><label><?php error('website') ?></label>
    <label>City</label><input type="text" name="city" value="<?php fill('city')?>"><label><?php error('city')?></label>

    <br/>
    <?php if(isset($_POST['submit'])){if($_POST['place_type']=='choose')echo"please select one";}?><br/>
    <input type="submit" value="Add" name="submit"><br>
    <?php
        function error($key){
            if(isset($_POST['submit'])){
                $length=strlen($_POST[$key]);
                if($length==0) echo "input at least one character<br\>";
            }
        }
        function fill($key){
           echo isset($_POST[$key]) ? $_POST[$key] : '';
        }
    ?>
</form>
</body>
</html>