RedBeanPHP 数据存储：理解自动ID管理与常见陷阱

require "rb.php";

R::setup('mysql:host=localhost;dbname=building_framework', 'root', '');

// Books table (正确示例：未手动设置ID)
$books1 = R::dispense('books');
$books1->title = "Wonders of the world";
$books1->author_id = "1";
$books1->publisher_id = "1";

$books2 = R::dispense('books');
$books2->title = "Math for dummy's";
$books2->author_id = "1";
$books2->publisher_id = "1";

// Author table (错误示例：手动设置ID)
$author = R::dispense('author');
$author->id = "1"; // <--- 错误！不应手动设置新Bean的ID
$author->author = "Francesco Boccia";

// Publisher table (错误示例：手动设置ID)
$publisher = R::dispense('publisher');
$publisher->id = "1"; // <--- 错误！不应手动设置新Bean的ID
$publisher->publisher = "Metro Books";

// 存储操作
$store1 = R::store($books1); // 成功，因为id未手动设置
$store2 = R::store($books2); // 成功，因为id未手动设置
$store3 = R::store($author);   // 可能失败或行为异常
$store4 = R::store($publisher); // 可能失败或行为异常

echo "Book 1 ID: " . $store1 . "\n";
echo "Book 2 ID: " . $store2 . "\n";
echo "Author ID: " . $store3 . "\n";
echo "Publisher ID: " . $store4 . "\n";

<?php

require "rb.php";

// 设置数据库连接
// 建议在生产环境中使用更安全的密码管理方式
R::setup('mysql:host=localhost;dbname=building_framework', 'root', '');

// 确保数据库连接成功
if (!R::testConnection()) {
    die('Could not connect to database.');
}

// =======================================================
// Books 表：创建并存储新的书籍记录
// 无需手动设置id，RedBeanPHP会自动生成
// =======================================================

// 第一本书
$book1 = R::dispense('books');
$book1->title = "Wonders of the world";
$book1->author_id = 1; // 假设作者和出版商ID已存在或稍后创建
$book1->publisher_id = 1;
$book1Id = R::store($book1); // 存储并获取新生成的ID
echo "Stored Book 1 with ID: " . $book1Id . "\n";

// 第二本书
$book2 = R::dispense('books');
$book2->title = "Math for dummy's";
$book2->author_id = 1;
$book2->publisher_id = 1;
$book2Id = R::store($book2);
echo "Stored Book 2 with ID: " . $book2Id . "\n";

// =======================================================
// Author 表：创建并存储新的作者记录
// 关键：不手动设置id
// =======================================================

$author = R::dispense('author');
// $author->id = 1; // <--- 移除这一行！让RedBeanPHP自动处理
$author->name = "Francesco Boccia"; // 假设作者表有'name'字段
$authorId = R::store($author);
echo "Stored Author with ID: " . $authorId . "\n";

// =======================================================
// Publisher 表：创建并存储新的出版商记录
// 关键：不手动设置id
// =======================================================

$publisher = R::dispense('publisher');
// $publisher->id = 1; // <--- 移除这一行！让RedBeanPHP自动处理
$publisher->name = "Metro Books"; // 假设出版商表有'name'字段
$publisherId = R::store($publisher);
echo "Stored Publisher with ID: " . $publisherId . "\n";

// =======================================================
// 示例：更新现有记录
// 如果要更新记录，则需要先加载它，然后修改属性并存储
// =======================================================

// 加载ID为1的作者（假设已成功存储，且其ID为1）
$existingAuthor = R::load('author', 1);
if ($existingAuthor->id) { // 检查是否成功加载
    $existingAuthor->email = "francesco.boccia@example.com";
    R::store($existingAuthor);
    echo "Updated Author ID 1 with email.\n";
} else {
    echo "Author with ID 1 not found for update.\n";
}

// 关闭RedBeanPHP连接（可选，脚本结束时会自动关闭）
R::close();

?>