GAE PHP MySQLI

[Terence Ramos]

I'm completely new to GAE development. I'm just trying to connect to the Cloud SQL instance I created for my App Engine PHP application. My php file is a bare bones:

<?php


// Using mysqli (connecting from App Engine)

$sql = new mysqli(
  null, // host
  'root', // username
  '',     // password
  '', // database name
  null,
  '/cloudsql/my-app-id:my-sql-db'
  );

My application does have permission to use the cloud sql instance. The issue is this seems to work when deployed, but locally it doesn't. I get: 

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /Users/myuser/Work/projects/default/index.php on line 23
indexaction

The GAE PHP help files don't seem to help. They state something like, see above for how to use GAE locally with the book sample. But the sample above in the web site is the Hello, world! Does anyone know where I can find information on this, or how to do this?

Thanks

[Terence Ramos]

Okay, I found their sample. It basically does a check on the global SERVER variable to determine if they are running locally and changes the connection string. So I got this out of it:

$isLocal = !isset($_SERVER['SERVER_SOFTWARE']) || strpos($_SERVER['SERVER_SOFTWARE'], 'Google App Engine') === false;

I guess I have to find out why my local PHP is not configured to properly for mysql.

[Thomas Valadez]

How did you get the mysqli function to work when deployed. I am getting an error Warning: mysqli::__construct(): (HY000/2002): Connection timed

I detailed the problem here https://stackoverflow.com/questions/44708684/cannot-use-mysqli-in-php-flex-env-on-app-engine

any tips on how you set this up to get it to work?