PHP - Show Value From A Mysql Table Selected

hi, i'm new to php. i've got a problem.
I've 3 tables and table has following content

table 1
id  name  email   address   phone   execution_date   executor_name   web_address


table 2
id  name  email   address   phone   execution_date   executor_name   project_title


table 3
id  name  email   address   phone   execution_date   executor_name   reviewer

I want to export these table to and spreadsheet (.xls) with some criteria

a form will assign which data will published at the spreadsheet with these criteria
#all data can be exported from three tables
#some column can be selected from three tables
#some or all data can be selected from individual table

i've implement a script for this but it didn't meet my requirements. Can anyone help?

here is my script

<?php

$DB_Server = "localhost"; //your MySQL Server 
$DB_Username = "root";  //your MySQL User Name 
$DB_Password = "pass"; //your MySQL Password 
$DB_DBName = "mydb"; //your MySQL Database Name 
$search_from_date = $_POST['start_date'];
$search_to_date = $_POST['end_date'];
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
$Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
$now_date = date('m-d-Y H:i');

if(($_POST['typer_of_report'] == 'rrc_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName = 'rrc_record';
}

if(($_POST['typer_of_report'] == 'erc_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName2 = 'erc_record';
}

if(($_POST['typer_of_report'] == 'aeec_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName3 = 'aeec_record';
}



$file_type = "vnd.ms-excel";
$file_ending = "xls";
//}
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=protocol_report.$file_ending");
header("Pragma: no-cache");
header("Expires: 0");

if($DB_TBLName)
{
$sql = "Select * from ".$DB_TBLName." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$Use_Title = 1;


$title = "Report for $DB_TBLName on $now_date";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());

if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
//}

echo "\n...\n";
}

if($DB_TBLName2)
{
$sql = "Select * from ".$DB_TBLName2." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$Use_Title = 1;
$title = "Report for $DB_TBLName2 on $now_date";
if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}


echo "\n...\n";
}

if($DB_TBLName3)
{
$sql = "Select * from ".$DB_TBLName3." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$Use_Title = 1;
$title = "Report for $DB_TBLName3 on $now_date";
if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
}

?>

have anyone any idea?

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hi,

How can I get others informations on another page by clicking on one row's value

I have this code, but it doesn't work:


while($row = mysql_fetch_array($result))
  {
 echo "<tr><p>";
 
  echo "<th><p>" . $row['fname'] . "&nbsp;&nbsp;&nbsp;" . $row['lname'] . "</p></th>";
  echo"<th><p><a href='student.php?id='".$row['topic']."'\'>".$row['topic']."</p></a></th>";

  echo "</tr>";
  }
echo "</table>";


Student.php


<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("college", $con);

$result = mysql_query("SELECT * FROM students");
$topic = $_Get['topic'];
while($row = mysql_fetch_array($result))
  {
  
 echo "<tr><p>";
  echo "<th><p>" . $row['month']."&nbsp;" .$row['datetime']."</p></th>";
  echo"<th><p>". $row['topic'] ."</p></th>"; 
  echo "<th><p>" . $row['gender'] . "</p></th>";
  echo "<th><p>" . $row['fname'] . "&nbsp;&nbsp;&nbsp;" . $row['lname'] . "</p></th>";
  echo "<th ><p>" . $row['id'] . "</p></th>";
  echo "</tr>";
  
echo "</table>";

mysql_close($con);
  }
?> 

friend the code display all the managers name  

  <?php

        echo '<select name="Manager">';

        $query="SELECT * FROM managers";

        $result = mysql_query($query);

        while ($row = mysql_fetch_array($result)) {

            echo "<option value='" . $row['manager_name'] . "'>" . $row['manager_name'] . "</option>";

        }

        echo '</select>';

        ?>

  and the variable below displays the result   $Manager= $row['Manager'] ;     but how do i do it on the above dropdown list the it shows which result is in the $Manager variable?

I have a form gathering data from the database. There is one field 'country' which is a combo box. The combo box is populated from the countries table which joins the customers table to provide the country specific to the customer. I'm trying to have the combo box display the country associated with the customer. I think I'm close in my code, but unsure. This is a playground to so I can implement on our other site. 

<?php
require_once('database.php');
$sql2 = "SELECT * From countries
";
$countries = $db->query($sql2);

if(isset($_GET['customerID'])) {
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $sql = "SELECT * FROM customers  WHERE customerID =$customerID ";
//$sql2 = "SELECT * From countries
//INNER JOIN customers ON countries.countryCode=customers.countryCode
//WHERE customers.customerID = $customerID";
    $stmt = $db->query($sql);
}
if(isset($_GET['customerID'])){
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $countryQuery = "
    {$sql2} INNER JOIN customers ON countries.countryCode = customers.countryCode WHERE customers.customerID = $customerID";

    $countriesQuery = $db->prepare($countryQuery);
    $countriesQuery->execute(['customerID' => $_GET['customerID']]);

    $selectedCountry = $countriesQuery->fetch(PDO::FETCH_ASSOC);

    var_dump($selectedCountry);

}

?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<!-- the head section -->
<head>
    <title>My Guitar Shop</title>
    <link rel="stylesheet" type="text/css" href="main.css" />
</head>

<!-- the body section -->
<body>
<div id="page">

    <div id="header">
        <h1>SportsPro Technical Support</h1>
        <p>Sports management software for the sports enthusiast.</p></h1>
    </div>

    <div id="main">

        <h1>View/Update Customer</h1>

        <form action="update.php" method="get" >
        <?php




        ?>
        <div id="content">
            <!-- display a table of products -->
            <h2>Customers</h2>
            <form  name="customerInfo">
               <?php foreach ($stmt as $cust) { ?>
                <div>
                    <label>First Name</label>
            <input type="text" name="name" class ="form-control" value ="<?php echo $cust['firstName']; ?>">
            </div><br>
                <div>
                    <label>Last Name</label>
                    <input type="text" name="name" class ="form-control" value ="<?php echo $cust['lastName']; ?>">
                </div><br>
            <div>
            <label>Address</label>
            <input type="text" name="address" class ="form-control" value ="<?php echo $cust['address']; ?>">
                </div><br>
                <div>
                    <label>City</label>
            <input type="text" name="city" class ="form-control" value ="<?php echo $cust['city']; ?>">
                </div><br>
                <div>
                    <label>State</label>
            <input type="text" name="state" class ="form-control" value ="<?php echo $cust['state']; ?>">
                </div><br>
                <form action="update.php" method="get">
                    <select name="country">
                        <option value=""></option>
                        <?php
                        foreach ($countries->fetchAll() as $country): ?>
                            <option value="<?php echo $country['customerID']; ?>
                          <?php echo isset($customerID) == $selectedCountry['customerID'] ? ' selected':''?>
                            "><?php echo $country['countryName']; ?></option>

                        <?php endforeach;?>

                    </select>


                </form>
                </div>



                <br>
                <div>
                    <label>Country Code</label>
            <input type="text" name="countryCode" class ="form-control" value ="<?php echo $cust['countryCode']; ?>">
                </div><br>
                <div>
                    <label>Zip Code</label>
            <input type="text" name="postalCode" class ="form-control" value ="<?php echo $cust['postalCode']; ?>">
                </div><br>
                <div>
                    <label>Email </label>
            <input type="text" name="email" class ="form-control" value ="<?php echo $cust['email']; ?>">
                </div><br>
                <div>
                    <label>Phone Number </label>
            <input type="text" name="phone" class ="form-control" value ="<?php echo $cust['phone']; ?>">
                </div><br>
                <div>
                    <label>Password </label>
            <input type="text" name="password" class ="form-control" value ="<?php echo $cust['password']; ?>">
                </div><br>
                <div>

                <?php    }

                                ?>


        </div>

    </div>
            <form action="UpdateCustomer.php" method="get">
                <input   type="submit" name="data" value="Update_Data"></input>
            </form>
    <div id="footer">
        <p>
            © <?php echo date("Y"); ?> SportsPro, Inc.
        </p>
    </div>

</div><!-- end page -->
</body>
</html>