Jump to content

Recommended Posts

I have  a PHP Page that asks user to "Enter database Password"  every time I had to Login to the Report section.My aim to get rid of that screen .

By that I mean ,basically whenever I should hit Reports.Php page"sessionpassword" should go into the database password automatically.I should only see what ever is  there in Report Page.

 

"Enter database password" comes from this form :

<FORM>
<%*/ function superpw() {
%>
	<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
	  <TBODY> 
		 <TR> 
			<TD>Database Password</TD> 
			<TD>  </TD> 
			<TD> 
			  <INPUT TYPE="PASSWORD" NAME="super_pass" SIZE="20"></TD> 
			<TD>  </TD> 
			<TD> 
			    <INPUT TYPE="SUBMIT" NAME="Submit1" VALUE="GO"></TD> 
		 </TR> 
	  </TBODY> 
	</TABLE>
<%} /*%>
 </FORM>

 

Super_pass Function Is defined as:

 

function opendb() {
globvars('super_pass');
global $globvars; extract($globvars) ;
$GLOBALS['db'] = $dbnam ;
$cfgServer['host'] = $dbhst;


$GLOBALS['link'] = '' ;
if($super_pass) {
	// user supadmin login

	$cfgServer['user'] = $_SESSION['user'];
	$cfgServer['password'] = $_SESSION['password'] ;

	//$cfgServer['password'] = sp_code($_SESSION['password'],'d') ;
	//print_r($cfgServer);

	$GLOBALS['link'] = mysql_connect(  $cfgServer['host'] ,$cfgServer['user'] , $cfgServer['password'] );
	//$globvars['dblog'] = $cfgServer['user'] ;
	$globvars['dblog'] = $dbsup ;

}

 

 

 

Report where this function has been called:

 

template('Reporting > MIS Reports');
  function main() {
globvars();
global $globvars; extract($globvars) ;



  	if($dblog == $dbsup  ) {
	if($done) {
		dispres() ;
	}
	else {
        	form() ;
	}
}
else {

	superpw() ;


}

  }
  
  function form() {
global $globvars; extract($globvars) ;
$globvars['super_pass'] = sp_code($super_pass,'e') ;
ihide('super_pass');
%>
	<TABLE BORDER="0" CELLPADDING="4" CELLSPACING="1" CLASS="dtable" WIDTH="100%"> 
	  <TBODY> 
		 <TR> 
			<TD> 
}

$globvars['super_pass'] = sp_code($_SESSION['password'],'e') ;
//$globvars['super_pass'] = sp_code($super_pass,'e') ;	
ihide('super_pass', 'done', 'manufacturer', 'process', 'wafer', 'purchase_from', 'as_of', 'location', 'group_by', 'output_to');
%>
	<INPUT TYPE="HIDDEN" NAME="output_to" VALUE="xls"> <BR> 
	<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
	  <TBODY> 
		 <TR> 
			<TD><A HREF="javascript:main.submit();">Open in Excel</A></TD> 
			<TD><IMG SRC="../images/blank.gif" WIDTH="100" HEIGHT="1" BORDER="0"
			  ALT=" "></TD> 
			<TD><A HREF="misreport.php">New Report</A></TD> 
			<TD><IMG SRC="../images/blank.gif" WIDTH="100" HEIGHT="1" BORDER="0"
			  ALT=" "></TD> 
			<TD><A HREF="#top">Top of Page</A></TD> 
		 </TR> 
	  </TBODY> 
	</TABLE><%
  }

 

Link to comment
https://forums.phpfreaks.com/topic/132201-how-to-hide-a-page-in-php/
Share on other sites

One thing you can look at is cookies. You can set cookies to expire in 20 minutes, days or never. This way if you close your browser and you come back you are still logged in, not very secure but definitely an option you have. I usually set cookies to expire within an hour or the day then require the user to login after that time has passed.

/agree

 

At least hash it, then check the hash when it comes back.

 

<?php
if ( (isset($_COOKIE['TestCookie'])) AND ($_COOKIE['TestCookie'] === md5('password') ) )  {
  //show secret stuff here
  }
else if ( (isset($_POST['password'])) AND ($_POST['password'] === "password") )  {
  setcookie("TestCookie", md5($_POST['password']), time()+3600);  //1 hour
  //show secret stuff here too
  }
else  {
  //login form
  }

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.