为什么我没有从数组中找到我的MySQL查询的正确输入?

发布于 2025-02-11 13:11:31 字数 3779 浏览 1 评论 0原文

我有一个表格,带有这样的表格:

项目可以从1到10。DateProject1

ProjectnProject2ProjectnHolidayIll2022-06-27
352022-06-28
8

是我的代码:

    $postarray = array();

foreach ($_POST as $field => $value) {


    $postdata = array($field => $value);
    array_push($postarray, $postdata);
    
}

$count = count($postarray);
$countcalculation = $count/ 7;

$output = array_chunk($postarray, $countcalculation);

$input= new Test\Hours\HoursEntry();
$input= $input->hoursentry($output);

这是我的输出:

    Array
    (
        [0] => Array
            (
                [0] => Array
                    (
                        [day_0] => 2022-06-27
                    )
    
                [1] => Array
                    (
                        [project1_0] => 3
                    )
    
                [2] => Array
                    (
                        [project2_0] => 5
                    )
                [3] => Array
                    (
                        [project1_n] => 
                    )
    
                [4] => Array
                    (
                        [holiday_0] => 
                    )
    
                [5] => Array
                    (
                        [ill_0] => 
                    )
    
        [1] => Array
            (
                [0] => Array
                    (
                        [day_1] => 2022-06-28
                    )
    
                [1] => Array
                    (
                        [project1_1] => 1
                    )
    
                [2] => Array
                    (
                        [project2_1] => 2
                    )

                [3] => Array
                    (
                        [projectn_1] => 2
                    )
    
    
                [4] => Array
                    (
                        [holiday_1] => 
                    )
    
                [5] => Array
                    (
                        [ill_1] => 8
                    )
    
            )
)

我需要这样的数据库中的输入:

日期项目小时度假期Ill
2022-06-27Project15
2022-06-288

这是我尝试写入数据库中的:

$ i = 0;

foreach ($output as $postdata) {

        foreach ($postdata as $post => $p) {

            $count = count($postdata);

            foreach ($p as $input => $value) {

                $var[$i] = $value;
                $name[$i] = $input;
                $i++;
            }

                $day = date_format(new DateTime($var[0]), 'Y.m.d');
                $ill = $var[$count];
                $holiday = $var[$count - 1];

            for ($z = 1; $z <= $count - 2; $z++) {

                $hours = $var[$z];
                $project = $name[$z];

            
               // The Echo is to simulate the MySql query
                echo $tag . '</br>';
                echo $hours. '</br>';
                echo $project . '</br>';
             }   


        
          // The Echo is to simulate the MySql query
             echo $ill. '</br>';
             echo $holiday. '</br>';
            }

    }

i have a Form with a table like this:

The projects can be from 1 up to 10.

Dateproject1project2projectnholidayill
2022-06-2735
2022-06-288

Here is my code:

    $postarray = array();

foreach ($_POST as $field => $value) {


    $postdata = array($field => $value);
    array_push($postarray, $postdata);
    
}

$count = count($postarray);
$countcalculation = $count/ 7;

$output = array_chunk($postarray, $countcalculation);

$input= new Test\Hours\HoursEntry();
$input= $input->hoursentry($output);

Here is my output:

    Array
    (
        [0] => Array
            (
                [0] => Array
                    (
                        [day_0] => 2022-06-27
                    )
    
                [1] => Array
                    (
                        [project1_0] => 3
                    )
    
                [2] => Array
                    (
                        [project2_0] => 5
                    )
                [3] => Array
                    (
                        [project1_n] => 
                    )
    
                [4] => Array
                    (
                        [holiday_0] => 
                    )
    
                [5] => Array
                    (
                        [ill_0] => 
                    )
    
        [1] => Array
            (
                [0] => Array
                    (
                        [day_1] => 2022-06-28
                    )
    
                [1] => Array
                    (
                        [project1_1] => 1
                    )
    
                [2] => Array
                    (
                        [project2_1] => 2
                    )

                [3] => Array
                    (
                        [projectn_1] => 2
                    )
    
    
                [4] => Array
                    (
                        [holiday_1] => 
                    )
    
                [5] => Array
                    (
                        [ill_1] => 8
                    )
    
            )
)

I need a input in my Database like this:

Dateprojecthoursholidayill
2022-06-27project15
2022-06-288

Here is my try to write into the database:

$i = 0;

foreach ($output as $postdata) {

        foreach ($postdata as $post => $p) {

            $count = count($postdata);

            foreach ($p as $input => $value) {

                $var[$i] = $value;
                $name[$i] = $input;
                $i++;
            }

                $day = date_format(new DateTime($var[0]), 'Y.m.d');
                $ill = $var[$count];
                $holiday = $var[$count - 1];

            for ($z = 1; $z <= $count - 2; $z++) {

                $hours = $var[$z];
                $project = $name[$z];

            
               // The Echo is to simulate the MySql query
                echo $tag . '</br>';
                echo $hours. '</br>';
                echo $project . '</br>';
             }   


        
          // The Echo is to simulate the MySql query
             echo $ill. '</br>';
             echo $holiday. '</br>';
            }

    }

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文