FilesExpand file tree

 cakephp

/

main.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

58 lines (52 loc) · 1.72 KB

 cakephp

/

main.php

Copy path

Top

File metadata and controls

• Code
• Blame

58 lines (52 loc) · 1.72 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

<?php

/**

* Copyright 2015 Google Inc. All Rights Reserved.

*

* 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.

*/

require_once __DIR__.'/vendor/autoload.php';

// [START all]

// [START build_service]

$client = new Google_Client();

$client->useApplicationDefaultCredentials();

$client->addScope(Google_Service_Bigquery::BIGQUERY);

$bigquery = new Google_Service_Bigquery($client);

// [END build_service]

$projectId = '';

if ($projectId) {

// The programmer already set the projectId above.

} elseif ($argc > 1) {

$projectId = $argv[1];

} else {

echo 'Enter the project ID: ';

$projectId = trim(fgets(STDIN));

}

// [START run_query]

// Pack a BigQuery request.

$request = new Google_Service_Bigquery_QueryRequest();

$request->setQuery('SELECT TOP(corpus, 10) as title, COUNT(*) as unique_words '.

'FROM [publicdata:samples.shakespeare]');

$response = $bigquery->jobs->query($projectId, $request);

$rows = $response->getRows();

// [END run_query]

// [START print_results]

// Print the results to stdout in a human-readable way.

echo "\nQuery Results:\n------------\n";

foreach ($rows as $row) {

foreach ($row['f'] as $field) {

printf('%-30s', $field['v']);

}

echo "\n";

}

// [END print_results]

// [END all]