Linux, Apache, MySQL, PHP

Re: login page is not working

11-Dec-11 22:04

I have an admin page which user MUST enter user id and password to get in. The login.php is working fine, it's accepting correct user id and password and rejecting incorrect user id or password but the admin index.pho is not working properly..! it's accepting direct navigation even and not redirecting to the login.php

could you please help..

here is my index.php

PHP

<?php
     if (isset($_SESSION["status"]) && $_SESSION["status"] != true)
     {
        header('Location:login.php');
     }
?>

and this is my login.php:

PHP

<?php
    session_start();

    error_reporting(E_ALL);

    $username = $_POST['username'];
    $password = $_POST['password'];

    $conn = mysql_connect('mysql.jassimrahma.com', 'jassimxxx', 'xxxxxxx');
    $sql = "SELECT * FROM website_admin WHERE website_admin_user_name = '$username' and website_admin_password = '$password'";
    mysql_select_db("jassimrahma", $conn) or die(mysql_error());
    $result = mysql_query($sql, $conn) or die(mysql_error());
    $count = mysql_num_rows($result);

    if($count == 1)
    {
        // session_regenerate_id();
        $db_field = mysql_fetch_assoc($result);
        $_SESSION['status'] = true;
        $_SESSION['full_name'] = $db_field['website_admin_full_name'];
        header("location:index.php");
    }
    else
    {
        header("location:login.php");
    }
?>

modified 12-Dec-11 4:35am.

Graham Breach11-Dec-11 22:25

Re: login page is not working

11-Dec-11 22:25

Your index page is checking if the session variable status has been set, and then redirecting only if it has been set to false (or anything except true to be precise).

If that is the whole of your index.php file then the status will never be true, because you haven't called session_start().

More importantly, $_SESSION["status"] will not be set even if you have been through the login page, so it won't even get to the $_SESSION["status"] != true condition.

If you had not successfully gone through the login page, status would not be set even if you had started the session.

Jassim Rahma11-Dec-11 22:40

Re: login page is not working

11-Dec-11 22:40

More importantly, $_SESSION["status"] will not be set even if you have been through the login page, so it won't even get to the $_SESSION["status"] != true condition.

why?

so let me see if I understood..

I changed to this but still the same result:

PHP

<?php
	session_start();
	
	if (isset($_SESSION["status"]) && $_SESSION["status"] != true)
	{
		header('Location:login.php');
	}
?>

Graham Breach12-Dec-11 0:09

Is there Dictionary Object in PHP

12-Dec-11 0:09

You are setting the status to true if the user logs in successfully.

If the user does not log in, then $_SESSION['status'] is not being set to anything.

You should redirect to the login page whenever $_SESSION['status'] is not set - and unless you have a page somewhere else that sets it to anything other than true, you don't even need to check what its value is.

awedaonline11-Dec-11 7:49

Re: Is there Dictionary Object in PHP

11-Dec-11 7:49

Hi guys;

I wish to store KeyValuePair collection as I do in C# or VB.NET. Is there a way to achieve this in PHP and how?

Thanks for your cordial supports.

Graham Breach11-Dec-11 8:28

Re: Is there Dictionary Object in PHP

11-Dec-11 8:28

You can do that using an array:

<?php
$dict = array('a' => 1, 'b' => 2, 'z' => 0);
$dict['c'] = 5;
$dict['a more complex value'] = array('X' => 'OK');

foreach($dict as $key => $value)
  echo "$key : $value<br />\n";

awedaonline11-Dec-11 10:57

11-Dec-11 10:57

Thanks Graham.

Your solution works.

Thanks.

date format problem

Jassim Rahma10-Dec-11 21:40

10-Dec-11 21:40

I have this date in mysql datetime field:

2011-12-10 18:27:51

I am using this code in php to display it:

PHP

$created_date = mysql_result($result, $i ,"created_date");
		
echo date("d/m/Y", $created_date);

but the result is wrong! here is the result:

31/12/1969

how can I fix it please?

Re: date format problem

Graham Breach10-Dec-11 23:09

10-Dec-11 23:09

If a function doesn't do what you expect it to, you should go back and read the manual. The second argument to the date function should be an integer timestamp, but you are giving it a string.

You can get an integer timestamp from your string using the strtotime function[^].

Re: date format problem

awedaonline11-Dec-11 7:57

page not showing in full height

11-Dec-11 7:57

Have you tried

<?php echo date_format($date, 'd-m-Y H:i:s'); ?>

Re: date format problem

cjoki12-Dec-11 6:40

cjoki

12-Dec-11 6:40

2nd arguement requires a unix timestamp. Take a look at date() and mktime() functions in the manual.

If your dat coming from the db is a datetime stamp you may want to use strtotime() to convert it into the unix timestamp needed for the 2nd date arg.

Chris J
www.redash.org

Jassim Rahma10-Dec-11 3:46

Re: page not showing in full height

10-Dec-11 3:46

I am using an iframe with 100% table and td as well as iframe but the ifarame is still not going into full height..

here is my code:

!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-us">
<head>
	<title>Jassim Rahma</title>
	<?php include("tags.php"); ?>
	<meta name="description" content="Where technology meets business intelligence." />
</head>
<body dir="ltr" lang="en-us">
<table width="100%" cellpadding="0" cellspacing="0" height="100%">
	<tr><td colspan="3" style="border-bottom-color: #D3D3D3; border-bottom-style:solid;; border-bottom-width: thin"><?php include("header.php"); ?></td></tr>
	<tr>
		<td valign="top" style="padding: 10px" height="100%">
			<iframe src="http://www.boutell.com/newfaq/creating/include.html" style="border:0px #FFFFFF none;" name="headline" scrolling="no" frameborder="0" marginheight="0px" marginwidth="0px" height="100%" width="100%"></iframe>            
		</td>
	</tr>
</table>

<?php include("Piwik.php"); ?>

</body>
</html>

cjoki12-Dec-11 6:42

cjoki

12-Dec-11 6:42

does the include file Piwik.php have any output?

try hiding it and see if you issue persist.

Chris J
www.redash.org

Re: page not showing in full height

Danny Martin5-Jan-12 2:48

Danny Martin

5-Jan-12 2:48

This is not a PHP problem, it's a CSS style issue. Try setting the height of the and tags to 100% and 'absolutely' position the outer table (or better still, replace it with a div)

That should solve the problem...

Danny

include question

Jassim Rahma10-Dec-11 3:35

10-Dec-11 3:35

I am trying to use include to place a web page from another webiste on my website using this code but I am just getting it blank! how can I fix this please..

XML

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-us">
<head>
    <title>Jassim Rahma</title>
    <?php include("tags.php"); ?>
    <meta name="description" content="Where technology meets business intelligence." />
</head>
<body dir="ltr" lang="en-us">
<table width="100%" cellpadding="0" cellspacing="0">
    <tr><td colspan="3" style="border-bottom-color: #D3D3D3; border-bottom-style:solid;; border-bottom-width: thin"><?php include("header.php"); ?></td></tr>
    <tr>
        <td valign="top" style="padding: 10px">
            <?php include("http://www.boutell.com/newfaq/creating/include.html"); ?>
        </td>
    </tr>
</table>

<?php include("Piwik.php"); ?>

</body>
</html>

awedaonline11-Dec-11 7:52

11-Dec-11 7:52

This is how I do this within my site but have not tried the remote side of it.

include_once $_SERVER['DOCUMENT_ROOT'] . 'aweklin/classes/StringHelper.php';

Gerben Jongerius11-Dec-11 19:34

Gerben Jongerius

11-Dec-11 19:34

You can't do a cross server include like that. PHP include directive only works with files on the same webserver. The way I see it you have two options to solve this:

* put the file on the same server and use normal include directives
* use the file_get_contents or an iframe to load the external resource

Jassim Rahma11-Dec-11 21:44

11-Dec-11 21:44

I used file_get_conetnts and it's working fine except with some links but I don't know why..

if you check www.JassimRahma.com[^] you'll see all links are working perfectly under my domain but getting external page excet:

http://www.jassimrahma.com/16[^]

and:

http://www.jassimrahma.com/17[^]

both from http://www.telegraph.co.uk/[^]

what could be the reason?