FRIHOSTFORUMSSEARCHFAQTOSBLOGSCOMPETITIONS
You are invited to Log in or Register a free Frihost Account!


PHP issues >.>





ALostSoul
Code:
<?php
require "connect.php";
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
$result = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."' AND `password` = '".$password."'");
if(mysql_num_rows($result) > 0) {
$_SESSION['username'] = $username;
} else {
 die("Lol");
}
?>
<?php
header("Pragma: no-cache");
$gDate = time();
$gClockShowsSeconds = false;
function getServerDateItems($inDate) {
return date('Y,n,j,G,',$inDate).intval(date('i',$inDate)).','.intval(date('s',$inDate));
}
function clockDateString($inDate) {
return date('l, F j, Y',$inDate);
}
function clockTimeString($inDate, $showSeconds) {
return date($showSeconds ? 'g:i:s' : 'g:i',$inDate).' ';
}
?>
<html>

<head>
  <title>Home.</title>
  <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
  <link rel="stylesheet" type="text/css" href="style/style.css" />
  <link rel="stylesheet" type="text/css" href="style/purple.css" />
<meta name="template" content="none">
<script language="JavaScript" type="text/javascript">
<!--
var clockLocalStartTime = new Date();
var clockServerStartTime = new Date(<?php echo(getServerDateItems($gDate))?>);
function clockInit() {
}
//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
function simpleFindObj(name, inLayer) {
return document[name] || (document.all && document.all[name]) || (document.getElementById && document.getElementById(name)) || (document.layers && inLayer && document.layers[inLayer].document[name]);
}
var clockIncrementMillis = 60000;
var localTime;
var clockOffset;
var clockExpirationLocal;
var clockShowsSeconds = false;
var clockTimerID = null;
function clockInit(localDateObject, serverDateObject)
{
var origRemoteClock = parseInt(clockGetCookieData("remoteClock"));
var origLocalClock = parseInt(clockGetCookieData("localClock"));
var newRemoteClock = serverDateObject.getTime();
var newLocalClock = localDateObject.getTime();
var maxClockAge = 60 * 60 * 1000;
if (newRemoteClock != origRemoteClock) {
document.cookie = "remoteClock=" + newRemoteClock;
document.cookie = "localClock=" + newLocalClock;
clockOffset = newRemoteClock - newLocalClock;
clockExpirationLocal = newLocalClock + maxClockAge;
localTime = newLocalClock;
}
else if (origLocalClock != origLocalClock) {
clockOffset = null;
clockExpirationLocal = null;
}
else {
clockOffset = origRemoteClock - origLocalClock;
clockExpirationLocal = origLocalClock + maxClockAge;
localTime = origLocalClock;
}
var nextDayLocal = (new Date(serverDateObject.getFullYear(),
serverDateObject.getMonth(),
serverDateObject.getDate() + 1)).getTime() - clockOffset;
if (nextDayLocal < clockExpirationLocal) {
clockExpirationLocal = nextDayLocal;
}
}
function clockOnLoad()
{
clockUpdate();
}
function clockOnUnload() {
clockClearTimeout();
}
function clockClearTimeout() {
if (clockTimerID) {
clearTimeout(clockTimerID);
clockTimerID = null;
}
}
function clockToggleSeconds()
{
clockClearTimeout();
if (clockShowsSeconds) {
clockShowsSeconds = false;
clockIncrementMillis = 60000;
}
else {
clockShowsSeconds = true;
clockIncrementMillis = 1000;
}
clockUpdate();
}
function clockTimeString(inHours, inMinutes, inSeconds) {
return inHours == null ? "-:--" : ((inHours == 0 ? "12" : (inHours <= 12 ? inHours : inHours - 12)) + (inMinutes < 10 ? ":0" : ":") + inMinutes + (clockShowsSeconds? ((inSeconds < 10 ? ":0" : ":") + inSeconds) : "") + (inHours < 12 ? " AM" : " PM"));
}
function clockDisplayTime(inHours, inMinutes, inSeconds) {
clockWriteToDiv("ClockTime", clockTimeString(inHours, inMinutes, inSeconds));
}
function clockWriteToDiv(divName, newValue)
{
var divObject = simpleFindObj(divName);
newValue = '<p>' + newValue + '<' + '/p>';
if (divObject && divObject.innerHTML) {
divObject.innerHTML = newValue;
}
else if (divObject && divObject.document) {
divObject.document.writeln(newValue);
divObject.document.close();
}
}
function clockGetCookieData(label) {
var c = document.cookie;
if (c) {
var labelLen = label.length, cEnd = c.length;
while (cEnd > 0) {
var cStart = c.lastIndexOf(';',cEnd-1) + 1;
while (cStart < cEnd && c.charAt(cStart)==" ") cStart++;
if (cStart + labelLen <= cEnd && c.substr(cStart,labelLen) == label) {
if (cStart + labelLen == cEnd) {
return "";
}
else if (c.charAt(cStart+labelLen) == "=") {
return unescape(c.substring(cStart + labelLen + 1,cEnd));
}
}
cEnd = cStart - 1;
}
}
return null;
}
function clockUpdate()
{
var lastLocalTime = localTime;
localTime = (new Date()).getTime();
if (clockOffset == null) {
clockDisplayTime(null, null, null);
}
else if (localTime < lastLocalTime || clockExpirationLocal < localTime) {
document.cookie = 'remoteClock=-';
document.cookie = 'localClock=-';
location.reload();
}
else {
var serverTime = new Date(localTime + clockOffset);
clockDisplayTime(serverTime.getHours(), serverTime.getMinutes(),
serverTime.getSeconds());
clockTimerID = setTimeout("clockUpdate()",
clockIncrementMillis - (serverTime.getTime() % clockIncrementMillis));
}
}
//-->
</script>
</head>
<body onload="clockInit(clockLocalStartTime, clockServerStartTime);clockOnLoad();" onunload="clockOnUnload()">
  <div id="main">
    <div id="logo"><h1>Welcome! ( this will be changed later )</h1></div>
    <div id="menu">
      <ul>
        <li><a id="selected" href="http://cyberinfections.frih.net/">home</a></li>
        <li><a href="I-told-you.php">I told you</a></li>
        <li><a href="#">Main Link</a></li>
        <li><a href="#">Main Link</a></li>
        <li><a href="#">Main Link</a></li>
      </ul>
    </div>
    <div id="content">
      <div id="column1">
        <div class="sidebaritem">
          <h1>Log in!</h1>
<?php
if(isset($_POST['login'])){
echo "You're logged in as: $username\n\n\n\n";
echo "<a href='index.php?logout=true'>Logout?</a>";
}else{
echo "<form method=\"post\"> Username: <input type=\"text\" name=\"username\"><br>Password: <input type=\"password\" name=\"password\"><br><input type=\"submit\" name=\"login\" value=\"Log In\"></form>\n\n";
echo "<a href=\"register.php\">Register!</a>";
}
if ($_POST['logout'] == true) {
unset($_SESSION['username']);
}
?>
        </div>
        <div class="sidebaritem">
          <div class="sbilinks">
<li>
<ul>
<div id="ClockTime" onclick="clockToggleSeconds()">
<?php echo(clockTimeString($gDate,$gClockShowsSeconds));?>
</div>
<div id="ClockBkgnd">
<?php echo(clockDateString($gDate)); ?>
</div>
</ul>
</li>
          </div>
        </div>
        <div class="sidebaritem">
          <h1>Staff</h1>
          <p>
Admin: Joshua Houde (Admin)<br>
Admin: Caleb Smelser(Smelserdude1)<br>
Admin: Hunter (last name)(hunter612)<br>
Mod/Site Helper: Patrick McKenna(Patrick)
          </p>
        </div>
      </div>
      <div id="column2">
        <h1>Stuff</h1>
        <p>
Content
        </p>
      </div>
    </div>
    <div id="footer">
      Copyright &copy; 2006 Joshua Houde
    </div>
  </div>
</body>
</html>



Well, that's my whole index page....Im having a problem with the log in...Instead of giving a person a chance to log in, it automatically dies with the failed login error...Any idea how to stop this?
ALostSoul
Anyone?
Clever_As_Sin
I've rewrited 1st block of your code, it's not hte same, but you'd see the main idea: a **if ($_POST)** check up.

Code:
<?php
session_start();

$username = $_POST['username'];
$password = $_POST['password'];
$result = ($username == 'user' && $password == '1') ? true : false;

if ($_POST)
{
   if($result)
   {
      $_SESSION['username'] = $username;
   }
   else
   {
      die("Lol");
   }
}
?>


You should check if login form has POSTed user's name and password, actually just POST something. If it does not, than just show the entire page with login form.
ALostSoul
Well, it worked, but now its saying every username/password is wrong when i login.
DjinniFire
Mine is similar.
I cut back everything that didn't pertain to form and login. Here's what I got that should work.

Code:



<?php
require "connect.php";
session_start();

if(isset($_POST['username']) && isset($_POST['password'])) {

   $username = $_POST['username'];
   $password = $_POST['password'];
   $result = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."' AND `password` = '".$password."'");
      if(mysql_num_rows($result) > 0) {
         $_SESSION['username'] = $username;
      } else {
         die("Lol");
      }
}
?>


<?php
if(isset($_SESSION['username'])){
   $username=$_SESSION['username'];
      echo "You're logged in as: $username\n\n\n\n";
      echo "<a href='index.php?logout=true'>Logout?</a>";
}
else{
   echo "<form method=\"post\"> Username: <input type=\"text\" name=\"username\"><br>Password: <input type=\"password\" name=\"password\"><br><input type=\"submit\" name=\"login\" value=\"Log In\"></form>\n\n";
   echo "<a href=\"register.php\">Register!</a>";
}
if ($logout == true) {
   unset($_SESSION['username']);
}
?>


Place where needed. Also I noticed you did index.php?logout=true
$_POST['logout'] is not the same as logout=true for the URL. but it does set a variable called $logout as true. So I think it should work now.
ALostSoul
Fire, I love you forever for this! Although, you didn't need the $ before the logout section of the code Wink thank you SO much *hugs*
hitzonline
If any of you guys need help with PHP/MySql i am here, i have an expert knoweledge in the coding. So - if you need help gimme a shout, craiganderson-1@hotmail.co.uk

Regards,

Craig Anderson
Related topics
Including With PHP
PHP: Feedback form issues.. help =P
Ip Banning Using Php
I have a question about php configuration
php script in php nuke - need help!
PHP Navigation
error in my PHP script
PHP Tutorial: Basic Shoutbox w/ MySQL
help with php
uma grande dúvida em php, por favor me ajudem
PHP Includes and Variables?
What for <script type="text/php"> is used?
<?php session_start(); ?> on Every Page
Help with php email
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.