最受欢迎

将数据发布到数据库w/cURL的PHP/SQL问题

PHP/SQL Issues on Posting Data to Database w/ cURL

本文关键字：cURL SQL 问题 PHP 数据 数据库 | 更新日期: 2023-09-27

您将在下面找到代码。

我正试图用它来检索JSON数据，并将值发布到我的数据库中。

JSON结构以及输出顺序。。。

[{
    "record_locator": "value",
    "status": "value",
    "area": "value",
    "region": "value",
    "name": "value",
    "position":"value",
    "phone_": "value",
    "project_manager": "value",
    "ipad_email": "value",
    "email": "value",
    "team_leader": "value",
    "regional": "value",
    "title": "value",
    "start_date": "value",
    "employee_id_number": "value",
}]

对于眼睛来说。。。

$VAR=我的表密钥=JSON密钥

$area   =area   =area
    $email  =email  =email
    $ipad_email =ipad_email =ipad_email
    $empid  =empid  =employee_id_number
    $fullname   =fullname   =name
    $manager    =manager    =If Clause
    $mobilenumber   =mobilenumber   =phone_
    $record_locator =record =record_locator
    $status =status =status
    $region =region =region
    $position   =position   =position
    $project_manager    =project_manager    =project_manager
    $team_leader    =team_leader    =team_leader
    $regional   =regional   =regional
    $title  =title  =title
    $startdate  =startdate  =startdate

我对这个值做了一个简单的回声测试，他们正在获取它，只是出于某种原因，它没有发布到数据库中。遗憾的是，我想不通。

如有任何帮助，我们将不胜感激这不起作用

<html>
                <head>
                <style>
                td {
                    text-align:center;
                    border: 1px solid black;
                }
                </style>
                </head>
                <body>
                <div style="margin-top:5%; width:300px; margin:auto; border: 1px solid black; padding:3px;"><center><p id="container">Loading...</p></div>
                <?php
                $error_msg = "";
                        $url="someurl.com";
                         $ch = curl_init();
        curl_setopt($ch, CURLOPT_AUTOREFERER, TRUE);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);       
        $json = curl_exec($ch);
        curl_close($ch);
        $rdata = json_decode($json, TRUE);
    $c=0;
    $repverified = 0;
    foreach ($rdata as $data) { 
    //  Assigned key            JSON KEY 
    $user_rl    = $rdata[$c]['record_locator'];
    $status = $rdata[$c]['status'];
    $area   = $rdata[$c]['area'];
    $region = $rdata[$c]['region'];
    $fullname   = $rdata[$c]['name'];
    $position   = $rdata[$c]['position'];
    $mobilenumber   = $rdata[$c]['phone_'];
    $project_manager    = $rdata[$c]['project_manager'];
    $ipad_email     = $rdata[$c]['ipad_email'];
    $email  = $rdata[$c]['email'];
    $team_leader    = $rdata[$c]['team_leader'];
    $regional   = $rdata[$c]['regional'];
    $title  = $rdata[$c]['title'];
    $startdate  = $rdata[$c]['start_date'];
    $empid  = $rdata[$c]['employee_id_number'];

        if(
            $fullname       == $rdata[$c]['project_manager'] || 
            $fullname       == $rdata[$c]['team_leader'] || 
            $fullname       == $rdata[$c]['regional'] || 
            $fullname       == $rdata[$c]['director']) 
                {
                $manager = 'YES';
                } 
        else {
                $manager = 'NO';
             }
            // Insert the new user into the database 
$sql = "
    INSERT INTO memberss (
    record,
    status,
    area,
    region,
    fullname,
    manager,
    position,
    mobilenumber,
    project_manager,
    ipad_email,
    email,
    team_leader,
    regional,
    title,
    startdate,
    empid
    )
    VALUES (
    ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
   $insert_stmt = $mysqli->prepare($sql);
    // Insert the new user into the database
    if ($insert_stmt)
    {
        $insert_stmt->bind_param('ssssssssssssssss',$user_rl,$status,$area,
                $region,$fullname,$manager,$position,$mobilenumber,
                $project_manager,$ipad_email,$email,$team_leader,
                $regional,$title,$startdate,$empid);
        // Execute the prepared query.
        if (! $insert_stmt->execute()) {
            header('Location: ../error.php?err=Registration failure: INSERT');
        }
    }
    }
    echo    '<div>Check to ensure we are grabbing the values</div>';
    echo    '<td>'. $user_rl    .'</td><br>';
    echo    '<td>'. $status .'</td><br>';
    echo    '<td>'. $area   .'</td><br>';
    echo    '<td>'. $region .'</td><br>';
    echo    '<td>'. $fullname   .'</td><br>';
    echo    '<td>'. $manager    .'</td><br>';
    echo    '<td>'. $position   .'</td><br>';
    echo    '<td>'. $mobilenumber   .'</td><br>';
    echo    '<td>'. $project_manager    .'</td><br>';
    echo    '<td>'. $ipad_email .'</td><br>';
    echo    '<td>'. $email  .'</td><br>';
    echo    '<td>'. $team_leader    .'</td><br>';
    echo    '<td>'. $regional   .'</td><br>';
    echo    '<td>'. $title  .'</td><br>';
    echo    '<td>'. $startdate  .'</td><br>';
    echo    '<td>'. $empid  .'</td><br>';

        $c++;

        echo "<script>document.getElementById('container').innerHTML = 'Registration Completed!<br><b> Active Users will now be visible</b>';</script>";
        ?>

我甚至试图更改if语句和bind_params，但仍然没有成功

if (! $insert_stmt->execute()) {
                header('Location: ../error.php?err=Registration failure: INSERT');
            }
        }
        } else {
        // Insert the new user into the database 
        if ($insert_stmt = $mysqli->prepare("INSERT INTO members (email, password, status, empid, name, area, manager, record) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")) {
            $insert_stmt->bind_param('ssssssss', $email, $repEmail, $status, $employeeID, $FullName, $area, $manager, $record_locator);
            // Execute the prepared query.
            if (! $insert_stmt->execute()) {
                header('Location: ../error.php?err=Registration failure: INSERT');
            }
        }

添加了一个回声，以再次检查我们是否正在获取值。成功我们是！

echo"检查以确保我们正在获取值"；

echo    '<td>'. $user_rl    .'</td><br>';
echo    '<td>'. $status .'</td><br>';
echo    '<td>'. $area   .'</td><br>';
echo    '<td>'. $region .'</td><br>';
echo    '<td>'. $fullname   .'</td><br>';
echo    '<td>'. $manager    .'</td><br>';
echo    '<td>'. $position   .'</td><br>';
echo    '<td>'. $mobilenumber   .'</td><br>';
echo    '<td>'. $project_manager    .'</td><br>';
echo    '<td>'. $ipad_email .'</td><br>';
echo    '<td>'. $email  .'</td><br>';
echo    '<td>'. $team_leader    .'</td><br>';
echo    '<td>'. $regional   .'</td><br>';
echo    '<td>'. $title  .'</td><br>';
echo    '<td>'. $startdate  .'</td><br>';
echo    '<td>'. $empid  .'</td><br>';

DB方案

CREATE TABLE IF NOT EXISTS `memberss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `empid` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `record` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `area` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `region` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fullname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `position` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mobilenumber` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `project_manager` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `ipad_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `regional` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `startdate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

这是两件事中的任何一件；要么我的DB表设置不正确，要么我的主体脚本运行不正确。

我没有任何错误。即使我试图在发布时发现错误。是哪一个引导我走向桌子的？设置不正确吗？？

感谢您的帮助。

诙谐的附言；是的，我有我的DB连接文件，只是没有将其包含在代码的正文中

我已经弄清楚我做错了什么

我没有通过足够的

VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

我也没有绑足够的绳子。

$insert_stmt->bind_param('ssssssssssssssss'匹配我的

if ($insert_stmt = $mysqli->prepare("INSERT INTO members (values)"))

相关文章：
最新更新
www.56WenDa.com 2012-2023 | php问答网 | php学习