Register Page Database Connection Error

[brunalima]

i did followed the tutorial and the message at the top continue appearing with issues !!!

[Desponia]

the correct data entered in the php?

[brunalima]

yes so it wont connect idk why

[Amanecer]

Maybe the inserted data doesn't match your table? There are probably some required columns that aren't being filled. Check the code or screenshot the INSERT statement in the source + your Account table (richt click > Design).

[brunalima]

here



i did changed system and register page if its works ! and anything works

[Amanecer]

I see you're using the Register I released. It's currently missing the sUserIP column so replace:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW) VALUES (?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);

with:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW, sUserIP) VALUES (?, ?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);
$sth->bindValue(3, $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);

[brunalima]

what file from the folders i need to edit ????
i did not found the file to edit with these config above !

 Spoiler

<?php

$ip = $_SERVER["REMOTE_ADDR"];

include_once('settings.php');
include_once('functions.php');

$conn = sqlsrv_connect( $serverName, $connectionInfo);

if(!$conn ) {
die( print_r( sqlsrv_errors(), true));
}

$_POST['status'] = "NULL";
$_POST['type'] = "fail";

$user = @_clean($_POST['user']);
$pass = @_clean($_POST['pass']);

$userLength = strlen($user);
$passLength = strlen($pass);



if (($userLength < 5) || ($userLength > 20))
{
$_POST['status'] = "Username entered is too short or too long.";
return;
}

if (($passLength < 5) || ($passLength > 32))
{
$_POST['status'] = "Password entered is too short or too long.";
return;
}

if ($_POST["pass"] != $_POST["passconfirm"]) {
$_POST['status'] = "Password's don't match.";
return;
}


$checkAccount = "SELECT sUserID FROM tUser WHERE sUserID = '$user'";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $checkAccount , $params, $options );
$row_count = sqlsrv_num_rows( $stmt );


if ($row_count > 0) {
$_POST['status'] = "Username is taken.";
return;
}


$maxID = "SELECT MAX(nUserNo) FROM tUser";
$executeID = sqlsrv_query($conn, $maxID);
$row = @srv_fetch_array($executeID, SQLSRV_FETCH_NUMERIC);
$currentID = $row[0];
$newID = ++$currentID;


if ($_POST['status'] == "Query failed")
return;


$insertAccount = sqlsrv_query($conn, "INSERT tUser (sUserID, sUserPW, sUserName, nAuthID, sUserIP) VALUES ('$user', '$pass', '$user', 1, '$ip')");


if($insertAccount) {
$_POST['type'] = "success";
$_POST['status'] = "Account has been created successfully.";
} else {
$_POST['type'] = "fail";
$_POST['status'] = "Account creation has failed.";
die( print_r( sqlsrv_errors(), true));
}


sqlsrv_close($conn);
?>

that i need to edit?

[Amanecer]

It should be index. Could you post full source so I can further assist you?

[brunalima]

i will send you the private message
Check if the message has been sent for you!

if you do not receive the message here the link with the file



the key i will send for u

[Amanecer]

The link you've sent isn't the same Register as the screenshot in the first post? Please check htdocs/www and upload again!

[brunalima]

i did sent for you again i guess its correctly!!

[Amanecer]

Originally Posted by Amanecer

I see you're using the Register I released. It's currently missing the sUserIP column so replace:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW) VALUES (?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);

with:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW, sUserIP) VALUES (?, ?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);
$sth->bindValue(3, $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);

Now you just have to do it as I previously said here. And of course define the Database in config.php (or index.php if you're using the single file version).

[brunalima]

i did so continues with database error

[Amanecer]

Change

$error = 'Database connect error!';

to

$error = $e->getMessage;

Try again and send the output.

[brunalima]

i guess its new error

and the password from the Account uses Md5 hash and do not normal password !!