back/phexample/contact_index.php

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

    $params["query"] = "select id,firstname,lastname,phone,email,typeid from contact";
    $params["defaultsort"] = "lastname";
    $params["editlink"] = "contact_detail.php";
    $params["newlink"] = "contact_detail.php";
    $params["addmultiplelink"] = "contact_multi.php";
    $params["delquery"] = "delete from contact where id = ";
    $params["predelete_hook"] = "my_predelete_fcn";
    $params["key"] = "id";

    $fields[] = "firstname";  $names[] = "First Name";
    $fields[] = "lastname";   $names[] = "Last Name";
    $fields[] = "phone";    $names[] = "Phone Number";
    $fields[] = "email";    $names[] = "Email Address";
    $fields[] = "typeid";   $names[] = "Type";

    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 photo from contact where id = $record_id";
        $result = pg_exec( $query );
        if( $result ) {
            $array = pg_fetch_array( $result, 0 );
            $filename = "/home/jdhildeb/public_html/phexample/pics/" . 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			$params["query"] = "select id,firstname,lastname,phone,email,typeid from contact";
8			$params["defaultsort"] = "lastname";
9			$params["editlink"] = "contact_detail.php";
10			$params["newlink"] = "contact_detail.php";
11			$params["addmultiplelink"] = "contact_multi.php";
12			$params["delquery"] = "delete from contact where id = ";
13			$params["predelete_hook"] = "my_predelete_fcn";
14			$params["key"] = "id";
15
16			$fields[] = "firstname"; $names[] = "First Name";
17			$fields[] = "lastname"; $names[] = "Last Name";
18			$fields[] = "phone"; $names[] = "Phone Number";
19			$fields[] = "email"; $names[] = "Email Address";
20			$fields[] = "typeid"; $names[] = "Type";
21
22			function my_predelete_fcn( $record_id )
23			{
24			// since we also have to delete a photo when we delete this record,
25			// we write a short function to do this. We pass the name of the function
26			// to Phormation in the "params" array, so that it will call this
27			// function just before deleting a record from the database.
28			$query = "select photo from contact where id = $record_id";
29			$result = pg_exec( $query );
30			if( $result ) {
31			$array = pg_fetch_array( $result, 0 );
32			$filename = "/home/jdhildeb/public_html/phexample/pics/" . trim( $array[0] );
33			@unlink( $filename );
34			}
35			}
36
37			table_index( $fields, $names, $params );
38			?>