FilesExpand file tree

 phpunit-update

/

app.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

94 lines (79 loc) · 2.67 KB

 phpunit-update

/

app.php

Copy path

Top

File metadata and controls

• Code
• Blame

94 lines (79 loc) · 2.67 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

<?php

/**

* Copyright 2016 Google Inc.

*

* Licensed under the Apache License, Version 2.0 (the "License");

* you may not use this file except in compliance with the License.

* You may obtain a copy of the License at

*

* http://www.apache.org/licenses/LICENSE-2.0

*

* Unless required by applicable law or agreed to in writing, software

* distributed under the License is distributed on an "AS IS" BASIS,

* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

* See the License for the specific language governing permissions and

* limitations under the License.

*/

# [START gae_php_mysql_app]

use Silex\Application;

use Silex\Provider\TwigServiceProvider;

use Symfony\Component\HttpFoundation\Request;

// create the Silex application

$app = new Application();

$app->register(new TwigServiceProvider());

$app['twig.path'] = [ __DIR__ ];

$app->get('/', function () use ($app) {

/** @var PDO $db */

$db = $app['database'];

/** @var Twig_Environment $twig */

$twig = $app['twig'];

// Show existing guestbook entries.

$results = $db->query('SELECT * from entries');

return $twig->render('cloudsql.html.twig', [

'results' => $results,

]);

});

$app->post('/', function (Request $request) use ($app) {

/** @var PDO $db */

$db = $app['database'];

$name = $request->request->get('name');

$content = $request->request->get('content');

if ($name && $content) {

$stmt = $db->prepare('INSERT INTO entries (guestName, content) VALUES (:name, :content)');

$stmt->execute([

':name' => $name,

':content' => $content,

]);

}

return $app->redirect('/');

});

// function to return the PDO instance

$app['database'] = function () use ($app) {

// Connect to CloudSQL from App Engine.

$dsn = getenv('MYSQL_DSN');

$user = getenv('MYSQL_USER');

$password = getenv('MYSQL_PASSWORD');

if (!isset($dsn, $user) || false === $password) {

throw new Exception('Set MYSQL_DSN, MYSQL_USER, and MYSQL_PASSWORD environment variables');

}

$db = new PDO($dsn, $user, $password);

return $db;

};

# [END gae_php_mysql_app]

$app->get('create_tables', function () use ($app) {

/** @var PDO $db */

$db = $app['database'];

// create the tables

$stmt = $db->prepare('CREATE TABLE IF NOT EXISTS entries ('

. 'entryID INT NOT NULL AUTO_INCREMENT, '

. 'guestName VARCHAR(255), '

. 'content VARCHAR(255), '

. 'PRIMARY KEY(entryID))');

$result = $stmt->execute();

if (false === $result) {

return sprintf("Error: %s\n", $stmt->errorInfo()[2]);

} else {

return 'Tables created';

}

});

return $app;