$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; ##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]);
$raws3url = $url; $finisheds3url = "none"; $jpegfilename = basename($_FILES['userfile']['name']); $state = 0; $res = $link->query("SELECT * FROM MiniProject1 where email='{$email}'"); if ($res->num_rows > 0) { if (!($stmt = $link->prepare("INSERT INTO MiniProject1 (uname,email,phoneforsms,raws3url,finisheds3url,jpegfilename,state) VALUES (?,?,?,?,?,?,?)"))) { echo "Prepare failed: (" . $link->errno . ") " . $link->error; } $stmt->bind_param("ssssssi", $uname, $email, $phoneforsms, $raws3url, $finisheds3url, $jpegfilename, $state); if (!$stmt->execute()) { echo "Execute failed: (" . $stmt->errno0 . ") " . $stmt->error; } printf("%d Row inserted.\n", $stmt->affected_rows); $stmt->close(); $pub = $sns->publish(array('TopicArn' => $topicARN, 'Subject' => 'Image Upload Notification', 'Message' => 'Image is successfully uploaded and saved!')); $link->real_query("SELECT * FROM MiniProject1"); $res = $link->use_result(); echo "Result set order...\n"; while ($row = $res->fetch_assoc()) { echo $row['id'] . " " . $row['email'] . " " . $row['phoneforsms']; } $link->close(); $url = "gallery.php"; header('Location: ' . $url, true); die; } else { $url = "temp.php"; header('Location: ' . $url, true); die; }
$raws3url = $url; $finisheds3url = "none"; $jpegfilename = basename($_FILES['userfile']['name']); $state = 0; $stmt->bind_param("ssssssi", $uname, $email, $phoneforsms, $raws3url, $finisheds3url, $jpegfilename, $state); if (!$stmt->execute()) { echo "Execute failed: (" . $stmt->errno0 . ") " . $stmt->error; } printf("%d Row inserted.\n", $stmt->affected_rows); $stmt->close(); $sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']); $result1 = $sns->listTopics(array()); print_r($result1); $snsendpoint = $result1['Topics'][0]['TopicArn']; echo "============\n" . $snsendpoint . "================"; $publish1 = $sns->publish(array('TopicArn' => $snsendpoint, 'Message' => 'Image Inserted Successfully', 'Subject' => 'Image Insertion Notification')); echo "hiii"; //print_r($publish1); $link->real_query("SELECT * FROM MiniProject1"); $res = $link->use_result(); echo "Result set order...\n"; while ($row = $res->fetch_assoc()) { echo $row['id'] . " " . $row['email'] . " " . $row['phoneforsms']; } $link->close(); /*$url = "gallery.php"; header('Location: ' . $url, true); die();*/ ?>
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();
<?php require __DIR__ . '/vendor/autoload.php'; $sns = new Aws\Sns\SnsClient(['region' => 'ap-northeast-1', 'version' => '2010-03-31']); $topics = $sns->listTopics(); // Publish something to each topic foreach ($topics['Topics'] as $topic) { $rand1 = rand(1, 100); $rand2 = rand(1, 100); $response = $sns->publish(['TopicArn' => $topic['TopicArn'], 'Message' => "Start: {$rand1}, End: {$rand2}\n", 'Subject' => "Price Change"]); }
print "Execute failed: (" . $stmt->errno . ") " . $stmt->error; } //printf("%d Row inserted.\n", $stmt->affected_rows); $stmt->close(); $sql1 = "SELECT topicarn,topicname FROM topic "; $result = mysqli_query($link, $sql1); //$imgLocations = array(); //print "Result set order...\n"; if (mysqli_num_rows($result) > 0) { // output data of each row while ($row = mysqli_fetch_assoc($result)) { // echo "topicarn:".$row["topicarn"]."<br>"; if ($row["topicname"] == 'Mp2-S3Upload1') { //create sns and configure autoscaling to send notification to sns on alarm $sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']); $result = $sns->publish(['Message' => 'Image uploaded successfully', 'Subject' => 'Image has been uploaded successfully to S3', 'TopicArn' => $row["topicarn"]]); } //this will append the path of images to an array // $imgLocations[$row["JpgFileName"]] = $row["RawS3URL"]; // echo "id: " . $row["ID"]."- RawS3URL" . $row["RawS3URL"]. "<br>"; } } else { echo "----0 results"; } $link->close(); } function redirect() { // echo "inside redirect"; ?> <script>location.href='/gallery.php'</script>
} // 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']); ?>
if (!$stmt->execute()) { echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error; } else { //printf("%d Row inserted.\n", $stmt->affected_rows); #create sns client $sns = new Aws\Sns\SnsClient(['version' => 'latest', 'region' => 'us-east-1']); //to list topic list $result = $sns->listTopics(array()); //to get Topic ARN of MP2ImageSubscriptions foreach ($result['Topics'] as $key => $value) { if (preg_match("/MPFinalImageSubscriptions/", $result['Topics'][$key]['TopicArn'])) { $topicARN = $result['Topics'][$key]['TopicArn']; } } // to publish message $result = $sns->publish(array('TopicArn' => $topicARN, 'Subject' => 'AWS Email Notification', 'Message' => 'New image is uploaded..!!')); } #explicit close of prepared statement recommended $stmt->close(); #close db connection mysqli_close($link); //function to redirect function redirect($url, $statusCode = 303) { header('Location: ' . $url, true, $statusCode); die; } $url = "gallery.php"; redirect($url); } } else {
printf("%d Row inserted.\n", $stmt->affected_rows); /* explicit close recommended */ $stmt->close(); $link->real_query("SELECT * FROM data"); $res = $link->use_result(); echo "Result set order...\n"; while ($row = $res->fetch_assoc()) { echo $row['id'] . " " . $row['email'] . " " . $row['phone']; } $link->close(); #read replica to read the database $result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'jaysharma-readreplica']); $endpoint = $result['DBInstances'][0]['Endpoint']['Address']; echo "============\n" . $endpoint . "================"; $link1 = mysqli_connect($endpoint, "JaySharma", "sharma1234", "datadb") or die("Error " . mysqli_error($link)); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit; } $sqlsns = "SELECT * FROM snstopic"; $result = mysqli_query($link1, $sqlsns); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { $result = $sns->publish(['Message' => 'Congratulations your Image uploaded successfully', 'Subject' => 'UPLOAD', 'TopicArn' => $row["topicArn"]]); } } else { echo "SNS Result"; } $link1->close(); header("refresh:3;url=gallary1.php");