1#@!#!123s

��JFIF�� 1#@!#!123s

: / home / earnlouq / www / public / functions /

Filename : helpers.php

back

<?php 
// Helper function for prepared statements
function db_prepare_execute($sql, $params, $types) {
    global $con;
    $stmt = mysqli_prepare($con, $sql);
    if (!$stmt) {
        trigger_error("Prepare failed: " . mysqli_error($con), E_USER_ERROR);
        return false;
    }

    if (!mysqli_stmt_bind_param($stmt, $types, ...$params)) {
        trigger_error("Binding failed: " . mysqli_stmt_error($stmt), E_USER_ERROR);
        return false;
    }

    return $stmt;
}

function db_select($sql, $params, $types) {
    global $con;
    $stmt = db_prepare_execute($sql, $params, $types);
    if (!$stmt || !mysqli_stmt_execute($stmt)) return false;
    $result = mysqli_stmt_get_result($stmt);
    $rows = mysqli_fetch_all($result, MYSQLI_ASSOC);
    mysqli_stmt_close($stmt);
    return $rows;
}