Saturday, November 30, 2019

Remove CSS round border from iOS devices

Following CSS options must be enabled for your element:

element{
border-radius:0;
-webkit-appearance: none;
}

Saturday, November 23, 2019

Linux: Find and replace text from file

sed -i 's/text-to-replace/text-new/g' destination-file-path

Linux: Find and remove file in one command

Navigate to folder, find the file and remove using the following command. It also asks for confirmation before removing:

cd /destination-folder-path && find -type f -name filename -exec rm -i {} \;

Thursday, November 7, 2019

PHP - Get last element from array

//array is called here $arrayVariable

$lastElement=end($arrayVariable);

Example: 
If $arrayVariable=["apple","pear","peach","cherry"], the function above is to return cherry.

Thursday, October 31, 2019

PHP Get current date and insert to MySql Database


0. Make sure field to be inserted is of date type:



1. Get current date in php:
date_default_timezone_set("UTC");
$now=new DateTime();
echo $now->getTimestamp();

2. Connect to database and insert using the following statement:

$sql = "INSERT INTO bins (Number, Text, Created, TTL, Property)
VALUES (".$number.", '".$text."','".date("Y-m-d",$now->getTimestamp())."', '1','Active')";


if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
 

Saturday, September 7, 2019