1#@!#!123s

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

: / home / earnlouq / public_html / public / functions /

Filename : providers.php

back

<?php
// public/functions/providers.php
require_once __DIR__ . '/../../config/gl_config.php';

function create_provider($name, $email, $service_type) {
    $sql = "INSERT INTO providers (name, email, service_type) VALUES (?, ?, ?)";
    $result = db_prepare_execute($sql, [$name, $email, $service_type], 'sss');
    if ($result !== false) {
        return mysqli_insert_id($con);
    }
    return false;
}

function get_provider_by_email($email) {
    $sql = "SELECT id, name, email FROM providers WHERE email = ? LIMIT 1";
    $result = db_prepare_execute($sql, [$email], 's');
    return mysqli_fetch_assoc($result);
}