Linux, Apache, MySQL, PHP

need to add date in the file name into outfile caluse below please suggest

SET @outpath = "/var/lib/mysql-files/";
SET @outfile = (SELECT NOW());
SET @outextension = "_StepCount.csv";
SET @SQL := CONCAT("Select Concat(ifnull(First_Name,'')," ",ifnull(Middle_Name,'')," ",ifnull(Last_name,'')) AS Name, u.email from users",@outpath,@outfile,@outextension ) ;
PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

$offline = $odb->query("SELECT COUNT(*) FROM bots WHERE (UNIX_TIMESTAMP()-time)>20")->fetch()[0]; 
$offliner $offline->fetchColumn();

I want to solve a PHP issue

I have a db with 2 tables: first one is "document":

           id  |    title       |                                   
      ================================
           1   |    equations    | 
           2   |    great        |  
           3   |    painting     |
second one is "pic":

          id   |   doc_id        |   description
    ===============================================
           1   |    1            |  "mathematics"
           2   |    1            |  "physic"
           3   |    2            |  "litterature"
           4   |    2            |  "art"
     
the "doc_id" is a foreign key, related to the id of the table "document"
this is my question: I'm trying to print for each title, all the descriptions related to it, example:

  for the title "equations" , the foreign key related to it, is "doc_id =1"
  wich means for "equations" i will  print "matematics" and "physic" 
the final table printed using PHP and SQL, on my browser, should be:

             |   tiltle      |   description
    ===============================================
             | equations     |  mathematics, physic
             | great         |   litterature , art 
             | painting      |  
        
Here's my code:

<pre><?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "doc-pic";
// Create connection
$conn =  mysqli_connect($servername, $username, $password, $dbname);
// Check connection
$sql = "SELECT * FROM pic LEFT JOIN document ON pic.doc_id=document.id";
                   $result = mysqli_query($conn, $sql);
$sql1 = "SELECT title from document";
                  $result1 = mysqli_query($conn, $sql1);
?>
           <table>    
           <?php
 if (mysqli_num_rows($result1) > 0)
            while($row = mysqli_fetch_array($result1)){?>
            <tr>
            <td><?php echo $row["title"]; ?></td>
            </tr>
            <?php  if (mysqli_num_rows($result) > 0 )
                     while($row = mysqli_fetch_array($result)){
                     ?>
                     <tr>
                     <td><?php echo $row["doc_id"]; ?></td>
                     <td><?php echo $row["description"]; ?></td>
                     </td>
                     </tr>
                     </td>
           <?php }

 } ?>

<pre>I have an issue while calculating the column-like bank statement. actually, I am trying to calculate Opening Balance/today In /today Out / Closing Bal in MySQL PHP. I have two tables. material_infor `IN +` entry and material_approvefor `OUT -`. I am considering my opening balance was `123`.

I am new in PHP and I am here using Union All function. Please help me to create the function for getting Opening / In today / out today/closing calculation in my code.



`table- material_in`

| id   | components_key | insert_date | credit      |
|------|----------------|-------------|-------------|
| 1    | 12345          | 2021-04-16  | 100         |
| 2    | 12345          | 2021-04-16  | 50          |



`table- material_approve`

| id   | components_key | insert_date | debit       |
|------|----------------|-------------|-------------|
| 1    | 12345          | 2021-04-16  | 30          |
| 2    | 12345          | 2021-04-16  | 2           |

<pre>I am trying the code - 

    SELECT
        `u`.`component_key`,
        `u`.`insert_date`,
        `u`.`transaction_qty`
    FROM
        (
        SELECT
            `components_key` AS `component_key`,
            `insert_date`,
            `credit` AS `transaction_qty`
        FROM
            `material_in`
        UNION ALL
        SELECT
            `components_key`,
            `insert_date`,
            `debit` AS `transaction_qty`
        FROM
            `material_approve`
        ) u
    WHERE
        `u`.`component_key` = '12345'
    ORDER BY
        `u`.`insert_date`
    DESC

the output comes - 

| components_key | insert_date | transaction_qty|
|-------------|-------------|------------|
| 12345      | 2021-04-16  | 100         |
| 12345      | 2021-04-16  | 50          |
| 12345      | 2021-04-16  | 30          |
| 12345      | 2021-04-16  | 2           |

`output will be-`

| components_key | insert_date | openbal| today_in | today_out | closebal
|-----------|-------------|-------------|----------|-----------|---------|
|12345      | 2021-04-16  | 123         | 100      | 30        | 193     | 
|12345      | 2021-04-16  | 193         | 243      | 2         | 241     |

//openbal + today_in - today_out  = closebal

<?php
phpinfo();
?>

{
    "version": "0.2.0",
    "configurations": [
        {
            "name": "Listen for Xdebug",
            "type": "php",
            "request": "launch",
            "port": 9000
        }
    ]
}

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\phs\check.php on line 

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use PDO;

class ImportProducts extends Command
{
    /**
     * @var string
     */
    protected $signature = 'import:products';

    /**
     * @var string
     */
    protected $description = 'Imports products into database';

    /**
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * @return mixed
     */
    public function handle()
    {
        // Rename from products1.csv into products2.csv to import a file with slightly different data
        $contents = file_get_contents('products.csv');
        $lines = explode("\n", $contents);

        $i = 0;

        foreach ($lines as $line) {

            $fields = explode(';', $line);

            $pdo = new PDO('mysql:dbname=coding_challenge;host=172.0.0.1;port=3306', 'root', 'secret');

            $query = $pdo->prepare("SELECT COUNT(*) AS c from products WHERE id=?");
            $result = $query->execute([$fields[0]]);
            if($query->rowCount()) {
                $pdo->query('DELETE FROM products WHERE id = "' . $fields[0] . '"');
                print('Deleted existed product to be updated.');
            }

            $query = $pdo->prepare('INSERT INTO products (id, name, sku,status,variations, price, currency) VALUES (?, ?, ?, ? , ? , ?, ?)');
            $result = $query->execute([$fields[0], ($fields[4] ?? ''), ($fields[5] ?? ''), ($fields[6] ?? ''), ($fields[9] ?? ''), ($fields[10] ?? '') ]);

            // TODO: Soft delete no longer exist products from the database.

            $i++;
        }

        die('Updated ' . $i . ' products.');
    }
}

<?php

namespace App\Console;

use App\Console\Commands\ImportProducts;
use Illuminate\Console\Scheduling\Schedule;
use Illuminate\Foundation\Console\Kernel as ConsoleKernel;

class Kernel extends ConsoleKernel
{
    /**
     * The Artisan commands provided by your application.
     *
     * @var array
     */
    protected $commands = [
        ImportProducts::class,
    ];

    /**
     * Define the application's command schedule.
     *
     * @param  \Illuminate\Console\Scheduling\Schedule  $schedule
     * @return void
     */
    protected function schedule(Schedule $schedule)
    {
        // $schedule->command('inspire')
        //          ->hourly();
    }

    /**
     * Register the commands for the application.
     *
     * @return void
     */
    protected function commands()
    {
        $this->load(__DIR__.'/Commands');

        require base_path('routes/console.php');
    }
}

<?php
@session_start();
header('Content-Type: text/html; charset=ISO-8859-1');
include('includes/config.php');
?>
		<link rel="stylesheet" type="text/css" href="css/chat.css" />
<div id="sidebar_header">Garderobe</div>
<div id="sidebar_content">
	<p style="display: inline;">Skid i havet.</p><br /><br />
	<select name="sko">
<?php

	if(isset($_SESSION['logget_ind']) && $_SESSION['logget_ind'] == true) {
		$getSko = mysql_query("SELECT `navn` FROM `chat_clothes` WHERE `ejer` = '".$_SESSION['brugernavn']."' AND `type` = 'sko'");

		
		while ($showSko = mysql_fetch_array($getSko)) {
			echo '<option id="sko" name="sko" style="width: 300px;">'.$showSko['navn'].'</option><br />'
			;
			}
	}
?>

</div>

			</select>
<?php
	if (isset($_POST['sko'])) {
		

						mysql_query("UPDATE chat_brugere SET shoes='".$getSko."' WHERE id='".$_SESSION['id']."'");

						echo 'sko er opdateret!';
				} else {
					echo '';
				}
			
			echo '
			<form action="nygad.php" method="POST">

				<div>
					<table>
					
						<tr>
							<td><center><input type="submit" name="sko" value="Opdater!" /></center></td>
						</tr>
					</table>
				</div>
			</form>
			';
		?>