Browsed by
Tag: MySQL

Training: Mobile Apps Development with Intel XDK

Training: Mobile Apps Development with Intel XDK

Location: Medina Arabic Training & Solutions, Bangi Sentral (Above Melaka Kitchen Restauurant)   Date: 23th & 24th January 2016 Available Seats: 20 seats Fees: Student Package Intel XDK API 2 Days 150 1 Day 50 120   Public Package Intel XDK API 2 Days 250 1 Day 100 175 * Fee payment must be made first in order to reserved your seats.   Loading…   Register here if you unable to see the Google Form embed in this post.

Y2016

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

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: http://stackoverflow.com/questions/3075577/convert-mysql-datetime-stamp-into-javascripts-date-format http://stackoverflow.com/questions/12346381/set-date-in-input-type-date

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