Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //DatabaseClassを読み込み
- include_once "DatabaseClass.php";
- //テーブル名と追加する値が選択されているかどうか確認
- if($_POST["table_name"] && $_POST["addtext1"]
- && $_POST["addtext2"] && $_POST["addtext3"])
- {
- //DB名設定
- $table_name = $_POST["table_name"];
- $addtext1 = $_POST["addtext1"];
- $addtext2 = $_POST["addtext2"];
- $addtext3 = $_POST["addtext3"];
- $database = new Database("test");
- //データ追加用SQL
- $sql = "INSERT INTO {$table_name} (field_A,field_B,field_C)
- VALUES ('{$addtext1}','{$addtext2}','{$addtext3}');";
- //クエリ送信
- $query = $database->query($sql);
- //一応結果を出力用SQL
- $sql = ("SELECT * FROM {$table_name}");
- //クエリ送信
- $query = $database->query($sql);
- $json= array();
- if(strstr($table_name, 'test_json')){
- while ($row = mysqli_fetch_object($query)) {
- $json[] = array(
- 'field_A'=> $row->field_A
- ,'field_B'=> $row->field_B
- ,'field_C' => $row->field_C
- );
- }
- }//if(strstr($table_name, 'test_json'))
- //JSON形式で出力
- header("Content-Type: application/json; charset=utf-8");
- echo json_encode($json);
- //DBを閉じる
- $database->close();
- }//if($_POST["table_name"])
- ?>
- <?php
- //内部文字コードを変更
- mb_language("uni");
- mb_internal_encoding("utf-8");
- mb_http_input("auto");
- mb_http_output("utf-8");
- class Database{
- var $dbServer;
- var $dbName;
- var $dbUser;
- var $dbPass;
- var $link;
- var $db;
- var $query;
- //DB接続
- function Database($db_name)
- {
- //DBの情報
- $this->dbServer="localhost:8889";
- $this->dbName=$db_name;
- $this->dbUser="root";
- $this->dbPass="XXXX";
- //MySQLに接続
- $this->link=mysqli_connect($this->dbServer,
- $this->dbUser,
- $this->dbPass)
- or
- die(exit);
- //DBを選択
- $this->db=mysqli_select_db($this->dbName,$this->link);
- //UTF-8の文字コードに変更
- $this->query=mysqli_query('SET NAMES utf8',$this->link);
- }
- //DBを閉じる
- public function close()
- {
- return mysqli_close($this->link);
- }
- //読み込むテーブルの選択
- public function select($query)
- {
- $result=mysqli_query($query);
- $row=array();
- $row=mysqli_fetch_assoc($result);
- return $row;
- }
- //指定したクエリの実行
- public function query($query)
- {
- return mysqli_query($query);
- }
- //JSON形式に変換用の出力
- public function jsonparse($query)
- {
- $row = mysqli_fetch_object($query);
- return $row;
- }
- }
- ?>
- - (void)send_request
- {
- AFHTTPSessionManager* manager = [AFHTTPSessionManager manager];
- NSDictionary* postparam = @{ @"table_name" : @"test_json",
- @"addtext1" : @"add_A",
- @"addtext2" : @"add_B",
- @"addtext3" : @"add_C"};
- [manager POST:@"http://localhost:8888/send_request.php"
- parameters:postparam progress:nil
- success:^(NSURLSessionTask* task, id responseObject) {
- //通信成功
- NSLog(@"成功response: %@", responseObject);
- }
- failure:^(NSURLSessionTask* operation, NSError* error) {
- //通信失敗
- NSLog(@"失敗Error: %@", error);
- }];
- }
- function Database($db_name)
- {
- function __construct($db_name)
- {
- $this->db=mysqli_select_db($this->link,$this->dbName);
- $this->query=mysqli_query($this->link,'SET NAMES utf8');
- //指定したクエリの実行
- public function query($query)
- {
- return mysqli_query($query);
- }
- //指定したクエリの実行
- public function query($query)
- {
- return mysqli_query($this->link,$query);
- }
Add Comment
Please, Sign In to add comment