Category : PHP



How to get current month data in MySql PHP ?

If you require to get all the records of current month using mysql query. for example you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this month. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In following example you can see how to select data of current month. <strong class="example">Example:</strong> <pre class="language-mysql">SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 MONTH);</pre>

By Hardik Savani | March 17, 2016 | | 5146 Viewer | Category : PHP
READ MORE

How to count number of files in directory PHP?

If you are working on code php and you require to count number of files, images, zip file, rar files, etc in the given folder path, then you can count using glob() and count() of php. So, let's see this bellow example and learn how it done. <strong class="example"></strong> <pre class="prettyprint lang-php"> $folderPath = "upload/"; $countFile = 0; $totalFiles = glob($folderPath . "*"); if ($totalFiles){ $countFile = count($totalFiles); } print_r($countFile); </pre>

By Hardik Savani | March 14, 2016 | | 3322 Viewer | Category : PHP
READ MORE

How to remove specific value from php array?

When i was working on my code PHP project, at that time i need to remove specific items value from my array. i did google search and solve that but i would like to share in my site how to remove value from array. so, let's see how to use: <strong class="example">Example:</strong> <pre class="prettyprint lang-php"> $myArray = array('php', 'laravel', '.net', 'java', 'c#', 'javascript'); $myArray = array_diff($myArray, array('laravel')); print_r($myArray); </pre>

By Hardik Savani | March 14, 2016 | | 1188 Viewer | Category : PHP
READ MORE

How to create Event for Mail sending in Laravel 5.2?

Events provides a simple observer implementation, allowing you to subscribe and listen for events in your application. In this posts you can learn how to create event for email send in your laravel 5.2 application. event is very help to create proper progmamming way. First create event using bellow command. <pre class="prettyprint lang-php">php artisan make:event SendMail</pre> Ok, now you can see file in this path <strong class="path">app/Events/SendMail.php</strong> and put bellow code in that file. <strong>app/Events/SendMail.php</strong> <pre class="prettyprint lang-php"> namespace App\Ev.....

By Hardik Savani | March 13, 2016 | | 47137 Viewer | Category : PHP
READ MORE

Laravel 5.2 chat message module using socket.io, redis, express and nodejs from from scratch.

In this tutorial, i going to show you how to make real time chat message module using socket.io, redis, express and nodejs in Laravel 5. socket.io through we can make real time chat module in our Laravel 5 application. i show you from scratch because you can install nodejs and its packages etc. in this post you can undestand and learn step by istalling and how to write code. You have to follow the step and implement real time chat module in your application. So basically you can see bellow preview of our chat message module. <strong>Preview:</strong> <img width="100%" src="/upload/socketio.png.....

By Hardik Savani | March 12, 2016 | | 159163 Viewer | Category : PHP
READ MORE

Sql function remove numeric characters from column example

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove numeric characters from table field value. this function through you can also remove numeric characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeNumber function:</strong> <pre class="prettyprint lang-mysql"> DROP FUNCTION IF EXISTS removeNumber; DELIMITER | CREATE FUNCTION removeNumber( str CH.....

By Hardik Savani | March 12, 2016 | | 1275 Viewer | Category : PHP
READ MORE

How to remove special characters by mysql custom function.

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove special characters from table field value. this function through you can also remove special characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeSpacialChar function:</strong> <pre class="prettyprint lang-mysql"> CREATE FUNCTION `removeSpacialChar`(`in_str` varchar(4096)) RETURNS varchar(4096) C.....

By Hardik Savani | March 10, 2016 | | 7254 Viewer | Category : PHP
READ MORE

How to add mysql trigger from migrations in Laravel 5?

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 DB::unprepared() through we can create trigger for database. In Following example you can see how to create migration and create trigger code and how to write drop trigger code, so let's do it this way. <strong class="step">Create Migration:</strong> <pre>php artisan make:migration add_trigger</pre> <strong class="step">Migration:</stron.....

By Hardik Savani | March 8, 2016 | | 11545 Viewer | Category : PHP
READ MORE

Multi select autocomplete jquery example with code

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 multiselect autocomplete because its like choose js or something like plugin. But for layout i just add my own css. this example i use jquery ui js file and one more multiselect js file that file through we can do multi select and one more thing you can also customization of autocomplete.multiselect.js fi.....

By Hardik Savani | March 8, 2016 | | 35063 Viewer | Category : PHP
READ MORE

How to confige Elasticsearch in our local system

In this tutorials we have learn how to configer a Elastic search in our local system. follow this step and easily configer an Elastic Search. <strong class="step">1) Step 1 — Installing Java :</strong> -Before installing OpenJDK with APT, update the list of available packages for installation on your Ubuntu Droplet by running the command: <pre class="prettyprint lang-php prettyprinted"> <span style="color:#FFFFFF;font-weight:900;">$ sudo apt-get update</span> </pre> -After that, you can install OpenJDK with the command: <pre class="prettyprint lang-php prettyprinted"> <span style="color:#.....

By Hardik Savani | March 7, 2016 | | 7867 Viewer | Category : PHP
READ MORE

    How to execute artisan commands from route or controller in Laravel ?

    How to execute artisan commands from route or controller in Laravel ?

    Open Post

    How to add custom jquery validation for image file upload in summernote ?

    How to add custom jquery validation for image file upload in summernote ?

    Open Post

    Jquery - How to copy text to clipboard without flash example ?

    Jquery - How to copy text to clipboard without flash example ?

    Open Post

    Ajax Image Upload using PHP and jQuery Example from scratch

    Ajax Image Upload using PHP and jQuery Example from scratch

    Open Post

    Laravel 5 Stripe example using Laravel Cashier from Scratch

    Laravel 5 Stripe example using Laravel Cashier from Scratch

    Open Post

    Paypal payment gateway integration in php source code example

    Paypal payment gateway integration in php source code example

    Open Post