how to conect the reg page to sql server 2011

[gaby001]

ok so now i have some eroor with my reg page
is no error from mysql but i sommfing what i ned to do in php any one know where i ned to
EDIT View image: Untitled

ok so now i have some eroor with my reg page
is no error from mysql but i sommfing what i ned to do in php any one know where i ned to
EDIT View image: Untitled

[MentaL]

[DragonLord]

1. English?
2. Connect to it via what, air?

[Selfrot]

If it's your own Launcher - make it so that the launcher search in yourdatabase@yourdomain : youruser;yourpass.

If it's a custom launcher - search for a config file and enter your details there.


It's a little hard to guess exactly what you want here, since in the Thread title you're telling us that you need it for a Registration page, and in the thread body you tell us it's a launcher - can't do much more for ya.

[Kasistar]

1. English?
2. Connect to it via what, air?

[gaby001]

sry abouth thta but i 2 question in the treat 1 is what i ned to do to conect the reg page to sql 2012 to atum2_db _account to create new loghinn in bicouse i make manual the new account in' "ti_account" so i ned to rezolve that
and2 how to add that web page i have in "launcher .atm "

is hard bicouse i never do that in rest al is ok
1 ODBC=OK
2SQL serv 2012= ok
3 client =OK
so that i asck
dragon lord if u know why do you not share or realy maibe u make a tutorial how to do this ty

:PS: sry about my English i was not born in us or UK im in RO and i learn Litle englis

[sami37]

Hi,

You need to create a php script for your launcher with 2/3 input :

Account Name
Password
Email
And a validate buttom

It's really simple when you know php/html

Good Luck.
Pm me if you don't understand.

[St0rmy95]

Are you using the register script from ragezone?

[NomCake]

Are you using the register script from ragezone?

Unless you use an old version of Apache or XAMPP, you'll be better off changing the functions to the old registration or even creating your own. MSSQL Driver is discontinued now and the best one to use for SQL connections with MSSQL2012 or so on would be through sqlsrv:

PHP: SQLSRV - Manual

Good luck.

[DragonLord]

Or you could try ASP.NET, since most of you here seem to like VB.NET so much.

[gaby001]

ok now i undestend ty i go whach some tutorial and i wil rezolve

[Kasistar]

whatever.... good luck

[inetpub]

For example:

<?php

if(!function_exists('mssql_connect')){
	echo 'You must have the php_mssql library for Apache installed and enabled to connect to an MSSQL database.  Uncomment the line that says extension=php_mssql.dll in your php.ini (XAMPP/WAMP only).  This requires a restart of the Apache service to take effect.'; die();
}
// Database configuration 
$db_host = ''; //host
$db_user = ''; //user
$db_pass = ''; //pass


$conn = @mssql_connect($db_host,$db_user,$db_pass) or die('Error! Please contact me, thanks!');
$db = @mssql_select_db('atum2_db_account',$conn) or die('Error! Please contact me, thanks!^^');
?>

its only connect script, all mssql query's do yourself

[St0rmy95]

Yes and then write a register script like this:

INSERT INTO atum2_db_account.dbo.td_Account (AccountUniqueNumber, AccountName, Password) VALUES ('$n', '$userid', '$passMd5')

[inetpub]

Or change a AccountUniqueNumber column (set 'Is Identity' and primary key) , then you can do smth like that:

//query string
$qry123 = "INSERT INTO [atum2_db_account].[dbo].[td_Account](AccountName, Password) VALUES ('$username','$password',)";
$result123 = mssql_query($qry123); //execute query

+ some simple check data (no double accname for ex) and simple form

<?php

if(!function_exists('mssql_connect')){
	echo 'You must have the php_mssql library for Apache installed and enabled to connect to an MSSQL database.  Uncomment the line that says extension=php_mssql.dll in your php.ini (XAMPP/WAMP only).  This requires a restart of the Apache service to take effect.'; die();
}
// Database configuration 
$db_host = ''; //host
$db_user = ''; //user
$db_pass = ''; //pass


$conn = @mssql_connect($db_host,$db_user,$db_pass) or die('Error! Please contact me, thanks!');
$db = @mssql_select_db('atum2_db_account',$conn) or die('Error! Please contact me, thanks!^^');

$err_string = array();

if(isset($_POST) && !empty($_POST)){
$username = $_POST["user"];
$password = $_POST["pass"];
$result = @mssql_query("SELECT AccountName FROM atum2_db_account.dbo.td_Account WHERE AccountName = '$username'") or die('Error! Please contact me, thanks!');
if(mssql_num_rows($result)){
		$err_string[] = 'Username Allready exist.';
	}

if(count($err_string) == 0){
$qry123 = "INSERT INTO [atum2_db_account].[dbo].[td_Account](AccountName, Password) VALUES ('$username','$password',)";
$result123 = mssql_query($qry123); //execute query
}
}
?>
//show error
<?php if(count($err_string)){ ?>
<?php foreach($err_string as $err_string){ ?>
<?php echo $err_string; ?>
<?php } ?>
<?php } ?>

<form action="#" method="post">
<input type="text" name="user" />
<div style="height: 5px;">&nbsp;</div>
<input type="password" name="pass" />
<div style="height: 5px;">&nbsp;</div>
<input type="submit" id="submit" value="Register"/>
</form>

its for example ofc.

[gaby001]

i ghyve up i cant conect the reg page to mySQL i tri all u post but stil cant make this any one have a totorial i go to my slq home pahe i read stil can make this so if u have a tutorial ... question i ned to make a conexion with ODBC ?
like how i make in global. cfg like My sql_dns ????? conect with user and pass ????