Nah itu error di mysql, cara perbaikinya dengan cara :
mysql_upgrade;
atau
mysql_upgrade -p;
Solved after read article from http://www.robsearles.com/
Jakarta, 26 September 2012
Mahasiswa Komputer, IT, Bisnis Unik Mahasiswa, Universitas, Kampus, Belajar Java, Belajar Python, Event Mahasiswa, Lowongan Kerja, Motivasi Mahasiswa
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
<?php function activation($cardId){ mysql_connect("localhost","root","asdf"); mysql_select_db("xl"); $result = mysql_query("select * from card where id_kartu ='".$cardId."'"); while ($data = mysql_fetch_array($result)) { $update = mysql_query("update card set tgl=now(), status='active', msdn='1234321',sn='2345623' where id_kartu ='".$cardId."'"); $card = array( "id" => $data['id'], "id_kartu" => $data['id_kartu'], "tgl" => $data['tgl'], "status" => $data['status'], "msdn" => $data['msdn'], "sn" => $data['sn'] ); } mysql_close(); return $card; } require ("../lib/nusoap/nusoap.php"); $server = new nusoap_server(); $server->configureWSDL("Activation","urn:activationService"); $server->wsdl->addComplexType( "card", "complexType", "struct", "all", "", array( "id_kartu"=>array("name"=>"id_kartu","type"=>"xsd:string"), "tgl"=>array("name"=>"tgl","type"=>"xsd:string"), "status"=>array("name"=>"status","type"=>"xsd:string"), "msdn"=>array("name"=>"msdn","type"=>"xsd:string"), "sn"=>array("name"=>"sn","type"=>"xsd:string") ) ); $server->register("activation",array("cardId"=>"xsd:string"), array("return"=>"tns:card"),"urn:activationService","urn:activationService#activation"); $HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : ""; $server->service($HTTP_RAW_POST_DATA); ?>
<?php require ("../lib/nusoap/nusoap.php"); ?> <html> <head> <title>Activation Card</title> </head> <body> <form action="<?= $_SERVER['PHP_SELF'] ?>" method = "POST"> ID Kartu : <input type="text" name="idkartu"> <input type="submit" name="submit" value="Activate"> </form> <?php $url = "http://localhost/xl/app/server.php"; if($_POST['submit']){ $client = new nusoap_client($url); $result = $client->call("activation",array("cardId"=>$_POST["idkartu"])); $err = $client->getError(); if($err){ echo $client->getError(); } else{ if($result!=null){ echo $result['id_kartu']." Berhasil diaktivasi"; } else{ echo "Code Not Found!!!"; } } } ?> </body> </html>Kode lengkap beserta sql dapat di unduh di sini