Roman Ožana Roman's notes GitHub StackOverflow Twitter
  • Homepage
    • AI
    • Awesome list
    • Books
    • Earl Grey
    • Email
    • Gettings Real highlights
    • IOT
    • Jokes
    • LEGO
    • Lightsabers
    • Links
    • Payment
    • Queues
    • Regex testers
    • Regex
    • Retro console
    • Security list
    • Services
    • Stock Photos
    • Storage
    • AutoExpand textarea
    • Center div content
    • Display HTML with embed tag
    • HTML Skeleton
    • Highlighting external links
    • How to detect Retina display in CSS
    • Responsive Typography
    • Symbols
    • iMessage like Chat Bubbles with CSS and SVG
    • iOS like switch button with CSS and HTML
    • Backup mongo indexes
    • User agents
    • Docker cleanup guide
    • MariaDB and Docker Compose
    • Backup git repository as single bundle file
    • Clone all branches and tags at once
    • How to keep GitHub Fork Updated (no merge - the right way)
    • Bluetooth sensor mesh
    • Bonjour service for IOT
    • Install Nodejs and NPM on Raspberry Pi
    • Raspberry PI with Bonjour service and Time Machine
    • Read Temperature and Huminidy from MHO-C401
    • Add copy to clipboard button to all preformat code in pure Javascript
    • Creating nested menu from directory with Nodejs
    • Document write replacement
    • Editors
    • Javascript
    • Node.js
    • Packages
    • Polly.js
    • Server side Javascript
    • Yarn tips and tricks
    • Backup
    • Bikes
    • Jak správně přepsat ojeté auto
    • Jste hromádkář
    • Kindle
    • Návod na život
    • Parkinsonův zákon
    • Pro každý den
    • Quotes
    • Streaming services
    • Tik v oku
    • Život podle Charlese Bukowského
    • China shops list
    • Online účetnictví
    • Series
    • Apps and tools
    • Backup iCloud drive with rclone
    • Clean flash drive before unmount
    • Controll TimeMachine from terminal
    • Create macOS Big Sur ISO Image File
    • Delete local TimeMachine snapshots
    • Development tools
    • File management
    • Homebrew
    • Install Mongo on MacOS
    • Markdown editors
    • Retrieve AirPrint Printer IP address
    • Run FTP server on Mac OS X
    • Screenshotter settings
    • Toggle Hidden Files in Finder
    • Useful commands
    • 2020-11
    • 2020-12
    • 2020
    • 2021-01
    • 2021-02
    • 2021-03
    • 2021-04
    • 2021-07
    • Google Analytics alternative
    • Travel bag and Google AnaAnternative
    • Apps
    • Best cameras
    • Camera gear
    • Image viewers and managers
    • Photo storages
    • RAW Editors
    • The best Fujifilm X-mount lenses
    • Case insensitive in_array v PHP
    • Composer require PEAR package
    • Convert JSON data to valid PHP code
    • Convert MYSQL HEX to string with PHP
    • Get currency rates from ČNB in PHP
    • Getting GitHub latest release URL
    • Hardcore Simple Events Dispatcher for PHP
    • How to protect your emails with PHP and Javascript
    • How to safely commit vendor dir with php Composer
    • Jak okopírovat adresář s celým obsahem v PHP
    • PHP code speed comparison
    • Setup email sending from PHP on Mac
    • Snadné připojení k FTP pomocí PHP
    • Usefull traits
    • Výpočet hash objektu v PHP
    • YouTube embedding using PHP
    • Zjištění práv k souboru nebo adresáři v PHP
    • Jak (ne)napsat diplomku
    • Jak poznat Gisáka
    • Made in China
    • Mé Bulharské dobrodružství
    • Schůze, porady, meetingy a briefing
    • Awsome Tailwind
    • CSS only toggle switch using TailwindCSS (checkbox replacement)
    • Comment buble with Tailwind
    • Dropdown menu with Tailwind and Vanilla JS
    • Form validation with Tailwind
    • Showhide password with Tailwind and Vanilla JavaScript
    • Tailwind tooltip without Javascript (CSS only)
    • Create a tar archive from each folder
    • Download subreddit images
    • Download website mirror with wget
    • Exiftool tips and tricks
    • Join multiple GoPro MP4 files to single one
    • Load .env file in Bash
    • Response times with curl
    • Tools
    • Twitter and YouTube download
      • Convert GIF to WebM
      • Convert video for iMovie
      • Create image slideshow
      • Timelapse image capture
      • Download all images from website
    • CSS
    • Colors
    • Databases
    • Hosting
    • Icons
    • Add custom post type
    • Debug 404 page
    • Fist post in loop
    • Get user by metadata
    • Globals as static class
    • Heighlights search
    • Human-readable intervals
    • Monospaced fonts
    • Register widgets from PHP
    • Remove link manager
    • Syntax highlight
    • Use TinyMCE in user description
    • Wordpress Themes

#mysql

  • Convert MYSQL HEX to string with PHP