<html> <head> <link rel="stylesheet" type="text/css" href="/Main Style.css"> <title>CoolHeat comfort CRM</title> <link rel="shortcut icon" href="/icon.ico" /> </head> <body> <div id="numsect"> <?php session_start(); echo "your next number is:"; getnextnumber(); function getnextnumber() { $idnum = $_SESSION["idnum"]; $sql = "SELECT MIN(IDNKey),Pnumber,Fname,Lname,Address,Comments1,Comments2 FROM numbers WHERE AssignedUser='******' AND Response='booked';"; //echo $sql; $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) == 1) { $row = $result->fetch_assoc(); echo "#" . $row["Pnumber"] . "<br>" . $row["Fname"] . "," . $row["Lname"] . "<br>" . $row["Address"] . "<br>" . $row["Comments1"] . "<br>" . $row["Comments2"]; $_SESSION["IDNKey"] = $row["MIN(IDNKey)"]; //echo "IDKey=".$_SESSION["IDNKey"]; } elseif (mysqli_num_rows($result) == 0) { echo "Tell Aric your out of rows!"; echo $sql;
<body> <div id="numsect"> <?php session_start(); $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $idnum = $_SESSION["idnum"]; $sqlpunch = "SELECT Type FROM punches WHERE IDKey IN (SELECT MAX(IDKey) FROM punches WHERE AgentID='{$idnum}')"; $resultpunch = mysqli_query($conn, $sqlpunch); $rowpunch = $resultpunch->fetch_assoc(); $punchedin = $rowpunch["Type"]; if ($punchedin == '0') { $zone = getnextnumber(); } else { echo "Please punch in."; } function getnextnumber() { $idnum = $_SESSION["idnum"]; $sql = "SELECT MIN(IDNKey),Pnumber,Fname,Lname,Address,Zone FROM numbers WHERE AssignedUser='******' AND AssignedUser<>'0' AND Response='o' AND (Length(Pnumber)='14' OR Length(Pnumber)='10');"; //echo $sql; $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) == 1) {