if (!($stmt = $link->prepare("INSERT INTO Projectrec (uname, email, phone, raws3url, finisheds3url, jpegfilename, state, DateTime) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"))) {
echo "Prepare failed: (" . $link->errno . ") " . $link->error;
}
$uname = "MyName";
$email = $_POST['useremail'];
$phone = $_POST['phone'];
$raws3url = $url;
$jpegfname = basename($fname);
$finisheds3url = "none";
$state = 0;
$DateTime = date("Y-m-d H:i:s");
$stmt->bind_param("ssssssis", $uname, $email, $phone, $raws3url, $finisheds3url, $jpegfilename, $state, $DateTime);
if (!$stmt->execute()) {
echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
printf("%d Row inserted.\n", $stmt->affected_rows);
/* explicit close recommended */
$sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-west-2']);
$Arn = $sns->createTopic(['Name' => 'mp2']);
$subscribe = $sns->subscribe(['Endpoint' => $email, 'Protocol' => 'email', 'TopicArn' => $Arn['TopicArn']]);
$settopic = $sns->setTopicAttributes(['AttributeName' => 'DisplayName', 'AttributeValue' => 'mp2', 'TopicArn' => $Arn['TopicArn']]);
$publisher = $sns->publish(['Message' => 'Congrats!! Your Image has been uploaded Successfully', 'TopicArn' => $Arn['TopicArn']]);
header("location: gallery.php");
$stmt->close();
$link->real_query("SELECT * FROM Projectrec");
$res = $link->use_result();
echo "Result set order...\n";
while ($row = $res->fetch_assoc()) {
echo $row['id'] . " " . $row['email'] . " " . $row['phone'];
}
$link->close();
require 'vendor/autoload.php';
#use Aws\S3\S3Client;
#$client = S3Client::factory();
$s3 = new Aws\S3\S3Client(['version' => 'latest', 'region' => 'us-east-1']);
echo $_POST['useremail'];
$email = $_POST['useremail'];
$sn = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']);
$resARN = $sn->createTopic(['Name' => 'testmp2']);
print "List All Platform Applications:\n";
$Model1 = $sn->listTopics();
foreach ($Model1['Topics'] as $App) {
print $App['TopicArn'] . "\n";
}
print "\n";
$AppArn = $Model1['Topics'][0]['TopicArn'];
$resSetTopicAttr = $sn->setTopicAttributes(['AttributeName' => 'DisplayName', 'AttributeValue' => 'mp2tester', 'TopicArn' => $AppArn]);
$uploaddir = '/tmp/';
$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);
echo '<pre>';
if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) {
echo "File is valid, and was successfully uploaded.\n";
} else {
echo "Possible file upload attack!\n";
}
echo 'Here is some more debugging info:';
print_r($_FILES);
print "</pre>";
$bucket = uniqid("php-rca-", false);
#$result = $client->createBucket(array(
# 'Bucket' => $bucket
#));
$sql_insert = "INSERT INTO topic (topicarn,topicname) VALUES (?,?)";
if (!($stmt = $link->prepare($sql_insert))) {
echo "Prepare failed: (" . $link->errno . ") " . $link->error;
}
$stmt->bind_param("ss", $topicarn, $topicName);
if (!$stmt->execute()) {
print "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
// printf("%d Row inserted.\n", $stmt->affected_rows);
$stmt->close();
}
}
} else {
$sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']);
$topicName = 'Mp2-S3Upload1';
$result = $sns->createTopic(['Name' => $topicName]);
$topicarn = $result['TopicArn'];
// echo "topic arn value is ----------- $topicarn";
//set topic attributes
$result = $sns->setTopicAttributes(['AttributeName' => 'DisplayName', 'AttributeValue' => 'S3Upload', 'TopicArn' => $topicarn]);
$sql_insert = "INSERT INTO topic (topicarn,topicname) VALUES (?,?)";
if (!($stmt = $link->prepare($sql_insert))) {
echo "Prepare failed: (" . $link->errno . ") " . $link->error;
}
$stmt->bind_param("ss", $topicarn, $topicName);
if (!$stmt->execute()) {
print "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
$stmt->close();
}
$link->close();