<?php
$connect = mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db(pages); //
if (isset($_POST['submit']))
{
$title = $_POST['title'];
$theme = $_POST['theme'];
$text = $_POST['text'];
$query = mysql_query("INSERT INTO information VALUES('','$title','$theme','$text')")or die(mysql_error());
print "Тема добавлено успушно)"; // Добовление информации
}
// Извлечение Бд
$connect = mysql_query("SELECT * FROM information") or die("Could not connect: " . mysql_error());
while($row = mysql_fetch_array($connect, MYSQL_ASSOC))
{
echo '<br>' . $row['theme'] . '<br>' . $row['text'] . '<br>';
}
// Удаления из бд
if($_POST['pages']) {
$pages_id = join(',', $_POST['pages']);
$connect->query('DELETE FROM information WHERE id IN('/$pages_if.')');
echo 'Заметки с ID: '.$pages_id.'; удалены';
}
$connect = mysql_query('SELECT * FROM pages');
echo '<br><from method="post">';
while($row = mysql_fetch_array($connect, MYSQL_ASSOC)) {
echo '<input type="checkbox" id='.$row['id'].'.value='.$row['id'].'.name="pages[]" />
<label for='.$row['id'].'.style="cursor: pointer;">'.$row['title'].'</label><br>';
}
echo '<input type="submit" style="padding; 3px 6px; value="Удалить" />';
echo '</from>';