duanjiao2978 2016-08-12 17:11
浏览 51
已采纳

使用好的SQL查询而不是PHP代码

I have a page that is taking a kind of long time to load, and I'm almost sure that this is caused by too many sql requests (AKA caused by my bad SQL skills). Is there anyway to join these 3 queries into one?

What I want to do with this query is to try to select a specific id from cardapios and, if there is anything there (if $num_rows > 0) the only thing I want to do is select that id. If there is nothing there, then I want to insert something and then select the id of that.

    $query = "SELECT id FROM cardapios WHERE nome='$nome'";
    $sql = mysqli_query($con,$query);
    $num_rows = mysqli_num_rows($sql);
    if ($num_rows > 0){
            while ($row = mysqli_fetch_array($sql)){
                $_SESSION['id_cardapio'] = $row['id'];
      $num_rows = 0;
    }}else{
            $query = "INSERT INTO cardapios (nome, kcal, semana)
            VALUES('$nome', '$kcal', '$semana')" or die(mysqli_error($con));
            $sql = mysqli_query($con,$query);

            $query = "SELECT id FROM cardapios WHERE nome='$nome' ";
            $sql = mysqli_query($con, $query);
            while ($row = mysqli_fetch_array($sql)){
                $_SESSION['id_cardapio'] = $row['id'];
            }
      }

I am trying to put all of this into one query but getting nowhere. Is there anyway to use just one query for doing all of this?

Thanks in advance!

  • 写回答

1条回答 默认 最新

  • duan0065626385 2016-08-12 17:20
    关注

    You can replace the last query by getting the mysqli_insert_id($con); as you already have the insert id available after the insert

    $query = "SELECT id FROM cardapios WHERE nome='$nome'";
    $sql = mysqli_query($con,$query);
    $num_rows = mysqli_num_rows($sql);
    if ($num_rows > 0){
        while ($row = mysqli_fetch_array($sql)){
            $_SESSION['id_cardapio'] = $row['id'];
            $num_rows = 0;
        }
    }else{
        $query = "INSERT INTO cardapios (nome, kcal, semana)
            VALUES('$nome', '$kcal', '$semana')" or die(mysqli_error($con));
            $sql = mysqli_query($con,$query);
    
            if ( $sql !== false) {    // did insert work
                $_SESSION['id_cardapio'] = mysqli_insert_id($con);
            } else {
                // insert did nto work??
            }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?