ACIL FM

Pilih semua

Nama	Ukuran	Aksi
attachments_upload.php	1.17 MB	View DL Edit
delete_bacheca.php	534 B	View DL Edit
new_bacheca.php	2.03 MB	View DL Edit
update_bacheca.php	758 B	View DL Edit

Edit file: /home/mhhtmff/timbrature/NH-HR-test/ds/php/bacheca/new_bacheca.php

<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../database.php";
include "../globals.php";
require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";

$bacheca_object = $_POST["bacheca_object"];
$bacheca_body = $_POST["bacheca_body"];
$nl = ["\r\n","\n","\r"];
$body = str_replace($nl, '<br>', $bacheca_body);

$datetime    = date("Y-m-d H:i:s");

$sql_insert = "INSERT INTO bacheca VALUES (NULL,'$bacheca_object','$body','$datetime',".$_SESSION['id'].")";
if ($con->query($sql_insert) === true) {
    $id = mysqli_insert_id($con);

//Invio mail a tutti
    $sql = "SELECT * FROM users WHERE bacheca_notifies = 1";
    $result = mysqli_query($con, $sql);
    if ($result->num_rows > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $email = new \SendGrid\Mail\Mail();
            $email->setFrom("info@n-hub.com", "NH-HR");
            $email->addTo("" . $row["email"] . "", "" . $row["name"] . " " . $row["surname"] . "");
            $email->SetTemplateId("d-55b033ba0ed74378a00855406e634540");
            //Here is the Place holder values you need to replace.
            $email->addDynamicTemplateData("NHHR_oggetto_pubblicazione", "" . $bacheca_object . "");
            $email->addDynamicTemplateData("NHHR_data_pubblicazione", "" . date('d/m/Y H:i', strtotime($datetime)) . "");
            $email->addDynamicTemplateData("NHHR_link_visualizza_pubblicazione", $view_bacheca_url."?bacheca_id=" . $id);
            $sendgrid = new \SendGrid(SENDGRID_API_KEY);
            try {
                $response = $sendgrid->send($email);
            } catch (Exception $e) {
                echo 'Caught exception: ' . $e->getMessage() . "\n";
            }
        }
    }

$sql        = "SELECT * FROM bacheca ORDER BY id DESC LIMIT 1";
    $result     = mysqli_query($con, $sql);
    $first_bacheca = mysqli_fetch_assoc($result);
    echo $first_bacheca["id"];
} else {
    echo "error";
}

$con->close();

Batal

Isi Zip:

Create