Ejemplos de connect_MySQL en PHP

Ejemplo n.º 1

Archivo: dbaccesUtil.php Proyecto: ryosuke89/SNS_picture_analysis

function url_photo($photoID)
{
    $select_db = connect_MySQL();
    $select_sql = "SELECT photoURL FROM photo WHERE photoID=:photoID";
    $select_query = $select_db->prepare($select_sql);
    $select_query->bindValue(':photoID', $photoID);
    try {
        $select_query->execute();
    } catch (PDOException $e) {
        $select_query = null;
        return $e->getMessage();
    }
    return $select_query->fetchAll(PDO::FETCH_ASSOC);
}

Ejemplo n.º 2

Archivo: api_dbaccesUtil.php Proyecto: ryosuke89/SNS_picture_analysis

function delete_all($all, $id)
{
    $delete_db = connect_MySQL();
    $delete_id = $all . 'ID';
    $delete_sql = "DELETE FROM {$all} WHERE {$delete_id}=:id";
    $delete_query = $delete_db->prepare($delete_sql);
    $delete_query->bindValue(':id', $id);
    try {
        $delete_query->execute();
    } catch (PDOException $e) {
        $delete_query = null;
        return $e->getMessage();
    }
    return null;
}