Pionia Get started

Database

//: # ‘

' [//]: # “This section assumes you have already set up your project and have already gone through the Api Tutorial guide atleast.” [//]: # "

" //: # //: # “## Introduction.” //: # //: # “Pionia uses PORM (Pionia ORM) to interact with the database. PORM is a simple and lightweight ORM that is built on top of the medoo framework. PORM provides a set of tools and conventions that make it easy to interact with the database in PHP. PORM is designed to be simple, lightweight, and easy to use.” //: # //: # “## Installation” //: # //: # “If you want to check out PORM alone or want to use it outside the Pionia framework, you can install it via composer.” //: # //: # “bash" [//]: # "composer require pionia/porm" [//]: # "” //: # //: # ‘

' [//]: # “If you are using Pionia, you do not need to install PORM separately. PORM is already included in the Pionia framework.” [//]: # "

" //: # //: # “## Configuration” //: # //: # “Configuring PORM is simple. All you need is the settings.ini file in the root of your project. The settings.ini file should contain the following:” //: # //: # “ini" [//]: # "[db]" [//]: # "database =" [//]: # "username =" [//]: # "type =" [//]: # "host =" [//]: # "password =" [//]: # "port =" [//]: # "” //: # //: # ‘

' [//]: # “If you are using Pionia, you do not need to configure PORM separately. PORM is already configured in the Pionia framework.” [//]: # "

" //: # //: # “### Multiple Database Connections” //: # //: # “If you want to connect to multiple databases, you can do so by adding the database connection settings to the settings.ini file. You can then specify the database connection to use when querying the database.” //: # //: # “ini" [//]: # "; other settings" [//]: # [//]: # "[db]" [//]: # "database =" [//]: # "username =" [//]: # "type =" [//]: # "host =" [//]: # "password =" [//]: # "port =" [//]: # [//]: # "[db2]" [//]: # "database =" [//]: # "username =" [//]: # "type =" [//]: # "host =" [//]: # "password =" [//]: # "port =" [//]: # [//]: # "; other settings" [//]: # [//]: # "” //: # //: # “You can then specify the database connection to use when querying the database.” //: # //: # “php" [//]: # "use Porm\\Porm;" [//]: # [//]: # "Porm::from('posts')->using('db2'); // will connect to the db2 database" [//]: # "” //: # //: # “By default, PORM will use the default database connection(db) to query the database.”