$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");
