When you are working on laravel projects and you need to use mysql function in where clause then you can easily use that using DBraw and whereRaw In this example you can show how to i use mysql function in where clause In this example i want to compare with year of createdat field but not w

Whenever you need to get nearest posts from lat and long and if you are working on laravel query builder then you can get distance easily using DBraw so you can learn from following example how to get nearest value from mysql laravelstrongExamplestrongpre classprettyprint langphp

Whenever you need to get nearest posts from lat and long and if you are working on laravel query builder then you can get distance easily using DBraw so you can learn from following example how to get nearest value from mysql laravelstrongExamplestrongpre classprettyprint langphp

Sometimes you require to add trigger in your mysql database of laravel 5 but you think how to create trigger using laravel migration because laravel not provide special function like insertTrigger and something so it problem to create direclty But laravel DBunprepared through we can create tri

Sometimes you require to add trigger in your mysql database of laravel 5 but you think how to create trigger using laravel migration because laravel not provide special function like insertTrigger and something so it problem to create direclty But laravel DBunprepared through we can create tri

This blog post discusses Orchestrator: MySQL Replication Topology Manager.

What is Orchestrator?

Orchestrator is a replication topology manager for MySQL.

It has many great features:

• The topology and status of the replication tree is automatically detected and monitored
• Either a GUI, CLI or API can be used to check the status and perform operations
• Supports automatic failover of the master, and the replication tree can be fixed when servers in the tree fail – either manually or automatically
• It is not dependent on any specific version or flavor of MySQL (MySQL, Percona Server, MariaDB or even MaxScale binlog servers)
• Orchestrator supports many different types of topologies, from a single …

Get an Early Look at the New NinesControl (beta)

We’re excited to announce NinesControl, a developer friendly service to deploy and manage MySQL, MariaDB and MongoDB clusters using your preferred Cloud Provider.

Building systems for the cloud today means designing an application and database architecture that is both resilient and scalable. However, setting up a database cluster can be time consuming and complex.

What is NinesControl?

NinesControl is a new online service for developers. With a couple of simple steps, you can deploy and manage MySQL, MariaDB and MongoDB clusters on your prefered public cloud.

Sign up up to stay informed and apply for early access

Who is it for?

NinesControl is specifically designed with …

In this tutorial we will explain how to install LiteCart on an Ubuntu 14.04 VPS with Nginx, PHP-FPM and MySQL. LiteCart is a free e-commerce, feature rich e-commerce solution. The framework is constructed to be lightweight and easy for developers to modify and build upon. LiteCart relies on the latest HyperText standard HTML 5, the latest CSS 3 for styling, the jQuery framework for client-side dynamics, and the popular web scripting language PHP for server-side dynamics. REQUIREMENTS We will be using our SSD 1 Linux VPS Hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully […]

In a previous post I took the new JSON datatype and functions for a test drive, using sample data provided by SF OpenData. Today I will extend that example to include indexing.

Introducing Generated Columns

MySQL 5.7 introduces a new feature called generated columns.…

In this post i show you how to use autocomplete with multiple select option by jquery I think you will did autocomplete for single option using jquery ui plugin but in this post you can learn multi selection autocomplete using jquery ui In bellow preview you can see how will output of your multis