public function findDatabases()
{
$result = $this->rdsClient->describeDBInstances();
$rows = $result->search('DBInstances[]');
$collection = new \AwsInspector\Model\Collection();
foreach ($rows as $row) {
$collection->attach(new Database($row));
}
return $collection;
}
<?php
session_start();
require 'vendor/autoload.php';
$_SESSION['upload'] = $_POST["email"];
$sessionUp = $_SESSION['upload'];
# Creating a client for the s3 bucket
use Aws\Rds\RdsClient;
$client = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-east-1']);
$result = $client->describeDBInstances(['DBInstanceIdentifier' => 'mp1-jgl']);
$endpoint = "";
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
# Connecting to the database
$link = mysqli_connect($endpoint, "controller", "letmein888", "customerrecords") or die("Error " . mysqli_error($link));
/* Checking the database connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
if (!empty($_POST['email'])) {
$email = $_POST["email"];
$link->real_query("SELECT * FROM jgldata WHERE email='" . $email . "'");
} else {
$link->real_query("SELECT * FROM jgldata");
}
$res = $link->use_result();
?>
<!DOCTYPE html>
<html lang="de">
$index_list = array('instance_id', 'image_id', 'dns_name', 'kname', 'instance_type', 'launch_dtime', 'region', 'subnet_id', 'vpc_id', 'local_ip', 'public_ip', 'security_group', 'status');
$ec2_outlist[] = '| ' . implode(' | ', $index_list) . ' |';
foreach ($ec2_infos as $info) {
$launch_dtime = $info[6]->__toString();
$launch_dtime = substr($launch_dtime, 0, 19);
$launch_dtime = str_replace('T', ' ', $launch_dtime);
$dt = new DateTime($launch_dtime, new DateTimeZone('UTC'));
$launch_dtime = $dt->setTimeZone(new DateTimeZone('Asia/Tokyo'))->format('Y-m-d H:i:s');
$tmp = array('instance_id' => $info[0], 'image_id' => $info[1], 'dns_name' => $info[3], 'kname' => $info[4], 'instance_type' => $info[5], 'launch_dtime' => $launch_dtime, 'region' => $info[7], 'subnet_id' => $info[8], 'vpc_id' => $info[9], 'local_ip' => $info[10], 'public_ip' => $info[11], 'security_group' => implode(',', $info[12]), 'status' => $info[2]);
$ec2_outlist[] = '| ' . implode(' | ', $tmp) . ' |';
}
print "###EC2\n";
print implode("\n", $ec2_outlist) . "\n\n";
//RDS情報取得
$rds = new RdsClient(['region' => 'ap-northeast-1', 'version' => '2014-10-31']);
$dbinstances = $rds->describeDBInstances();
$columns = sprintf("DBInstanceIdentifier," . "DBInstanceClass," . "Engine," . "DBInstanceStatus," . "MasterUsername," . "DBName," . "Endpoint," . "AllocatedStorage," . "InstanceCreateTime," . "DBSecurityGroups," . "VpcSecurityGroups," . "AvailabilityZone," . "MultiAZ," . "EngineVersion," . "PubliclyAccessible," . "StorageType");
$rds_infos = $dbinstances->search('DBInstances[].[' . $columns . ']');
$rds_outlist = array();
$index_list = array('instance_name', 'instance_type', 'db_engine', 'version', 'master_user', 'db_name', 'endpoint', 'port', 'strage', 'strage_type', 'create_dtime', 'security_group', 'region', 'multi_az', 'public', 'status');
$rds_outlist[] = '| ' . implode(' | ', $index_list) . ' |';
foreach ($rds_infos as $info) {
$launch_dtime = $info[8]->__toString();
$launch_dtime = substr($launch_dtime, 0, 19);
$launch_dtime = str_replace('T', ' ', $launch_dtime);
$dt = new DateTime($launch_dtime, new DateTimeZone('UTC'));
$launch_dtime = $dt->setTimeZone(new DateTimeZone('Asia/Tokyo'))->format('Y-m-d H:i:s');
$security_group = '';
if ($info[9]) {
$security_group = implode(',', $info[9]);
} elseif (count($info[10]) > 0) {
<html>
<head><title>JSS Gallery</title>
</head>
<body>
<?php
session_start();
ini_set('display_errors', 1);
$userEmail = $_POST['userInputEmail'];
echo $userEmail;
require '/var/www/html/vendor/autoload.php';
use Aws\Rds\RdsClient;
$rds = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-east-1', 'credentials' => ['key' => '', 'secret' => '']]);
$result = $rds->describeDBInstances(array('DBInstanceIdentifier' => 'jss-itmo444-db'));
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
// Do something with the message
echo "============" . $endpoint . "================ <br />";
//echo "begin database";
$link = mysqli_connect($endpoint, "controller", "letmein1234", "jssitmo444db") or die("Error " . mysqli_error($link));
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
//below line is unsafe - $userEmail is not checked for SQL injection -- don't do this in real life or use an ORM instead
$link->real_query("SELECT * FROM jssUserImages WHERE userEmailTable = '{$userEmail}'");
//$link->real_query("SELECT * FROM jssUserImages");
$res = $link->use_result();
echo "Result set order... <br />";
//if the session is valid it uses CSS to show a red header, if not CSS shows a blue header. If the session never occurs it shows a blank page.
while ($row = $res->fetch_assoc()) {
<!-- 2. Add images to <div class="fotorama"></div>. -->
<div class="fotorama" data-width= "1200" data-ratio="1200/467" data-max-width="100%">
<!-- 3. Enjoy! -->
<body>
<?php
session_start();
$email = $_POST["email"];
echo $email;
require 'vendor/autoload.php';
use Aws\Rds\RdsClient;
$client = new Aws\Rds\RdsClient(['region' => 'us-east-1', 'version' => 'latest']);
$result = $client->describeDBInstances(array('DBInstanceIdentifier' => 'mp1-db'));
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
//echo "begin database";
$link = mysqli_connect($endpoint, "controller", "letmein888", "customerrecords", 3306) or die("Error " . mysqli_error($link));
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
//below line is unsafe - $email is not checked for SQL injection -- don't do this in real life or use an ORM instead
//$link->real_query("SELECT * FROM arshadsTable WHERE email = '$email'");
$link->real_query("SELECT * FROM arshadsTable");
$res = $link->use_result();
echo "Result set order...\n";
while ($row = $res->fetch_assoc()) {
echo "<img src =\" " . $row['s3rawurl'] . "\" /><img src =\"" . $row['s3finishedurl'] . "\"/>";
