Dreamweaver Club Forums

Dreamweaver Club Forums (http://www.dreamweaverclub.com/forum//index.php)
-   Video Tutorials (http://www.dreamweaverclub.com/forum//forumdisplay.php?f=180)
-   -   Login Help (http://www.dreamweaverclub.com/forum//showthread.php?t=37320)

chris_burns7186 09-10-2010 12:01 PM

Login Help
I'm completing the video tutorial for the php log in script and I'm having trouble getting it to work. It keeps returning that my user/password are wrong even though I have checked these. can anyone help?

PHP Code:


$database "db";
$username "user";
$password "password";

// Choose Connection
$link = @mysql_connect($database ,$username$password);
$db   =mysql_select_db($database$link);

//catch field data
$userid    =  $_POST['userid'];
$password  =  $_POST['password'];
$submitted =  $_POST['submitted'];

if (
$userid && $password) {
$query     sprintf("SELECT * FROM users WHERE user_name = '$userid' AND user_password = '$password'");
$result     =@mysql_query($query);
$rowAccount =@mysql_fetch_array($result);

$rowAccount) {

<!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">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<form name="form1"  id="form1" method="post" action="<?php $_SERVER['PHP_SELF'];?>">
<table width="259" height="272" border="1" align="center">
    <td width="82" height="45">Username</td>
    <td width="161" ><input name="userid" type="text" id="userid" /></td>
    <td width="82" height="45">Password</td>
      <input name="password" type="text"  id="password" />
     <input name="Submit" type="submit" value="Submit"/>
      <input name="submitted" type="hidden" id="submitted" value="1" />

davidj 09-13-2010 05:18 PM

check your database table field naming conventions

krzy 10-23-2013 07:17 PM

user and user_name aren't the same :razz:

global2017 11-02-2017 07:28 AM

artikel bagus

edbr 11-03-2017 01:35 AM

Tidak Bagus. No not good. 7 year old post and mysql is depreciated so pretty useless now

All times are GMT. The time now is 06:35 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com