PHP - Override Script Generated Table Data

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

I have a function which echos an array output, which creates links on a page related to that page. It all works well, but the CSS is making the links blue and purple as standard, and I want to overwrite this to make the links white. What can I add to the code to overwrite the style of the echo? The font size is working, but the colour is being overridden.

The code I currently have is:

    echo "<p> <font color='ffffff' size='4pt'>$echo</font></p>";

What am I doing wrong?

the second database found on the cloud

i try to get JSON data but how to insert and update  them to another online database with the same table

my php script to return json data 

<?php        

 include_once('db.php');

        $users = array();

        $users_data = $db -> prepare('SELECT id, username FROM  users');

        $users_data -> execute();

        while($fetched = $users_data->fetch()) {

            $users[$fetchedt['id']] = array (

                'id' => $fetched['id'],

                'username' => $fetched['name']

            );

        }

        echo json_encode($leaders);

i get

{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}}

I need to add more code to an existing function located inside the parent class. I'm using code like this but can't get it working :

// Parent

class Default_Fields {

    public function fields() {

        $this->_fields = array()
            
        // Default Code
    }

}


// Child

class More_Fields extends Default_Fields {

    public function fields() {

        $this->_fields = array()
            
        // Modified Code
    }

}


$new = new More_Fields;

$new->fields();

The modified code in the child class is an extended version of whats in the parent. There's no errors but the additional code is not printing.

<?php

	// connect to the database
	 	include 'Connect.php';
	
	// confirm that the 'student_id' variable has been set
	 	if (isset($_GET['student_id']) && is_numeric($_GET['student_id']))
		{
	// get the 'student_id' variable from the URL
	 	$student_id = $_GET['student_id'];
		
	// delete record from database
		if ($stmt = $mysql->prepare("DELETE FROM student_information WHERE student_id = ? LIMIT 1")) 
		{
			$stmt->bind_param("i",$student_id);	
			$stmt->execute();
			$stmt->close();
		}
		else
		{
			echo "ERROR: could not prepare SQL statement.";
		}
		$mysql->close();
		
	// redirect user after delete is successful
		header("Location: Admin_Home.php");
	}
	else
	// if the 'student_id' variable isn't set, redirect the user
		{
			header("Location: Admin_Home.php");
		}
?>

Kindly help. Am a new php programmer and am learning how to HTML form data to a php script.

Have tried several times but information on html form never get submitted. For some unknown  reasons, the codes are failing . Here are my codes:

<html>
   <head>
       <title>Form Destination</title>
   </head>
   <body>
   <?php
    if(isset($_POST['submit']))
       {
           echo "Name: {$_POST['name']} <br/>";
           echo "Age : {$_POST['age']} <br/>";
           echo "Gender:{$_POST['gender']} <br/>";
           echo "Email:{$_POST['email']} <br/>";              
       }
       else
       {
           echo "Form was not submitted";  
       }
    ?>
   </body> 
</html>

and 

<html>
  <head>
      <title>Form Source</title>
  </head>

<body>
  <form  action="form_destination.php" method="post">
       <br/><br/>
    Name: <input type="text" name="name"/>
       <br/><br/>
    Age:&nbsp;&nbsp;&nbsp;<input type="text" name="age"/>
       <br/><br/>
    Gender: &nbsp;Male<input type="radio" name="gender" value="male"/>
    Female<input type="radio" name="gender" value="female"/>
       <br/><br/>
     Email:&nbsp;<input type="text" name="email"/>
       <br/><br/>
     <input type="submit" value="submit"/>
     
  </form>
</body>
</html>