Linux, Apache, MySQL, PHP

1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
   
   
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
   
   
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
   
   
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
   
   
5. Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
   
   
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
   
   
7. If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode HTML tags when pasting" checkbox before pasting anything inside the PRE block, and make sure "Ignore HTML tags in this message" check box is unchecked.
   
   
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
   
   
9. Please do not post links to your question in one forum from another, unrelated forum (such as the lounge). It will be deleted.
   
   
10. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
    
    
11. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
    
    
12. No advertising or soliciting.
    
    
13. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

1. Read the question carefully
   
   
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
   
   
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
   
   
4. If the question is inappropriate then click the 'vote to remove message' button
   

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>
			';
		?>