dragon321723 2016-02-23 06:49
浏览 68
已采纳

如何将数据从iOS应用程序发布到MySQL数据库?

I saw a similar post to my question but his solution did not work for me for some odd reason and it is making me age faster than Obama.

Basically I want to post data from an iOS app to a MySQL database.

iOS code

NSString *strURL = [NSString stringWithFormat:@"http://www.example.com/phpfile.php?dishname=%@&description=%@",textfieldTwo.text, textfieldTwo.text];
NSData *data = [NSData dataWithContentsOfURL:[NSURL URLWithString:strURL]];
NSString *strResults = [[NSString alloc]initWithData:data encoding:NSUTF8StringEncoding];
    NSLog(@"%@", strResults);

PHP code

<?php

$servername="localhost";
$username="admin";
$password="admin";
$dbname="dbname";
$conn=mysqli_connect($servername, $username, $password, $dbname);
if (!$conn)
{
    die("Connection failed: " . mysqli_connect_error());
}
$dishname=$_POST['dishname'];
$description=$_POST['description'];
echo "Name : " . $dishname;
//echo "Mail : ". $mail;
$sql="insert into RecipeFeed (DishName, Description) values ('" . $dishname . "', '" . $description . "')";
$result=mysqli_query($conn, $sql);


?>

database image enter image description here

I have no idea whatsoever to why I am having this problem. Any help will be appreciated, thank you!

  • 写回答

3条回答 默认 最新

  • doucan1996 2016-02-25 01:06
    关注

    I figured it out and here is the code below.

    PHP

    <?php
    
    // Create connection
    $servername = "localhost";
    $username = "admin";
    $password = "admin";
    $dbname = "db";
    $con=mysqli_connect("localhost","admin","admin","db");
    
    if (!$con) {
     die("Connection failed: " . mysqli_connect_error());
     echo "Nothing happened";
    
    }else{
    
    
    }
    
    
    if (isset ($_GET["firstname"]))
            $firstname = $_GET["firstname"];
        else
            $firstname = "Null";
    if (isset ($_GET["lastname"]))
            $lastname = $_GET["lastname"];
        else
            $lastname = "Null";
    
    if (isset ($_GET["email"]))
            $email = $_GET["email"];
        else
            $email = "Null";
    
    if (isset ($_GET["password"]))
            $password = $_GET["password"];
        else
            $password = "Null";
    
    if (isset ($_GET["timestamp"]))
            $timestamp = $_GET["timestamp"];
        else
            $timestamp = "Null";
    $id = "null";
    
    
    echo "FirstName : ". $firstname;
    echo "LastName : ". $lastname;
    $sql = "insert into Users (FirstName, ID, LastName, Email, Password, TimeStamp) values ('".$firstname."', '".$id."', '".$lastname."', '".$email."', '".$password."', '".$timestamp."')";
    $result = mysqli_query($con, $sql);
    ?>
    

    iOS

      NSString *strURL = [NSString stringWithFormat:@"http://www.example.com/register.php?firstname=%@&lastname=%@&password=%@&email=%@&",firstName.text, lastName.text, password.text, email.text];
        NSData *dataURL = [NSData dataWithContentsOfURL:[NSURL URLWithString:strURL]];
        NSString *strResult = [[NSString alloc] initWithData:dataURL encoding:NSUTF8StringEncoding];
        NSLog(@"%@", strResult);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 wpf通过绑定控件自身的值,来实现背景颜色的切换
  • ¥15 CDH6.3 运行hive -e hive -e "show databases;"报错:hive-env.sh:行24: hbase-common.jar: 权限不够
  • ¥15 乌班图ip地址配置及远程SSH
  • ¥15 怎么让点阵屏显示静态爱心,用keiluVision5写出让点阵屏显示静态爱心的代码,越快越好
  • ¥15 PSPICE制作一个加法器
  • ¥15 javaweb项目无法正常跳转
  • ¥15 VMBox虚拟机无法访问
  • ¥15 skd显示找不到头文件
  • ¥15 机器视觉中图片中长度与真实长度的关系
  • ¥15 fastreport table 怎么只让每页的最下面和最顶部有横线