stos

add

<?php

/*

    

  ：u=   

v=   

         

*/



header("Content-Type:text/html; charset=utf-8");

$server ="(local)";  //   IP  ,     ，    localhost

$uid ="sa";  //   

$pwd ="123456"; //  

$database ="AAA";  //ms     

$conn =mssql_connect($server,$uid,$pwd) or die ("connect failed");

mssql_select_db($database,$conn);





//  my     

$con = mysql_connect("localhost","root","root");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_query("set names utf8");//ut8  

mysql_select_db("openfire", $con);//  my     



//get  

$u=$_GET['u'];

$v=$_GET['v'];



//  my             

$my = mysql_query("SELECT * FROM ofgroupuser");

while($myrow = mysql_fetch_array($my))

  {

print_r ($myrow);

echo "<br>";

  }



echo "<br>";

echo "<br>";

echo "<br>";



//  my          

$hang=$result = mysql_query("SELECT * FROM ofgroupuser WHERE username LIKE '".$u."' ");



// ms     my    get 

while($row = mysql_fetch_array($hang))

  {

$query123 ="INSERT INTO guanlian (uer,goup,visty) VALUES (N'".$row['username']."',N'".$row['groupName']."','".$v."')";

$haha=mssql_query($query123);

  }



//  ms  

$query ="select * from guanlian";

$row =mssql_query($query);

while($list=mssql_fetch_array($row))

{

       print_r($list);

       echo "<br>";

}

?>

del

<?php

/*

    

id ms  id

id=id 

u=   

  id        

                

v=   

                

*/



header("Content-Type:text/html; charset=utf-8");

$server ="(local)";  //   IP  ,     ，    localhost

$uid ="sa";  //   

$pwd ="123456"; //  

$database ="AAA";  //ms     

$conn =mssql_connect($server,$uid,$pwd) or die ("connect failed");

mssql_select_db($database,$conn);



//get  

$id=$_GET['id'];

$u=$_GET['u'];

$v=$_GET['v'];



//  id  

$iddel = "DELETE FROM guanlian WHERE id = ".$id."";

@mssql_query($iddel);

$udel = "DELETE FROM guanlian WHERE uer = '".$u."'";

@mssql_query($udel);

$vdel = "DELETE FROM guanlian WHERE visty = '".$v."'";

@mssql_query($vdel);



print_r ($v);

echo "<br>";

print_r ($vdel);

echo "<br>";



//  ms  

$query ="select * from guanlian";

$row =mssql_query($query);

while($list=mssql_fetch_array($row))

{

       print_r($list);

       echo "<br>";

}

?>

select

<?php

/*

    

  ：g=          

v=    

           

msu=ms       

  msu  my    ，       ，   ms    

*/

header("Content-Type:text/html; charset=utf-8");

$server ="(local)";  //   IP  ,     ，    localhost

$uid ="sa";  //   

$pwd ="123456"; //  

$database ="AAA";  //ms     

$conn =mssql_connect($server,$uid,$pwd) or die ("connect failed");

mssql_select_db($database,$conn);



//  my     

$con = mysql_connect("localhost","root","root");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_query("set names utf8");//ut8  

mysql_select_db("openfire", $con);//  my     



//  my             

$my = mysql_query("SELECT * FROM ofgroupuser");

while($myrow = mysql_fetch_array($my))

  {

print_r ($myrow);

echo "<br>";

  }



echo "<br>";

echo "<br>";



//get  

$g=$_GET['g'];

$v=$_GET['v'];

$msu=$_GET['msu'];



/*     ms       ，       my          

  ms            ，        my   ，     

           ms      

       ，           

*/



$msmy = mysql_query("SELECT username FROM ofgroupuser where username = '".$msu."'");

@$eq = mysql_fetch_array($msmy);//              name

if(!empty($eq['username']))

{  

    echo "   ";

    }else{  

        $udel = "DELETE FROM guanlian WHERE uer = '".$msu."'";

@mssql_query($udel);

        }











/*     、      */

$s ="select uer from guanlian";//         

@$ss =mssql_query($s);//       ms   

while($go=@mssql_fetch_array($ss))//       

{

$sql="SELECT username FROM ofgroupuser where username = '".$go['uer']."'";//            my       

$msmy = mysql_query($sql);//       my   

while($mysql = @mysql_fetch_array($msmy))//     my    ，    ，     my ms   

  {

$ok="DELETE FROM guanlian WHERE uer <> '".$go['uer']."'";//  ms  my      

@mssql_query($ok);// ms       

  }

}

/*     、      */











//  ms  ，        

$sql ="select * from guanlian where visty= '".$v."' and goup='".$g."' ";

@$mssql =mssql_query($sql);

while($display=@mssql_fetch_array($mssql))

{

    print_r ($sql);

       print_r($display);

       echo "<br>";

}



echo "<br>";

echo "<br>";



//  ms  ，        

$query ="select * from guanlian";

$row =mssql_query($query);

while($list=mssql_fetch_array($row))

{

       print_r($list);

       echo "<br>";

}

?>