Guest User

Untitled

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