使用Doctrine将随机字节生成的密钥保存在数据库中

$key = random_bytes(32);

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="keys")
 */
class KeyEntity
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     * @ORM\Column(type="integer")
     */
    private $id;

    /**
     * @ORM\Column(type="binary")
     */
    private $key;

    // Getters and setters
}

use Doctrine\ORM\Tools\Setup;
use Doctrine\ORM\EntityManager;

$paths = [__DIR__ . '/src/Entity'];
$isDevMode = true;

$dbParams = [
    'driver'   => 'pdo_mysql',
    'host'     => 'localhost',
    'dbname'   => 'your_database_name',
    'user'     => 'your_username',
    'password' => 'your_password',
];

$config = Setup::createAnnotationMetadataConfiguration($paths, $isDevMode);
$entityManager = EntityManager::create($dbParams, $config);

$keyEntity = new KeyEntity();
$keyEntity->setKey($key);

$entityManager->persist($keyEntity);
$entityManager->flush();

$keyRepository = $entityManager->getRepository(KeyEntity::class);
$keys = $keyRepository->findAll();

foreach ($keys as $keyEntity) {
    echo bin2hex($keyEntity->getKey()) . "\n";
}