setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("SELECT COUNT(*) AS count FROM appointment WHERE email = :email AND view_status = 0"); $stmt->bindParam(':email', $_SESSION['email']); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); $total_notice = $result['count']; } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } try { $conn = new PDO("mysql:host=$mariaServer;dbname=$mariaDb", $mariaUser, $mariaPass); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("SELECT COUNT(*) AS count FROM cleads WHERE user = :user AND date IS NOT NULL AND date >= CURRENT_DATE"); $stmt->bindParam(':user', $_SESSION['email']); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); $follow_date_count = $result['count']; } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } ?>
beanstalkedu logo

CRM

0){ ?>

0){ // echo '
//

'.$total_notice.'

//
'; // } ?> Logout
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("SELECT * FROM users WHERE email=:email"); $stmt->bindParam(':email', $_SESSION['email']); $stmt->execute(); $usersNames = $stmt->fetchAll(PDO::FETCH_ASSOC); $num_rows = $stmt->rowCount(); foreach($usersNames as $user_name){ $nameParts = explode(" ", $user_name['name']); $firstInitial = substr($nameParts[0], 0, 1); $lastInitial = substr($nameParts[count($nameParts) - 1], 0, 1); echo '

Hi '.ucfirst($nameParts[0]).'

  '.$firstInitial.$lastInitial.'
'; } } catch (PDOException $e) { echo "

Error: " . $e->getMessage() . "

"; } ?>