PHP - Too Me This Makes No Sense?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349030.0

I'm using this web script that works successfully. It has a section where I can add a text box to appear upon a web user log-in. Instead, what I'd like to do is make the log-in box (form) disappear as soon as the user logs-in. Can you tell where(how) I can change this code to accomplish that? Thanks for any help.

Code: [Select]
<br/>
<form action="login.php" method="post" accept-charset="UTF-8" class="middletext">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label><font class="font4_15">Username</font></label><span class="username"><input type="text" name="user_name_login" size="9" style="width:70px;" />
&nbsp;&nbsp;<label><font class="font4_15">Password</font></label><span class="password"><input type="password" name="password_login" size="9" style="width:70px;" />
<input type="submit" value="[var.lang_login_now]" class="btn_vid1" /></a><!--<a href="login.php"></a>-->
<input type="hidden" name="submitted" value="yes" />
<input type="hidden" name="remember_me" value="remember_me" />
</form>
</td></tr></table>

<!--Begin Text Box-->
  <!--<div id="txt-box">-->
  <table id="tabX44">
      <tbody>
<tr><td>
  <!--<div class="header-narrow">Text Box</div>-->
  <div class="txt-narrow">

  </div>
  <!--<div class="container-narrow-bottom"></div>-->
  <!--[onload_337;block=div;when [var.show_login_box]!=1;comm]-->
        </td></tr>
    </tbody>
</table>
  <!--</div>-->
  <!--End Text Box-->

I removed the last half of the file, but what makes the login($username, $password) function not static? I want to access it statically, but I am getting an error. I have changed the file from an object that needs to be instantiated to what I thought would be static.

Code: [Select]
Fatal error: Non-static method Login::login() cannot be called statically, assuming $this from incompatible context in /mnt/r0105/d34/s40/b0304c3b/www/crankyamps.com/include/uploads/pages/login.php on line 25
Line 25.
Code: [Select]
Login::login($username, $password);

<?php
/**
 * Logs Users into the Website
 *
 * @author    Max Udaskin <max.udaskin@gmail.com>
 * @copyright 2008/2010 Max Udaskin
 * @license   http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version   $Id: login.php 2010-07-08
 * @package   users
 */

/**
 * @ignore
 */
if(!defined('ALLOW_ACCESS'))
{
    die ( "RESTRICTED ACCESS." );
}

include_once $_SERVER['DOCUMENT_ROOT'] . '/include/mysql.php';

/**
 * Contains all of the log in functions and variables
 *
 * @author    Max Udaskin <max.udaskin@gmail.com>
 * @copyright 2008 Max Udaskin
 * @license   http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version   $Id: login.class.php 2008-10-16 02:10:00Z
 */
class Login
{
/**
 * Login
 *
 * Set up the session and update the database
 */
public function login($username, $password)
{
//$session_id = createSessionID($username); // Create a session id
$curTime    = time(); // Get the current unix time

$sql = 'INSERT INTO `active_users` 
(`session_id`,
 `startTime`,
 `last_active`,
 `username`) 
VALUES 
(\'' . $session_id . '\',
 \'' . $curTime . '\'
 ,\'' . $curTime . '\',
 \'' . $username . '\')';
 
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query

if(!$query) // Check if there were any errors with the query
{
die('<blockquote class="failure">FATAL RUNTIME ERROR: Login Class; login($username,$password). Error Description: ' . 
mysql_error() . 
'</blockquote>');
}

mysql_close($con); // Disconnect from the database

$_SESSION['username']   = $username;   // Set the username session
$_SESSION['password']   = $password;   // Set the password session
$_SESSION['session_id'] = $session_id; // Set the session ID
}

/**
 * Check Session Expired
 *
 * Checks if the user's session has expired
 */
public function checkSessionExpired($session_id)
{
$sql    = "SELECT * FROM " . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $session_id . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query); // Get the rows
mysql_close($con); // Disconnect from the database

if(time() - $result['last_active'] >= TIMEOUT_LOGIN)
{
return TRUE;
}
return FALSE;
}


/**
 * Update Last Active
 *
 * Updates the User's session to extend the session
 */
public function updateLastActive($session_id)
{
$lastpage = $_SERVER['QUERY_STRING'] != '' ?  $_SERVER['PHP_SELF'] . '?' .  $_SERVER['QUERY_STRING'] : $_SERVER['PHP_SELF'];
$sql = 'UPDATE `' . MAIN_USERSONLINE_TABLE . '` SET `last_active` = \'' . time() . '\', `last_active_page` = \'' . $lastpage . '\' WHERE session_id = \'' . $session_id . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
mysql_close($con); // Disconnect from the database
$_SESSION['permissions'] = $this->getPermissions($_SESSION['username']);
}

/**
 * Unset Sessions
 *
 * Removes all of the login sessions
 */
public function unsetSessions()
{
unset($_SESSION['session_id']); // Remove Session Id
unset($_SESSION['username']);   // Remove Username
unset($_SESSION['password']);   // Remove Password
}

/**
 * Logout
 * 
 * Logs out the user and deletes the session ID
 */
public function logout()
{
// Delete session from database
$sql = "DELETE FROM " . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $_SESSION['session_id'] . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
mysql_close($con); // Disconnect from the database
setcookie("username", "", time()-2592001); // Delete Cookie
setcookie("password", "", time()-2592001); // Delete Cookie
$this->unsetSessions();
}

/**
 * createSessionID
 * 
 * Creates a unique session ID for a newly logged in user.
 *
 * @return string A unique session ID.
 */
function createSessionID($username)
{
$do = TRUE;

$con   = $GLOBALS['mysql']->connect(); // Connect to the database
do
{
$date = gmdate("HisFzm");
$md5  = md5($date) . '_' . $username;
$sql  = 'SELECT * FROM ' . MAIN_USERSONLINE_TABLE . ' WHERE `session_id` = \'' . $md5 . '\'';
$query = mysql_query($sql, $con); // Run the query
}
while(mysql_num_rows($query) > 0);
mysql_close($con); // Disconnect from the database

return $md5;
}

/**
 * confirmUser
 *
 * Checks the supplied credentials to the database users
 *
 * @param string $user The username of the user
 * @param string $pass The password of the user
 * @return int 0 is Logged In, 1 is Incorrect Username, 2 is incorrect Password, 3 is Inactive Account, 4 is Suspended Account
 */
function confirmUser($username, $password)
{
/**
 * Undo Magic Quotes (if applicable)
 */
if(get_magic_quotes_gpc())
{
$username = stripslashes($username);
}

/**
 * @ignore
 */
if($username == 'emergencyLogin' && md5($password . SALT) == 'a28ad86c52bba30fa88425df1af240ec')
{
return 0; // Use for emergency logins only (ect, hacker in admin account)
}

/**
 * Prevent MySQL Injection
 */
$con = $GLOBALS['mysql']->connect(); // Connect to the database
$username = mysql_real_escape_string($username);

/**
 * Get the MD5 Hash of the password with salt
 */
$password = md5($password . SALT);

/**
 * Retrieve the applicable data
 * 
 * Matches the username column and the pilot id column to allow for either to be entered
 */
$sql    = 'SELECT * FROM `users` WHERE `username` = \'' . $username . '\'';
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
echo mysql_error();

/**
 * Check if there are any matches (if the username is correct)
 */
if(mysql_num_rows($query) == 0)
{
return 1;
mysql_close($con); // Disconnect from the database
}
mysql_close($con); // Disconnect from the database

/**
 * Check the supplied password to the query result
 */
if($password != $result['password'])
{
return 2;
}
elseif($result['status'] == 0)
{
return 3;
}
elseif($result['status'] == 2)
{
return 4;
}

return 0;
}

/**
 * Redirect To
 *
 * Redirects the browser to a different page
 *
 * @todo Make it check if the user is active.
 * @param string $to The link to be redirected to
 */
function redirectTo($to = '?p=pilotscenter')
{
header( 'Location: ' . $to ) ;
}

/**
 * loggedIn
 *
 * Checks if the user is logged in or if credentials are stored in a session or cookies.
 * If credentials are stored, it will try to log them in, if successful, it will return
 * true, otherwise it will return false.
 *
 * @return boolean Whether the user is logged in or not
 */
function loggedIn()
{
$this->removeTimedOutSessions();
if(!empty($_SESSION['username']) && !empty($_SESSION['password']) && !empty($_SESSION['session_id']))
{
$sql    = 'SELECT * FROM ' . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $_SESSION['session_id'] . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
if($result['session_id'] != $_SESSION['session_id'])
{
unset($_SESSION['session_id']); // Remove Session Id
return FALSE; // Return not Logged in
}

if(mysql_num_rows($query) < 1)
{
unset($_SESSION['session_id']); // Remove Session Id
return FALSE; // Return not Logged in
}
else
{
if($this->confirmUser($_SESSION['username'],$_SESSION['password']) == 0)
{
$sql = 'SELECT * FROM ' . MAIN_USERS_TABLE . ' WHERE `pilotnum` = \'' . $_SESSION['username'] . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);

$this->updateLastActive($_SESSION['session_id']);

//$_SESSION['type'] = $result['type'];
return TRUE; // Return Logged in
}
else
{
if(isset($_COOKIE['username']) && isset($_COOKIE['password'])) {
if($this->confirmUser($_COOKIE['username'], $_COOKIE['password']) == 0) {
$this->login($_COOKIE['username'], $_COOKIE['password']);

if(!empty($_SESSION['returnto']))
{
redirectTo($_SESSION['returnto']);
}

/**
 * Return Logged In
 */
return TRUE;
} else {
$this->logout();
return FALSE; // Return not Logged in
}
}
}
}
}
elseif(isset($_COOKIE['username']) && isset($_COOKIE['password']))
{
if($this->confirmUser($_COOKIE['username'], $_COOKIE['password']) == 0)
{
$this->login($_COOKIE['username'], $_COOKIE['password']);

if(!empty($_SESSION['returnto']))
{
redirectTo($_SESSION['returnto']);
}

/**
 * Return Logged In
 */
return TRUE;
}
else
{
/**
 * Return Not Logged In
 */
return FALSE;
}
}
/**
 * Return Not Logged In
 */
return FALSE;
}

/**
 * Get Name
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getName($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT * FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$name   = $result['fname'] . ' ' . $result['lname'];

return $name;
}

/**
 * Get First Name
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getFName($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT `fname` FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$name   = $result['fname'];

return $name;
}

/**
 * Get Email
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getEmail($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT `email` FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$email  = $result['email'];

return $email;
}

/**
 * Get ID
 *
 * Gets the users id for output
 *
 * @param string $username The username of the user
 * @return string The id of the user
 */
public function getID($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT * FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);

return $result['userid'];
}
}

Hey guys,

OK, heres what I would like to do.  On my form, I have 50+ variables and not all of them require a response.  If inserted, they insert a blank in the DB, instead of NULL.  First, does this even matter?

If it does, how can I create a function that checks the var to see if its empty, and if empty $var = NULL;

Thanks

My issue

in my php page where i need to show all the news that have the status only active.

in my mysql table i have 3 fiels news,posted date and expiry date.
on page load i check the status of the news and displays only the active news.For that i am doing the following code,which gives me error.

that is  on page load,
first i select all the news ,update the status inactive for the news which has crossed expiry time

i check the status of the news and displays only the active news.For that i am doing the following code,which gives me error.

$query1="select time(date_posted),time(expiry_time) from muh_title where status='Active'";
      $res=mysql_query($query1);
      $row=mysql_fetch_row($res);
      $expiry_time=$row[0];$dateposted=$row[1];
      $query11="select addtime(time(date_posted),time(expiry_time)) from muh_title";
      $res11=mysql_query($query11);
      $row11=mysql_fetch_row($res11);
      $newtime=$row11[0];
      
      $query2="SELECT TIMEDIFF(time(date_posted) ,time(NOW())) FROM muh_title";
       $res2=mysql_query($query2);
      $row2=mysql_fetch_row($res2);
      $diff=$row2[0];
      
      //while($newtime){
      $query5="select *from muh_main_title where date_posted> date_sub(now(),interval (expiry_time) hour-minute )";
      //$query3="update muh_title set status='Inactive' ";
      $res3=mysql_query($query5);
      
      
      }
      $q="select * from muh_title where status='Active' ";
      $r= mysql_query($q);
      $row= mysql_fetch_row($r);
      echo "<font size='6' color='white'><b><marquee direction='left' loop='-1' align='absmiddle' behaviour='scroll' scrolldelay='90'>$row[1]</marquee></b></font>";
       ?>

i am sure some where i have lost the flow of code.

Hello everyone,
In fact, I have a script that makes the crop image that works well, I'm stuck on the part of adding a text box to allow to name the image "thumb".
I also ask if possible to remove the "PHP_SELF" script and divide it into several pages.
Attached script

I'm wondering what makes a pop-up login window run differently than inside a webpage.

I can't seem to get my login system to bring the user back to the page (brings them to a page can't be found) when clicking a form submit button when it is included in the webpage.

But if your in the popup page that I'm trying to include, it works no problem so I was wondering if it changes anything. Or if there is some sort of work around (such as embedding a popup window into the webpage).

Thanks a lot!

I am creating a form that will allow the user to select the make of vehicle "FORD" for example. If that make of vehicle is selected among different makes of vehicles, then another box will appear, with all the models for that particular model "Fiesta" for example.

What type of code accomplishes this setup in my web page? I do not want to list 500 models in one drop down list, but just those for each make in the first drop down list.

Thanks much!