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

2. Column Headings
By default, phpMyCRUD uses the field names from the database for the column headings. You can change column headings by calling the method set_alt_field_names(). Note: set_alt_field_names() does NOT change the field names in the database, it merely changes the text that is displayed in column headings and on the Insert and Update forms.

Hiding Columns
Columns can be hidden by calling the hide_field() method.
The 'Actions' column can be hidden by setting $crud_obj->show_actions = 0.
The 'Checkbox' column can be hidden by setting $crud_obj->show_checkbox = 0.

Example 2: Changing/Hiding Columns (See it Live!)
The addition of the switch() statement allows conditionally changing Column Headings based on which table is being displayed.

<?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) { // Need at least 1 comment within the 'switch' so this code displays in textarea of tutorial. Too weird! case 'albums': $crud_obj->permission = 'crud'; $crud_obj->hide_field('id', 'all'); $crud_obj->hide_field('genre', 'lists'); $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')); 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 >>