back/news/index.php

<?
    include_once( "global.php" );
    include_once( "dbconnect.php" );
    include_once( "$phormationdir/displaytable.php" );
        

    $params["query"] = "select id,visible,priority,title,town_date,date,body,pic,more,pdf,type from news";
    $params["defaultsort"] = "date desc";
    $params["editlink"] = "detail.php";
    $params["newlink"] = "detail.php";
    $params["addmultiplelink"] = "multi.php";
    $params["delquery"] = "delete from news where id = ";
    $params["predelete_hook"] = "my_predelete_fcn";
    $params["key"] = "id";
    $params["back"] = "../";

    function my_predelete_fcn( $record_id ) 
    {
        // since we also have to delete a photo when we delete this record,
        // we write a short function to do this.  We pass the name of the function
        // to Phormation in the "params" array, so that it will call this
        // function just before deleting a record from the database.
        $query = "select pic from news where id = $record_id";
        $result = pg_exec( $query );
        if( $result ) {
            $array = pg_fetch_array( $result, 0 );
            $filename = "$dir/".trim( $array[0] );
            @unlink( $filename );
        }
    }

    table_index( $fields, $names, $params );
?>
1	dpavlin	1.1	<?
2			include_once( "global.php" );
3			include_once( "dbconnect.php" );
4			include_once( "$phormationdir/displaytable.php" );
5
6
7	dpavlin	1.3	$params["query"] = "select id,visible,priority,title,town_date,date,body,pic,more,pdf,type from news";
8	dpavlin	1.1	$params["defaultsort"] = "date desc";
9			$params["editlink"] = "detail.php";
10			$params["newlink"] = "detail.php";
11			$params["addmultiplelink"] = "multi.php";
12			$params["delquery"] = "delete from news where id = ";
13			$params["predelete_hook"] = "my_predelete_fcn";
14			$params["key"] = "id";
15	dpavlin	1.2	$params["back"] = "../";
16	dpavlin	1.1
17			function my_predelete_fcn( $record_id )
18			{
19			// since we also have to delete a photo when we delete this record,
20			// we write a short function to do this. We pass the name of the function
21			// to Phormation in the "params" array, so that it will call this
22			// function just before deleting a record from the database.
23			$query = "select pic from news where id = $record_id";
24			$result = pg_exec( $query );
25			if( $result ) {
26			$array = pg_fetch_array( $result, 0 );
27			$filename = "$dir/".trim( $array[0] );
28			@unlink( $filename );
29			}
30			}
31
32			table_index( $fields, $names, $params );
33			?>