Content

https://www.microsoft.com/pl-pl/sql-server/sql-server-downloads

INDEX.PHP

<?php

session_start();

if(isset($_POST['loguj'])){

$login = $_POST['login'];

$haslo = $_POST['pass'];

$serverName = "10.10.1.10,55555";

$uid = "sa";

$pwd = "Start1234$";

$databaseName = "FIRMA";

$databaseName = "WMS";

$connectionInfo = array( "UID"=>$uid,

"PWD"=>$pwd,

"Database"=>$databaseName);

/* Podłączenie do bazy danych MSSQL */

$conn = sqlsrv_connect( $serverName, $connectionInfo);

$tsql = "SELECT TOP (1000) [strLogin]

,[strPassword]

,[strRole]

,[idUżytkownika]

FROM [WMS].[dbo].[Hive] WHERE [strLogin] = '$login' AND [strPassword] = '$haslo';";

/* Execute the query. */

$params = array();

$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );

$policz = sqlsrv_query( $conn, $tsql , $params, $options );

$stmt = sqlsrv_query( $conn, $tsql);

$ile = sqlsrv_num_rows( $policz );

$row = sqlsrv_fetch_array($stmt, 2);

$role = $row['strRole'];

$id = $row['idUżytkownika'];

if($role === 'admin'){

$_SESSION['admin'] = true;

}

if ($ile > 0){

$_SESSION['logged_in'] = true;

$_SESSION['login'] = $login;

$_SESSION['logged_id'] = $id;

unset($_SESSION['login_fail']);

header('Location: main.php');

}else {

$_SESSION['login_fail'] = true;

}

?>

<!doctype html>

<head>

<?php require_once 'crudbase/includes/head.php'; ?>

<title>WMS | Zaloguj się</title>

</head>

<h1 class="h3 mb-3 font-weight-heavy ">Zaloguj się</h1>

<?php

if(isset($_SESSION['login_fail'])){

echo '<div class="alert alert-danger" role="alert">

Podano błędny login lub hasło!

</div>';

unset($_SESSION['login_fail']);

}

?>

<br>

<label for="inputEmail" class="sr-only"><b>Użytkownik</label>

<br>

<br>

<label for="inputPassword" class="sr-only"><b>Hasło</label>

<br>

<br>

<label>

<br>

<input type="checkbox" value="remember-me"> Zapamiętaj mnie

</label>

</div>

<br>

<button class="btn btn-lg btn-primary btn-block" name="loguj" type="submit">Zaloguj się</button> </form>

// JQuery confirmation

$('.confirmation').on('click', function () {

return confirm('Are you sure you want do delete this user?');

});

</script>

</body>

</html>

MAIN.PHP

<?php

session_start();

if(!isset($_SESSION['logged_in'])){

header('Location: index.php');

}

unset($_SESSION['klucz_dok']);

?>

<!doctype html>

<head>

<?php require_once 'crudbase/includes/head.php'; ?>

<style>

.btn-circle {

width: 30px;

height: 30px;

text-align: center;

padding: 6px 0;

font-size: 12px;

line-height: 1.428571429;

border-radius: 15px;

}

</style>

<style>

.bd-placeholder-img {

font-size: 1.125rem;

text-anchor: middle;

-webkit-user-select: none;

-moz-user-select: none;

user-select: none;

}

@media (min-width: 768px) {

.bd-placeholder-img-lg {

font-size: 3.5rem;

}

</style>

</head>

<body>

<?php require_once 'crudbase/includes/header.php'; ?>

<?php

if(isset($_SESSION['admin_fail'])) {

echo '<div class="alert alert-danger" role="alert">

Barak uprwanień, zaloguj się jako admin!

</div>';

unset($_SESSION['admin_fail']);

}

?>

</div>

WMS APK<br>MAIN MENU<br>

</h1>

</div>

<div>

<a href="http://wms.it-on.pl:8888/info.php" class="ms-auto link-light" hreflang="ar">Aplikacja Mobilna v.1.2<br></a>

</div>

</header>

</a>

</a>

</a>

</a>

</a>

</a>

</div>

<a href="http://wms.it-on.pl:8888/logout.php"> <button type="button" class="btn btn-success">Wyloguj</button> </a>

<h1 class="align-left">Lista do kompletacji:</h1>

<thead>

<tr>

<th scope="col">Numer dokumentu</th>

<th scope="col">Liczba pozycji</th>

<th scope="col">Suma ilości</th>

</tr>

</thead>

<?php

$serverName = "10.10.1.10,55555";

$uid = "sa";

$pwd = "Start1234$";

$databaseName = "FIRMA";

$connectionInfo = array( "UID"=>$uid,

"PWD"=>$pwd,

"Database"=>$databaseName);

/* Podłączenie do bazy danych MSSQL */

$conn = sqlsrv_connect( $serverName, $connectionInfo);

$tsql = "SELECT top(1000)

[KLUCZ_DOK],

[SUMA_IL],

[UWAGI]

,(SELECT count(*) FROM [FIRMA].[dbo].[POZ_DOK] where [POZ_DOK].[KLUCZ_DOK] = [NAGL_DOK].[KLUCZ_DOK] ) AS LICZBA_POZYCJI

,(SELECT count(*) FROM [FIRMA].[dbo].[NAGL_DOK] where [FIRMA].[dbo].[NAGL_DOK].[KLUCZ_DOK] like 'ZO/%'

and [FIRMA].[dbo].[NAGL_DOK].[STATUS_ZAM]=23 or [FIRMA].[dbo].[NAGL_DOK].[STATUS_ZAM]=22 ) AS LICZBA_ZAMOWIEN_RAZEM

FROM [FIRMA].[dbo].[NAGL_DOK]

where [FIRMA].[dbo].[NAGL_DOK].[KLUCZ_DOK] like 'ZO/%'

and [FIRMA].[dbo].[NAGL_DOK].[STATUS_ZAM]=23 or [FIRMA].[dbo].[NAGL_DOK].[STATUS_ZAM]=22

order by row_dtime desc;";

/* Execute the query. */

$params = array();

$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );

$policz = sqlsrv_query( $conn, $tsql , $params, $options );

$ile = sqlsrv_num_rows( $policz );

$stmt = sqlsrv_query( $conn, $tsql);

for ($i = 1; $i <= $ile; $i++)

{

$row = sqlsrv_fetch_array($stmt, 2);

$a1 = $row['KLUCZ_DOK'];

$a2 = $row['STATUS_ZAM'];

$a3 = round($row['SUMA_IL'],2);

$a4 = $row['SUMA_BRU'];

$a5 = $row['UWAGI'];

$a6 = $row['LICZBA_POZYCJI'];

$a7 = $row['LICZBA_ZAMOWIEN_RAZEM'];

echo '

<td>

</button>

</td>

<td>

</form>

</td>

</tr>

<tr>

<p class="pl-3"><b> | Uwagi: | '.$a5.' | </b></p>

</div>

</td>

</tr>';

}

sqlsrv_free_stmt( $stmt);

sqlsrv_close( $conn);

?>

</div>

</body>

</html>

Top Menu

Side Menu

Content

INDEX.PHP

MAIN.PHP

Top Menu

Welcome to OpenProject

Get an overview

Side Menu

Content

10. - Instalacja silnika serwera MSSQL Microsoft

INDEX.PHP

MAIN.PHP