MySQL PDO connection

Run a SQL INSERT statement to open and close a connection to Cloud SQL for MySQL by using the PHP Data Objects (PDO) extension.

Documentation pages that include this code sample

To view the code sample used in context, see the following documentation:

Code sample

PHP

// Use prepared statements to guard against SQL injection.
$sql = "INSERT INTO votes (time_cast, candidate) VALUES (NOW(), :voteValue)";

try {
    $statement = $conn->prepare($sql);
    $statement->bindParam('voteValue', $value);

    $res = $statement->execute();
} catch (PDOException $e) {
    throw new RuntimeException(
        "Could not insert vote into database. The PDO exception was " .
        $e->getMessage(),
        $e->getCode(),
        $e
    );
}

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.