Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- chat.html:
- <!DOCTYPE HTML>
- <html>
- <head>
- <script>
- setInterval(
- function getChatMessages () {
- if(window.XMLHttpRequest){
- xmlhttp = new XMLHttpRequest();
- }
- else{
- xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
- }
- xmlhttp.onreadystatechange = function () {
- if(xmlhttp.readyState == 4 && xmlhttp.status == 200){
- document.getElementById("chat").innerHTML = xmlhttp.responseText;
- }
- }
- xmlhttp.open("GET", "gchat.php", true);
- xmlhttp.send();
- }, 1);
- </script>
- <link href="chatStyle.css" rel="stylesheet">
- </head>
- <body style="background-color:gray">
- <div class="main-chat-wrapper">
- <div class="listusers">
- All users:<br/>
- <a href="users/foo">foo</a>, <a href="/users/bar">bar</a>
- </div>
- <div class="chat-wrapper">
- <div class="chat-output-feed" id="chat">
- </div>
- <form action="chat.php">
- Send a message to your friends:
- <input class="msg" type="text" name="msg" />
- <input type="submit" value="Send!" />
- </form>
- </div>
- </div>
- </body>
- </html>
- chat.php:
- <?php
- $server = "tcp:s0rq688sz1.database.windows.net,1433";
- $user = "raumaan@s0rq688sz1";
- $pwd = "Qwertyuiop1";
- $db = "raumaansql";
- $connectionInfo = array("UID" => "raumaan@s0rq688sz1", "pwd" => "Qwertyuiop1", "Database" => "raumaansql", "LoginTimeout" => 30, "Encrypt" => 1);
- $serverName = "tcp:s0rq688sz1.database.windows.net,1433";
- $conn = sqlsrv_connect($serverName, $connectionInfo);
- if($conn === false){
- die(print_r(sqlsrv_errors()));
- }
- $sql = "INSERT INTO chat VALUES ('foo',?)";
- $params = array($_GET['msg']);
- $stmt = sqlsrv_query($conn, $sql, $params);
- if($stmt === false){
- die(print_r(sqlsrv_errors(), true));
- }
- sqlsrv_close($conn);
- ?>
- <!DOCTYPE HTML><html><head><meta http-equiv="refresh" content="0;url=chat.html"/></head></html>
- gchat.php:
- <?php
- $server = "tcp:s0rq688sz1.database.windows.net,1433";
- $user = "raumaan@s0rq688sz1";
- $pwd = "Qwertyuiop1";
- $db = "raumaansql";
- $connectionInfo = array("UID" => "raumaan@s0rq688sz1", "pwd" => "Qwertyuiop1", "Database" => "raumaansql", "LoginTimeout" => 30, "Encrypt" => 1);
- $serverName = "tcp:s0rq688sz1.database.windows.net,1433";
- $conn = sqlsrv_connect($serverName, $connectionInfo);
- if($conn === false){
- die(print_r(sqlsrv_errors()));
- }
- $sql = "SELECT * FROM chat";
- $stmt = sqlsrv_query($conn, $sql);
- if($stmt === false){
- die(print_r(sqlsrv_errors(), true));
- }
- while($row = sqlsrv_fetch_array($stmt)) {
- echo $row['username'] . "› " . $row['message'] . "<br/>";
- }
- sqlsrv_close($conn);
- ?>
- link: raumaan.azurewebsites.net/chat.html
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement