# `PDO_MySQL`: Example for Connecting to `TiDB Cloud`

```
  <?php
  echo "PDO_MySQL Example for TiDB Cloud" . "<p>";

  $host = "gateway01.us-west-2.prod.aws.tidbcloud.com";
  $port = 4000;
  $user = "3pMz3G2CUHiTPer.root";
  $password = "▧▧▧▧▧▧▧▧▧▧▧▧▧";
  try {
    $dsname = "mysql:host=$host;port=$port;dbname=test";
    $dbhandle = new PDO($dsname, $user, $password, ~!@array(PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => 1, PDO::MYSQL_ATTR_SSL_CA => "/etc/ssl/cert.pem")@!~);
    print "Connection established.<p>";
    $dbhandle->exec("DROP TABLE IF EXISTS t_php");
    $dbhandle->exec("CREATE TABLE t_php (id BIGINT PRIMARY KEY AUTO_RANDOM, name VARCHAR(20))");
    $num = $dbhandle->exec("INSERT INTO t_php (name)"
      . " VALUES "
      . "('mysqli'), ('PDO_MySQL')");
    echo $num . " rows(s) inserted.<p>";
    $statementhandle = $dbhandle->query("SELECT id, name FROM t_php");
    while ($row = $statementhandle->fetch(PDO::FETCH_NUM)) {
      printf("ID: %s, Name: %s<p>", $row[0], $row[1]);
    }
    print "End.";
  } catch (PDOException $err) {
    die($err);
  }

  ?>
```
--------------------------------------------------------------
Example for connecting to `TiDB Cloud`:
```
<html>

<body>
  <h1>201.4-PHP Connection 13</h1>
  <?php
  echo "PDO_MySQL Example for TiDB Cloud" . "<p>";

  $host = "gateway01.us-west-2.prod.aws.tidbcloud.com";
  $port = 4000;
  $user = "3pMz3G2CUHiTPer.root";
  $password = "▧▧▧▧▧▧▧▧▧▧▧▧▧";
  try {
    $dsname = "mysql:host=$host;port=$port;dbname=test";
    $dbhandle = new PDO($dsname, $user, $password, array(PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => 1, PDO::MYSQL_ATTR_SSL_CA => "/etc/ssl/cert.pem"));
    print "Connection established.<p>";
    $dbhandle->exec("DROP TABLE IF EXISTS t_php");
    $dbhandle->exec("CREATE TABLE t_php (id BIGINT PRIMARY KEY AUTO_RANDOM, name VARCHAR(20))");
    $num = $dbhandle->exec("INSERT INTO t_php (name)"
      . " VALUES "
      . "('mysqli'), ('PDO_MySQL')");
    echo $num . " rows(s) inserted.<p>";
    $statementhandle = $dbhandle->query("SELECT id, name FROM t_php");
    while ($row = $statementhandle->fetch(PDO::FETCH_NUM)) {
      printf("ID: %s, Name: %s<p>", $row[0], $row[1]);
    }
    print "End.";
  } catch (PDOException $err) {
    die($err);
  }

  ?>

</body>

</html>
```