/
submit.php
119 lines (104 loc) · 3.12 KB
/
submit.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
// Start the session
session_start();
// In PHP versions earlier than 4.1.0, $HTTP_POST_FILES should be used instead
// of $_FILES.
echo $_POST['useremail'];
$uploaddir = '/tmp/';
$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);
$fname = $_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>";
require 'vendor/autoload.php';
$s3 = new Aws\S3\S3Client([
'version' => 'latest',
'region' => 'us-west-2'
]);
#print_r($s3);
$bucket = uniqid("nandinibuckettest",false);
echo $bucket;
# AWS PHP SDK version 3 create bucket
$result = $s3->createBucket([
'ACL' => 'public-read',
'Bucket' => $bucket,
]);
# PHP version 3
$result = $s3->putObject([
'ACL' => 'public-read',
'Bucket' => $bucket,
'Key' => $fname,
'SourceFile' => $uploadfile,
]);
$url = $result['ObjectURL'];
echo $url;
$rds = new Aws\Rds\RdsClient([
'version' => 'latest',
'region' => 'us-west-2'
]);
$result = $rds->describeDBInstances([
'DBInstanceIdentifier' => 'Project1db',
]);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
echo "============\n". $endpoint . "================";
$link = mysqli_connect($endpoint,"nandini","nandinipwd","Project1db") or die("Error " . mysqli_error($link));
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* Prepared statement, stage 1: prepare */
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();
?>