phpMyCRUD - Create, Read, Update, Delete

This is the Top Ad Block. Hidden via CSS for phpMyCRUD site

phpMyCRUD Demos

Generic Admin
Custom Admin
Tutorial Demos: 1 2 3 4 5

phpMyCRUD Tutorial

Documentation

3. Transformations
A transformation overrides the way a field is displayed in list 'view', and how the input field is displayed and processed on the insert/update forms. Custom transformations can be written to suit specific needs. phpMyCRUD has built-in transformations for:

disp_as_blob - Displays a 'blob' field as an image rather than 'binary blob'.
disp_as_image - Displays a field's data as a linked image.
disp_as_link - Displays a field's data as a hyperlink.
disp_as_select - Displays a select menu populated with data from another field.
disp_as_dir_select - Displays a select menu populated with directories and/or file names.

Example 3: Transformations (See it Live!)
Some fields are now displayed as images and hyperlinks on the list view. The "title" field from the "genres" table is displayed as a drop-down select menu on the insert/update forms for the "albums" table.

<?php include("config_tut.php"); include("../phpmycrud/phpmycrud.php"); $crud_obj = new phpMyCRUD($dbhost, $username, $password); // Setup a table switch for easy expandability switch($crud_obj->tbl) { case 'albums': $crud_obj->permission = 'crud'; $crud_obj->hide_field('id', 'all'); $crud_obj->hide_field('url', 'lists'); $crud_obj->set_alt_field_names(array('id' => 'id','title' => 'Title','artist' => 'Artist','genre' => 'Genre','url' => 'URL','desc' => 'Description','img' => 'Image')); // Add disp_as_image transformation $trans_info = array('field' => 'img', 'func' => 'disp_as_image'); $cust_data = array('src_dir' => '/demos/demo_images/', 'width' => '', 'height' => '100'); $crud_obj->add_trans($trans_info, $cust_data); // Add disp_as_select transformation $trans_info = array('field' => 'genre', 'func' => 'disp_as_select'); $cust_data = array('src_db' => 'phpmycru_tut', 'src_tbl' => 'genres', 'src_values' => 'id', 'src_options' => 'title'); $crud_obj->add_trans($trans_info, $cust_data); // Add disp_as_link transformation $trans_info = array('field' => 'artist', 'func' => 'disp_as_link'); $cust_data = array('src_db' => 'phpmycru_tut', 'src_tbl' => 'albums', 'src_col' => 'url'); $crud_obj->add_trans($trans_info, $cust_data); break; default: $crud_obj->permission = 'crud'; break; } $crud_html = $crud_obj->dispatch(); $db_controls = $crud_obj->create_controls(); echo $crud_obj->create_header_links(); echo $crud_html; ?>

<< Prev Example | Next Example >>