# CMS Login "problem"

**URL:** <https://forum.kirupa.com/t/cms-login-problem/193030>\
**Category:** programming\
**Created:** [July 3, 2006, 7:24pm UTC](https://forum.kirupa.com/t/cms-login-problem/193030 "2006-07-03T19:24:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cokelatdesign](https://avatars.discourse-cdn.com/v4/letter/c/7c8e57/32.png) [@cokelatdesign](https://forum.kirupa.com/u/cokelatdesign)\
**Post date:** [July 3, 2006, 7:24pm UTC](https://forum.kirupa.com/t/cms-login-problem/193030/1 "2006-07-03T19:24:07Z")

</div>

Hi,  
I’ve created cms with login page everything was all right when I test it in Apache but after I upload everything to my server for some unknown reason it won’t let me to log in

here are the page

Login Page

\<html\>  
\<head\>  
\<title\>CCC [Login]\</title\>  
\<style type = “text/css”\>@import url(c/tips.css);\</style\>  
\</head\>  
\<body\>  
\<?php  
if(@$\_SESSION[‘auth’] == 0){  
echo ‘\<form action = “login.php” method = “post”\>’;  
echo ‘username: \<input type = “text” name = “n” size = “15” /\>’;  
echo ‘password: \<input type = “password” name = “p” size = “15” /\>’;  
echo ‘\<input type = “submit” value=“login” /\>\</form\>’;  
}else{  
echo ‘::’. $\_SESSION[‘name’] . ‘:: \<a href=“logout.php”\>Logout\</a\>’;  
}

?\>  
\</body\>  
\</html\>

Login Function

\<?php  
include\_once(‘lib/db\_fns.php’);  
$name = $\_POST[‘n’];  
//echo $name;  
$pass = $\_POST[‘p’];  
//echo $pass;

```
$conn = dbConnect();
$sql = "SELECT * FROM users WHERE name = '$name' AND password = PASSWORD('$pass')";
//echo $sql;
$result = mysql_query($sql);
//echo $result;
if(!$result || mysql_num_rows($result)&lt;1){
    echo "Please try again";
    exit;
}
    
$row = mysql_fetch_array($result);

session_start();
$_SESSION['auth']=$row['permissions'];
//echo $_SESSION['auth']=$row['permissions'];
$_SESSION['name']=$row['name'];
echo $_SESSION['name']=$row['name'];
$_SESSION['id']=$row['id'];
//echo $_SESSION['id']=$row['id'];
$_SESSION['id']=$row['id'];
//echo $_SESSION['id']=$row['id'];
header('location:tips.php');

```

?\>

Database Function Page

\<?php

function dbConnect()  
{  
$results = @mysql\_connect(‘dbname’, ‘username’, ‘password’);  
if (!$results)  
return false;  
if (!@mysql\_select\_db(‘CCC’))  
return false;  
return $results;  
}

?\>

Session start Page

\<?php

```
session_start();

function guard($level=1){
    if(@$_SESSION['auth'] &lt;$level){//not logged in
        header('location:login_page.php');
        exit;
    }
}

```

?\>

if anyone ever have the same problem as me please tell me how you solve it cos I’ve tried everything but it still doesn’t work