Mysql Table Editor

by Mr Me on June 4, 2009 in php, php source code

In a php project, if we get the requirement , we usually start design and database. But the data entry procedure is very hard. In this case PhpMyadmin is a good comfort.

Here is another tool from phpguru.org , MySQL Table Editor. Using this library you can make your database table editable from your php code.

You can :

Select the table to be displayed
decide which column should be hidden
Whether a column should be editable or not
Add advanced searching option
Download the table as csv format
Add pagination
Set alias display name for your column

Download Library from:

http://www.phpguru.org/downloads/TableEditor/TableEditor.zip

Documentation:

http://www.phpguru.org/static/TableEditor.html

Sample Code Below:

<?php
require_once('TableEditor.php');
//database connection object 
$db_conn = mysql_connect('localhost','root','');
mysql_select_db('mydbname'); 




//select the table to be edited, here it is accounts
$editor = new TableEditor($db_conn, 'accounts');
//I dont want to display id and password column
$editor->noDisplay('id');
$editor->noDisplay('password');
//the email column should not be editable
$editor->noEdit('email');
//set display name for column email and login
$editor->setDisplayNames(array('email'       => 'Email',
                              'login'     => 'Username'
                              ));
//sort order of first name
$editor->setDefaultOrderby('namefirst', 0);
//set which are the filed to be searchable
$editor->setConfig('searchableFields', array('namefirst', 'namelast', 'email'));
//can set the type of input field
$editor->setInputType('available', 'select');
//finally display the editor window
$editor->display();
?>

<?php

require_once('TableEditor.php');

//database connection object

$db_conn = mysql_connect('localhost','root','');

mysql_select_db('mydbname');

//select the table to be edited, here it is accounts

$editor = new TableEditor($db_conn, 'accounts');

//I dont want to display id and password column

$editor->noDisplay('id');

$editor->noDisplay('password');

//the email column should not be editable

$editor->noEdit('email');

//set display name for column email and login

$editor->setDisplayNames(array('email' => 'Email',

'login' => 'Username'

));

//sort order of first name

$editor->setDefaultOrderby('namefirst', 0);

//set which are the filed to be searchable

$editor->setConfig('searchableFields', array('namefirst', 'namelast', 'email'));

//can set the type of input field

$editor->setInputType('available', 'select');

//finally display the editor window

$editor->display();

3 Comments code, editor, msql, php, phpmyadmin, query, sql, table

3 Responses to “Mysql Table Editor”

Ronnie Sullivan July 3, 2009 at 12:51 pm #

Great Job ..Exactly ..Perfect points mentioned

Reply
Cartoon Bears July 28, 2009 at 11:25 pm #

I’ve been using the MySQL Administrator and MySQL Query Browser.

The problem is those program only allow me to create and edit tables and columns but not the actual data itself.

So are there any Visual MySQL database editor that actually let you enter data, copy and paste, drag data around where ever I want, all just with the mouse ?

Oh, also I don’t want to learn the codes to do those kind of things. I find learning and typing hundreds lines of code just to manage a 20 row 5 column data a bit too much of a work. =/

Reply
Joseph Wright May 19, 2010 at 2:23 pm #

i applied for data entry jobs over the internet and it is also a good part time job.,~:

Reply