Guest User

Untitled

a guest
Jul 27th, 2018
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.73 KB | None | 0 0
  1. - (void)send_request
  2. {
  3. AFHTTPSessionManager* manager = [AFHTTPSessionManager manager];
  4. NSDictionary* postparam = @{ @"table_name" : @"test_json",
  5. @"addtext1" : @"add_A",
  6. @"addtext2" : @"add_B",
  7. @"addtext3" : @"add_C"};
  8. [manager POST:@"http://XXX.XXX.XX.XXX/send_request.php"
  9. parameters:postparam progress:nil
  10. success:^(NSURLSessionTask* task, id responseObject) {
  11. //通信成功
  12. NSLog(@"成功response: %@", responseObject);
  13. }
  14. failure:^(NSURLSessionTask* operation, NSError* error) {
  15. //通信失敗
  16. NSLog(@"失敗Error: %@", error);
  17. }];
  18. }
  19.  
  20. <?php
  21. mb_language("uni");
  22. mb_internal_encoding("utf-8");
  23. mb_http_input("auto");
  24. mb_http_output("utf-8");
  25. class Database{
  26. var $dbServer;
  27. var $dbName;
  28. var $dbUser;
  29. var $dbPass;
  30. var $link;
  31. var $db;
  32. var $query;
  33.  
  34. function Database1($db_name)
  35. {
  36.  
  37. $this->dbServer="localhost";
  38. $this->dbName=$db_name;
  39. $this->dbUser="ユーザ名";
  40. $this->dbPass="パスワード";
  41.  
  42. $this->link=mysql_connect($this->dbServer,
  43. $this->dbUser,
  44. $this->dbPass)
  45. or
  46. die(exit);
  47.  
  48. $this->db=mysql_select_db($this->dbName,$this->link);
  49.  
  50. $this->query=mysql_query('SET NAMES utf8',$this->link);
  51. }
  52.  
  53. public function close()
  54. {
  55. return mysql_close($this->link);
  56. }
  57.  
  58. public function select($query)
  59. {
  60. $result=mysql_query($query);
  61. $row=array();
  62. $row=mysql_fetch_assoc($result);
  63. return $row;
  64. }
  65.  
  66. public function query($query)
  67. {
  68. return mysql_query($query);
  69. }
  70.  
  71. public function jsonparse($query)
  72. {
  73. $row = mysql_fetch_object($query);
  74. return $row;
  75. }
  76. }
  77. ?>
  78.  
  79. <?php
  80. include_once "DatabaseClass.php";
  81.  
  82. if($_POST["table_name"] && $_POST["addtext1"]
  83. && $_POST["addtext2"] && $_POST["addtext3"])
  84. {
  85. $table_name = $_POST["table_name"];
  86. $addtext1 = $_POST["addtext1"];
  87. $addtext2 = $_POST["addtext2"];
  88. $addtext3 = $_POST["addtext3"];
  89.  
  90. $database = new Database("test");
  91.  
  92. $sql = "INSERT INTO {$table_name} (field_A,field_B,field_C) VALUES ('{$addtext1}','{$addtext2}','{$addtext3}');";
  93.  
  94. $query = $database->query($sql);
  95.  
  96. $sql = ("SELECT * FROM {$table_name}");
  97.  
  98. $query = $database->query($sql);
  99. $json= array();
  100.  
  101. if(strstr($table_name, 'test_json')){
  102. while ($row = mysql_fetch_object($query)) {
  103. $json[] = array(
  104. 'field_A'=> $row->field_A
  105. ,'field_B'=> $row->field_B
  106. ,'field_C' => $row->field_C
  107. );
  108. }
  109. }//if(strstr($table_name, 'test_json'))
  110.  
  111.  
  112. header("Content-Type: application/json; charset=utf-8");
  113. echo json_encode($json);
  114.  
  115. $database->close();
  116.  
  117. }//if($_POST["table_name"])
  118. ?>
  119.  
  120. function Database1($db_name)
  121.  
  122. function __construct($db_name)
  123.  
  124. $database = new Database("test");
Add Comment
Please, Sign In to add comment