<?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']); ?>