Hello, I need sql server for this php code <div class = \"container form-signin\

Question

Hello, I need sql server for this php code

<div class = "container form-signin">

<h2>Sign-In For Best Prices</h2>

<?php

$msg = '';

if (isset($_POST['login']) && !empty($_POST['username'])

&& !empty($_POST['password'])) {

if ($_POST['username'] == 'tutorialspoint' &&

$_POST['password'] == '1234') {

$_SESSION['valid'] = true;

$_SESSION['timeout'] = time();

$_SESSION['username'] = 'tutorialspoint';

echo 'You have entered valid use name and password';

}else {

$msg = 'Wrong username or password';

}

}

?>

</div> <!-- /container -->

<div class = "container">

<form class = "form-signin" role = "form"

action = "<?php echo htmlspecialchars($_SERVER['PHP_SELF']);

?>" method = "post">

<h4 class = "form-signin-heading"><?php echo $msg; ?></h4>

<input type = "text" class = "form-control"

name = "username" placeholder = "username = tutorialspoint"

required autofocus></br>

<input type = "password" class = "form-control"

name = "password" placeholder = "password = 1234" required>

<button class = "btn btn-lg btn-primary btn-block" type = "submit"

name = "login">Login</button>

</form>

Click here to clean <a href="logout.php" tite = "Logout">Session.

</div>

Explanation / Answer

Here it is

just add this to your code and it will establish the connection with server.

<?php
$serverName = "serverNamesqlexpress, 1542";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"tutorialspoint", "PWD"=>"1234");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.