时间戳

首页 > 解决方案 > 当我运行此代码时，计数器仅变为 1 和 2，但我想让它变为 5

php - 当我运行此代码时，计数器仅变为 1 和 2，但我想让它变为 5

问题描述

当我运行这个 php 代码时，计数器变量只变为 1 和 2，但我想让它变为 5，这里有什么问题有人可以帮助我吗？为什么计数器从 2 上升？

<?php
session_start();
include "sql.php";
$date = $_POST['date'];
$email = $_SESSION[email];
$counter = 0;
$check = " select * from reservations where date = '$date'";
$result = mysqli_query($con, $check);
$num = mysqli_num_rows($result);

if($num = 1){

    $data = " select * from reservations where date = '$date'";
    $dresult = mysqli_query($con, $data);
    $row = mysqli_fetch_array($dresult); 

    $counter = $row[counter];
    echo $counter;
    if ($counter < 5){

        $counter=$counter+1;
        $reg= "insert into reservations(date,counter,email) values('$date' , '$counter' , '$email')";
        mysqli_query($con, $reg);
    }

    else{

        echo "no tables available";
    }

}
else{

    $data = " select * from reservations where date = '$date'";
    $dresult = mysqli_query($con, $data);
    $row = mysqli_fetch_array($dresult);
    $counter = $row[counter];

    $counter=$counter+1;
    $reg= "insert into reservations(date,counter,email) values('$date' , '$counter' , '$email')";
    mysqli_query($con, $reg);
}

标签： phpsql

解决方案

我认为你应该把它放在一个循环上。
检查以下代码： 

<?php
session_start();
include "sql.php";
$date = $_POST['date'];
$email = $_SESSION[email];
$counter = 0;
$check = " select * from reservations where date = '$date'";
$result = mysqli_query($con, $check);
$num = mysqli_num_rows($result);

if($num = 1){

    $data = " select * from reservations where date = '$date'";
    $dresult = mysqli_query($con, $data);
    $row = mysqli_fetch_array($dresult); 

    $counter = $row[counter];
    echo $counter;
    if ($counter < 5){
      while($counter <= 5){

        //$counter=$counter+1;
        $reg= "insert into reservations(date,counter,email) values('$date' , '$counter' , '$email')";
        mysqli_query($con, $reg);
       $counter++;

      }
    }

    else{

        echo "no tables available";
    }

}
else{

    $data = " select * from reservations where date = '$date'";
    $dresult = mysqli_query($con, $data);
    $row = mysqli_fetch_array($dresult);
    $counter = $row[counter];

    $counter=$counter+1;
    $reg= "insert into reservations(date,counter,email) values('$date' , '$counter' , '$email')";
    mysqli_query($con, $reg);
}

推荐阅读