[download files for login tutorial]

I would need to double check, but I think that this line:

 

$mysqli->("SELECT password FROM members WHERE id = ?")

 

should be:

 

$mysqli->query("SELECT password FROM members WHERE id = ?")

 

...or something similar -- I can't remember the syntax off the top of my head. Double check my video.

 

EDIT: Just sent you the files.

 

 

OK, Thanks

 

even though it is not in your video, adding the 'query' to the statement fixed it... Thank You!

 

Have a great weekend.. Leonard

[download files for login tutorial]

Oh, sorry. I'm not super familiar with those packages -- Stefan handles that side of things. Can you PM me your email address, and I'll send you a link to the files?

 

I'll have to talk to Stefan about giving a place for people who download one of the "Complete" courses to find the source files. Sorry about that!

 

 

OK ... My Email is lgabrielse@verizon.net

 

Also, I am going crazy trying to find an error ... You will probably see it right away...

 

 

Do you see it on line 76 below, i.e. if ($check = $mysqli->("SELECT password FROM members WHERE id = ?"))

 

Parse error: syntax error, unexpected '(', expecting T_STRING or T_VARIABLE or '{' or '$' in C:\Inetpub\wwwroot\phproot\LoginKiller\change_password.php on line 76

 

Here is the code:

 

<?php

/*

* REGISTER.php

* Register New members

*/

 

//start session / load configs

session_start();

include('includes/config.php');

include('includes/db.php');

 

// check that the user is loggeed in

if(!isset($_SESSION['username']))

{

header("location: login.php");

}

 

// check for inactivity

if (time() > $_SESSION['last_active'] + $config['session_timeout'])

{

// log out user

session_destroy();

header("Location: login.php?timeout");

}

else

{

$_SESSION['last_active'] = time();

}

 

//form defaults

$error['alert'] = '';

$error['current_pass'] = '';

$error['pass'] = '';

$error['pass2'] = '';

$input['current_pass'] = '';

$input['pass'] = '';

$input['pass2'] = '';

 

if (isset($_POST['submit']))

{

// process form

if ($_POST['current_pass'] == '' || $_POST['password'] == '' || $_POST['password2'] == '')

{

// all fields need to be filled in

if ($_POST['current_pass'] == '') {$error['current_pass'] = 'required!';}

if ($_POST['password'] == '') {$error['pass'] = 'required!';}

if ($_POST['password2'] == '') {$error['pass2'] = 'required!';}

$error['alert'] = 'Please fill in the required fields!';

 

$input['current_pass'] = htmlentities($_POST['current_pass'], ENT_QUOTES);

$input['pass'] = htmlentities($_POST['password'], ENT_QUOTES);

$input['pass2'] = htmlentities($_POST['password2'], ENT_QUOTES);

// show form

include('views/v_password.php');

}

elseif ($_POST['password'] != $_POST['password2'])

{

// both password fields need to match

$error['alert'] = 'Password fields must match!';

 

$input['current_pass'] = htmlentities($_POST['current_pass'], ENT_QUOTES);

$input['pass'] = htmlentities($_POST['password'], ENT_QUOTES);

$input['pass2'] = htmlentities($_POST['password2'], ENT_QUOTES);

 

//show form

include('views/v_password.php');

 

}

else

{

// get data from form

$input['current_pass'] = $_POST['current_pass'];

$input['pass'] = $_POST['password'];

$input['pass2'] = $_POST['password2'];

 

if ($check = $mysqli->("SELECT password FROM members WHERE id = ?"))

{

$check->bind_param("s", $_SESSION['id']);

$check->execute();

$check->bind_result($current_pass);

$check->fetch();

$check->close();

}

if (md5($input['current_pass'] . $config['salt']) != $current_pass)

{

// error

$error['alert'] = "Your current password is incorrect!";

$error['current_pass'] = "incorrect";

include('views/v_password.php');

}

else

{

//update database

if ($stmt = $mysqli->prepare("UPDATE members SET password = ? where ID = ?"))

 

$stmt->bind_param("ss", md5($input['current_pass'] . $config['salt']), $_SESSION['id']);

$stmt->execute();

$stmt->close();

 

$error['alert'] = 'Member added successfully!';

//clear varaibles

$input['current_pass'] = '';

$input['pass'] = '';

$input['pass2'] = '';

include('views/v_password.php');

 

}

else

{

echo "ERROR: Could not prepare MYSQLi statement.";

}

}

}

else

{

 

include('views/v_password.php');

}

 

 

// close db connection

$mysqli->close();

 

?>

[download files for login tutorial]

Welcome to the forum, and I hope you are finding the videos useful.

 

This assumes you are a member of the KillerSites university... You can download the files by going to http://killersites.com/university/, logging in, and looking at the downloads within the PHP > PHP Login section.

 

I purchased the CompletePHP Programmer and downloaded it yesterday. I did 1-7 and now you give instruction to download.

Are you saying I need to pay for a subscription too now??

[download files for login tutorial]

Where do I find the site to download the files for Login part 8. Ben rapidly says 'from killersites university', but i cannot find this. Help