Guest User

Untitled

a guest
Aug 15th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.78 KB | None | 0 0
  1. //内部文字コードを変更
  2. mb_language("uni");
  3. mb_internal_encoding("utf-8");
  4. mb_http_input("auto");
  5. mb_http_output("utf-8");
  6.  
  7. class Database{
  8.  
  9. var $dbServer;
  10. var $dbName;
  11. var $dbUser;
  12. var $dbPass;
  13. var $link;
  14. var $db;
  15. var $query;
  16.  
  17. //DB接続
  18. function __construct($db_name)
  19. {
  20. //DBの情報
  21. $this->dbServer="localhost";
  22. $this->dbName=$db_name;
  23. $this->dbUser="root";
  24. $this->dbPass="root";
  25.  
  26. //ポスグレに接続
  27. $this->link=pg_connect($this->dbServer,
  28. $this->dbUser,
  29. $this->dbPass,
  30. $this->link,
  31. $this->dbName
  32. )
  33. or
  34. die(exit);
  35.  
  36.  
  37. //UTF-8の文字コードに変更
  38. $this->query=pg_query($this->link,'SET NAMES utf8');
  39. }
  40.  
  41. //DBを閉じる
  42. public function close()
  43. {
  44. return pg_close($this->link);
  45. }
  46.  
  47. //読み込むテーブルの選択
  48. public function select($query)
  49. {
  50. $result=pg_query($query);
  51. $row=array();
  52. $row=pg_fetch_assoc($result);
  53. return $row;
  54. }
  55.  
  56. //指定したクエリの実行
  57. public function query($query)
  58. {
  59. return pg_query($this->link,$query);
  60. }
  61.  
  62. //JSON形式に変換用の出力
  63. public function jsonparse($query)
  64. {
  65. $row = pg_fetch_object($query);
  66. return $row;
  67. }
  68. }
  69. ?>
  70.  
  71. <?php
  72. //DatabaseClassを読み込み
  73. include_once "DatabaseClass.php";
  74.  
  75. //テーブル名と追加する値が選択されているかどうか確認
  76. if($_POST["table_name"] && $_POST["addtext1"]
  77. && $_POST["addtext2"] && $_POST["addtext3"])
  78. {
  79. //DB名設定
  80. $table_name = $_POST["table_name"];
  81. $addtext1 = $_POST["addtext1"];
  82. $addtext2 = $_POST["addtext2"];
  83. $addtext3 = $_POST["addtext3"];
  84.  
  85. $database = new Database("test");
  86.  
  87. //データ追加用SQL
  88. $sql = "INSERT INTO {$table_name} (field_A,field_B,field_C) VALUES
  89. ('{$addtext1}','{$addtext2}','{$addtext3}');";
  90.  
  91. //クエリ送信
  92. $query = $database->query($sql);
  93.  
  94. //一応結果を出力用SQL
  95. $sql = ("SELECT * FROM {$table_name}");
  96.  
  97. //クエリ送信
  98. $query = $database->query($sql);
  99. $json= array();
  100.  
  101.  
  102. if(strstr($table_name, 'test_json')){
  103. while ($row = pg_fetch_object($query)) {
  104. $json[] = array(
  105. 'field_A'=> $row->field_A
  106. ,'field_B'=> $row->field_B
  107. ,'field_C' => $row->field_C
  108. );
  109. }
  110. }//if(strstr($table_name, 'test_json'))
  111.  
  112.  
  113. //JSON形式で出力
  114. header("Content-Type: application/json; charset=utf-8");
  115. echo json_encode($json);
  116.  
  117. //DBを閉じる
  118. $database->close();
  119.  
  120. }//if($_POST["table_name"])
  121. ?>
  122.  
  123. - (void)send_request
  124. {
  125. AFHTTPSessionManager* manager = [AFHTTPSessionManager manager];
  126. NSDictionary* postparam = @{ @"table_name" : @"test_json",
  127. @"addtext1" : @"add_A",
  128. @"addtext2" : @"add_B",
  129. @"addtext3" : @"add_C"};
  130. [manager POST:@"http://localhost:8888/send_request.php"
  131. parameters:postparam progress:nil
  132. success:^(NSURLSessionTask* task, id responseObject) {
  133. //通信成功
  134. NSLog(@"成功response: %@", responseObject);
  135. }
  136. failure:^(NSURLSessionTask* operation, NSError* error) {
  137. //通信失敗
  138. NSLog(@"失敗Error: %@", error);
  139. }];
  140. }
  141.  
  142. $this->link=pg_connect("host={$this->dbServer} dbname={$this->dbName} user={$this->dbUser} password={$this->dbPass}");
Add Comment
Please, Sign In to add comment