Route of type POST is not working on server in Laravel

See also questions close to this topic

• Permission error with PHP 8 and Session Handler

  Dears, I`m refracting old php code 4 to php 8, but I'm having some errors on Session Control. I implementing a SessionHandlerInterface, but I still having error when execute session write

  Warning: file_put_contents(../sessions/sess_fc6a0b26f218654ca0f45493861fdf58): failed to open stream: Arquivo ou diretório inexistente in /home/pedro/htdocs/ypanel/session.controller.php on line 36
  
  Warning: session_write_close(): Failed to write session data using user defined save handler. (session.save_path: ../sessions) in Unknown on line 0
  

  I'm using Lampp with Mysql on Debian.

  Here my class

      <?php
  header('Content-Type: application/json');
  //=========================================================================================
  ini_set('session.save_path',realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/../session'));
  //=========================================================================================
  session_save_path("../sessions");
  //=========================================================================================
  error_reporting(2);
  //=========================================================================================
  class MySessionHandler implements SessionHandlerInterface
  {
      private $savePath;
  
      public function open($savePath, $sessionName)
      {
          // printf(file_exists($savePath));
          // printf(is_dir($this->savePath).' dir');
          $this->savePath = $savePath;
          if (!is_dir($this->savePath)) 
          {
              chmod($this->savePath,0777);
              mkdir($this->savePath, 0777,true);
          }
          else printf('diretorio ja existe'); 
          return true;
      }
  
      public function close()
      {
          return true;
      }
  
      public function read($id)
      {
          return (string)@file_get_contents("$this->savePath/sess_$id");
      }
  
      public function write($id, $data)
      {
          return file_put_contents("$this->savePath/sess_$id", $data) === false ? false : true;
      }
  
      public function destroy($id)
      {
          $file = "$this->savePath/sess_$id";
          if (file_exists($file)) {
              unlink($file);
          }
  
          return true;
      }
  
      public function gc($maxlifetime)
      {
          foreach (glob("$this->savePath/sess_*") as $file) {
              if (filemtime($file) + $maxlifetime < time() && file_exists($file)) {
                  unlink($file);
              }
          }
  
          return true;
      }
  }
  
      $handler = new MySessionHandler();
      session_set_save_handler($handler, true);
      session_start();
  
      
  
  ?>
  
• Executing PowerShell Script from Server Using PHP

  I have a PowerShell script hosted on a server. I am calling PowerShell script from Php as below:

  <?php
  header('Content-Type: text/plain');
  $csv = file_get_contents('http://domaincom/wp-content/uploads/csv-samples.csv');
  echo $csv;
  
  shell_exec('pwsh -File http://domaincom/wp-content/uploads/pscript.ps1');
  
  $psPath = "powershell.exe";
  $psDIR = "http://domaincom/wp-content/uploads/";
  $psScript = "pscript.ps1";
  $runScript = $psDIR. $psScript;
  $runCMD = $psPath." ".$runScript." 2>&1"; 
  
  echo "\$psPath  $psPath <br>";
  echo "\$psDIR  $psDIR <br>";
  echo "\$psScript  $psScript <br>";
  echo "\$runScript  $runScript <br>";
  echo "\$runCMD   $runCMD  <br>";
  
  exec( $runCMD,$out,$ret);
  
  echo "<pre>";
  print_r($out);
  print_r($ret);
  echo "</pre>";
  ?>
  

  Script executes and I can see csv-samples.csv results in browser, but the powershell script doesn't execute. I get below message in browser:

  Site,URL,Category
  Sitepoint,http://www.sitepoint.com/,Web development
  Html.it,http://www.html.it/,Web development
  Wamboo,http://www.wamboo.it/,Web development$psPath  powershell.exe <br>$psDIR  http://domaincom/wp- 
  content/uploads/ <br>$psScript  pscript.ps1 <br>$runScript  http://domaincom/wp- 
  content/uploads/pscript.ps1 <br>$runCMD   powershell.exe http://domaincom/wp- 
  content/uploads/pscript.ps1 2>&1  <br><pre>Array
  (
      [0] => sh: 1: powershell.exe: not found
  )
  127</pre>
  

  Your help is very much appreciated.

  Thank You.
• mysql select query does not fetch columns

  I am trying to log in with php and mysql using the post method, only that when I go to press submit the sql query cannot find the records that exist, and therefore cannot log in this is my code:

  <?php
  
  session_start();
    $hostname="";
    $username="";
    $password="";
    $dbname="";
    $conn = new mysqli($hostname,$username, $password, $dbname); 
  
  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    ?> <script> console.log("Connection to db failed");</script><?
  }
  
      $username = $_POST["username"];
      $password = $_POST["password"];
  
      $sql = "SELECT username, password FROM admin WHERE utente = '$username' AND password = '$password'";
     if($result = $conn->query($sql)){
          if($result->num_rows > 0)
          echo 'sei loggato!!!';
      else
         echo 'non sei loggato!!!';
     }
  ?>
  

  Could someone tell me what I'm doing wrong? (I did not use prepared statements because it is only a test)
• Laravel join table with null

  i want join 2 table with spesifik data, like supplyments where id is 1 but get all data from the other table, i test with this code and success but when id is not 1 but not null in supplyments data from other table not show, from that output as you can see id 3 in supply_categories not show because id is not 1 but not null too

  $this->hasMany(Supplyment::class, 'id_user')
       ->rightJoin('supply_categories as category', 'category.id', '=', 'supplyments.id_category')
       ->orWhereNull('supplyments.id_user');
  

  output

  "supplyment": [
          {
              "id": 1,
              "name": "egg",
              "id_user": 1
          },
          {
              "id": 2,
              "name": "glass",
              "id_user": 1
          },
          {
              "id": 4,
              "name": "table",
              "id_user": null
          }
      ]
  
• How to loop through $request and extract specific parameters

  This is a screenshot dd($request) it contains alot information. I'd like to extract just the #parameter: array:10 bits. I know how to pull them out one at a time with the $request->get('parametername') method, but I was hopeing there's a way to do it with a loop. This will run in the controler.

  
• Retrieve data from multiple tables using their relationships-Laravel

  I have a table I need to complete, for now, it has 3 columns DATE, SHIFT and STATION.

  I only want the data that is attached to the logged-in user.
  I have a pivot table where I can call the data from for DATE and SHIFT, but Stations is a separate table,

  My pivot table is to display my many to many relationships between USER and SHIFTS called shift_user. this works, the STATIONS table relationship is a one to many relationship with USER as a User will belong to one station, but a station will have multiple users

  Stations model

  public function user()
  {
      return $this->hasMany('App\User');
  }
  

  }

  User Model

  public function station()
  {
      return $this->belongsTo('App\Station');
  }
  

  Controller for Project

  $user = Auth::user();
  
      return view('layouts/timesheet/index', ['user' => $user]);
  }
  

  Blade view to get info into tables

                  <table class="table table-sm table-success">
  
              <tr>
                  <th scope="col">DATE/DAY</th>
                  <th scope="col">SHIFT</th>
                  <th scope="col">STATION</th>
              </tr>
  
              <tbody class="table-light">
  
                  @foreach ($user->Station as $station)
                  @endforeach
                  @foreach ($user->shifts as $shift)
  
                      <tr>
                          <td>{{ $shift->created_at }}</td>
                          <td>{{ $shift->Name }}</td>
                          <td>{{ $station->Name }}</td>
  
                      </tr>
  
  
                  @endforeach
  

  Here is a picture of the table I want to fill in. I want the Station name to display, but I just get this ID which I think is the user I.D

  

  Please can you let me know what I can do to call the data from another table via the relationship? Thank you for any help