edycja newsa (php) - Wersja do druku

Kod:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 

<html xmlns="http://www.w3.org/1999/xhtml"> 

    <head> 

        <title>Edycja newsa</title> 

        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 

        <link type="text/css" href="css/reset.css" rel="stylesheet" />

        <link type="text/css" href="css/master.css" rel="stylesheet" />

    </head> 

<body>

    <div class="center">

        <?php

        

            ///// wyswietlanie ID newsa /////

        

            if (!empty ($_GET['id'])){

            echo "<b>ID wybranego newsa: {$_GET['id']}</b>";

            echo "<br />";

            echo "____________________";

            echo "<br /><br />";

            

                    $host="localhost";

                    $db_user="root";

                    $db_password="qwe123";

                    $database="testnews";



                        mysql_connect($host, $db_user, $db_password)

                                or die('Połączenie z bazą danych nieudane');

                        mysql_select_db($database)

                                or die('Wybór bazy danych nieudany');



                    $wynik=mysql_query("SELECT * FROM news WHERE id=$id")

                                or die('Pobranie danych nieudane');

                                        

                        while($wiersz=mysql_fetch_array($wynik))

                                { 

                                echo "<b>Data dodania: </b>({$wiersz['data']})";                                

                                echo "<br /><br />";                               

                                }

                         }

                else {

                    echo "<br /><br />";

                    echo "<b><u>Niepoprawne ID</u></b>";

                     }

                     

                 ///// edycja newsa /////    

                     

                 if (!empty ($_POST)){          

                    $username="root";

                    $password="qwe123";

                    $database="testnews";



                    mysql_connect('localhost',$username,$password);

                    @mysql_select_db($database) or die("Nie znaleziono bazy danych");

                                        

                    $tytul=$_POST['tytul'];

                    $autor=$_POST['autor'];

                    $tresc=$_POST['tresc'];



                    mysql_query("UPDATE news SET tytul='$tytul' WHERE id='$id'");

                       

//                    header("location:newsList.php");



            }    

         ?>

        

<!--        formularz dla edycji-->



            <form action="newsEdit.php" method="post">

                tytul: <textarea name="tytul" rows="1" cols="40"><?php echo "'.{$wiersz['tytul']}.'"; ?></textarea><br/><br/>

                autor: <textarea name="autor" rows="1" cols="40"></textarea><br/><br/>

                treść: <br/><textarea name="tresc" rows="15" cols="50"></textarea>        

                <br/><br/><input name="add" type="submit" value="Dodaj newsa" />

            </form>  



        

        

           

        <ul class="footerNav">

            <li>

                <a href="index.php">Strony główna</a>

            </li>

            <li>

                <a href="newsList.php">Lista newsów</a>

            </li>

            <li>

                <a href="admin.php">Panel admina</a>

            </li>            

        </ul><!-- koniec footerNav -->        

    </div><!-- koniec center -->

</body>

</html>