dqtu14636 2018-12-24 07:36
浏览 47

如何使用implode和explode插入单个数据

I want to insert single data into SQL. I have instert table and first and lastname I will post data to service.php using implode and in service I will exlope data and add into a database. But it doesn't work.

Here is my inser.php page

     if($_POST)
    {
    $first_name = ($_POST['first_name']);
    $last_name  = ($_POST['last_name']);

    $query=$first_name.'|'.$last_name;
    $params=array(
        'action' => "INSERTSINGLE",
        'query' => $query
    );
    $postData='';
    foreach($params as $k => $v){
        $postData .= $k . '='.$v.'&';
    }
    rtrim($postData, '&');
    if(is_array($postData)){
        $count=count($postData);
    }else{
        $count=0;
    }
    print_r($postData);
    $ch=curl_init();
    curl_setopt($ch, CURLOPT_URL,"service.php");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
    curl_setopt($ch, CURLOPT_HEADER,false);
    curl_setopt($ch, CURLOPT_POST,$count);
    curl_setopt($ch, CURLOPT_POSTFIELDS,$postData);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: 
            application/json'));
    $responsedata=curl_exec($ch);
    curl_close($ch);
    print_r($responsedata);
}

and here is my webservice page

require_once('index.php');
$action=$_POST["action"];

echo $action;
$query = $_POST["query"];
$gelendata=explode('|',$query);
$firstname=$gelendata[0];
$lastname=$gelendata[1];
switch ($action)
{
case 'GETCLIENTS':

echo $firstname;
$query = $myPDO->query("SELECT * FROM users",PDO::FETCH_ASSOC);
foreach ($query as $row) {
    echo $row['first_name']."-".$row['last_name']."<br />
";
}
break;
case 'GETCLIENT':
echo 'client çekildi.';
$query = $myPDO->query("SELECT * FROM users WHERE user_id='{$query}'")->fetch(PDO::FETCH_ASSOC);
print_r($query);
break;
case 'INSERTSINGLE':
echo 'client çekildi.';
$query = $myPDO->query("INSERT INTO users (firs_name,last_name) VALUES({$firstname},{$lastname})")->fetch(PDO::FETCH_ASSOC);
print_r($query);
break;

I can take the data but I can not insert. Can you please forward me? Thanks...

  • 写回答

1条回答 默认 最新

  • drzbc6003 2018-12-24 07:47
    关注
    case 'INSERTSINGLE':
    echo 'client çekildi.';
    $query = $myPDO->query("INSERT INTO users (firs_name,last_name) VALUES('{$firstname}','{$lastname}')")->fetch(PDO::FETCH_ASSOC);
    print_r($query);
    break;
    
    评论

报告相同问题?

悬赏问题

  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图