{"id":1087,"date":"2025-06-12T12:33:44","date_gmt":"2025-06-12T04:33:44","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/php\/php-application-manual\/symfony\/1087.html"},"modified":"2025-06-12T12:33:44","modified_gmt":"2025-06-12T04:33:44","slug":"php-doctrine-%e5%a6%82%e4%bd%95%e8%bf%9e%e6%8e%a5%e5%88%b0-sqlite-%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"my1js","link":"https:\/\/www.zhaozhao123.cn\/php\/my1js\/1087.html","title":{"rendered":"PHP Doctrine: \u5982\u4f55\u8fde\u63a5\u5230 SQLite \u6570\u636e\u5e93"},"content":{"rendered":"
\r\n
\r\n
\r\n
\r\n
\r\n
\"Bug编译狮\"<\/figure>\r\n\r\n\r\n\r\n

Bug编译狮<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n

要使用 PHP Doctrine 连接到 SQLite 数据库，你需要按照以下步骤进行操作：<\/p>\n

    \n
  1. \n

    安装 Doctrine ORM<\/strong>：\n首先，确保你已经安装了 Doctrine ORM。你可以通过 Composer 来安装它：<\/p>\n

    composer require doctrine\/orm<\/code><\/pre>\n<\/li>\n
  2. \n
    配置数据库连接<\/strong>：\n创建一个 config\/doctrine.yaml<\/code> 文件来配置数据库连接。假设你有一个名为 database.sqlite<\/code> 的 SQLite 数据库文件，并且你想将它放在项目根目录下。<\/p>\n
    doctrine:\n   dbal:\n       default_connection: default\n       connections:\n           default:\n               driver: pdo_sqlite\n               url: file:%kernel.project_dir%\/database.sqlite\n               charset: utf8mb4\n               options:\n                   encoding: UTF-8<\/code><\/pre>\n<\/li>\n
  3. \n
    创建实体类<\/strong>：\n定义你的实体类。例如，假设你有一个 User<\/code> 实体类：<\/p>\n
    namespace AppEntity;\n\nuse DoctrineORMMapping as ORM;\n\n\/**\n* @ORMEntity(repositoryClass=\"AppRepositoryUserRepository\")\n*\/\nclass User\n{\n   \/**\n    * @ORMId\n    * @ORMGeneratedValue(strategy=\"AUTO\")\n    * @ORMColumn(type=\"integer\")\n    *\/\n   private $id;\n\n   \/**\n    * @ORMColumn(type=\"string\", length=255)\n    *\/\n   private $username;\n\n   \/\/ Getters and Setters\n}<\/code><\/pre>\n<\/li>\n
  4. \n
    创建实体映射<\/strong>：\n在 src\/Entity\/User.php<\/code> 中，添加 @ORMTable<\/code> 注解以定义表结构：<\/p>\n
    \/**\n* @ORMTable(name=\"users\")\n*\/<\/code><\/pre>\n<\/li>\n
  5. \n
    创建实体仓库<\/strong>：\n为了方便操作实体，创建一个实体仓库类：<\/p>\n
    namespace AppRepository;\n\nuse DoctrineBundleDoctrineBundleRepositoryServiceEntityRepository;\nuse AppEntityUser;\n\n\/**\n* @extends ServiceEntityRepository<User>\n*\/\nclass UserRepository extends ServiceEntityRepository\n{\n   public function __construct(ManagerRegistry $registry)\n   {\n       parent::__construct($registry, User::class);\n   }\n\n   \/\/ Additional methods for querying users\n}<\/code><\/pre>\n<\/li>\n
  6. \n
    编写控制器<\/strong>：\n创建一个控制器来处理用户请求。例如，创建一个 UserController<\/code>：<\/p>\n
    namespace AppController;\n\nuse SymfonyBundleFrameworkBundleControllerAbstractController;\nuse SymfonyComponentHttpFoundationRequest;\nuse SymfonyComponentRoutingAnnotationRoute;\nuse AppEntityUser;\nuse AppRepositoryUserRepository;\n\nclass UserController extends AbstractController\n{\n   private $userRepository;\n\n   public function __construct(UserRepository $userRepository)\n   {\n       $this->userRepository = $userRepository;\n   }\n\n   \/**\n    * @Route(\"\/users\", name=\"app_users_index\")\n    *\/\n   public function index(Request $request): Response\n   {\n       $users = $this->userRepository->findAll();\n\n       return $this->render('user\/index.html.twig', [\n           'users' => $users,\n       ]);\n   }\n\n   \/**\n    * @Route(\"\/users\/new\", name=\"app_users_new\")\n    *\/\n   public function new(Request $request): Response\n   {\n       $form = $this->createForm(UserType::class);\n\n       if ($form->isSubmitted() && $form->isValid()) {\n           $user = $form->getData();\n           $this->userRepository->save($user, true);\n\n           return $this->redirectToRoute('app_users_index');\n       }\n\n       return $this->render('user\/new.html.twig', [\n           'form' => $form->createView(),\n       ]);\n   }\n}<\/code><\/pre>\n<\/li>\n
  7. \n
    创建视图<\/strong>：\n创建相应的 HTML 视图文件（例如 templates\/user\/index.html.twig<\/code> 和 templates\/user\/new.html.twig<\/code>）来显示和编辑用户数据。<\/p>\n<\/li>\n<\/ol>\n
    通过以上步骤，你就可以使用 PHP Doctrine 连接到 SQLite 数据库并进行基本的 CRUD 操作了。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \"黑板Bug讲师\"<\/figure>\r\n\r\n\r\n\r\n
    黑板Bug讲师<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    介绍<\/h2>
    在这次教程中，我们将探索如何使用Doctrine ORM（对象关系映射）连接到SQLite数据库。Doctrine是一个强大的ORM，允许开发人员以面向对象的方式与数据库交互。通过使用Doctrine和SQLite，我们可以利用其功能进行快速开发，同时保持SQLite数据库的简单性。我们从基础开始，逐步深入更复杂的概念。<\/p>
    安装Doctrine<\/h2>
    在连接到SQLite数据库之前，我们需要安装Doctrine。我们将使用Composer来管理依赖项。如果你还没有安装Composer，请在官方网站上找到安装说明。安装完成后，可以运行以下命令将Doctrine添加到项目中：<\/p>
    composer require doctrine\/orm<\/code><\/pre>
    bootstrap doctine<\/h2>
    为了使用Doctrine，我们需要配置一个EntityManager，这是Doctrine的中央访问点，管理对象的持久化。以下的bootstrap文件设置了配置：<\/p>
    <?php\n\nuse DoctrineORMToolsSetup;\nuse DoctrineORMEntityManager;\n\nrequire_once 'vendor\/autoload.php';\n\n\/\/ Create a simple default Doctrine ORM configuration for Annotations\n$isDevMode = true;\n$config = Setup::createAnnotationMetadataConfiguration(array(__DIR__.'\/src'), $isDevMode);\n\n\/\/ or if you prefer YAML or XML\n\/\/ $config = Setup::createXMLMetadataConfiguration(array(__DIR__.'\/config\/xml'), $isDevMode);\n\/\/ $config = Setup::createYAMLMetadataConfiguration(array(__DIR__.'\/config\/yaml'), $isDevMode);\n\n\/\/ database configuration parameters\n$conn = array(\n    'driver' => 'pdo_sqlite',\n    'path' => __DIR__.'\/db.sqlite',\n);\n\n\/\/ obtaining the entity manager\n$entityManager = EntityManager::create($conn, $config);<\/code><\/pre>
    定义实体<\/h2>
    使用Doctrine，我们将数据库表表示为PHP类，称为实体。这里有一个示例实体：<\/p>
    <?php\n\n\/**\n * @Entity @Table(name=\"products\")\n **\/\nclass Product\n{\n    \/** @Id @Column(type=\"integer\") @GeneratedValue **\/\n    protected $id;\n\n    \/** @Column(type=\"string\") **\/\n    protected $name;\n\n    public function getId()\n    {\n        return $this->id;\n    }\n\n    public function getName()\n    {\n        return $this->name;\n    }\n\n    public function setName($name)\n    {\n        $this->name = $name;\n    }\n}<\/code><\/pre>
    当你定义类时，请确保遵循Doctrine实体规则。一个实体必须至少有一个字段带有@Id注解才能作为主键使用。<\/p>
    创建数据库模式。<\/h2>
    在定义了实体之后，你可以使用 cli-config.php 文件和Doctrine的命令行工具来创建SQLite数据库模式。以下是一个cli-config.php文件的例子：<\/p>
    <?php\n\nuse DoctrineORMToolsConsoleConsoleRunner;\n\nrequire_once 'bootstrap.php';\n\n\/\/ replace with mechanism to retrieve EntityManager in your app\n$entityManager = GetEntityManager();\n\nreturn ConsoleRunner::createHelperSet($entityManager);<\/code><\/pre>
    完成设置后，运行以下命令以生成数据库模式：<\/p>
    php vendor\/bin\/doctrine orm:schema-tool:create<\/code><\/pre>
    在数据库上执行操作<\/h2>
    在数据库设置完成后，可以执行创建、读取、更新和删除记录（CRUD操作）。以下是创建并保存新产品的步骤：<\/p>
    <?php\n\n\/\/ ... bootstrap.php and Entity\/Product.php included above\n\n$product = new Product();\n$product->setName('iPhone X');\n\n$entityManager->persist($product);\n$entityManager->flush();\n\necho \"Created Product with ID \" . $product->getId() . \"n\";<\/code><\/pre>
    为了读取数据，可以使用EntityManager的find或repository方法：<\/p>
    <?php\n\n\/\/ ... bootstrap.php and Entity\/Product.php included above\n\n$productRepository = $entityManager->getRepository('Product');\n$products = $productRepository->findAll();\n\nforeach ($products as $product) {\n    echo $product->getId() . ' - ' . $product->getName() . \"n\";\n}<\/code><\/pre>
    更新数据非常简单，只需修改对象并调用flush即可：<\/p>
    <?php\n\n\/\/ ... bootstrap.php and Entity\/Product.php included above\n\n$product = $entityManager->find('Product', $productId);\n$product->setName('New Product Name');\n$entityManager->flush();<\/code><\/pre>
    删除记录也很简单：<\/p>
    <?php\n\n\/\/ ... bootstrap.php and Entity\/Product.php included above\n\n$product = $entityManager->find('Product', $productId);\n$entityManager->remove($product);\n$entityManager->flush();<\/code><\/pre>
    高级：使用查询构建器<\/h2>
    当需要处理更复杂的查询时，可以使用Doctrine的Query Builder。以下是如何使用Query Builder创建自定义查询的例子：<\/p>
    <?php\n\n\/\/ ... bootstrap.php and Entity\/Product.php included above\n\n$queryBuilder = $entityManager->createQueryBuilder();\n$queryBuilder->select('p')\n    ->from('Product', 'p')\n    ->where('p.name = :name')\n    ->setParameter('name', 'iPhone X');\n\n$result = $queryBuilder->getQuery()->getResult();\n\nforeach ($result as $product) {\n    echo $product->getName();\n}<\/code><\/pre>
    处理事务性操作<\/h2>
    事务操作在维护数据完整性方面至关重要。Doctrine 事务管理使用 EntityManager 的事务方法：<\/p>
    <?php\n\n\/\/ ... bootstrap.php and Entity\/Product.php included above\n\ntry {\n    $entityManager->beginTransaction();\n\n    $product1 = new Product();\n    $product1->setName('Product 1');\n    $entityManager->persist($product1);\n\n    $product2 = new Product();\n    $product2->setName('Product 2');\n    $entityManager->persist($product2);\n\n    \/\/ More operations...\n\n    $entityManager->flush();\n    $entityManager->commit();\n\n    echo \"Both products saved!\";\n} catch (Exception $e) {\n    $entityManager->rollback();\n    echo \"Transaction failed!\";\n}<\/code><\/pre>
    实体仅在事务提交时保存到数据库。如果发生错误，该事务将回滚，并且不会持久化任何更改。<\/p>
    结论。<\/h2>
    在本教程中，我们已经看到如何使用PHP中的Doctrine ORM与SQLite数据库设置连接、定义实体以及通过Doctrine的EntityManager执行各种数据库操作。掌握这些基本原理后，您可以使用Doctrine和SQLite创建具有有效数据库层的强大PHP应用程序。<\/p><\/body>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \"长工码奴1523\"<\/figure>\r\n\r\n\r\n\r\n
    长工码奴1523<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    为了使用 PHP 连接到 SQLite 数据库，你需要遵循以下步骤：<\/p>\n
    步骤 1: 安装 SQLite3<\/h3>\n
    首先，确保你的系统上安装了 SQLite3。你可以通过访问SQLite的官方网站（https:\/\/www.sqlite.org\/download.html）来下载和安&#35013<\/a>;<\/a>。<\/p>\n
    步骤 2: 编写 SQL 语句<\/h3>\n
    打开终端并输入以下命令来创建一个新的 SQLite 数据库文件：<\/p>\n
    sqlite3 your_database_name.db<\/code><\/pre>\n
    这将提示你输入数据库的名字，然后按下回车键。接下来，输入以下 SQL 语句以创建一个新的表：<\/p>\n
    CREATE TABLE users (\n    id INTEGER PRIMARY KEY,\n    name TEXT NOT NULL,\n    email TEXT UNIQUE NOT NULL\n);<\/code><\/pre>\n
    这里，我们创建了一个名为 users<\/code> 的表，其中包含三个字段：id、name 和 email。<\/p>\n
    步骤 3: 连接到 SQLite 数据库<\/h3>\n
    在你的 PHP 脚本中，你可以直接使用 SQLite3 类来建立与 SQLite 数据库的连接。例如，如果你有一个名为 db.php<\/code> 的文件，并且你想在这个文件中使用 SQLite 数据库，可以这样操作：<\/p>\n
    <?php\n$dsn = 'mysql:host=localhost;dbname=your_database_name';\n$username = 'your_username';\n$password = 'your_password';\n\ntry {\n    $pdo = new PDO($dsn, $username, $password);\n\n    \/\/ 使用 PDO 函数执行 SQL 语句\n    $stmt = $pdo->prepare('SELECT * FROM users');\n    $stmt->execute();\n\n    \/\/ 打印查询结果\n    foreach ($stmt as $row) {\n        echo $row['id'] . ': ' . $row['name'] . '<br>';\n    }\n} catch (PDOException $e) {\n    die('Connection failed: ' . $e->getMessage());\n}\n?><\/code><\/pre>\n
    在这个例子中，我们假设数据库名称为 your_database_name<\/code>，用户名为 your_username<\/code>，密码为 your_password<\/code>。<\/p>\n
    注意事项<\/h3>\n
      \n
    • 确保在生产环境中替换 localhost<\/code>, your_database_name<\/code>, your_username<\/code> 和 your_password<\/code>。<\/li>\n
    • 在生产环境中运行此脚本时，请确保具有足够的权限来访问 SQLite 数据库文件。<\/li>\n<\/ul>\n
      以上就是使用 PHP 连接到 SQLite 数据库的基本方法。根据需要调整 SQL 语句以满足特定的需求。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
      Bug编译狮 要使用 PHP Doctrine 连接到 SQLite 数据库，你需要&#2535..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[],"my1js2nav":[45],"tuisongtax":[],"class_list":["post-1087","my1js","type-my1js","status-publish","hentry","my1js2nav-symfony"],"acf":{"qian_art_seotitle":"","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":""},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":""}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js\/1087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/types\/my1js"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/media?parent=1087"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tags?post=1087"},{"taxonomy":"my1js2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js2nav?post=1087"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tuisongtax?post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}