Category: Php
-
Important laravel Sentinel Helper functions
Hello to all, welcome to therichpost.com. In this post, I will tell you, Important laravel Sentinel Helper functions. I am doing with laravel first time in my website. Laravel is one of the top php mvc framework. Here are the Important laravel Sentinel Helper functions and you can add these Sentinel Helper functions into your…
Written by
-
Important Mysql date, concat queries
Hello to all, welcome to therichpost.com. In this post, I will tell you Important Mysql date, concat queries. MySQL is an open source relational database management system. Here are the some Important Mysql date, concat queries: 1. Mysql concat two columns in single column: SELECT id, CONCAT(firstName, ‘-‘, phone) AS FIRSTNAME FROM `users` ORDER BY…
Written by
-
How to create custom middleware in laravel for user authorize?
Hello to all, welcome to therichpost.com. In this post, I will tell you, How to create custom middleware in laravel for user authorize? I am doing with laravel first time in my website. Laravel is one of the top php mvc framework. Here are the steps in laravel for making middleware: I have done this…
Written by
-
How to make like query in pdo mysql?
Hello to all, welcome to therichpost.com. In this post, I will tell you, How to make like query in pdo mysql? PDO means PHP Data Object. PDO is more secure and it is opps based. Here is the working like query in pdo mysql and you can do like this query: <?php //You can define…
Written by
-
Laravel custom raw queries example
Hello to all, welcome to the richpost.com. In this post, I will tell you, how to do raw queries in laravel? Laravel is one of the top Mvc php framework. Sometime we do custom queries in simple mysql in core php but In laravel there are some tricky ways to do this. Here is the…
Written by
-
How to change MySQL data in JSON format?
Hello to all, welcome to therichpost.com. In this post, I will tell you How to change MySQL data in JSON format? When we want to send data one page to other page then we can use json formatted data. We will save Mysql data in json format. We can this json formatted data jquery ajax…
Written by
-
How to create ajax middleware in laravel with php artisan command?
Hello to all, welcome to therichpost.com. In this post, I will tell you, How to create ajax middleware in laravel with php artisan command? I am doing with laravel first time in my website. Laravel is one of the top php mvc framework. Here are the steps in laravel for making middleware: I have done…
Written by
-
Mysql query for last 7 days and 30 days
Hello to all, welcome to therichpost.com. In this post, I will tell you Mysql query for last 7 days and 30 days. Today in my running project, I made query for getting last 7 days result and last 30 days result. Here is the query code for last 7 days and 30 days: where add_date…
Written by
-
How to remove .php extension from url?
Hello to all, welcome to therichpost.com. In this post, I will tell you How to remove .php extension from url? We will remove .php extension from url? and you need to add this code into your .htaccess file. Here is the working code and you need to add this .htaccess file: RewriteEngine On RewriteCond %{REQUEST_FILENAME}…
Written by
-
How php session works?
Hello to all, welcome to therichpost.com. Today, In this post, I will let you know How php session works? Sessions are very important and store unique value in it. Sessions are used to store unique data throughout the website. when php script is closed or session will be destroy after closing browser. Here is the…
Written by