C # webcoder tüm hashtable geçmek

0 Cevap

I'm trying to pass a entire hashtable to a php webservice. How can I accomplish this? I tried string[] but that does not work so tried something else and this is what I have currently:

  thrkeys = hshTable.Keys;

            uploadattempt.retrievesdl ws = new uploadattempt.retrievesdl();
                    foreach (object Key in thrkeys)
                    {
                        string final = Key.ToString() + ": Full Name";
                        ws.upload(final);
                    }

Ve aşağıdaki kodu php webservice için:

<?
//call library
require_once ('lib/nusoap.php');

//using soap_server to create server object
$server = new soap_server;

// initialize WSDL support
 $server->configureWSDL( 'retrievesdl' , 'urn:retrievesdl' );

// place schema at namespace with prefix tns
 $server->wsdl->schemaTargetNamespace = 'urn:retrievesdl';
  // register methode
  $server->register("upload",
                array('numbers' => 'xsd:string'),
    array('return'=>'xsd:string'),// output
                'urn:retrievesdl',
                'urn:retrievesdl#upload');


// create the function
function upload($numbers)
{
$table = explode(":", $numbers);
$my_array = array($table[0],$table[1]);

 $conn = mysql_connect('myserverip','username','password');
 mysql_select_db('username_db', $conn);
 $query="INSERT INTO test(columnO, columnT) VALUES ('$table[0]', '$table[1]')";
 mysql_query($query) or die('Error, insert query failed');

return json_encode($values);
//return var_dump($values);

 /*
 $rows=mysql_num_rows($q);
 $i=0;
    while ($i <= 5)//($i < $rows)
    {        
 $tried = mysql_result($q, $i, "tried");
 return $tried;
 $i++;
 }
 */

  mysql_close($conn);
}

// create HTTP listener
 $HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';

 $server->service($HTTP_RAW_POST_DATA);

exit();

?>

Yukarıdaki kod iyi çalışıyor ama webservice sürekli bir mysql veritabanına bağlanmak ve hashtable her değer için veritabanına bir dize eklemek beri son derece yavaş ve güvenilmez. Ve bu Hashtable çoğu zaman 3k + bin girdileri olacaktır.

0 Cevap