Легко, удобно, универсально!

Это сайт о компоненте универсального менеджера каталогов информации для CMS Joomla. Информация хранимая в каталогах может быть различной. В состав компонента LURM входит удобный конструктор каталогов, который позволит самостоятельно задавать необходимые характиристики для каждого каталога.


www.zavkom.byethost5.com | uchus.info

О LURM'е > Прочие разработки > Joomla Easy SQL

Версия для печати

Joomla Easy SQL

EasySQL - компонент для Joomla, позволяющего администраторам сайта быстро и легко просматривать содержимое таблиц базы данных и выполнять различные SQL-запросы к базе данных сайта, а также восстанавливать БД из резервной копии используя дамп.

EasySql таблица запроса EasySql редактирование записи

Возможности:

  • выполнение любых запросов к MySQL;
  • выполнение нескольких запросов за раз;
  • внесение sql-дампа таблиц в БД;
  • просмотр данных выбранной из списка таблицы текущей БД;
  • вывод результатов запроса SELECT в таблицу;
  • удобный выбор команд SELECT, SHOW KEYS, SHOW DATABASES, SHOW TABLES, SHOW FULL COLUMNS FROM, SHOW INDEX FROM, SHOW TABLE STATUS, SHOW STATUS, SHOW VARIABLES, SHOW LOGS, SHOW FULL PROCESSLIST, SHOW GRANTS FOR, SHOW CREATE TABLE, SHOW MASTER STATUS, SHOW MASTER LOGS, SHOW SLAVE STATUS, SHOW KEYS FROM, SHOW FULL FIELDS FROM, REPAIR TABLE, OPTIMIZE TABLE, CHECK TABLE, ANALYZE TABLE;
  • горизонтальная прокрутка широкой таблицы;
  • опционально урезание длинных строк в ячейках таблицы;
  • создание записи;
  • редактирование записи;
  • удаление записи;
  • запрет редактирования уникального поля;
  • экспорт результатов sql-запроса в csv-файл
  • смена префикса таблиц базы данных REPLACE PREFIX `jos_` TO `newprefix_`

Скачать компонент: EasySQL v.1.27 [14 кб] (2009-01-11)

Примечание: работает на Joomla 1.0.x (native), Joomala 1.5 (native), поддержка локалей (EN, RU, FR, ES).


Отзывы о компоненте
Great component by graemelg, February 11, 2008
Installed on J1.5 stable without a hitch. Works as advertised so far. Would love to see CREATE TABLE supported.

[I found that I could create tables by entering the full command in the free text area. It gives an error message but the tables were created exactly as specified. I don't recommend it but it worked for me.]

great by goryl, February 6, 2008
this component is so great as it's simple :)
Whenever you have some problem with other components/modules or whatever it is great help for debuging

A lifesaver!!! by xjc, February 1, 2008
I'm serious, this component is a lifesaver!! I've been needing to delete the tables from fireboard to do a clean install. Without phpmyadmin or any clue how to query a sql database, this program did it.

There is a dropdown list which doesn't list the command "drop", but it works fine if you throw the command into the blank window and hit execute.

Thanks for putting this together :)

Very simple, but useful alternative to phpMyAdmin by thepisu, August 22, 2007
This component is very simple, and surely could be expanded with other features, for example view / edit / create table structure, but it's a valid and useful alternative for sysadmin if phpMyAdmin is not available, to have a basic control of records. In fact, with this extension you can easily list, edit, delete and create records; in addiction there are also some useful queries like "SHOW STATUS" and "SHOW CREATE TABLE".

To use at best this extension, you should have a minimum SQL knowledge.

PHPMyAdmin replacement by gws, August 21, 2007
When I first checked this out and went to the home page and discovered it was Russian I thought bugger. Downloaded the component and unzipped and there was no help documentation either, again thought bugger. However, ever adventurous I uploaded it to my test site and it could not be easier. 95% of all the mysql functions have been predefined and you can very simply right your own query and see the results and then click a button and they are exported to a csv. Magic component.It is not quite as powerful as phpmyadmin but comes close.

Awesome! by derebo, August 21, 2007
Just 10 minutes after this tool comes up in the New Extensions category and here I go! Just what I was looking for! A _simple_ way to query SQL tables and get results displayed. I'll rate it after some serious testing. KRUTO!!!