Advertisement
Guest User

Untitled

a guest
Jan 27th, 2011
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.94 KB | None | 0 0
  1. <?php
  2. $dbuser = "note";
  3. $dbpass = "note";
  4. $dbname = "note";
  5. $table = "table3";
  6. $table2 = "table2";
  7. if ($_POST["user"] && $_POST["pass"] && !$_COOKIE["login"]) {
  8.   $user = md5($_POST["user"]);
  9.   $pass = md5($_POST["pass"]);
  10.   $sql = mysql_connect('localhost', '$dbuser', '$dbpass') or exit(mysql_error());
  11.   mysql_select_db('$dbname', $sql) or exit(mysql_error());
  12.   $query = mysql_query("SELECT * FROM $table WHERE (`username`, `password`) = ('$user', '$pass')") or exit(mysql_error());
  13.   $info = mysql_fetch_array($query);
  14.   if ($info) {
  15.     setcookie("login", $_POST["user"], time()+3600);
  16.   }
  17. }
  18. elseif ($_COOKIE["login"]) {
  19.   $user = $_COOKIE["login"];
  20.   print("<center>You are logged in as $user</center>");
  21.   if ($user == kingskrown) {
  22.     #mysql_query("INSERT INTO $table (`username`, `password`) VALUES ('username', 'password')") or exit(mysql_error());
  23.  }
  24.   $sql = mysql_connect('localhost', '$dbuser', '$dbpass') or exit(mysql_error());
  25.   mysql_select_db('$dbname', $sql) or exit(mysql_error());
  26.   if ($_POST["msg"]) {
  27.     $msg = $_POST["msg"];
  28.     $time = date("[H:i:s]");
  29.     mysql_query("INSERT INTO $table2 (`time`, `user`, `msg`) VALUES ('$time', '$user', '$msg')") or exit(mysql_error());
  30.   }
  31.   $info = mysql_query("SELECT * FROM $table2") or exit(mysql_error());
  32.   while ($read = mysql_fetch_array($info)) {
  33.     $msg = "$msg\n$read[0] <$read[1]> $read[2]";
  34.   }
  35. }
  36. :
  37. ?>
  38. <html>
  39. <form action="<?php print($_SERVER["PHP_SELF"]); ?>" method="post">
  40. <center>
  41. username
  42. <input name="user" type="text" maxlength="12" value="">
  43. password
  44. <input name="pass" type="password" maxlength="30" value="">
  45. <input name="login" type="submit" value="login">
  46. </center>
  47. <center>
  48. <textarea name="box" rows="10" cols="75" readonly="readonly"><?php print($msg); ?></textarea><br>
  49. <input type="text" name="msg" maxlength="50" value=""/><input type="submit" value="Shout"><br>
  50. </center>
  51. </form>
  52. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement