Download the PHP package gabriel-binotti/connection-pdo without Composer
On this page you can find all versions of the php package gabriel-binotti/connection-pdo. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package connection-pdo
Library to database connection using PDO
This library is for database connection in PHP using PDO.
Require
- PHP >= 7.0
- Composer installed
Start
The first you need install the library:
Configuration .ini
After downloading, you need set the parameters in the database.ini file with your database connection data. If you prefer, you can create a new .ini file, the file is located in vendor/gabriel-binotti/database/databaseApplication/config/database.ini
- DB_HOST => hostname or IP
- DB_NAME => name of database
- DB_PORT => number porto to connection
- DB_USER => username
- DB_PASS => password
- DB_TYPE => type to batabase coneccetion tha value cad do(mysql, pgsql. srqsrv)
Import
Include the autoload.php file in the header file
Simple Struct
-
Connection::init('database'): This method init() is called to initiate the database connection and your parameter is the file name configured before .ini.
-
Connection::close(): This method should be called every time a database connection is opened.
- $pdo = Connection::get(): The method get() return the same instance of the class every time
All code should be between try and catch
Transactions
If you need to ensure that the transaction is successfully executed, you can initiate a transaction with the command Connection::transaction() and after execute SQL command. To finish using the command Connection::commit() when the transaction is successfully or Connection::rollback() to return to the initial state.
What use PDO?
Above I show like to use PDO in PHP with simple examples:
Select All
Select with where
By default is returned a object, if you need an array you can set parameter \PDO::FETCH_ASSOC in method fetchAll() or in method fetch().
Insert
Update
Delete
bindValue VS bindParam
The simple form bindParam receives a variable like argument, not accepting direct values or functions return.
The bindValue() accept direct values, variables and functions return.
Third parameter bindValue or bindParam
The third parameter is the data type, by default is string, but you can change that accord with value type.
SQL Server
To use SQL Server you need to install the driver and configure some lines in php.ini, as shown in the example above:
-
Download => https://learn.microsoft.com/pt-br/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver15
- After you need copy the files to directory ext, my example using xampp
- To finish edit the file php.ini
