Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <!DOCTYPE HTML>
- <?php
- $server = 'localhost';
- $user = 'root';
- $password = '';
- $db = 'byf_db';
- $charset ='utf8';
- $link = mysql_connect($server, $user, $password);
- mysql_set_charset($charset, $link);
- mysql_select_db($db, $link);
- if (($_POST[titlecag] != NULL) or ($_POST[feedcag] != NULL) or ($_POST[imgcag] != NULL)) {
- $query = mysql_query('UPDATE `byf_db`.`feeds` SET `title` = "'.$_POST[titlecag].'", `feed` = "'.$_POST[feedcag].'", `img` = "'.$_POST[imgcag].'" WHERE `feeds`.`id` = '.$_GET[c].';');
- }
- if ($_GET[del] != NULL) {
- $query = mysql_query("DELETE FROM `byf_db`.`feeds` WHERE `id` = $_GET[del];");
- }
- $query = mysql_query("SELECT * FROM `feeds`;", $link);
- ?>
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <title>Редактирование новостей</title>
- <meta name="description">
- <link rel="stylesheet" href="admin.css">
- </head>
- <body>
- <div class="menu"> <b>
- <a href="Time_Table.html"><div class="button">Рассписание
- </div></a>
- <a href="Treners/Trener.html"><div class="button">О преподавателях
- </div>
- <a href="Gallary/Gallary.html"><div class="button">Галлерея
- </div></a>
- <div class="button">Новости
- </div>
- <a href="Favorite.html"><div class="button">Главная
- </div></a>
- </b>
- </div>
- <div class="table_div"> //Главный родитель <---------------------------------------------------------------------
- <div class="table"> // 1 блок <-----------------------------------------------
- <?php
- echo "<table border='1px' bgcolor='white'>";
- echo
- '<tr><td>Индетификатор</td>
- <td>Название</td></tr>';
- for ($row = 0; $row < mysql_num_rows($query); $row++) {
- $f = mysql_fetch_array($query);
- echo "<tr>";
- echo "<td>".$f[id]."</td>";
- echo "<td>".$f[title]."</td>";
- echo "<td><a href='add.php?change=".$f[id]."'>Change</a></td>";
- echo "<td><a href='add.php?del=".$f[id]."'>Delete</a></td>";
- echo "</tr>";
- }
- echo "</table>";
- ?>
- </div>
- <?php
- if ($_GET[change] != NULL){
- echo '<div class="changer">'; // 2 блок <-----------------------------------------------
- echo '<form method="post" action="add.php?c='.$_GET[change].'">';
- echo 'Заголовок<br></br>';
- echo '<textarea rows="10" cols="45" name="titlecag">';
- $s = mysql_query('SELECT * FROM `feeds` WHERE `id` = '.$_GET[change].';', $link);
- $m = mysql_fetch_array($s);
- echo $m[title];
- echo '</textarea><br></br>';
- echo 'Описание<br></br>';
- echo '<textarea rows="10" cols="45" name="feedcag">';
- echo $m[feed];
- echo '</textarea><br></br>';
- echo 'Ссылка на изображение<br></br>';
- echo '<textarea rows="10" cols="45" name="imgcag">';
- echo $m[img];
- echo '</textarea><br></br>';
- echo '<input type="submit" value="Изменить">';
- echo '</form>';
- echo '</div>';
- echo '<div style=" width:100%; height:1px; clear:both;"></div>';
- mysql_close($link);
- } ?>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement