phpMyAdmin/Documentation — Bosnian @ Hosted Weblate

Exit Zen

1 ../phpmyadmin/docs/bookmarks.rst:4
	Source change ~~:ref:`glossary`~~Bookmarks English bc6e7668e6ee426392da6211a464c280 Bookmarks

2 ../phpmyadmin/docs/bookmarks.rst:8
	English You need to have configured the :ref:`linked-tables` for using bookmarks feature.

3 ../phpmyadmin/docs/bookmarks.rst:12
	Source change ~~:ref:`glossary`~~Storing bookmarks English bc6e7668e6ee426392da6211a464c280 Storing bookmarks

4 ../phpmyadmin/docs/bookmarks.rst:14
	English Any query that is executed can be marked as a bookmark on the page where the results are displayed. You will find a button labeled :guilabel:`Bookmark this query` just at the end of the page. As soon as you have stored a bookmark, that query is linked to the database. You can now access a bookmark dropdown on each page where the query box appears on for that database.

5 ../phpmyadmin/docs/bookmarks.rst:21
	English Variables inside bookmarks

6 ../phpmyadmin/docs/bookmarks.rst:23
	English Inside a query, you can also add placeholders for variables. This is done by inserting into the query SQL comments between ``/`` and ``/``. The special string ``[VARIABLE{variable-number}]`` is used inside the comments. Be aware that the whole query minus the SQL comments must be valid by itself, otherwise you won't be able to store it as a bookmark. Also, note that the text 'VARIABLE' is case-sensitive.

7 ../phpmyadmin/docs/bookmarks.rst:30
	English When you execute the bookmark, everything typed into the Variables input boxes on the query box page will replace the strings ``/[VARIABLE{variable-number}]/`` in your stored query.

8 ../phpmyadmin/docs/bookmarks.rst:34
	English Also remember, that everything else inside the ``/[VARIABLE{variable-number}]/`` string for your query will remain the way it is, but will be stripped of the ``/**/`` chars. So you can use:

9 ../phpmyadmin/docs/bookmarks.rst:42
	English which will be expanded to

10 ../phpmyadmin/docs/bookmarks.rst:48
	English in your query, where VARIABLE1 is the string you entered in the Variable 1 input box.

11 ../phpmyadmin/docs/bookmarks.rst:50
	English A more complex example, say you have stored this query:

12 ../phpmyadmin/docs/bookmarks.rst:56
	English If you wish to enter "phpMyAdmin" as the variable for the stored query, the full query will be:

13 ../phpmyadmin/docs/bookmarks.rst:63
	English NOTE THE ABSENCE OF SPACES inside the ``/**/`` construct. Any spaces inserted there will be later also inserted as spaces in your query and may lead to unexpected results especially when using the variable expansion inside of a "LIKE ''" expression.

14 ../phpmyadmin/docs/bookmarks.rst:69
	English Browsing a table using a bookmark

15 ../phpmyadmin/docs/bookmarks.rst:71
	English When a bookmark has the same name as the table, it will be used as the query when browsing this table.

16 ../phpmyadmin/docs/bookmarks.rst:76
	Source change :ref:`~~glossary~~faqbookmark`, :ref:`faq6_22` English bc6e7668e6ee426392da6211a464c280 :ref:`faqbookmark`, :ref:`faq6_22`

17 ../phpmyadmin/docs/charts.rst:4 • ../phpmyadmin/docs/credits.rst:273
	English a2809b302df8435a9025c7ff367e7697 Charts

18 ../phpmyadmin/docs/charts.rst:8
	English Since phpMyAdmin version 3.4.0, you can easily generate charts from a SQL query by clicking the "Display chart" link in the "Query results operations" area.

19 ../phpmyadmin/docs/charts.rst:13
	English A window layer "Display chart" is shown in which you can customize the chart with the following options.

20 ../phpmyadmin/docs/charts.rst:15
	English Chart type: Allows you to choose the type of chart. Supported types are bar charts, column charts, line charts, spline charts, area charts, pie charts and timeline charts (only the chart types applicable for current series selection are offered).

Shortcut	Action
`?`	Open available keyboard shortcuts.
`Alt` + `Home`	Navigate to the first translation in the current search.
`Alt` + `End`	Navigate to the last translation in the current search.
`Alt` + `PageUp` or `Ctrl` + `↑` or `Alt` + `↑` or `Cmd` + `↑` or	Navigate to the previous translation in the current search.
`Alt` + `PageDown` or `Ctrl` + `↓` or `Alt` + `↓` or `Cmd` + `↓` or	Navigate to the next translation in the current search.
`Ctrl` + `Enter` or `Cmd` + `Enter`	Submit current form; this works the same as pressing Save and continue while editing translation.
`Ctrl` + `Shift` + `Enter` or `Cmd` + `Shift` +`Enter`	Unmark translation as Needing edit and submit it.
`Alt` + `Enter` or `Option` + `Enter`	Submit the string as a suggestion; this works the same as pressing Suggest while editing translation.
`Ctrl` + `E` or `Cmd` + `E`	Focus on translation editor.
`Ctrl` + `U` or `Cmd` + `U`	Focus on comment editor.
`Ctrl` + `M` or `Cmd` + `M`	Shows Automatic suggestions tab.
`Ctrl` + `1` to `Ctrl` + `9` or `Cmd` + `1` to `Cmd` + `9`	Copies placeable of a given number from source string.
`Ctrl` + `M` followed by `1` to `9` or `Cmd` + `M` followed by `1` to `9`	Copy the machine translation of a given number to current translation.
`Ctrl` + `I` followed by `1` to `9` or `Cmd` + `I` followed by `1` to `9`	Ignore one item in the list of failing checks.
`Ctrl` + `J` or `Cmd` + `J`	Shows the Nearby strings tab.
`Ctrl` + `S` or `Cmd` + `S`	Focus on search field.
`Ctrl` + `O` or `Cmd` + `O`	Copy the source string.
`Ctrl` + `Y` or `Cmd` + `Y`	Toggle the Needs editing checkbox.
`→`	Browse the next translation string.
`←`	Browse the previous translation string.