What is MySQL DBMS?
About 100 million copies of the MySQL software have been downloaded or distributed during its lifetime, making it the most widely used open source database program in the world. Because MySQL solves key issues...
Tagged: mysql
Dynamic pivot tables (transform rows to columns)
A pivot table in MySQL with dynamic headers. Assume we have a table of properties – ‘properties’ (script for its creation is provided below), and we need to do data transformation for the report....
Reasons for choosing Mysql storage over Firebase
Starting from a love letter from Google on Saturday, August 14, 2021, with details below, requires my attention to this issue. Based on this letter, my developer account will be closed because it has...
React Native Expo Login/Register with PHP Mysql database
Hello friends, back to our programming tutorial this time. For friends who are new to React native, it’s a good idea to read the article Get to know React, React Native, Bare React Native,...
Extract one table from mysqldump backup file
Starting from the difficulties I experienced, when I wanted to retrieve a table from a large mysqldump backup file… which was around 500mb and above, while the conventional method was too time-consuming even though...
Script simple backup database Mysql dengan command prompt
Confused looking for automatic backup for mysql database? Here are easy and simple steps to perform scheduled automatic backups using the command prompt bat script and Task Scheduler 1. Create a bat file with...
PHP Joomla: Generate certificates with the mpdf library
The company I work for happens to have to issue various certificates to many users, it would be very tiring if I had to input user names one by one. By generating the certificate...
Fabrik Joomla Component : Cheet Sheet Sample Code
Fabrik is one of the components in the Joomla CMS, the usefulness of the Fabrik component is a tool to easily create web applications. With Fabrik it is very easy to create forms and...
PHP: Creating Custom Feedback Forms in Joomla
There are various components provided by Joomla CMS to create forms, one of which is Fabric, but sometimes we also want to create our own custom forms for our own reasons, the form will...