<?php
// Start the session^M
require 'vendor/autoload.php';
$rds = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-west-2']);
$result = $rds->createDBInstance(['AllocatedStorage' => 5, 'DBInstanceClass' => 'db.t1.micro', 'DBInstanceIdentifier' => 'isu-db', 'DBName' => 'customerrecords', 'Engine' => 'MySQL', 'MasterUserPassword' => 'ilovebunnies', 'MasterUsername' => 'controller', 'PubliclyAccessible' => true]);
print "Create RDS DB results: \n";
# print_r($rds);
$result = $rds->waitUntil('DBInstanceAvailable', ['DBInstanceIdentifier' => 'isu-db']);
// Create a table
$result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'isu-db']);
print_r($result);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
print "============\n" . $endpoint . "================\n";
print_r($endpoint);
//$endpoint = substr($endpoint,0,-5);
//print "================\n".$endpoint."===================\n";
$link = mysqli_connect($endpoint, "controller", "ilovebunnies", "customerrecords") or die("Error " . mysqli_error($link));
//echo "Here is the result: " . $link;
$sql = "CREATE TABLE comments \n(\nID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\nPosterName VARCHAR(32),\nTitle VARCHAR(32),\nContent VARCHAR(500)\n)";
$link > query($sql);
<?php
// Start the session^M
require 'vendor/autoload.php';
$rds = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-east-1']);
$result = $rds->createDBInstance(['AllocatedStorage' => 10, 'DBInstanceClass' => 'db.t1.micro', 'DBInstanceIdentifier' => 'mp1-jrh', 'DBName' => 'customerrecords', 'Engine' => 'MySQL', 'EngineVersion' => '5.5.41', 'MasterUserPassword' => 'letmein888', 'MasterUsername' => 'controller', 'PubliclyAccessible' => true]);
print "Create RDS DB results: \n";
# print_r($rds);
$result = $rds->waitUntil('DBInstanceAvailable', ['DBInstanceIdentifier' => 'mp1-jrh']);
// Create a table
$result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'mp1-jrh']);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
print "============\n" . $endpoint . "================\n";
$link = mysqli_connect($endpoint, "controller", "letmein888", "3306") or die("Error " . mysqli_error($link));
echo "Here is the result: " . $link;
$sql = "CREATE TABLE comments \n(\nID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\nPosterName VARCHAR(32),\nTitle VARCHAR(32),\nContent VARCHAR(500)\n)";
$con->query($sql);
?>
<?php
// Start the session
require 'var/www/html/vendor/autoload.php';
$rds = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-east-1']);
$result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'itmo444-mp1']);
$rds->waitUntil('DBInstanceAvailable', ['DBInstanceIdentifier' => 'itmo444-mp1']);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
print "============\n" . $endpoint . "================\n";
$link = mysqli_connect($endpoint, "balrifai", "ilovebunnies", "balrifai", 3306) or die("Error " . mysqli_error($link));
echo "Here is the result: " . $link;
$sql = "CREATE TABLE IF NOT EXISTS User \n(\nID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\nemail VARCHAR(20),\nusername VARCHAR(20),\ntelephone VARCHAR(20),\nraws3url VARCHAR(256),\nfinished3url VARCHCAR(256),\nfilename VARCHAR(256),\nstate TINYINT(3),\ndatetime VARCHAR\n\n)";
$link->query($sql);
shell - exec("chmod 600 setup.php");
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
// Start the session^M
require '/var/www/html/vendor/autoload.php';
$rds = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-east-1', 'credentials' => ['key' => '', 'secret' => '']]);
$result = $rds->createDBInstance(['AllocatedStorage' => 10, 'DBInstanceClass' => 'db.t1.micro', 'DBInstanceIdentifier' => 'jss-itmo444-db', 'DBName' => 'jsstestdb', 'Engine' => 'MySQL', 'MasterUserPassword' => 'letmein1234', 'MasterUsername' => 'controller', 'PubliclyAccessible' => true]);
print "Create RDS DB results: \n";
# print_r($rds);
$result = $rds->waitUntil('DBInstanceAvailable', ['DBInstanceIdentifier' => 'jss-itmo444-db']);
// Create a table
$result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'jss-itmo444-db']);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
print "============\n" . $endpoint . "================\n";
$link = mysqli_connect($endpoint, "controller", "letmein1234", "jss-itmo444-db") or die("Error " . mysqli_error($link));
#echo "Here is the result: " . $link;
$sql = "DROP TABLE IF EXISTS jssUserImages";
if (!mysqli_query($link, $sql)) {
echo "Error : " . mysqli_error($link);
}
$sql = "CREATE TABLE jssUserImages \n(\nID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\nusername VARCHAR(20),\nuseremail VARCHAR(20),\ntelephone VARCHAR(20),\nraws3url VARCHAR(256),\nfinisheds3url VARCHAR(256),\nfilename VARCHAR(256),\nstate TINYINT(3),\ndatetime timestamp \n)";
