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

5. Permissions
Permissions control which action(s) can be performed on a particular table. A default permission value is set in phpmycrud.php and is used for all tables unless the permission is specifically changed before calling dispatch().

If you set the default permission to 'cruda', you would need to lower the permissions on any table you don't want to have full admin permissions. Alternately, if you set the default permission level to '' (an empty string), then you would need to increase the permission level to at least 'r' in order to view any tables. Either way, permissions can be individually changed on a table-by-table basis as needed by your application.

Permission	Allows	URL action (act)
c	Creating new records	insert
r	Reading records (browse)	view
u	Updating existing records	update
d	Deleting records	delete
a	Altering table structures, indexes and all other operations	alter, ops, query

Example 5: Read Only (See it Live!)
Permission 'r' allows only the 'view' action. The 'Actions' column, checkboxes and editing controls are automatically hidden on read-only tables, because there is no need for them.

<?php include("config_tut.php"); include("../phpmycrud/phpmycrud.php"); $crud_obj = new phpMyCRUD($dbhost, $username, $password); $crud_obj->permission = 'r'; // Setup a table switch for easy expandability switch($crud_obj->tbl) { case 'albums': $crud_obj->show_actions = 0; $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')); // Use a custom template for browse $crud_obj->use_custom_template = 'phpmycru_tut.albums.tpl'; // 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: break; } $crud_html = $crud_obj->dispatch(); //$db_controls = $crud_obj->create_controls(); //echo $crud_obj->create_header_links(); echo $crud_html; ?>

<< Prev Example