PHP&MySQL — Learning Notes

15th July 2024 at 1:25pm

In this tiddlywiki: my notes for learning php & mysql, personal projects notes, useful links to learn, code snippets and playground using php-wasm.

This TiddlyWiki contains the following tiddlers:

📄
$:/03-02-2024
$:/23-05-2024
$:/config/AutoSave
$:/config/codemirror/theme
$:/config/DefaultMoreSidebarTab
$:/config/ExternalJS/EnableExternalPlugins
$:/config/ExternalJS/Prefix/Core
$:/config/ExternalJS/Prefix/Plugins
$:/config/fileUploads/uploadsEnabled
$:/config/NewJournal/Title
$:/config/PageControlButtons/Visibility/$:/core/ui/Buttons/home
$:/config/PageControlButtons/Visibility/$:/core/ui/Buttons/new-journal
$:/config/RelinkOnRename
$:/config/SaveWikiButton/Template
$:/config/Tiddlers/TitleLinks
$:/config/TiddlyWiki-CPL/GitHub
$:/config/ViewTemplateBodyFilters/missing
$:/config/ViewToolbarButtons/Visibility/$:/core/ui/Buttons/fold-bar
$:/core/ui/Buttons/stablelink
$:/core/ui/Buttons/stableview
$:/DefaultTiddlers
$:/Editor/Macro
$:/ExportWikiToHTML
$:/ExternalJS
$:/Import
$:/isEncrypted
$:/palette
$:/plugins/Telumire
$:/plugins/Telumire/Fonts/categories/customCategory
$:/plugins/Telumire/Fonts/categories/tc-body
$:/plugins/Telumire/Fonts/categories/tc-site-subtitle
$:/plugins/Telumire/Fonts/categories/tc-site-title
$:/plugins/Telumire/Fonts/categories/tc-tiddler-body
$:/plugins/Telumire/Fonts/categories/tc-title
$:/plugins/Telumire/Fonts/imports
$:/plugins/Telumire/PLM/ViewTemplate/title/nav
$:/plugins/Telumire/PLM/ViewTemplateTitleFilters/nav
$:/plugins/Telumire/Shortcuts/copy-code/full
$:/plugins/Telumire/Shortcuts/copy-code/short
$:/plugins/Telumire/Switcher/palettes
$:/portfolio/.github/workflows/main.yml
$:/portfolio/www/.htaccess
$:/portfolio/www/robots.txt
$:/portfolio/www/sitemap.xml
$:/portfolio/www/src/bootstrap.php
$:/portfolio/www/src/controllers/Account.php
$:/portfolio/www/src/controllers/Page.php
$:/portfolio/www/src/lib/ErrorHandler.php
$:/portfolio/www/src/lib/Logger.php
$:/portfolio/www/src/lib/LogLevels.php
$:/portfolio/www/src/model/Account.php
$:/portfolio/www/src/model/database.sql
$:/portfolio/www/templates/error.php
$:/portfolio/www/templates/home.php
$:/portfolio/www/templates/layout.php
$:/portfolio/www/templates/login.php
$:/portfolio/www/templates/soon.php
$:/showInfo/code/Stylesheet/ViewTemplate
$:/showInfo/macro/copy-code
$:/showInfo/macro/copy-code/examples
$:/showInfo/macro/copy-code/shortcuts/full
$:/showInfo/macro/copy-code/shortcuts/short
$:/showInfo/macro/copy-code/style
$:/showInfo/Stylesheet/Style
$:/SiteDomain
$:/SitePreviewUrl
$:/SiteSubtitle
$:/SiteTitle
$:/SiteUrl
$:/snippet/cc/PHP
$:/snippet/tagged
$:/SplashScreen
$:/state/add-plugin-info/$:/temp/ServerConnection/https://tiddlywiki.com/library/v5.3.5/index.html/$:/temp/RemoteAssetInfo/https://tiddlywiki.com/library/v5.3.5/index.html/$:/plugins/tiddlywiki/async
$:/state/add-plugin-info/$:/temp/ServerConnection/https://tiddlywiki.com/library/v5.3.5/index.html/$:/temp/RemoteAssetInfo/https://tiddlywiki.com/library/v5.3.5/index.html/$:/plugins/tiddlywiki/browser-storage
$:/state/add-plugin-info/$:/temp/ServerConnection/https://tiddlywiki.com/library/v5.3.5/index.html/$:/temp/RemoteAssetInfo/https://tiddlywiki.com/library/v5.3.5/index.html/$:/plugins/tiddlywiki/freelinks
$:/state/advancedsearch/currentTab
$:/state/http-requests
$:/state/showeditpreview
$:/state/sidebar
$:/state/tab--1498284803
$:/state/tab-1188684346
$:/state/tab-1749438307
$:/state/tab/sidebar--595412856
$:/status/RequireReloadDueToPluginChange
$:/StoryList
$:/Styles/Copy-code-to-clipboard
$:/Styles/CopyCodeFlash
$:/tagged
$:/themes/tiddlywiki/vanilla/options/sidebarlayout
$:/ui/TiddlerInfo/Prefix
$:/UploadURL
$:/UploadWithUrlOnly
$this
a/b/c
Accessibility
Accessibility with web animations
Adminer
Apache
Associative array
Calculer une Somme avec for
Check if input data send from form is empty
Comparison operators
Concatenation operator
Control structures
Conventional commits
create_filename() function
Creating Lottie JSON Animations
CSS
Echo shorthand
Escaping characters in PHP
Establishing a connection to a mysql database
Establishing a connection to a sqlite database
Examples
Filtrer des Éléments avec foreach et if
Formations Laravel
Générer du Contenu Dynamique avec for et echo
Get data from sql db with php
Home
hosting a php based website on a static file hosting with web assembly
How to set a secure cookie in PHP
HTML5
Import a database into PhPMyAdmin / Adminer
Indexed array
JavaScript (Front-End Validation)
Journal
Js
JS Form Validation
JS frameworks
Laragon
LARAGON – Update PHP
Learn PHP The Right Way (Program With Gio)
Learning objectives
Learning PHP, MySQL JavaScript, 6th Edition - Robin Nixon (2021)
Logical operators
Manifesto for software craftsmanship
Manipulation de Données SQL avec while et PDO
match
Mathematical operators
Mermaidjs macro
MVC
MySQL
New Tiddler
Parcourir un Tableau avec foreach
Passing `null` to Built-In String Functions in PHP 8.1+
PHP
PHP (Back-End Logic and Security)
PHP & MySQL: Server-side Web Development by Jon Duckett (15 February 2022)
PHP basics
PHP Block
PHP Classes
PHP coding style
PHP Comments
PHP Control structures
PHP Expressions
PHP Functions
PHP Objects
PHP Operators
PHP Types
PHP Variables
phpMyAdmin & xampp
playground-php
Principes SOLID
Project - Creating a Club Registration System
Project: Ebisu
Project: Portfolio
Projects
Projects folder location
Protect against XSS attack
References
Resetting a session
Sanitize input
Secure MySQL Database Connection with PHP and Form Submission Handling
Semantic Versioning
Sending emails using phpmailer
Separation of concern
Session timeout settings
Settings to connect to the SMTP server
SQL (Database Management)
SQL injection prevention
Starting a session
String operators
The Open Graph protocol
Transition from MD5 password encryption to a more robust system
Type juggling
URL to local php website
Useful functions
Utilisation des boucles pour la manipulation de données
UX Design Process
Validating structured data
yt player macro