PHP get_new_connection Exemples

Exemple #1

Fichier : getsponsor.php Projet : pecey/Edge2k15

<?php

include 'content/lib/database.php';
$conn = get_new_connection();
$result = $conn->query("SELECT * FROM sponsors ORDER BY priority DESC");
$results_array = array();
while ($row = $result->fetch_assoc()) {
    $results_array[] = $row;
}
echo json_encode($results_array);

Exemple #2

Fichier : database.php Projet : pecey/Edge2k15

function update_contact($id, $name, $email, $phone, $facebook)
{
    $conn = get_new_connection();
    $statement = $conn->prepare("UPDATE contacts SET name = ?, email = ?, phone = ?, facebook = ? WHERE id = ?");
    $statement->bind_param("ssssi", $name, $email, $phone, $facebook, $id);
    $statement->execute();
}