Php-Wasm | pdo-cfd1

I am giving up my bed for one night.

My Sleep Out helps youth facing homelessness find safe shelter and loving care at Covenant House. That care includes essential services like education, job training, medical care, mental health and substance use counseling, and legal aid — everything they need to build independent, sustainable futures.

By supporting my Sleep Out, you are supporting the dreams of young people overcoming homelessness.

Together, we are working towards a future where every young person has a safe place to sleep.

Thank you.

Connect & Configure

Pass the D1 object into the php-wasm constructor as a key to the cfd1 object to enable pdo_cfd1 support.

cfd1: will become available as a PDO driver:

export async function onRequest(event)
{
    const php = new PhpWorker({
        cfd1: { mainDb: event.env.mainDb }
    });

    php.run(`<?php $pdo = new PDO('cfd1:mainDb');`);
}

You can check phpinfo() to make sure that the D1 object is detected. CloudFlare D1 SQL module detected will display “yes” when the object has been passed in correctly:

PDO can be used with D1 just like any other SQL server:

export async function onRequest(event)
{
    const php = new PhpWorker({
        cfd1: { mainDb: event.env.mainDb }
    });

    php.run(`<?php
        $pdo = new PDO('cfd1:main');
        $select = $pdo->prepare(
            'SELECT PageTitle, PageContent FROM WikiPages WHERE PageTitle = ?'
        );
        $select->execute([$pageTitle]);
        $page = $select->fetchObject();`
    );
}

pdo-cfd1

Connect & Configure

Todo

CloudFlare D1