Category : PHP

MYSQL Get column names concatenated

If you want to get a table column names from mysql database as a concatenated string, you can use the following code

Data scraping using guzzle HTTP

This snippet will teach you how to scrape data from any website using guzzle http with php

MYSQL swap two fileds values in mySql

If you have a table and want to swap two field values together, here is a simple snippet.

From Excel to SQL Query

If you have data in an Excel sheet and would like to create a sql query to add/insert data here is the way,

disable dates before today in input type date

this snippet will teach you how to disable dates before today in input type date

Get unique values from multi-dimensional array

Sometimes you have a multi-dimensional array and you only need the unique arrays in it. here is a simple solution using pure php function

Increase memory size or execution time

In case you wanted to increase memory size or loading or execution time here is this small snippet

Mysql timestamp to date

To convert a mysql date to an ordinary date you can use the following snippet

Search in a multi-dimensional array

If you want to search for a value in a certian column in a multi-dimensional array, consider using one of the following examples.