Login script (probably a simple error)
Posted on
16th Feb 2014 07:03 pm by
admin
dbConfig.php
Code: <?
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "username";
$pass = "password";
$db = "annarbo1_Archives";
// This part sets up the connection to the
// database (so you don't need to reopen the connection
// again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.n";
}
// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>
login.php
Code: <?php
// dBase file
include "dbConfig.php";
session_start();
if ($_GET["op"] == "login")
{
if (!$_POST["username"] || !$_POST["password"])
{
die("You need to provide a username and password.");
}
// Create query
$q = "SELECT * FROM `people` "
."WHERE `username`='".$_POST["username"]."' "
."AND `password`=PASSWORD('".$_POST["password"]."') "
."LIMIT 1";
// Run query
$r = mysql_query($q);
if ( $obj = @mysql_fetch_object($r) )
{
// Login good, create session variables
$_SESSION["valid_user"] = $_POST["username"];
// Redirect to member page
Header("Location: index.php");
}
else
{
// Login not successful
die("Sorry, could not log you in. Wrong login information.");
}
}
?>
when I run this online i get this error:
"Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home4/annarbo1/public_html/login.php:2) in /home4/annarbo1/public_html/login.php on line 4"
I have yet to figure out what's wrong
No comments posted yet
Your Answer:
Login to answer
115
28
Other forums
PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw
chat
hello i'm amir
i need a chat source code in asp.net 2.0 without Ajax.
anybody can help me?
array & querys help/advice.
Ok so here goes , I have a mysql database and basically here's what I need to do.
// foreach
C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr
Display search result
Hi!
I have a SQL database with information about albums and track (music).
This is wh
How to add advertisment on top of videos
Hello,
I was told that i should find the answer for this problem in this forums.
I searched a
dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but i
NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '
Parse XML
Good day,
I use oempro software and try to parse XMLReturn but it's not working for me, simpl
PHP Upload issue
Hi guys,
I have stumble across an interesting issue with my script and is doing my head in.