[php]problem

08/11/2014 23:42 mohamad512#1

[CENTER]Hello first and foremost! I want to apologize from the member Thndr on dispositive improper in the previous topic.

Now enter the objective:

I have modified a registration page that I received From a Friend !

But no matter how I tried to stay error "Failed to verify is the provided user named already exists." Shows

Now, with CODE: I wish news what's wrong!

Fixed BY Using :

PHP Code:


			
INSERT INTO [Auth].[dbo].[Account] ( account_id,account,password,email,pk_ ,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2 ) VALUES('','$username','$converted_password','$email','1','NULL','NULL','NULL','NULL','NULL','com.elixir.billing.impl.ImmAccount','NULL','$password2')

Thanks !!

08/12/2014 03:35 ThunderNikk#2

There is a help thread for questions like these...

[Only registered and activated users can see links. Click Here To Register...]

That being said...next time please use it.

Are you sure your account table is really named dbo.accounts because mine is dbo.account

You would need to change the PHP to match.

08/12/2014 03:58 mohamad512#3

Thanks man

Lol xD o_o

dbo.account(s) because mine is dbo.account

-------------------

I try put the same error

I update the topic

08/12/2014 10:30 Musta�#4

Hello,

First of all, you'll need to verify your connection string, make sure everything matches, and if it contains special characters, use '\' before it. (e.g.: $password = "p@ssw0rd!@#\'", the result password: P@ssw-rd!@#'.

Secondly, verify that the columns specified in the SQL commands and the table names match your database version, because the database that has the accounts table named 'dbo.Account' is Auth v2, and it uses 'username' instead of 'login_name'.

It'll be better if you provided more information for us, otherwise we'll keep mentioning frequent problems.

08/12/2014 15:09 sunnyxie49#5

Quote:

Originally Posted by mohamad512

PHP Code:

$result = @odbc_exec($conn,"SELECT login_name FROM Account WHERE login_name = '$username'") or die('Failed to verify is the provided user named already exists.');

PHP Code:


			
$server = "192.168.1.104";
$user =  "sa";
$password= "";
$database = "Auth";
$conn = odbc_connect("Driver={SQL Server Native Client 11.0};Server=$server;Database=$database;", $user, $password);
$result = odbc_exec($conn,"SELECT login_name FROM Account WHERE login_name = '$username'");
$checked_id = odbc_fetch_row($result);
if( ($checked_id) == ("1") ) 
{
    echo "Failed to verify is the provided user named already exists.";
}
else 
{
}

try

08/12/2014 15:47 mohamad512#6

I 'll try ! every thing u gays said

I update the topic with new code that i wanna now if it right !!

I think Accounts wrong ?!

if any one expert in that !

plz give me your skype !!

and i'm gonna send the script yo u to see it

second [php] then the first !! ^^

what about this !