<?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^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 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)";