PHP code example of google / cloud-bigquery
1. Go to this page and download the library: Download google/cloud-bigquery library. Choose the download type require. 2. Extract the ZIP file and open the index.php. 3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
google / cloud-bigquery example snippets
use Google\Cloud\BigQuery\BigQueryClient;
$bigQuery = new BigQueryClient();
// Get an instance of a previously created table.
$dataset = $bigQuery->dataset('my_dataset');
$table = $dataset->table('my_table');
// Begin a job to import data from a CSV file into the table.
$loadJobConfig = $table->load(
fopen('/data/my_data.csv', 'r')
);
$job = $table->runJob($loadJobConfig);
// Run a query and inspect the results.
$queryJobConfig = $bigQuery->query(
'SELECT * FROM `my_project.my_dataset.my_table`'
);
$queryResults = $bigQuery->runQuery($queryJobConfig);
foreach ($queryResults as $row) {
print_r($row);
}