phpmyadmin / phpmyadmin Goto Github PK
View Code? Open in Web Editor NEWA web interface for MySQL and MariaDB
Home Page: https://www.phpmyadmin.net/
License: GNU General Public License v2.0
A web interface for MySQL and MariaDB
Home Page: https://www.phpmyadmin.net/
License: GNU General Public License v2.0
Finally…
- Original URL: https://sourceforge.net/p/phpmyadmin/translations/1/
- Original author: d_nordenberg
One big feature that is missing in phpmyadmin is a
whole range of search options.
The search on the main.php page would search all
fields in all databases.
The search on the db-details page would search all
fields of all the tables in the current DB.
The search on the table properties page would search
all fields in the current table.
The output would create one or more html tables, each
table would be for a different database/table, the
tables would also contain an edit button/link.
Pete
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/22/
- Original author: trafficg
To make querying from a specific table easier
(I do this a lot), a textarea box (copy partially from
database page) is added.
A default query (select \* from thistable where 1)
is given in the box as well
- Original URL: https://sourceforge.net/p/phpmyadmin/patches/3/
- Original author: korakot
Hi
I have been using the orgiinal MyAdmin and it is
great .. shame works not continued .. which is why i
was gald to find your here.
Only problem.. pasting SQL into old version works fine
with quotes
e.g. DEFAULT =‘0’
But on your version it escapes them with \‘0\’ which
creates an SQL error.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/9/
- Original author: *anonymous
In many cases, with older versions of MySQL still quite prevalent out there, we should detect what
versions those are and hide some of the features that only the new versions support, such as table types
and full-text searchs.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/12/
- Original author: robbat2
Hi,
in lib.inc.php3, get_table_def should support FULLTEXT
indexes.
Some of the problems if we don’t support it:
-we can’t copy a table containing a FULLTEXT index
-if we try to dump the structure, the result is not
valid
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/17/
- Original author: lem9
Warning: mysql_db_query is deprecated; use
mysql_select_db() and mysql_query() instead
in /home/httpd/htdocs/phpmyadmin/sql.php3 on line 69
Warnings like this are generated when the warning
level is set appropriately. Software like phpMyAdmin
should work smoothly even at the highest error
reporting level.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/16/
- Original author: *anonymous
Hi
I just installed the latest version and received this
message.
Warning: Undefined index: en-gb in select_lang.inc.php
on line 43
I am running Win2000,IIS5,PHP4.
I looked around various files to see if anything was
setup wrong and everything seemed OK
In the config file these are the language settings.
$cfgDefaultLang = "en";
$cfgLang = "en";
The error was the same with and without $cfgLang
I can get everything up and running if I add this line
to the language array
$txt_langname[‘en-gb’] = "english.inc.php";
Thanks
Pete Kelly
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/5/
- Original author: trafficg
Ability to create index on more than one field
or for the first N character of the field.
Creation of full-text index.
This should be a separate page.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/2/
- Original author: korakot
Here is the thai language file.
It is done by someone at thaidev.com, I suppose.
- Original URL: https://sourceforge.net/p/phpmyadmin/patches/1/
- Original author: korakot
phpmyadmin has differnet dom paths for IE and other
browsers, it should be modified to work with all
dom-capable browsers, see:
http://bugzilla.mozilla.org/show_bug.cgi?id=66791
(this bug relates to 2.1, but I guess this hasn’t fixed
yet?)
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/2/
- Original author: *anonymous
I would like to have a .php release just as they used
to have in PHPWizards. I use PHP 4 extensivly and I
really don’t like to have to change the exension.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/7/
- Original author: baldusi
try to translate in english below.
Pour la création d’une table ou l’ajout d’un champs.
on a 3 check box.
PRIMARY UNIQUE et INDEX.
Mais sauf si je me trompe.
UNIQUE -> toujours un index
et
PRIMARY -> Toujours un INDEX UNIQUE
When adding a fields we have 3 check box for
PRIMARY UNIQUE et INDEX.
but if I’n not in wrong
UNIQUE is always an index
and
PRIMARY is always an INDEX UNIQUE
so why a check box and not a radio with 4 choice ?
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/25/
- Original author: moosh_fr
Could you add repair, check, optimise and any other
maintainance features to the main database pages.
Thanks
Pete Kelly
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/5/
- Original author: trafficg
New module for User Administration with the next functions:
- View all users
- Add/Edit/Delete users
- Change/Delete user’s password
- Add/Revoke/Edit user’s privileges with any Database/Table/Columns
- Check the user privileges with any Database
- Original URL: https://sourceforge.net/p/phpmyadmin/patches/6/
- Original author: dvilla
It would be great when you DUMP the whole database
but you want just a few of them (and you are lazy
to do id one by another :) to select (<SELECT>)
multiple tables to DUMP.
-th
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/21/
- Original author: *anonymous
In tbl_change, add some radio buttons to specify
what to do after the saving of the current record:
O go back to browse
X insert (new data)
O insert (clone last data)
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/15/
- Original author: lem9
On the select page (tbl_select.php3), when you you
suppress the 30 default value in the display xx
records per page (or put a non numeric value) then
click go, you’ve the following
sql error :
<———>
Error
SQL-query:
SELECT … // sql request // … where 1
MySQL said:
<———>
and nothing else …
Proposed patch:
on file "tbl_select.php3", on line 115-116
(before "header("Header("Location …"), add :
require("config.inc.php3"); // we need $cfgMaxRows …
if (($sessionMaxRows += 0) == 0) { $sessionMaxRows =
$cfgMaxRows;}
Since I don’t know if it might break something else,
would someone look at this ( and apply if safe ;-) ).
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/11/
- Original author: hal0802
Hi,
After Vérifier la table [Documentation]
Analyser la table [Documentation]
Réparer la table [Documentation]
Optimiser la table [Documentation]
you should not be allowed to insert or modify…
When I try it I get :
Warning: Supplied argument is not a valid MySQL result
resource in c:/anetpub/www/mysql/tblchange.php3 on
line 46
John.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/15/
- Original author: jonx
Some BLOBs (whose size I have not determined) are too
large to be edited. It does not seem to be based on
the datatype, but rather the amount of space used.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/8/
- Original author: *anonymous
une extention ŕ phpMyAdmin pour génerer un code php de
base ŕ partir des tables pour faire des formulaires
d’édition "affinés".
Les formulaires de phpMyAdmin
1° donnent accčs a tous les champs.
2° sont dynamiquement recréé ŕ chaque affichage.
3° affichent des informations sur le type de chaque
champs
4° ne vérifient pas l’intégrité d’un contenu de champs
lorsqu’il reprend un id venant d’une autre table de la
base.
Je voudrais faire un générateur paliant c’est 4
points.
Le but est de générer des formulaires "pręt" ŕ
l’emploi.
pour faire une page d’admin orienté vers la structure
de l’information et pas orienté vers la structure de
la base.
ainsi que le code générique traitant la soumission du
An extention to the project to generate a generic
code form a database to a HTML form.
Actual Form of PHPMyAdmin
1° give an acces edit to all fields
2° are dynamic rebuilt on every request
3° show all information about records
4° don’t check relation between table.
The extention should prupose an Form generator
readty to use on a website.
Two Use :
Admin page with control of relation between table.
User page on Insert/Edit records with control of
content.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/23/
- Original author: moosh_fr
Armel Fauveau suggests to replace, in table-edit mode,
pull-down menus by radio buttons, to improve the
interface.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/13/
- Original author: lem9
It would be useful if we can display the size of the
Databases & Tables or even a summary page with the
size breakdown.
Something like what ‘du -ach’ produces.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/24/
- Original author: valcrow
help path on MySQL website is buggy.
One extra slash in it.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/4/
- Original author: robbat2
If a field is an ENUM
i.e. ENUM
but not with NOT Null.
phpMyAdmin dont give the possibilities to empty the
field. In insert or change Form for a record.
Now In french because my English is perhaps too bad.
si on a un champs ENUM ŕ 2 cas
par exemple ENUM
mais pas avec NOT Null
dans un formulaire insert ou modif d’enregistrement,
phpMyAdmin ne permet pas de laisser le
champ "vide"//NULL.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/10/
- Original author: *anonymous
Show create database only on create_priv being set.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/10/
- Original author: robbat2
Hello,
I’ve a problem with the import of a csv-file into a
table.
The version of phpMyAdmin is 2.2.0pre3
After submitting the import-page, the following error
message appears:
Error
MySQL: Query was empty
This problem comes up if the magic_quotes_gpc is not
enabled. ( I have a ISP with and one without
magic_quotes_gpc enabled)
After this error i try the old version 2.1.0 and thsi
version import these csv-file.
Is this a bug?
Percy
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/12/
- Original author: *anonymous
In lib.inc.php3, get_table_def should support key length.
In the present version we lose the information about key lengths on table copy or table dump.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/20/
- Original author: lem9
Mysql do not accept the common windows directory
description with …
In ldi_check.php you will receive (if in an Windows
environment) a file path like c:\winnt\temp\php11.tmp
So to pass this path to MySQL, it will be needed to
change all \ into / or put a \ in front of all
existent …
You need to addslashes($textfile) before sending it to
mysql…
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/1/
- Original author: *anonymous
In the edit page, the function in the dropdown box
should be limited to a few related to the data type of field.
For example, in set and enum, there should be no
dropdown at all, and in the time-type, it should only show
functions related to time.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/14/
- Original author: korakot
Hi
I have known about this error for a while now and it
caused me loads of hassle in the past, luckily I can
use telnet now to backup and restore my databases but
a lot of users cannot.
The problems are caused by symbols within the data.
I have attached a sample database, if you can restore
this data you have solved 90% of the problems in this
area.
Another bug I have come across is, if your on a server
that only supports safemode, and you try and upload a
file, php will return a "permission denied" error when
you try and read the file.
Here is a helpful url.
http://www.aota.net/ubb/Forum15/HTML/000671-1.html
Good luck with these bugs.
If you need a hand testing any code in safe mode I
will help you out.
Pete Kelly
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/7/
- Original author: trafficg
Hi,
I get an error if I:
- select a subset of rows with the ‘select’ option, or
by a given query
- edit a single entry
- save it
Phpmyadmin wants to return to the subset of rows and
gives this error:
Warning: Supplied argument is not a valid MySQL result
resource
in /home/projects/phpmyadmin/phpmyadmin.openeye.nl/sql.
php3 on line 72
Database openeye – table CommInfo
Error
SQL-query:
SELECT Id,Value from CommInfo where 1 and Value like
MySQL said: You have an error in your SQL syntax
near ’’ at line 1
Back
This is not a valid query indeed…
Thanks,
Stijn.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/13/
- Original author: stijn
hi ,
i run Mysql 3.23.38
Apache 1.3.19
php 4.0.5
When :
$cfgServers1[‘adv_auth’] = false;
$cfgServers1[‘user’] = ‘root’;
$cfgServers1[‘password’] = ‘pass’;
everything works very well
When :
$cfgServers1[‘adv_auth’] = true;
$cfgServers1[‘stduser’] = ‘root’;
$cfgServers1[‘stdpass’] = ‘pass’;
i have a prompt for username / password
i enter :
login: root
pass : pass
and it doesn’t work
i can connect with command line to the sql server with
the same login/pass
the Officiel release work well
Best regards
Zappy
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/14/
- Original author: *anonymous
During table creation, it should allow user to specify
table type.
When modifying table structure, it should allow changing
the table type as well
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/1/
- Original author: korakot
The demo site has the hard-code font in the style sheet
section.
(Arial, Helvetica, sans-serif from header.inc.php3)
This will affect the display of thai font (and maybe other
non-europian font as well).
I suggest the system that sourceforge is using, ie. it
have a standard fonts (about 3) to include in the
stylesheet
for each language.
So I can specify the font to use for thai.
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/3/
- Original author: korakot
In the browse page, the data in table field should be
easily editable (change from text to text-box when clicked)
and many rows be edited simultaneosly.
This should be possible if implemented in cross-browser
javascript (DHTML).
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/11/
- Original author: korakot
When running apache/php under safe mode, the
set_time_limit() calls don’t work; ie php error msgs
like "Warning: Cannot set time limit in safe mode "
during
SQL data dumps.
I’d like to see a safe_mode unfriendly calls wrapped
in a conditional, the conditional based on whether
safe_mode is on/off.
In other words, a config option to make phpMyAdmin
safe_mode friendly.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/19/
- Original author: *anonymous
Hi,
maybe i have a suggestion for a next phpMyAdmin
Version to show in tbl_properties.php3 the spaceusage
for the current table.
Here is my sample code:
http://www.neptunlabs.de/phpMyAdmin/tbl_properties.new
Steve Alberty
ps: how can i develop on phpmyadmin cvs?
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/26/
- Original author: *anonymous
Need to change the method type from GET to POST in
tbl_select.php3 at LINE 19
This due problems when having huge tables with lots of
columns and the GET method will not allow so much data.
- Original URL: https://sourceforge.net/p/phpmyadmin/patches/2/
- Original author: *anonymous
Hi guys,
I made a little improvement which can GZIP the DUMP
sent to you.
Is there a possibility to add this improvement?
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/8/
- Original author: tehac
Hi
I have just setup the lastest CVS files and tested out
the new bookmark feature (cool), I just have one
suggestion:
When you select the bookmark can the bookmarked sql
string automatically appear in the "Run Sql Query"
text box. I run many queries that are identical apart
from one parameter. It would be nice if the bookmarked
query would appear and then I could just edit it a
little each time I wanted to run it.
eg…
If I bookmarked a query such as:
select \* from users where user = ‘pete’
Then next time I wanted to bring up a users
information I could just change pete to another name
etc…
Have fun
Pete Kelly
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/16/
- Original author: trafficg
You can see the "Bookmarked SQL-query" combo box under
the "Run SQL query" textarea when you click on a
database (left frame).
But when you click on a table (still left frame) the
page showing still has the "Run SQL query" textarea
but not anymore the "Bookmarked SQL-query" combo
box …
Should’nt it be added ?
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/18/
- Original author: hal0802
Hi. In db_read_dump you can enter a sql-Query. If you give something like
select \* from bla where blo>‘bla’
then it says something like syntax error:
select \* from bla where blo>\‘bla\’
changing the line 29 in db_read_dump from
$sql_query = trim($sql_query);
to
$sql_query = trim(stripslashes($sql_query));
solves the Problem.
Just a quickie!
Thanks
Tex
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/17/
- Original author: *anonymous
Ability to do some user administration if logged in as the root user.
Although it would probably be a lot of work.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/4/
- Original author: robbat2
When the tables are big (more than 30 fields) the
display of all fields is too slow and unnecessary.
Display the 10 first fields and all under request.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/6/
- Original author: *anonymous
There are many times when adding a new row is only
minor modification from a previous row.
In this case phpmyadmin should add a new button
(INSERT)
to the edit row page, to allow the newly edited data be
added to table instead of updating existing row.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/3/
- Original author: korakot
For config.inc.php3:
Added type synoynms for those that prefer them.
Complete change of function table to include most of the MySQL functions.
- Original URL: https://sourceforge.net/p/phpmyadmin/patches/5/
- Original author: robbat2
Browse a table with 70 records, click "End", then
press "previous" once.
Now at this point the "Previous" and "Begin" buttons
stop working.
or
Browse a table with 50 records, next click "End".
Now at this point the "Previous" and "Begin" buttons
stop working.
During these examples everything was set to the
default parameters.
Have fun :-)
- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/6/
- Original author: trafficg
Move strings that are not outsourced in main.php3 to
the language files.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/9/
- Original author: robbat2
Minor fix for the "<?" occuring on line 255 of tbl_properties.php3
- Original URL: https://sourceforge.net/p/phpmyadmin/patches/4/
- Original author: robbat2
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.