个人中心
gpt4 book ai didi

php - AJAX 成功函数不从 MYSQL 数据库中获取数据

转载 作者：行者123 更新时间：2023-11-30 21:47:49 27 4
gpt4 key购买 nike

对于这篇文章与我之前的文章之间的相似之处，我们深表歉意。如果有人可以帮助我再次发现我出错的地方，我将不胜感激。其他一切似乎都工作正常，但令我困惑的是 AJAX 成功功能的“安静”响应。控制台中也没有任何内容。

我已经使用 json_encode 和 print_r 函数测试了 JSON 输出并得到以下结果 - 所以我认为 JSON 字符串应该可以与 AJAX 一起使用:

Array
(
    [proj_start_date] => 2017-04-17
    [proj_end_date] => 2018-04-30
    [wo_nbr_new] => 10002-06
)
{"proj_start_date":"2017-04-17","proj_end_date":"2018-04-30","wo_nbr_new":"10002-06"}

下面是主文件的代码:

<?php
include 'connect_db.php';
$sql = "SELECT * FROM projects ORDER BY proj_nbr";
$result = mysqli_query($connect,$sql);
$rowCount = mysqli_num_rows($result);

?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Add New Work Order</title>
    <script
        src="https://code.jquery.com/jquery-3.2.1.min.js"integrity="sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4="
        crossorigin="anonymous">
    </script>
    <link rel="stylesheet" type="text/css" href="styles.css">
</head>

<body>

<h1>Add New Work Order</h1>

<div id="forms-add" name="forms-add">
<form action="add_workorders.php" method="POST">
    <label>Work Order Number (Auto-generated):</label>
    <input type="text" id="wo_nbr" name="wo_nbr"size="8"maxlength="8" value = "" readonly style="float: right"> 
    <br><br>
    <fieldset>
        <legend>Project Details</legend>

        <label>Project Number:</label>
        <select  class= "selects" id="proj_nbr" name="proj_nbr" required onchange="">
            <option value="">Select a project </option>
                <?php       
                    if($rowCount>0)
                    {
                        while ($row=mysqli_fetch_assoc($result))
                        {
                            echo '<option value="'.
                                $row['proj_id'].'">'.
                                $row['proj_nbr'].
                                ' - '.
                                $row['proj_desc'].
                                ' </option>';                
                        }
                    }
                    else
                    {
                        echo '<option value="">Project not available</option>';
                    }           
                ?>
        </select>
        <br><br>
        <label>Start Date:</label>
        <input type="text" id="proj_start_date" name="proj_start_date"size="8"maxlength="8" value = "" readonly style="float: right">
        <br><br>
        <label>End Date:</label>
        <input type="text" id="proj_end_date" name="proj_end_date"size="8"maxlength="8" value = "" readonly style="float: right">

    </fieldset>
    <br><br>

    <button type="submit" name="submit" >Save Work Order</button>

    </form>
</div>
</body>
    <script type="text/javascript" src="test_ajax.js"></script>

    <script>
        $(document).ready(function()
        {
            $('#proj_nbr').change(function()
            {
                var id=$('#proj_nbr').val();
                //alert(id); //this works ok 
                if (id != '')
                {
                    $.ajax({ 
                        url: "get_proj_nbrs2.php",
                        method:"POST",
                        data: {id:id}, //data to SEND to PHP file
                        dataType: "JSON",
                        success: function(output) 
                        {
                                console.log(output); //this doesn't return anything in the console??
                                $('#wo_nbr').val(output.wo_nbr_new);
                                $('#proj_start_date').val(output.proj_start_date);
                                $('#proj_end_date').val(output.proj_end_date);
                        }
                    });
                }
                else
                {
                    alert("Please select a Project");
                }           
            });
        });
    </script>

</html>

下面是PHP文件中的代码:

<?php
include 'connect_db.php';

if (isset($_POST['id']) && !empty($_POST['id']))
{
    $sql2 = "SELECT p.proj_nbr as wo_proj_nbr,p.start_date as proj_start_date,p.end_date as proj_end_date, MAX(w.wo_nbr) AS wo_nbr,
                            CASE WHEN SUBSTRING(MAX(w.wo_nbr),7,2)+1 <= 9 THEN CONCAT(p.proj_nbr,'-0',SUBSTRING(MAX(w.wo_nbr),7,2)+1) 
                            ELSE CONCAT(p.proj_nbr,'-',SUBSTRING(MAX(w.wo_nbr),7,2)+1) END AS wo_nbr_new
                            FROM workorders as w 
                            INNER JOIN projects as p on p.proj_id = w.proj_id
                            WHERE w.proj_id = '".$_POST['id']."'";
    $result2 = mysqli_query($connect,$sql2);

    while($row=mysqli_fetch_array($result2))
    {           
        if($result2 ==true)
        {
            $proj_nbr = $row['wo_proj_nbr'];
            $output['proj_start_date'] = $row['proj_start_date'];
            $output['proj_end_date'] = $row['proj_end_date'];               
            if ($row['wo_nbr_new'] != NULL)
            {
                $output['wo_nbr_new'] = $row['wo_nbr_new'];
                echo json_encode($output);
            }
            elseif($row['wo_nbr_new'] == NULL)
            {
                $output['wo_nbr_new'] = $proj_nbr."-01";
                echo json_encode($output);                          
            }
        }
    }
}?>

最佳答案 

<?php
include 'connect_db.php';

if (isset($_POST['id']) && !empty($_POST['id']))
{
$result = array();
    $sql2 = "SELECT p.proj_nbr as wo_proj_nbr,p.start_date as proj_start_date,p.end_date as proj_end_date, MAX(w.wo_nbr) AS wo_nbr,
                            CASE WHEN SUBSTRING(MAX(w.wo_nbr),7,2)+1 <= 9 THEN CONCAT(p.proj_nbr,'-0',SUBSTRING(MAX(w.wo_nbr),7,2)+1) 
                            ELSE CONCAT(p.proj_nbr,'-',SUBSTRING(MAX(w.wo_nbr),7,2)+1) END AS wo_nbr_new
                            FROM workorders as w 
                            INNER JOIN projects as p on p.proj_id = w.proj_id
                            WHERE w.proj_id = '".$_POST['id']."'";
    $result2 = mysqli_query($connect,$sql2);
if($result->num_rows > 0)
        {
    while($row=mysqli_fetch_array($result2))
    {           

            $proj_nbr = $row['wo_proj_nbr'];
            $output['proj_start_date'] = $row['proj_start_date'];
            $output['proj_end_date'] = $row['proj_end_date'];               
            if ($row['wo_nbr_new'] != NULL)
            {
                $output['wo_nbr_new'] = $row['wo_nbr_new'];

            }
            elseif($row['wo_nbr_new'] == NULL)
            {
                $output['wo_nbr_new'] = $proj_nbr."-01";

            }
           array_push($result,$output);
        }
      echo json_encode($result);
    }
  else
    {
      echo "no rows found";
     }
}?>

您正在回显每一行，因此您将从 ajax 中的成功函数获得结果作为每个单独的 sting。所以它无法解析。希望这个方法能解决您的问题。

关于php - AJAX 成功函数不从 MYSQL 数据库中获取数据，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/48616851/

27 4 0
文章推荐： mysql - CoderPad 不支持 SQL 中的排名函数吗？
文章推荐： c# - 使用 SharpZipLib 解压 .tar.gz
文章推荐： c# - 我需要带有 SQLBulkcopy 的进度条
文章推荐： c - 数组中的下标超出范围
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com