Untitled

<?php error_reporting(0); ?>

<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<title>Web hello</title>

<link rel="stylesheet" href="php.php">

<style>
table, th, td {
    border: 1px solid black;
}
</style>

</head>

<body>

     <form action="index.PHP" method="post">
   <select name="Sheets">
  <option class="Sheet" value="">Select from:</option>
  <option class="Sheet" value="All">All</option>
  <option class="Sheet" value="No answer">No answer</option>
  <option class="sheet" value="Voice mail">Voice mail</option>
</select>

      <input type="submit" name="submit" value="submit"/>
      </form>


  <?php
//<<<<<<<<<<<<<<<<<<<<<<<< Classes >>>>>>>>>>>>>>>>>>>>>>>>>
    class no_answer
    {
        public $Name;
        public $Number;
        public $Post_code;
        public $Email;

    }


     class voice_mail
    {
        public $Name;
        public $Number;
        public $Post_code;
        public $Email;

    }


    class Customer
    {
          var $price;
          var $name;
        var $photo;


        public function print_game()
         {
              echo $this->name;
                    echo $this->price;

                    echo $this->photo;


    }
    }

    $game= new Customer;
    $game->name='asdsadsad';
    $game->price=35453;
    $game->photo='asdsad';


    ?>

<?php


$servername = "localhost";
$username = "root";
$password = "";
$dbname = "testdb";

// <<<<<<<<<<<<<<<<<<<<<<<<<<Create connection>>>>>>>>>>>>>>>>>>>>>>>>>

$conn = mysqli_connect($servername, $username, $password, $dbname);


// <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<Check connection>>>>>>>>>>>>>>>>>>>>>
if (!$conn) {
   die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM yousef ";
$result = mysqli_query($conn, $sql);

//<<<<<<<<<<<<<<<<<<<<<<<< Agent >>>>>>>>>>>>>>>>>>>>>>

     if(isset($_POST['submit'])) {

     $wanted = $_POST["Sheets"];
       //echo $wanted;
   }


 if($wanted=="All")
{

if (mysqli_num_rows($result) > 0)
    {

    echo"<table><tr><th>Functions</th><th>Name</th><th>Number</th><th>Post code</th><th>Email</th><th>Submit</th></tr>";
while($row = mysqli_fetch_assoc($result))
{


  echo "<tr><td>".'<form name="myForm" method="post">
   <select name="seet" onChange="myfunction(this.value)"  >
  <option class="sheet" value="">Select from:</option>
  <option class="Sheet" id="No Answer" value="No answer">No answer</option>
  <option class="Sheet" id="Voice Mail" value="Voice mail">Voice mail</option>
</select></form>'."</td><td>".$row["Name"]."</td><td>".$row["Number"]."</td><td>".$row["Post code"]."</td><td>".$row["Email"]."</td><td>"."</td></tr>";


}

 }
   }
//<<<<<<<<<<<<<<<<<<<<<<<<<< No Answer >>>>>>>>>>>>>>>>>>>


    else if($wanted=="No answer")
{
     foreach($array_no as $k => $cur)
     {
         echo $cur['Name'];
         echo $cur['Number'];
         echo $cur['Post code'];
         echo $cur['Email'];
     }

}


//<<<<<<<<<<<<<<<<<<<<<<<<<<< Voice mail >>>>>>>>>>>>>>>>>>>>>>

else if($wanted=="Voice mail")
{
     $game->print_game();

 }


echo"</table>";


    ?>

    <?php //<<<<<<<<<<<<<<<<<<< JAva Script >>>>>>>>>>>>>>>> ?>
    <script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<script src="jquery-1.7.1.min.js"></script>
<script type="text/javascript"> </script>
<script>

    function myfunction(val)
    {
        if(val=="Voice mail")
            {


                alert("Items has succeful submitted");
            }
        else
            {

                alert("asdasdsadsadsadsads");
            }

    }

    </script>


    <form action="index.PHP" method="post">
    <input type="submit" name="Submit" value="Submit"/>
    </form>
<?php
    //<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Changes >>>>>>>>>>>>>>>>>>>>>>>>
    /*
     if(isset($_POST['Submit'])) {

        echo"asdasdsd";

   // if (mysqli_num_rows($result) > 0)
  //  {
//while($row = mysqli_fetch_assoc($result))
//{
    /*
    if($_POST["seet"]=="No answer")
    {
        array_push($array_no,$row["Name"],$row["Number"],$row["Post code"],$row["Email"]);
    }

    if($_POST["seet"]=="Voice mail")
    {
        array_push($array_no,$row["Name"],$row["Number"],$row["Post code"],$row["Email"]);
    }
    */

  //  echo $_POST["seet"];


 //  }
//}
//}


    ?>

    <?php
    mysqli_close($conn);
?>

</body>


</html>