Browsed by
Category: MySQL

Y2016 ?>


Year 2016, InsyaAllah, next year to be a year of sharing knowledge of what I’ve learnt so far. Following are the trainings I would like to conduct: 1. Mobile Apps Development with jQuery Mobile 2. Mobile Apps Development with Intel XDK (incoming) 3. API Development with Slim Framework (incoming) 4. PHP Basic / Advanced 5. Web Development with CakePHP 3 (incoming) 6. Web Development with Laravel 5 (incoming) 7. Web Development with Yii Framework 2 (incoming) 8. WordPress for Developers…

Read More Read More

7z: Zip MySQL Database Dump File via Batch File ?>

7z: Zip MySQL Database Dump File via Batch File

First, get 7zip Command Line here. Next, unzip to your desired directory – mine is in C:\7za920. Based on my previous post, MySQL: Backup Database using Batch File. Add the following lines after echo Database Backups Completed and before pause. Now you are done! Execute the batch file to see the result! p/s: >Log.txt 2>&1 used for creating a log file for all the process to zip the file.

jQuery Plugin: MySQL DateTime to Input Date Format ?>

jQuery Plugin: MySQL DateTime to Input Date Format

Simple solutions to convert MySQL DateTime to Input Date Format. You may change the format as your requirement. References:

Web Services: Slim Framework + Eloquent(Laravel) ?>

Web Services: Slim Framework + Eloquent(Laravel)

Setting up the Restful API is easy with Slim Framework & Eloquent(Laravel). Here are the steps: Install required components via composer – Slim Framework + Eloquent(Laravel) Create a database called web_services and create users table. Setting up Eloquent Setting up Routes Final Touch Install the necessary components using composer – create a composer.json and save it in a working directory and run composer install. We’re creating a simple web services for Users – Simple CRUD. Create a database called web_services…

Read More Read More

Micro-framework: Slim ?>

Micro-framework: Slim

Setting up Slim Application Create a folder for your project, mine called slim create a composer.json in the directory and open up your Command Prompt / Terminal and run composer install. Later you should have something similar to Screenshot #2. Setting up RedBeanPHP4 Download RedbeanPHP4 Create a folder named RedBeanPHP4 in vendor directory and extract download zip file above and copy the rb.php into slim/vendor/RedBeanPHP4 – see Screenshot #2. Include the rb.php in slim/vendor/autoloader.php Then, add MySQL connection settings. Let’s…

Read More Read More

MySQL: Save Arabic Characters / Words ?>

MySQL: Save Arabic Characters / Words

Database / Table for Arabic Usage Charset – UTF-8 Collation – utf8_unicode_ci Example: In CakePHP, make sure to set ‘encoding’ => ‘utf8’ in database.php. You can have Arabic Lorem Ipsum at Multilanguage Lorem Ipsum Generator For web page, please ensure to add meta tag, charset `utf-8′, as following: Reference: How to save Arabic Words Into MySQL Table

RDBMS Data Limit ?>

RDBMS Data Limit

== Microsoft SQL Server == Max DB Size: 524,272 TB (32 767 files * 16 TB max file size) Max Table Size: 524,272 TB Max Row Size: 8,060 bytes (Unlimited) Max Columns Per Row: 30,000 Max Blob / Clob Size: 2 GB Max Char Size: 2 GB Max Number Size: 126 bits Min Date Value: 0001 Max Date Value: 9999 Max Column Name Size: 128 == MySQL == Max DB Size: Unlimited Max Table Size: MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB Max Row Size:…

Read More Read More