Pavel

Fatal error: Uncaught mysqli_sql_exception: Too many connections in...

$mysqli = new mysqli

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes)
 in \core\src\Revolution\modParser.php on line 151

$dept = $full->Department;
$phone = $full->WorkPhone;
$cellphone = $full->Cellphone;
$name = $full->Name;
$position = $full->Position;
$department = $full->Department;
$mail = $full->Mail;
$id = $full->ID;

$mysqli = new mysqli(   $host, 
                        $username, 
                        $password, 
                        $dbname, 
                        $port, 
                        $charset
                    );

$queryfull = "SELECT `Users`.`ID` AS `ID`,
					`Users`.`Name`,
					`Mail`,
					`Position`,
					`Department`,
					`WorkPhone`,
					`Cellphone`,
					((DAYOFMONTH(Birthday) = DAYOFMONTH(NOW()))
					& (MONTH(Birthday) = MONTH(NOW())))
					AS bday
				FROM `erp`.`Users`
				WHERE NOT Fired AND Department != ''
				ORDER BY `Department`, `Name`";

$fullresult = $mysqli->query($queryfull);

             
    while ($full = $fullresult->fetch_object())
    
    {
        
            if ($dept != $full->Department)

        {
 
            $dept = $full->Department;
            $phone = $full->WorkPhone != 0 ? $full->WorkPhone : '';
	        $cellphone = $full->Cellphone != 0 ? $full->Cellphone : '';
            $name = $full->Name;
            $position = $full->Position;
            $department = $full->Department;
            $mail = $full->Mail;
            $id = $full->ID;

        }

    }
                $modx->setPlaceholders(array(
                'dept' => $dept,
                'phone' => $phone,
                'cellphone' => $cellphone,
                'name' => $name,
                'position' => $position,
                'mail' => $mail,
                'id' => $id,
                ),'ep.');
$mysqli->close();

[[!usr1]]  

        <table class="uk-table uk-table-hover uk-table-small uk-margin-small uk-table-responsive">
        <tr align="center">
            <td class="uk-text-emphasis" colspan=5> 
                <h3 class="uk-heading-line uk-text-center"><span>[[+ep.dept]]</span></h1>
            </td>
        </tr>
        <tr align="left" onMouseOver="className='hilighton';" onmouseout="className='hilightoff';">
            <td>
                <div uk-lightbox>
                    <a class="uk-text-emphasis" uk-tooltip="title: Посмотреть профиль; pos: top-left" href='[[~3]]?userid=[[+ep.id]]' data-type="iframe">[[+ep.name]]</a>
                </div>
            </td>
            <td>[[+ep.position]]</td>
            <td align=\"center">[[+ep.cellphone]]</td>
            <td>
                <a class="uk-text-emphasis" uk-tooltip="title: Позвонить; pos: top-center" href=callto:" . $phone . ">[[+ep.phone]]</a>
            </td>
            <td>
                <a class="uk-icon-link" uk-tooltip="Написать письмо" uk-icon="mail" href=mailto:[[+ep.mail]]>[[+ep.mail]]</a>
            </td>
        </tr>
        </table>

$input = JFactory::getApplication()->input;

$input

JFactory::getApplication()

$user_id = $input->getInt('userid', 0);

getInt

$mysqli = new mysqli("localhost", "root", "toor", "new", "3306", "utf8");

$queryfull = "SELECT `Users`.`ID` AS `ID`,
					`Users`.`Name`,
					`Mail`,
					`Position`,
					`Department`,
					`WorkPhone`,
					`Cellphone`,
					((DAYOFMONTH(Birthday) = DAYOFMONTH(NOW()))
					& (MONTH(Birthday) = MONTH(NOW())))
					AS bday
				FROM `new`.`Users`
				WHERE NOT Fired AND Department != ''
				ORDER BY `Department`, `Name`";

$fullresult = $mysqli->query($queryfull);

    echo "
        <div class=\"uk-panel uk-panel-box uk-panel-contents uk-container\">";
    echo "
        <div class=\"uk-card uk-card-default uk-card-body uk-overflow-auto\">";
    echo "
        <table class=\"uk-table\" border=0 width=\"100%\">";

while ($full = $fullresult->fetch_object())
{
        if ($dept != $full->Department)
    {
        $dept = $full->Department;
        echo "
            <tr align=\"left\">
.................