DBI::Library::Database - Database interface for MySQL::Admin::GUI
use DBI::Library::Database;
constructor
$name = $m_oDatabase->getName($m_sSid);
$sid = $m_oDatabase->setSid( name, pass );
$bool = $m_oDatabase->checkSession($sUser,$m_sSid);
bool checkPass( user, crypt_pass);
$nRight = right($m_sAction,$sUsername);
userright( user );
catright( 'name|name2' );
isMember($sUser);
bool hasAcount( $email )
$m_oDatabase->addUser(user, pass,mail);
set serverName.
set floodtime.
checkFlood(ip,optional time in seconds )
checkFlood( remote_addr() );
GetAutoIncrementValue(table)
liefert die primary_key(s) der tabelle zurueck @array = GetPrimaryKey(table)
returns the auto_increment Column. GetAutoIncrement(table)
returns a <select> list with the Databases.
Gibt die anzahl der tabellen fuer die angegebene Datenbank zurueck.
gibt das Charset zu coalation zurueck. GetCharacterSet(coalation);
gibt die verfuegbaren Engines zurueck. GetEngines(tabelle);
GetEngineForRow(tabelle, zeile);
gibt die NULL( NULL | not NULL ) auswahlliste zurueck GetNull( selected extra, slect_name );
gibt die extra(auto_increment) auswahlliste zurueck GetExtra(selected extra, slect_name);
gibt eine auswahlliste (select) zurueck. GetColumnCollation( tabelle ,columne, name_select);
$sel = GetCollation( name, selected );
$sel = GetCharset(name,selected table);
$sel = GetAttrs($tbl, $field, $name );
$sel = GetColumns($tbl , $name, $selected);
my %message = ( thread => $thread, title => $headline, body => $body, thread => $thread, cat => $cat, attach => $sra, format => $format, id => $id, user => $sUser, attach => $m_sFilename, ip => remote_addr(), ); my $id = addMessage(\%message);
my %message = ( thread => $thread, title => $headline, body => $body, thread => $thread, cat => $cat, attach => $sra, format => $format, id => $id, user => $sUser, attach => $m_sFilename, ip => remote_addr(), ); editMessage(\%message);
my %reply =( title => $headline, body => $body, id => $reply, user => $sUser, attach => $sra, format => $html, ip => remote_addr(), ); reply(\%reply);
$bool = $self->deleteMessage($table,$id);
@menu = $m_oDatabase->readMenu($sThread,$nRight,$nStart,$nEnd);
$rss = $m_oDatabase->rss($thread,int start);
searchDB($query,$column,$table,$rigt,$start,$end);
regexp search in tabelle ...
@messages = fulltext(query,table);
fulltextsuche in tabelle ...
$hashref = $m_oDatabase->getAction($m_sAction);
$right = $m_oDatabase->getActionRight($m_sAction);
topicright(id);
getSelf or CGI
MySQL::Admin::GUI DBI DBI::Library
Dirk Lindner <lze@cpan.org>
Copyright (C) 2005-2016 by Hr. Dirk Lindner
This program is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
To install MySQL::Admin, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MySQL::Admin
CPAN shell
perl -MCPAN -e shell install MySQL::Admin
For more information on module installation, please visit the detailed CPAN module installation guide.