<?

    include "init.php";

    $id = trim( $_POST["id"] );

    if( $id != "" )
    {
        // Is postback

        $name    = trim( $_POST["name"] );
        $address = trim( $_POST["address"] );
        $email   = trim( $_POST["email"]   );
        $phone   = trim( $_POST["phone"]   );

        $name    = utf8_encode($name);
        $address = utf8_encode($address);
        $email   = utf8_encode($email);
        $phone   = utf8_encode($phone);

        $name    = $conn->real_escape_string($name);
        $address = $conn->real_escape_string($address);
        $email   = $conn->real_escape_string($email);
        $phone   = $conn->real_escape_string($phone);

        $sql = "UPDATE sct_schools SET name='".$name."', address='".$address."', email='".$email."', phone='".$phone."' WHERE id=".$id.";";
        //echo $sql;
        if( $conn->query($sql) === TRUE )
        {
            header('Location: showschool.php?id='.$id);
            die();
        }
        else
        {
            die("Error in update school information query: ".$sql);
        }
    }

    include "header.php";
    ?><h1>Rediger skole</h1><?

    $sql = "SELECT * FROM sct_schools WHERE id=".$_GET["id"].";";
    $result = $conn->query($sql);
    if( $result->num_rows > 0 )
    {
        $school = $result->fetch_assoc();
?>
    <form action="editschool.php" method="post">
        <input type="hidden" name="id" id="id" value="<? echo $_GET["id"]; ?>"/>
        <table class="form">
            <tr>
                <th>Skole/institution</th>
                <td><input type="text" name="name" id="name" value="<? echo htmlspecialchars(utf8_decode($school["name"])); ?>"/></td>
            </tr>
            <tr>
                <th>Adresse</th>
                <td><textarea rows="5" name="address" id="address"><? echo htmlspecialchars(utf8_decode($school["address"])); ?></textarea></td>
            </tr>
            <tr>
                <th>E-mail</th>
                <td><input type="text" name="email" id="email" value="<? echo htmlspecialchars(utf8_decode($school["email"])); ?>"/></td>
            </tr>
            <tr>
                <th>Telefon</th>
                <td><input type="text" name="phone" id="phone" value="<? echo htmlspecialchars(utf8_decode($school["phone"])); ?>"/></td>
            </tr>
            <tr>
                <th></th>
                <td><input type="submit" value="Gem"/><button onclick="location.href='mergeschools.php?id=<? echo $id ?>';">Flet</button></td>
            </tr>
        </table>
    </form>
<?
    }
    include "footer.php";
?>