<?php
require __DIR__ . '/vendor/autoload.php';
$sns = new Aws\Sns\SnsClient(['region' => 'ap-northeast-1', 'version' => '2010-03-31']);
$topics = $sns->listTopics();
// Subscribe an email address to each topic
foreach ($topics['Topics'] as $topic) {
$response = $sns->subscribe(['TopicArn' => $topic['TopicArn'], 'Protocol' => 'email', 'Endpoint' => '*****@*****.**']);
printf('Subscribe to "%s": %s' . PHP_EOL, $topic['TopicArn'], $response['SubscriptionArn']);
}
//$endpoint = $resultrds['DBInstances'][0]['Endpoint']['Address'];
# echo "============\n". $endpoint . "================";
//$link = mysqli_connect($endpoint,"testconnection1","testconnection1","Project1");
//if (mysqli_connect_errno()) {
// printf("Connect failed: %s\n", mysqli_connect_error());
// exit();
//}
//else {
#echo "Success";
//}
#create sns client
$sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']);
$result = $sns->listTopics(array());
foreach ($result['Topics'] as $key => $value) {
if (preg_match("/ImageTopicSK/", $result['Topics'][$key]['TopicArn'])) {
$topicARN = $result['Topics'][$key]['TopicArn'];
}
}
$result = $sns->subscribe(array('TopicArn' => $topicARN, 'Protocol' => 'email', 'Endpoint' => $useremail));
#echo "Sub-test".$result;
#print_r($result);
//if (!($stmt = $link->prepare("INSERT INTO MiniProject1 (uname,email,phoneforsms) VALUES (?,?,?)"))) {
// echo "Prepare failed: (" . $link->errno . ") " . $link->error;
//}
//$stmt->bind_param("sss",$username,$useremail,$phone);
//if (!$stmt->execute()) {
// echo "Execute failed: (" . $stmt->errno0 . ") " . $stmt->error;
//}
#printf("%d Row inserted.\n", $stmt->affected_rows);
//$stmt->close();
echo "You have not subscribed yet! please confirm subcription sent to your email, Then click <a href='index.php'/>redirect!</a>";
<?php
session_start();
require 'vendor/autoload.php';
echo $_POST['phone'];
$phone = $_POST['phone'];
$rds = new Aws\Rds\RdsClient(['version' => 'latest', 'region' => 'us-east-1']);
$result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'jaysharma-rds']);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
$link = mysqli_connect($endpoint, "JaySharma", "sharma1234", "datadb") or die("Error " . mysqli_error($link));
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
$sql1 = "SELECT topicArn,topicName FROM snstopic ";
$result = mysqli_query($link, $sql1);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
if ($row["topicName"] == 'A20344475-SNS-SERVICE') {
$sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']);
$result = $sns->subscribe(['Endpoint' => $phone, 'Protocol' => 'sms', 'TopicArn' => $row["topicArn"]]);
}
}
}
$sArn = $result['SubscriptionArn'];
echo $subArn;
echo "Subscribe by replying Yes";
header("refresh:5;url=index.php");
?>
$s3rawurl = $url;
// $result['ObjectURL']; from above
$filename = basename($_FILES['userfile']['name']);
$s3finishedurl = $finurl;
$status = 0;
$issubscribed = 0;
mysqli_query($link, "INSERT INTO comments (ID, uname,email,phone,rs3URL,fs3URL,jpgfile,state,date) VALUES (NULL, '{$uname}', '{$email}', '{$phone}', '{$s3rawurl}', '{$s3finishedurl}', '{$filename}', '{$status}', NULL)");
$results = $link->insert_id;
##echo $link->error;
##echo $results;
$resultsubArns = $sn->listSubscriptionsByTopic(['TopicArn' => $AppArn]);
print $resultsubArns;
$resulstPub = $sn->publish(['Message' => 'An image has been posted to the gallery', 'TopicArn' => $AppArn]);
} else {
#not in db add and send sns
$resultSub = $sn->subscribe(['Endpoint' => $email, 'Protocol' => 'email', 'TopicArn' => $AppArn]);
$uname = $_POST['username'];
#$email = $_POST['useremail'];
$phone = $_POST['phone'];
$s3rawurl = $url;
// $result['ObjectURL']; from above
$filename = basename($_FILES['userfile']['name']);
$s3finishedurl = $finurl;
$status = 0;
$issubscribed = 0;
mysqli_query($link, "INSERT INTO comments (ID, uname,email,phone,rs3URL,fs3URL,jpgfile,state,date) VALUES (NULL, '{$uname}', '{$email}', '{$phone}', '{$s3rawurl}', '{$s3finishedurl}', '{$filename}', '{$status}', NULL)");
$results = $link->insert_id;
$resultsubArns = $sn->listSubscriptionsByTopic(['TopicArn' => $AppArn]);
#print $resultsubArns;
$resulstPub = $sn->publish(['Message' => 'An image has been posted to the gallery', 'TopicArn' => $AppArn]);
##echo $link->error;
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();
}
// creating sns topic
$snsclient = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']);
#$result = $snsclient->createTopic(array(
// Name is required
# 'Name' => 'CloudTrigger',
#));
#echo "Topic Created";
#echo $result;
#$topicArn = $result['TopicArn'];
// set topic attributes to set a diaply name for topic
#$result = $snsclient->setTopicAttributes([
# 'AttributeName' => 'DisplayName',
# 'AttributeValue' => 'CloudTrigger',
# 'TopicArn' => $topicArn,
#]);
echo "set display name to topic";
for ($i = 0; $i < 120; $i++) {
echo "=";
}
// returns the subscription arn
$result = $snsclient->subscribe(['TopicArn' => 'arn:aws:sns:us-east-1:311615471368:snsself', 'Protocol' => 'sms', 'Endpoint' => '13123950502']);
echo "Subcribed to topic for 3123950502";
echo $result;
for ($i = 0; $i < 120; $i++) {
echo "=";
}
$result = $snsclient->publish(['Message' => 'Check AWS', 'Subject' => 'Cloud Trigger', 'TopicArn' => 'arn:aws:sns:us-east-1:311615471368:snsself']);
?>
