Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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;
- }
- $array_no[]=new no_answer;
- class voice_mail
- {
- public $Name;
- public $Number;
- public $Post_code;
- public $Email;
- }
- $array_voice[]=new voice_mail;
- ?>
- <?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" id="myForm" method="post">
- <select name="seet" onChange="He();" >
- <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>".'<input type="button" value="Submit" onclick="myFunction()" />'."</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")
- {
- foreach($array_voice as $k => $cur)
- {
- echo $cur['Name'];
- echo $cur['Number'];
- echo $cur['Post code'];
- echo $cur['Email'];
- }
- }
- 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>
- var He=function(){
- alert($('Sheet').context();
- }
- </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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement