note 42452 rejected from function.mssql-execute by nlopess
| From: | nlopess@php.net | Date: | Mon, 17 May 2004 13:10:43 +0000 |
| Subject: | note 42452 rejected from function.mssql-execute by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-69712@lists.php.net to get a copy of this message | ||
Note Submitter: edouard.etienne@voila.fr
----
hello
i will want a exemple with mssql_execute
i have a php script to create a user on sql serveur 2000
and i can create a use on sql serveur 2000 so i can't use this sql count on query analyseur
it's the php script to create sql count
<?
$login=$_POST['login'];
$pass=$_POST['password'];
$table=$_POST['table'];
$droit=$_POST['privilége'];
$attribut=$_POST['attribut'];
mssql_connect( "eddysrv", "sa", "123");
mssql_select_db(config);
$resultat = mssql_query ("insert into compteuser (loginuser,password,attribut) values
('$login','$pass','$attribut')");
mssql_connect( "eddysrv", "sa", "123");
mssql_select_db(config);
$test= mssql_execute ("sp_addlogin '$login ','$pass
','config'");
mssql_connect("eddysrv","sa","123");
mssql_select_db(config);
$resultat = mssql_query ("sp_adduser
'$login','$login','db_owner'");
mssql_connect("eddysrv","sa","123");
mssql_select_db(config);
$resultat = mssql_query("sp_addsrvrolemember '$login','sysadmin '");
mssql_connect("eddysrv","sa","123");
mssql_select_db(config);
$resultat = mssql_query ("grant select on utilisateur to $login");
echo'les informations sont bien enregistrer ';
?>
thank you for the person who help me
eddy