[PHP 作为iOS后台Json格式HTTP通信及文件上传的实现]

1.数据库连接 configmysql.php

<?php
    $q = mysql_connect("localhost:8889","root","root");
    if(!$q)
    {
       die('Could not connect: ' . mysql_error());
    }
    mysql_query("set names utf8"); //以utf8读取数据
    //mysql_select_db("myDB",$q); //选择数据库
?>

2.POST或GET请求，Json返回 selectuser.php

<?
    include("configmysql.php");
    mysql_select_db("myDB",$q); //选择数据库  
    //GET或POST取的参数或者
    $TEMPid=$_GET['userid'];
    //$TEMPid=$_POST['userid'];
    $sql = "select * from UserinfoTB where userid=".$TEMPid;
    $query = mysql_query($sql)or die(mysql_error());
    while($row = mysql_fetch_array($query)){
        $json = $row;
    }
    echo json_encode($json);
?>

3.多组数据 selectuser.php

<?
    include("configmysql.php");
    mysql_select_db("chepaiDB",$q); //数据库  
    $TEMPid=$_GET['Driverid'];
    $sql = "select * from Driverinfo where Driverid=".$TEMPid;
    $query = mysql_query($sql)or die(mysql_error());
    while($row = mysql_fetch_array($query)){
        $json1 = $row;
    }
    
    $sql2 = "select * from Driverillegalinfo where IDriverid=".$TEMPid." order by Iid desc";
    $query2 = mysql_query($sql2)or die(mysql_error());
    $json2 =  array();
    $sum=0;
    while($row2 = mysql_fetch_array($query2)){
        $json2['row'.$sum] = $row2;
        $sum++;    
    }

    $newJson = json_encode(
          array_merge(
            array('info1' => $json1),
            array('info2' => $json2)
          )
    );
    echo $newJson;
?>

4.文件照片上传 upload_file.php

<?    
    header("Content-type: text/html; charset=UTF-8");
    include("configmysql.php");
    mysql_select_db("chepaiDB",$q); //数据库  

    //POST获取键值对参数
    $TEMPid=$_POST['Driverid'];
    echo "\nDriverid is ".$TEMPid."\n";

    foreach ($_FILES as $_eachFile) {
        //file文件处理
        if ($_eachFile["error"] > 0)
          {
          echo "错误: " . $_eachFile["error"] . "\n";
          }
        else
          {
          echo "文件名: " . $_eachFile["name"] . "\n";
          echo "类型: " . $_eachFile["type"] . "\n";
          echo "大小: " . ($_eachFile["size"] / 1024) . " Kb\n"; 
          }
         if (file_exists("uploadimage/" . $_eachFile["name"]))
            {
              echo $_eachFile["name"] . " 文件已经存在. ";
            }
        else
            {
              move_uploaded_file($_eachFile["tmp_name"],
              "uploadimage/" . $_eachFile["name"]);
              echo "文件已经被存储到: " . "uploadimage/" . $_eachFile["name"]."\n";
            }
    }
    /*
    //file文件处理
    if ($_FILES["file"]["error"] > 0)
      {
      echo "错误: " . $_FILES["file"]["error"] . "\n";
      }
    else
      {
      echo "文件名: " . $_FILES["file"]["name"] . "\n";
      echo "类型: " . $_FILES["file"]["type"] . "\n";
      echo "大小: " . ($_FILES["file"]["size"] / 1024) . " Kb\n"; 
      }
     if (file_exists("uploadimage/" . $_FILES["file"]["name"]))
        {
          echo $_FILES["file"]["name"] . " 文件已经存在. ";
        }
    else
        {
          move_uploaded_file($_FILES["file"]["tmp_name"],
          "uploadimage/" . $_FILES["file"]["name"]);
          echo "文件已经被存储到: " . "uploadimage/" . $_FILES["file"]["name"]."\n";
        }
    */
?>