⚙️
PHP Tools Hub
Tools
PHP
Quick
Contact
Home
>
Tutorials
>
PHP
>
PHP Database
PHP Database Tutorials
89 tutorials found.
📘
Associative Array Fetch
PDO Fetch | PDO FETCH_ASSOC | PHP
📘
Associative Array Fetch
MySQLi Fetch | mysqli_fetch_assoc | PHP
📘
Create PDO Instance
PDO Connection | PDO Constructor | PHP
📘
Disable Auto Commit
MySQLi Transactions | autocommit | PHP
📘
Escape Special Characters
MySQLi Escape | mysqli_real_escape_string | PHP
📘
Execute Multiple Queries
MySQLi Multi Query | multi_query | PHP
📘
Get Column Metadata
PDO Metadata | getColumnMeta | PHP
📘
Get Error Information Array
PDO Error | errorInfo | PHP
📘
Get Last Error Message
MySQLi Error | mysqli_error | PHP
📘
Get Last Inserted ID
PDO Last ID | lastInsertId | PHP
📘
List Available Drivers
PDO Drivers | getAvailableDrivers | PHP
📘
MySQL Improved Extension
MySQLi Introduction | MySQLi Extension | PHP
📘
MySQLi MySQL Only
PDO vs MySQLi | PDO More Databases | PHP
📘
mysqli_connect Function
MySQLi Connection | Procedural Connect | PHP
📘
mysqli_query Function
MySQLi Query | Simple Query | PHP
📘
PHP Data Objects
PDO Introduction | PDO Extension | PHP
📘
Prepare SQL Statement
PDO Prepared | prepare Method | PHP
📘
Prevent SQL Injection
MySQLi Prepared | Prepared Statement Benefits | PHP
📘
Set PDO Attribute
PDO Attributes | setAttribute | PHP
📘
Single Query Execution
PDO Query | query Method | PHP
📘
Start Transaction PDO
PDO Transactions | beginTransaction | PHP
📘
Supports 12 Drivers
PDO Benefits | Multiple Databases | PHP
📘
Bind by Reference
PDO Prepared | bindParam | PHP
📘
Commit Transaction PDO
PDO Transactions | commit | PHP
📘
Data Source Name Format
PDO Connection | DSN String | PHP
📘
Fetch Data from Database
MySQLi Query | SELECT Query | PHP
📘
Get Error Code
PDO Error | errorCode | PHP
📘
Get Last Error Code
MySQLi Error | mysqli_errno | PHP
📘
Get PDO Attribute
PDO Attributes | getAttribute | PHP
📘
Move to Next Result Set
MySQLi Multi Query | next_result | PHP
📘
new mysqli Constructor
MySQLi Connection | OOP Connect | PHP
📘
Object Fetch
MySQLi Fetch | mysqli_fetch_object | PHP
📘
Object Fetch
PDO Fetch | PDO FETCH_OBJ | PHP
📘
Prepare SQL Statement
MySQLi Prepared | prepare Method | PHP
📘
Returns Affected Rows
PDO Query | exec Method | PHP
📘
Start Transaction
MySQLi Transactions | begin_transaction | PHP
📘
Add New Records
MySQLi Query | INSERT Query | PHP
📘
Bind by Value
PDO Prepared | bindValue | PHP
📘
Bind Parameters
MySQLi Prepared | bind_param | PHP
📘
Both Associative Indexed
PDO Fetch | PDO FETCH_BOTH | PHP
📘
Both Types Fetch
MySQLi Fetch | mysqli_fetch_array | PHP
📘
Catch PDO Exceptions
PDO Error | PDOException | PHP
📘
Error Reporting Mode
PDO Attributes | ATTR ERRMODE | PHP
📘
Get SQL State Error
MySQLi Error | mysqli_sqlstate | PHP
📘
Host Username Password Database
MySQLi Connection | Connection Parameters | PHP
📘
mysql host dbname
PDO Connection | MySQL DSN | PHP
📘
Rollback Transaction PDO
PDO Transactions | rollBack | PHP
📘
Save All Changes
MySQLi Transactions | commit | PHP
📘
Check if Active
PDO Transactions | inTransaction | PHP
📘
Default Fetch Style
PDO Attributes | ATTR DEFAULT FETCH MODE | PHP
📘
Execute Statement
PDO Prepared | execute Method | PHP
📘
Fetch All Rows
MySQLi Fetch | mysqli_fetch_all | PHP
📘
Fetch into Class Instance
PDO Fetch | PDO FETCH_CLASS | PHP
📘
Modify Existing Records
MySQLi Query | UPDATE Query | PHP
📘
mysqli_connect_error
MySQLi Connection | Error Check | PHP
📘
Revert All Changes
MySQLi Transactions | rollback | PHP
📘
s i d b Strings Integer Double Blob
MySQLi Prepared | Parameter Types | PHP
📘
Set PDO Attributes
PDO Connection | Connection Options | PHP
📘
Bank Money Transfer
MySQLi Transactions | Example | PHP
📘
Colon Name Parameter Style
PDO Prepared | Named Placeholders | PHP
📘
Emulated Prepares
PDO Attributes | ATTR EMULATE PREPARES | PHP
📘
ERRMODE EXCEPTION
PDO Connection | Error Mode | PHP
📘
Execute Statement
MySQLi Prepared | execute Method | PHP
📘
Get Row Count
MySQLi Fetch | mysqli_num_rows | PHP
📘
Get Single Row
PDO Fetch | fetch Method | PHP
📘
mysqli_set_charset UTF-8
MySQLi Connection | Set Charset | PHP
📘
Remove Records
MySQLi Query | DELETE Query | PHP
📘
Affected Row Count
MySQLi Fetch | mysqli_affected_rows | PHP
📘
Get All Rows
PDO Fetch | fetchAll Method | PHP
📘
mysqli_close
MySQLi Connection | Close Connection | PHP
📘
Positional Parameters
PDO Prepared | Question Mark Placeholders | PHP
📘
Store Result Set
MySQLi Prepared | store_result | PHP
📘
Try Catch for Errors
PDO Connection | Connection Check | PHP
📘
Bind Result Columns
MySQLi Prepared | bind_result | PHP
📘
Get Single Column
PDO Fetch | fetchColumn | PHP
📘
Last Insert ID
MySQLi Fetch | mysqli_insert_id | PHP
📘
Secure Insert with PDO
PDO Prepared | INSERT Prepared | PHP
📘
Set PDO to null
PDO Connection | Close Connection | PHP
📘
Fetch Result Row
MySQLi Prepared | fetch Method | PHP
📘
Get Number of Rows
PDO Fetch | rowCount | PHP
📘
Secure Update with PDO
PDO Prepared | UPDATE Prepared | PHP
📘
Get Result Set Object
MySQLi Prepared | get_result | PHP
📘
Secure Delete with PDO
PDO Prepared | DELETE Prepared | PHP
📘
Secure Insert Operation
MySQLi Prepared | INSERT with Prepared | PHP
📘
Secure Select with PDO
PDO Prepared | SELECT Prepared | PHP
📘
Execute Multiple Times
PDO Prepared | Reuse Statement | PHP
📘
Secure Update Operation
MySQLi Prepared | UPDATE with Prepared | PHP
📘
Secure Delete Operation
MySQLi Prepared | DELETE with Prepared | PHP
📘
Secure Select Operation
MySQLi Prepared | SELECT with Prepared | PHP