1) PDO (PHP Data Objects) - A PHP library used for accessing and manipulating databases using object-oriented approach. PDO supports multiple database platforms and provides a consistent API for database access.
Example:
// Connect to database using PDO $pdo = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');
// Fetch rows from database using prepared statements $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([1]); $rows = $stmt->fetchAll();
2) MySQLi - A PHP library used for accessing and manipulating MySQL databases. MySQLi provides improved functionality and security compared to the older MySQL library.
Example:
// Connect to database using MySQLi $mysqli = new mysqli('localhost', 'username', 'password', 'my_database');
// Fetch rows from database using prepared statements $stmt = $mysqli->prepare("SELECT * FROM users WHERE id = ?"); $stmt->bind_param('i', 1); $stmt->execute(); $rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
3) Eloquent - A PHP package used for working with databases using the active record pattern. Eloquent provides an easy-to-use interface for accessing and manipulating database records, and supports multiple database platforms.
// Fetch rows from database using Eloquent $rows = \App\Models\User::where('id', 1)->get();
PHP DB::rows - 30 examples found. These are the top rated real world PHP examples of DB::rows from package TeamPass extracted from open source projects. You can rate examples to help us improve the quality of examples.