Cross-area library

Content Library

A single library for content items across the complete Content Area hierarchy. Content Areas and Categories define the structure;

261 results

261 resultsContent Area → Category

Guide

PHP Mysqli::commit() Method: Usage and Examples

Commits the transaction currently active on the MySQL connection. Only transactional statements on supported engines can be rolled back before commit.

0 views Oct 17, 2026

Guide

PHP Mysqli::get_result() Method: Usage and Examples

Retrieves buffered result rows from a prepared statement as a mysqli_result. Requires mysqlnd and a statement that produces a result set; use bind_result where unsupported.

0 views Oct 17, 2026

Guide

PHP Mysqli::prepare() Method: Usage and Examples

Prepares a parameterized SQL statement and returns a mysqli_stmt object. Placeholders represent values, not column or table names; bind parameters before execute.

0 views Oct 17, 2026

Guide

PHP Mysqli::query() Method: Usage and Examples

Executes a SQL statement and returns a result object or boolean as appropriate. Never interpolate untrusted values into the SQL; use prepared statements for user input.

0 views Oct 17, 2026

Guide

PHP Mysqli::real_escape_string() Method: Usage and Examples

Escapes a string for safe inclusion in a MySQL string literal under the current charset. Escaping is not a replacement for prepared statements, and the connection charset must be correct.

0 views Oct 17, 2026

Guide

PHP Mysqli::rollback() Method: Usage and Examples

Cancels changes pending in an active transaction. Rollback does not reverse MySQL DDL that performed an implicit commit.

0 views Oct 17, 2026

Guide

PHP Mysqli::set_charset() Method: Usage and Examples

Selects the connection character set used for client/server conversions and escaping. Set utf8mb4 before executing user data queries; changing only HTML meta charset is insufficient.

0 views Oct 17, 2026

Guide

Adding Database Transactions to a PHP Workflow

Transactions group related writes so either all succeed or all are rolled back. Catch Throwable, rollback on failure, and remember external APIs are not rolled back with the database.

0 views Oct 17, 2026

Guide

Binding Named and Positional SQL Parameters

Prepared statement placeholders separate SQL syntax from parameter values. Never mix named and positional placeholders in the same PDO statement; placeholders cannot stand for table names.

0 views Oct 17, 2026

Page 7 of 29 · 261 results

Content Library

Your privacy choices