Q: which method is responsible for sending query to database?
Ans: In PHP, the method for sending a query to a database is typically mysqli_query()
or PDO::query()
.
$result = mysqli_query($conn, $sql);
OR
$stmt = $conn->query($sql);
$result = $stmt->fetchAll();
It takes two arguments, the first is the database connection link, and the second is the SQL query. It returns a result set on success or FALSE
on failure.
It's important to notice that PDO is an extension that provides a data-access abstraction layer, it can be used with multiple database like MySQL, PostgreSQL, SQLite and others, while mysqli
is specific for MySQL.
No comments:
Post a Comment