48 lines
1.3 KiB
PHP
48 lines
1.3 KiB
PHP
|
<?
|
|||
|
|
|
|||
|
|
namespace controller\themes\merakomis\test;
|
|||
|
|
|
|||
|
|
use themes\merakomis\Emp;
|
|||
|
|
use themes\merakomis\Telegram;
|
|||
|
|
|
|||
|
|
class Api {
|
|||
|
|
public function test2(){
|
|||
|
|
exit;
|
|||
|
|
$a = Emp::getAll();
|
|||
|
|
foreach ($a as $v) {
|
|||
|
|
if($v[Emp::$TG_ACC]) {
|
|||
|
|
echo '<pre>';
|
|||
|
|
echo var_dump($v[Emp::$ID], $v[Emp::$TG_ACC], $v[Emp::$EMAIL]);
|
|||
|
|
echo '</pre>';
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
public function test()
|
|||
|
|
{
|
|||
|
|
exit;
|
|||
|
|
|
|||
|
|
//*
|
|||
|
|
// Показывать ли все ошибки
|
|||
|
|
error_reporting(E_ALL);
|
|||
|
|
ini_set('display_errors',true);
|
|||
|
|
/*/
|
|||
|
|
ini_set('display_errors','Off');
|
|||
|
|
/**/
|
|||
|
|
$serverName = '10.0.0.124\DATAPROJECT,5220'; //serverName\instanceName
|
|||
|
|
//$connectionInfo = array( "Database"=>"T51", "UID"=>"meraproject", "PWD"=>'~IA}QmLJdwrg');
|
|||
|
|
$connectionInfo = array( "Database"=>"T51", "UID"=>"meraproject", "PWD"=>'dfnRHM346DVkyjk');
|
|||
|
|
$conn =\sqlsrv_connect( $serverName, $connectionInfo);
|
|||
|
|
|
|||
|
|
$q = "SELECT * FROM Апрель_2025";
|
|||
|
|
$r = sqlsrv_query($conn,$q);
|
|||
|
|
while ($row = sqlsrv_fetch_array($r,SQLSRV_FETCH_ASSOC)) {
|
|||
|
|
print_r($row);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
echo '<pre>';
|
|||
|
|
echo var_dump($r,$conn,sqlsrv_errors());
|
|||
|
|
echo '</pre>';
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|