Форумы портала PHP.SU

PHP:
скопировать код в буфер обмена
 
<?PHP 
 
if ( !isset( $_GET["action"] ) ) $_GET["action"] = "showlist";
$action = $_GET["action"];
$id = $_GET["id"];
 
switch ( $action )
{
    case "showlist":
        show_list(); break;
    case "delete":
        delete_item( $id );
        show_list(); break;
    case "update":
        update_item( $id );
        show_list(); break;
    case "editform":
        get_edit_item_form( $id ); break;
    default:
        show_list();
}
 
function show_list()
{
    $query = "SELECT id, title, description FROM items WHERE 1";
    $res = db_query( $query );
    echo "<h2>Список</h2>";
    echo "<table>";
    echo "<tr><th>ID</th><th>Наименование</th><th>Описание</th><th>Ред.</th><th>Удл.</th></tr>";
    while ( $item = db_fetch_array( $res ) )
    {
        echo "<tr>";
        echo "<td>".$item["id"]."</td>";
        echo "<td>".$item["title"]."</td>";
        echo "<td>".$item["description"]."</td>";
        echo "<td><a href='".$_SERVER["PHP_SELF"]."?action=editform&id=".$item["id"]."'>Ред.</a></td>";
        echo "<td><a href='".$_SERVER["PHP_SELF"]."?action=delete&id=".$item["id"]."'>Удл.</a></td>";
        echo "</tr>";
    }
    echo "</table>";
}
 
function get_edit_item_form( $id )
{
    echo "<h2>Редактировать</h2>";
    $query = "SELECT title, description FROM items WHERE id=".$id;
    $res = db_query( $query );
    $item = db_fetch_array( $res );
    echo "<form name='editform' action='".$_SERVER["PHP_SELF"]."?action=update&id=".$id."' method='POST'>";
    echo "<table>";
    echo "<tr>";
    echo "<td>Наименование</td>";
    echo "<td><input type='text' name='title' value='".$item["title"]."'></td>";
    echo "</tr>";
    echo "<tr>";
    echo "<td>Описание</td>";
    echo "<td><textarea name='description'>".$item["description"]."</textarea></td>";
    echo "</tr>";
    echo "<tr>";
    echo "<td><input type='submit' value='Сохранить'></td>";
    echo "<td><button type='button' onClick='javascript: history.back();'>Отменить</button></td>";
    echo "</tr>";
    echo "</table>";
    echo "</form>"
}
 
function update_item( $id )
{
    $title = db_escape_string( $_POST['title'] );
    $description = db_escape_string( $_POST['description'] );
    $query = "UPDATE items SET title='".$title."', description='".$description."',
              WHERE id=".$id;
    db_query ( $query );
    return true;
}
 
function delete_item( $id )
{
    $query = "DELETE FROM items WHERE id=".$id;
    db_query ( $query );
    return true;
}
 
?>
 