How to Install Composer In Your Project ?
Run this in your command line: For more information please follow. https://getcomposer.org/doc/00-intro.md#installation-linux-unix-macos
Author Archives: phpspiderblog
How to remove primary key from table?
How to add primary key in table?
How to search JSON data in MySQL?
If you have JSON type columns in your database and want to run query on JSON type field. You can use the following query. In the above query <json_column> must be replace by your column name. $.id and $.response contains the JSON key of your columns. You can use for multiple values also. For example… Read More »
How to redirect from http to https using .htaccess ?
Redirect to https If you want to redirect each request coming should go to https instead of HTTP without any plugin. then Step1: Go to root directory of your website and look for .htaccess file. It should be exist in root directory. Step2: Find the ‘RewriteEngine On’ Add the following code after that. 1 2… Read More »
How to create custom helper functions in Laravel 5?
From the laravel official Laravel includes a variety of global “helper” PHP functions. Many of these helper functions are used by the framework itself; however, you are free to use them in your own applications if you find them convenient. Helpers are pre built utility functions in laravel which we can use directly without any… Read More »
Popular php repositories on github
If you want to know which php repositories are popular or trending on github now. Follow the following URL : Trending PHP repositories on GitHub
How to find duplicate rows from query ?
If you want to find duplicate rows from your table use the following query. SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1 Following are steps : To test the above query on sample table Step1 : First of all you need a table (Assuming you have… Read More »
Shri Ganeshaya Namah !
Jai Shree ganesh.
How to display image from database in PHP?
Step1 : Fetch/Retrieve the image from datbase using database functions. Step2 : Now use the image tag below. <?php $convertedImage =’CONVERTED_IMAGE_FROM_DB’; ?> <img src="data:image/jpg|gif|png;charset=utf8;base64,$convertedImage" /> jpg/gif/png depends on the type of image.<?php $convertedImage =’CONVERTED_IMAGE_FROM_DB’; ?> <img src="data:image/jpg|gif|png;charset=utf8;base64,$convertedImage" /> jpg/gif/png depends on the type of image.