如何解决PHP项目内容仓库部署难题？Jackalope-Doctrine-DBAL助你轻松实现PHPCR功能

<pre class="brush:php;toolbar:false;"># 首先，创建一个新项目目录并初始化Composer
$ mkdir my-phpcr-project
$ cd my-phpcr-project
$ composer init

# 然后，通过Composer安装Jackalope-Doctrine-DBAL
$ composer require jackalope/jackalope-doctrine-dbal

vendor/

jackalope

<pre class="brush:php;toolbar:false;">CREATE DATABASE jackalope CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON jackalope.* TO 'jackalope'@'localhost' IDENTIFIED BY '1234test';
FLUSH PRIVILEGES;

vendor/jackalope/jackalope-doctrine-dbal/cli-config.dist.php

cli-config.php

<pre class="brush:php;toolbar:false;">$ ./vendor/bin/jackalope jackalope:init:dbal

<pre class="brush:php;toolbar:false;"><?php

require 'vendor/autoload.php'; // 引入Composer自动加载

use Doctrine\DBAL\DriverManager;
use Jackalope\RepositoryFactoryDoctrineDBAL;
use PHPCR\SimpleCredentials;

// 1. 配置数据库连接
$connection = DriverManager::getConnection([
    'driver'    => 'pdo_mysql',
    'host'      => 'localhost',
    'user'      => 'jackalope',
    'password'  => '1234test',
    'dbname'    => 'jackalope',
    'charset'   => 'utf8mb4', // MySQL/MariaDB 推荐
]);

// 2. 创建Jackalope仓库工厂
$factory = new RepositoryFactoryDoctrineDBAL();
$repository = $factory->getRepository(
    ['jackalope.doctrine_dbal_connection' => $connection]
);

// 3. 登录到PHPCR Session
// 这里的用户名 'admin' 仅用于记录节点创建者信息，密码通常为null或空字符串
$credentials = new SimpleCredentials('admin', null);
$session = $repository->login($credentials, 'default'); // 'default' 是默认工作区

echo "成功连接到PHPCR内容仓库！\n";

// 4. 开始操作内容（PHPCR API）
$rootNode = $session->getNode('/'); // 获取根节点

// 添加一个新节点
$myBlogNode = $rootNode->addNode('my-blog');
$session->save(); // 保存更改

// 在博客节点下添加一篇文章
$firstPost = $myBlogNode->addNode('first-post');
$firstPost->setProperty('jcr:title', '我的第一篇博客文章');
$firstPost->setProperty('content', '这是一篇关于Jackalope-Doctrine-DBAL的精彩文章！');
$session->save(); // 再次保存

echo "创建了 'my-blog' 节点和 'first-post' 文章。\n";

// 读取内容
$retrievedPost = $session->getNode('/my-blog/first-post');
echo "文章标题: " . $retrievedPost->getProperty('jcr:title')->getString() . "\n";
echo "文章内容: " . $retrievedPost->getProperty('content')->getString() . "\n";

// 更多操作...
// $retrievedPost->remove();
// $session->save();
// $session->logout();
?>