CODEWITHSUNDEEP
phpmysqliprepared-statement
reformed
reformed

Reputation: 4780

Is there a difference between mysqli->prepare() and stmt->prepare()?

$sql = 'SELECT * FROM Table WHERE Column = ?';

$stmt = $mysqli->stmt_init();
if ($stmt->prepare($sql)) {
    $stmt->bind_param('s', $ColumnValue);
    $stmt->execute();
    $stmt->bind_result($Col1, $Col2);
    $stmt->fetch();
    $stmt->close();
}

// or

if ($stmt = $mysqli->prepare($sql)) {
    $stmt->bind_param('s', $ColumnValue);
    $stmt->execute();
    $stmt->bind_result($Col1, $Col2);
    $stmt->fetch();
    $stmt->close();
}

When dealing with prepared statements, what's the difference? Which should be used?

Upvotes: 0

Views: 108

Answers (1)

miken32
miken32

Reputation: 42695

Looking at the source, they both do the same thing. Personally, I'd go with the one that involves less typing since both are equally readable.

Upvotes: 1

Related Questions