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;
}
 

iPhone fix curly quotation marks to use default ASCII

1. Go to Settings 
2. General 
3. Keyboard
4. Disable Smart Punctuation.

PHP redirect to url command

header('Location: prod/index.php');

RedHat - check installed Apache httpd and latest version available

1. Check installed and latest version:
yum list httpd

Output:


Installed Packages                                                                  2.4.6-45.el7_3.4                                                                                          

Available Packages
 2.4.6-88.el7

2. List ChangeLog:

rpm -q --changelog httpd


OUTPUT:

* Mon May 28 2018 Luboš Uhliarik <luhliari@redhat.com> - 2.4.6-80.1
- Resolves: #1560609 - httpd: active connections being terminated when httpd
  gets gracefully stopped/restarted, GracefulShutdownTimeout is not being
  honored

* Mon Jan 08 2018 Luboš Uhliarik <luhliari@redhat.com> - 2.4.6-80
- Related: #1288395 - httpd segfault when logrotate invoked

* Wed Nov 01 2017 Luboš Uhliarik <luhliari@redhat.com> - 2.4.6-79
- Resolves: #1274890 - mod_ssl config: tighten defaults

....

Splunk Chart Legend: Fix start and end truncation

In order to avoid annoying ... punctuation when displaying a chart legend in Splunk, please follow next steps:

1. Edit the report/Dashboard and View Source

2. Look for the following patterns 

<option name="charting.legend.labelStyle.overflowMode">ellipsisStart</option>
OR
<option name="charting.legend.labelStyle.overflowMode">ellipsisEnd</option>

3. Replace with

<option name="charting.legend.labelStyle.overflowMode">ellipsisNone</option>

curl to disable/stop AEM component from under /system/console/components

Disable:
curl -d "action=disable" -u admin:"pass" -X POST http://IP:Port/system/console/components/component-name


Enable:
curl -d "action=enable" -u admin:"pass+" -X POST http://IP:Port/system/console/components/component-name

AWS CLI - Show snapshots for volume

1. List all snapshots for specific volume:
aws ec2 describe-snapshots --filters "Name=volume-id, Values=vol-xxxxxx"


2. If in progress, you can check following for status after getting snapshot-id at step 1:
aws ec2 describe-snapshots --snapshot-id snap-xxxx


You shall get something like the below:

...


            "VolumeId": "vol-xxxxx",
            "State": "pending",
            "VolumeSize": 900,
            "StartTime": "2019-06-30T21:26:16.662Z",
            "Progress": "46%",
            "OwnerId": "xxxx",
            "SnapshotId": "snap-xxxxx"
...