Skip to main content

Ajax returned an undefined php index error while the other one don't

I have a problem with ajax, when I call it, i get the undefined index error on my variables. I have other ajax call on all my website, and no problem, but this one give me an error. I search in my code and I don't see where my mistake is :(.

Here is my HTML :

<script type="text/javascript">

  $('#btnDispo').click(function()
  {
    var service = document.getElementById("serviceTest").value;
    var date = document.getElementById("DateReservation").value;
    var heure = document.getElementById("heureTest").value;
    if( service && date && heure)
    {
        $.ajax({
        type:"POST",
        url: "check-table.php",
        dataType: "json",
        data: 
        {
          service: service, date: date, heure: heure
        },
        success: function(output_string)
        {
          $("#result_table").html(output_string);
        } // End of success function of ajax form
        }); // End of ajax call 
    }
    else
    {
        alert("c'est pas rempli");
    }
  });
</script>

and this is my check-table.php :

<?php
    //DB Connection
    include("connection.php"); 

    $service = isset($_REQUEST['service']) ? $_REQUEST['service'] : 'serviceBug' ;
    $date = isset($_REQUEST['date']) ? $_REQUEST['date'] : 'dateBug' ;
    $heure = isset($_REQUEST['heure']) ? $_REQUEST['heure'] : 'heureBug' ;
    $output_string = "Service = " . $service . " et date = " . $date . " et heure = " . $heure; 
/*
    $tableDispo = "SELECT numTable FROM tbltable WHERE NOT EXISTS (SELECT * FROM tblreservation WHERE tblreservation";
    $tableDispo .=".idTable = tbltable.idTblTable and tblreservation.serviceReservation = '".$service."' and tblreservation.dateReservation = '".$date."' )";
    $result = mysqli_query($con, $tableDispo);

    $output_string = "";
    $output_string .=  "<table border='1'>\n";
    while($row = mysqli_fetch_assoc($result))
    {
        foreach($row as $value)
        {
            $id = $row['numTable'];
            $output_string .= "<img width='";
            $output_string .= "90%' src='";
            $output_string .= "../Images/Table";
            $output_string .= $id;
            $output_string .= ".png'>\n";
        }
        $output_string .= "</tr>\n";
    }
    $output_string .= "</table>\n";

    //mysql_close();
    // This echo for jquery */
    echo json_encode($output_string);
?>

I have the same in an another page, who works perfectly : html :

  <script type="text/javascript" language="javascript">

  $('#btnFiltre').click(function()
  {
    var service = document.getElementById("serviceTest").value;
    var date = document.getElementById("DateReservation").value;
    var heure = document.getElementById("heureTest").value;
    $.ajax({
      url: "check-gestionTable.php",
      type:'POST',
      dataType: 'json',
      data: 
      {
        service: service, date: date, heure: heure
      },
      success: function(output_string)
      {
        $("#result_table").html(output_string);
      } // End of success function of ajax form
    }); // End of ajax call 
  });
</script>

check-gestionTable.php :

<?php
   //DB Connection
   include("connection.php"); 

   $service = $_POST['service'];
   $date = $_POST['date'];
   $heure = $_POST['heure'];


   if($date)//Si la date n'est pas null
   {
        if ($service != "Tout")//Si le service n'est pas null
        {
            if($heure != "Toutes")// Si heure n'est pas null
            {
                $tableDispo = "SELECT idTblReservation as Numero_de_reservation, nombreClient as Couvert, dateReservation as Date_, serviceReservation as Service, heure as Heure, idTable as Numero_de_table FROM tblreservation where serviceReservation = '".$service."' AND dateReservation = '".$date."' AND heure = '".$heure."' ";
                $result = mysqli_query($con, $tableDispo);
                $header = false;
                $output_string = "";
                $output_string .=  "<table class='titreRes' id='titreRes' style='border: 10px ridge grey; margin-left: 25%; margin-right: 35%; width: 50%; background-color: lightgrey; font-family: Cooper;'>\n";
                while($row = mysqli_fetch_assoc($result))
                {
                    if(!$header)
                    {
                        $output_string .= "<tr>\n";
                        foreach($row as $header => $value)
                        {
                            $output_string .= "<th style='text-align:center'>{$header}</th>\n";
                        }
                        $output_string .= "<th style='text-align:center'>Supprimer ? </th>";
                        $output_string .= "</tr>\n";
                    }
                    $output_string .= "<tr>\n";
                    foreach($row as $value)
                    {
                        $output_string .= "<th style='text-align:center'>{$value}</th>\n";
                    }
                    $id = $row['Numero_de_reservation'];
                    $output_string .= "<th style='text-align:center'><a href='delete.php?id=";
                    $output_string .= $id;
                    $output_string .= "'>Supprimer</a></th>";
                    $output_string .= "</tr>\n";
                }
                $output_string .= "</table>\n";

                // This echo for jquery 
                echo json_encode($output_string);
            }
            else if ($heure == "Toutes")
            {
                $serviceDateTable = "SELECT idTblReservation as Numero_de_reservation, nombreClient as Couvert, dateReservation as Date_, serviceReservation as Service, heure as Heure, idTable as Numero_de_table FROM tblreservation where serviceReservation = '".$service."' AND dateReservation = '".$date."' ORDER BY heure ASC";
                $result = mysqli_query($con, $serviceDateTable);
                $header = false;
                $output_string = "";
                $output_string .=  "<table class='titreRes' id='titreRes' style='border: 10px ridge grey; margin-left: 25%; margin-right: 35%; width: 50%; background-color: lightgrey; font-family: Cooper;'>\n";
                while($row = mysqli_fetch_assoc($result))
                {
                    if(!$header)
                    {
                        $output_string .= "<tr>\n";
                        foreach($row as $header => $value)
                        {
                            $output_string .= "<th style='text-align:center'>{$header}</th>\n";
                        }
                        $output_string .= "<th style='text-align:center'>Supprimer ? </th>";
                        $output_string .= "</tr>\n";
                    }
                    $output_string .= "<tr>\n";
                    foreach($row as $value)
                    {
                        $output_string .= "<th style='text-align:center'>{$value}</th>\n";
                    }
                    $id = $row['Numero_de_reservation'];
                    $output_string .= "<th style='text-align:center'><a href='delete.php?id=";
                    $output_string .= $id;
                    $output_string .= "'>Supprimer</a></th>";
                    $output_string .= "</tr>\n";
                }
                $output_string .= "</table>\n";

                // This echo for jquery 
                echo json_encode($output_string);
            }
        }
        else if ($service == "Tout")
        {
            $dateTable = "SELECT idTblReservation as Numero_de_reservation, nombreClient as Couvert, dateReservation as Date_, serviceReservation as Service, heure as Heure, idTable as Numero_de_table FROM tblreservation where dateReservation = '".$date."' ORDER BY serviceReservation ASC, heure ASC";
            $result = mysqli_query($con, $dateTable);
            $header = false;
            $output_string = "";
            $output_string .=  "<table class='titreRes' id='titreRes' style='border: 10px ridge grey; margin-left: 25%; margin-right: 35%; width: 50%; background-color: lightgrey; font-family: Cooper;'>\n";
            while($row = mysqli_fetch_assoc($result))
            {
                if(!$header)
                {
                    $output_string .= "<tr>\n";
                    foreach($row as $header => $value)
                    {
                        $output_string .= "<th style='text-align:center'>{$header}</th>\n";
                    }
                    $output_string .= "<th style='text-align:center'>Supprimer ? </th>";
                    $output_string .= "</tr>\n";
                }
                $output_string .= "<tr>\n";
                foreach($row as $value)
                {
                    $output_string .= "<th style='text-align:center'>{$value}</th>\n";
                }
                $id = $row['Numero_de_reservation'];
                $output_string .= "<th style='text-align:center'><a href='delete.php?id=";
                $output_string .= $id;
                $output_string .= "'>Supprimer</a></th>";
                $output_string .= "</tr>\n";
            }
            $output_string .= "</table>\n";

            // This echo for jquery 
            echo json_encode($output_string);
        }
   }
   else
   {
        if ($service != "Tout")//Si le service n'est pas null
        {
            if($heure != "Toutes")// Si heure n'est pas null
            {
                $serviceHeureTable = "SELECT idTblReservation as Numero_de_reservation, nombreClient as Couvert, dateReservation as Date_, serviceReservation as Service, heure as Heure, idTable as Numero_de_table FROM tblreservation where serviceReservation = '".$service."' AND heure = '".$heure."' ORDER BY dateReservation ASC";
                $result = mysqli_query($con, $serviceHeureTable);
                $header = false;
                $output_string = "";
                $output_string .=  "<table class='titreRes' id='titreRes' style='border: 10px ridge grey; margin-left: 25%; margin-right: 35%; width: 50%; background-color: lightgrey; font-family: Cooper;'>\n";
                while($row = mysqli_fetch_assoc($result))
                {
                    if(!$header)
                    {
                        $output_string .= "<tr>\n";
                        foreach($row as $header => $value)
                        {
                            $output_string .= "<th style='text-align:center'>{$header}</th>\n";
                        }
                        $output_string .= "<th style='text-align:center'>Supprimer ? </th>";
                        $output_string .= "</tr>\n";
                    }
                    $output_string .= "<tr>\n";
                    foreach($row as $value)
                    {
                        $output_string .= "<th style='text-align:center'>{$value}</th>\n";
                    }
                    $id = $row['Numero_de_reservation'];
                    $output_string .= "<th style='text-align:center'><a href='delete.php?id=";
                    $output_string .= $id;
                    $output_string .= "'>Supprimer</a></th>";
                    $output_string .= "</tr>\n";
                }
                $output_string .= "</table>\n";

                // This echo for jquery 
                echo json_encode($output_string);
            }
            else if ($heure == "Toutes")
            {
                $serviceTable = "SELECT idTblReservation as Numero_de_reservation, nombreClient as Couvert, dateReservation as Date_, serviceReservation as Service, heure as Heure, idTable as Numero_de_table FROM tblreservation where serviceReservation = '".$service."' ORDER BY dateReservation ASC, heure ASC";
                $result = mysqli_query($con, $serviceTable);
                $header = false;
                $output_string = "";
                $output_string .=  "<table class='titreRes' id='titreRes' style='border: 10px ridge grey; margin-left: 25%; margin-right: 35%; width: 50%; background-color: lightgrey; font-family: Cooper;'>\n";
                while($row = mysqli_fetch_assoc($result))
                {
                    if(!$header)
                    {
                        $output_string .= "<tr>\n";
                        foreach($row as $header => $value)
                        {
                            $output_string .= "<th style='text-align:center'>{$header}</th>\n";
                        }
                        $output_string .= "<th style='text-align:center'>Supprimer ? </th>";
                        $output_string .= "</tr>\n";
                    }
                    $output_string .= "<tr>\n";
                    foreach($row as $value)
                    {
                        $output_string .= "<th style='text-align:center'>{$value}</th>\n";
                    }
                    $id = $row['Numero_de_reservation'];
                    $output_string .= "<th style='text-align:center'><a href='delete.php?id=";
                    $output_string .= $id;
                    $output_string .= "'>Supprimer</a></th>";
                    $output_string .= "</tr>\n";
                }
                $output_string .= "</table>\n";


                // This echo for jquery 
                echo json_encode($output_string);
            }
        }
        else if ($service == "Tout" && $heure == "Toutes") //Si tout est null
        {
            $touteTable = "SELECT idTblReservation as Numero_de_reservation, nombreClient as Couvert, dateReservation as Date_, serviceReservation as Service, heure as Heure, idTable as Numero_de_table FROM tblreservation";
            $result = mysqli_query($con, $touteTable);
            $header = false;
            $output_string = "";
            $output_string .=  "<table class='titreRes' id='titreRes' style='border: 10px ridge grey; margin-left: 25%; margin-right: 35%; width: 50%; background-color: lightgrey; font-family: Cooper;'>\n";
            while($row = mysqli_fetch_assoc($result))
            {
                if(!$header)
                {
                    $output_string .= "<tr>\n";
                    foreach($row as $header => $value)
                    {
                        $output_string .= "<th style='text-align:center'>{$header}</th>\n";
                    }
                    $output_string .= "<th style='text-align:center'>Supprimer ? </th>";
                    $output_string .= "</tr>\n";
                }
                $output_string .= "<tr>\n";
                foreach($row as $value)
                {
                    $output_string .= "<th style='text-align:center'>{$value}</th>\n";
                }
                $id = $row['Numero_de_reservation'];
                $output_string .= "<th style='text-align:center'><a href='delete.php?id=";
                $output_string .= $id;
                $output_string .= "'>Supprimer</a></th>";
                $output_string .= "</tr>\n";
            }
            $output_string .= "</table>\n";

            // This echo for jquery 
            echo json_encode($output_string);
        }
   }

?>

The problem doesn't even is in my php code, just the data don't go from my html to my php. Thank you everyone !



source https://stackoverflow.com/questions/69002855/ajax-returned-an-undefined-php-index-error-while-the-other-one-dont
Labels:

Comments

Post a Comment

Popular posts from this blog

Prop `className` did not match in next js app

I have written a sample code ( Github Link here ). this is a simple next js app, but giving me error when I refresh the page. This seems to be the common problem and I tried the fix provided in the internet but does not seem to fix my issue. The error is Warning: Prop className did not match. Server: "MuiBox-root MuiBox-root-1" Client: "MuiBox-root MuiBox-root-2". Did changes for _document.js, modified _app.js as mentioned in official website and solutions in stackoverflow. but nothing seems to work. Could someone take a look and help me whats wrong with the code? Via Active questions tagged javascript - Stack Overflow https://ift.tt/2FdjaAW
Post a Comment
Read more

How to show number of registered users in Laravel based on usertype?

i'm trying to display data from the database in the admin dashboard i used this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count(); echo $users; ?> and i have successfully get the correct data from the database but what if i want to display a specific data for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype i tried this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count()->WHERE usertype =admin; echo $users; ?> but it didn't work, what am i doing wrong? source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype
Post a Comment
Read more

Why is my reports service not connecting?

I am trying to pull some data from a Postgres database using Node.js and node-postures but I can't figure out why my service isn't connecting. my routes/index.js file: const express = require('express'); const router = express.Router(); const ordersCountController = require('../controllers/ordersCountController'); const ordersController = require('../controllers/ordersController'); const weeklyReportsController = require('../controllers/weeklyReportsController'); router.get('/orders_count', ordersCountController); router.get('/orders', ordersController); router.get('/weekly_reports', weeklyReportsController); module.exports = router; My controllers/weeklyReportsController.js file: const weeklyReportsService = require('../services/weeklyReportsService'); const weeklyReportsController = async (req, res) => { try { const data = await weeklyReportsService; res.json({data}) console
Post a Comment
Read more