(PHP-)Webentwickler-Links

(English below)

Ich habe hier angefangen eine Reihe Links für mich zusammen zu stellen, um in einem neuen Job mit den Browserbookmarks nicht komplett bei Null anfangen zu müssen. Der JavaScript-Teil ist etwas größer geraten, da er mit einem Update meiner Kenntnisse einherging. Das ist also eher eine „Notiz an mich selbst“. Viele der Links verweisen auf die englische Sprachversion der Seite, da diese meist aktueller sind.

This is a link list for PHP developers I primarily made (or rather „started to make“) for myself for the situation when I start with a new job with an empty browser history and without any Bookmarks. Some parts – especially the JavaScript part – are a bit more bloated than others as I created them while I was updating (or refreshing) my knowledge, so these parts may preferably be seen as a kind of „notices to myself“ …

Some of the links go to the german page versions – you can usually easily switch to english by clicking or selecting it on the linked page (btw. – in case the word „english“ or „language“ can’t be found there: the german word for „german“ is „Deutsch“, the one for „language“ is „Sprache“)

PHP

https://www.php.net/manual/de/funcref.php (add the search to your search providers to be able to directly search in php.net from your browser)
PCREs / RegExp: https://www.php.net/manual/de/pcre.pattern.php (to be used with preg_*-functions)
PDO (Database handling): https://www.php.net/manual/de/book.pdo.php
https://www.php.net/manual/de/book.reflection.php
Best Practice Standards: https://www.php-fig.org/psr/
https://www.phptutorial.net/php-oop/
https://docs.phpdoc.org/guide/references/phpdoc/index.html
https://github.com/php-fig/fig-standards/blob/master/proposed/phpdoc-tags.md
https://phpunit.de/documentation.html

PHP Debugging and Code Improvement
http://xdebug.org/
https://www.php.net/manual/de/intro.phpdbg.php
https://cs.symfony.com/ (Coding Standards Fixer)
https://getcomposer.org/

Online PHP shell (test in different versions)
https://3v4l.org/

Symfony & Doctrine

https://symfony.com/doc/current/setup.html
https://symfony.com/doc/current/reference/index.html
https://symfony.com/doc/current/doctrine.html
https://www.doctrine-project.org/projects/doctrine-orm/en/2.11/tutorials/getting-started.html
https://www.doctrine-project.org/projects/doctrine-orm/en/2.11/reference/association-mapping.html
https://symfony.com/bundles/KnpMenuBundle/current/index.html
https://symfony.com/bundles/SonataAdminBundle/current/index.html

JavaScript

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/String
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/TypedArray

Global functions
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/decodeURIComponent

jQuery

https://api.jquery.com/
https://api.jquery.com/category/utilities/
http://api.jquery.com/category/manipulation/
http://api.jquery.com/category/traversing/filtering/
https://api.jquery.com/prop/
https://api.jquery.com/attr/
https://api.jquery.com/css/
(… .css() can not handle „!important“-statements – use in that case:)
https://developer.mozilla.org/en-US/docs/Web/API/CSSStyleDeclaration/setProperty
https://api.jquery.com/category/deferred-object/
https://api.jquery.com/jQuery.fn.extend/
https://learn.jquery.com/plugins/
…
https://jqueryui.com/
https://jqueryui.com/download/
Ref.: https://api.jqueryui.com/
https://jquerymobile.com/
Ref.: https://api.jquerymobile.com/

Other JS-Frameworks …

Chart.js (simple data visualization)
https://www.chartjs.org/
https://www.chartjs.org/docs/latest/

leaflet.js (display and enrich maps)
https://leafletjs.com/SlavaUkraini/
https://leafletjs.com/SlavaUkraini/reference.html

React (Singe Page Apps similar to Angular.js)
https://reactjs.org/docs/getting-started.html
https://reactjs.org/docs/components-and-props.html
https://reactjs.org/docs/forms.html
https://reactjs.org/docs/events.html
Bidirectional binding in React:
… old approach:
https://reactjs.org/docs/two-way-binding-helpers.html
… today’s tools:
https://reactjs.org/docs/faq-state.html
https://reactjs.org/docs/hooks-overview.html

Node.js
https://nodejs.org/de/ (https://nodejs.org/en/)
https://nodejs.org/de/docs/
http://expressjs.com/
http://expressjs.com/en/starter/hello-world.html
http://expressjs.com/en/4x/api.html

Video embedding (JW Player)

https://www.jwplayer.com/
https://github.com/jwplayer/jwplayer
https://support.jwplayer.com/getting-started
https://developer.jwplayer.com/jwplayer/docs/jw8-add-a-player-library#self-hosted
https://developer.jwplayer.com/jwplayer/docs/jw8-embed-a-player
https://developer.jwplayer.com/jwplayer/docs/jw8-player-configuration-reference
https://support.jwplayer.com/topics/developer

SQL / Relational Databases etc.

Clients for MySQL-/MariaDB
https://www.heidisql.com/ (also available free of charge (and thus w/o account) in the MS Store)
https://www.mysql.com/products/workbench/
You may alternatively install https://www.phpmyadmin.net/ on your server (if you use PHP there), but make sure to safely protect it against unauthorised access!

MySQL statements
https://dev.mysql.com/doc/refman/8.0/en/examples.html
https://dev.mysql.com/doc/refman/8.0/en/sql-statements.html

MySQL Debugging-Informations
https://dev.mysql.com/doc/refman/8.0/en/show-variables.html
https://dev.mysql.com/doc/refman/8.0/en/setting-environment-variables.html
https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log

MySQL Glossary and thematic indexes
https://dev.mysql.com/doc/refman/8.0/en/indexes.html
https://dev.mysql.com/doc/refman/8.0/en/glossary.html

MariaDB
https://de.wikipedia.org/wiki/MariaDB
https://mariadb.com/docs/reference/

SQLite(3) – basic information:
Quick info for beginners: SQLite is a serverless relational database implementation comparable to MS Access (when used with .mdb-files).
Clients must thus implement all the necessary data processing logic, what they usually do by using the C/C++-API provided by sqlite.org. PHP comprises by default an SQLite3-Client and you can use it with PDO. Node.js also has a ready-made client. Thus, there is usually and conveniantly no need to install any further software on a server if you want to use an SQLite „database“ (or file, to be precise) with PHP or Node.js (or nearly any other code processing environment).
On the other hand, in many cases you should nontheless rethink if you really need the complexity of a database to achive your goal or if not a simple INI file or some XML could do the job, or – if you conclude, that a database is necessary – if you should not better use a more performant and remotely accessible database server like MySQL. All this of course depends on the specific situation and given parameters of your project.
To start with an empty SQLite-DB simply create an empty file „myDatabase.db“ (or the like) or, if you previously instalalled the CLI-Client, simply enter „sqlite3 myDatabase.db“ in your shell and the file will be created, if it does not exist. GUI clients habitually provide a wizard for this task.
To get a more detailed idea of SQLite see https://de.wikipedia.org/wiki/SQLite and https://www.sqlite.org/different.html.

SQLite(3) clients
CLI-Client: https://www.sqlite.org/cli.html (also comprises the manual, for example the list of „dot-commands“ and how to employ them) .
Ubuntu provides the CLI-Client as a package.
HeidiSQL (see also MySQL-Section) can also handle Sqlite3 quite reasonably (the feature is still marked „experimental“, but it will do for most of the basic operations).
There are many other specialised GUI-Clients, e.g the DB Browser for SQLite (also available as Ubuntu-Package) or SQLiteStudio.
Last but not least you have also the option to install https://www.phpliteadmin.org/ on your server, but – as with phpMyAdmin – remember to consider the security implications this has.

The „USE“ statement for the SQLite-CLI-client is represented by the „.open“ command. (in other environments you won’t need that as the connection you establish is usually already bound to a database(-file)). To be able to use more than one file (or a file and the „:memory:“-DB) you first need to attach the second data source by means of https://www.sqlite.org/lang_attach.html (and there is also a „detach“ of course).

SQLite(3) language references and some technical details
https://www.sqlite.org/lang.html
https://www.sqlite.org/docs.html
https://www.sqlite.org/faq.html
https://www.sqlite.org/lang_corefunc.html (see also Links to the Date & Time functions, aggregate functions, etc. there)
https://www.sqlite.org/keyword_index.html
https://www.sqlite.org/pragma.html
https://www.sqlite.org/quirks.html

Microsoft SQL Server & T-SQL (Transactional SQL)
https://docs.microsoft.com/de-de/sql/sql-server/?view=sql-server-ver15
Standard-Client:
https://docs.microsoft.com/de-de/sql/ssms/sql-server-management-studio-ssms?view=sql-server-ver15
HeidiSQL (see also MySQL-Section) can also connect to MS SQL Server and handle T-SQL

https://docs.microsoft.com/de-de/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports?view=sql-server-ver15