Guest User

data retreiving problem

a guest
Mar 22nd, 2017
25
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.10 KB | None | 0 0
  1. <?php
  2. //  $viewusername ="";
  3. // $viewcontactnumber = "";
  4. // $viewaddress = "";
  5. // $viewcountry = "";
  6. // $viewcity = "";
  7. // $viewzipcode = "";
  8.    
  9.     if ($_SERVER['REQUEST_METHOD'] == "POST") {
  10.         if (isset($_POST['mydata'])) {
  11.             $host = 'localhost';
  12.             $user = 'root';
  13.             $pass ='';
  14.             $db = 'valocy';
  15.  
  16.             $con = mysqli_connect($host,$user,$pass,$db) or die(mysqli_error());
  17.             $sql = "select * from addressdetails WHERE email='haroondar0037@gmail.com'";
  18.             if($result = mysqli_query($con, $sql)){
  19.            while ( $resultarr = mysqli_fetch_array($result)) {
  20.  
  21.                 $viewusername = $resultarr['fullname'];
  22.                  // $viewusername = htmlspecialchars($resultarr['fullname'],ENT_QUOTES);
  23.                 // $viewcontactnumber = $resultarr['contactnumber'];
  24.                 // $viewaddress = $resultarr['address'];
  25.                 // $viewcountry = $resultarr['country'];
  26.                 // $viewcity = $resultarr['city'];
  27.                 // $viewzipcode = $resultarr['zipcode'];
  28.             }
  29.         }
  30.         else{echo "jngjsngfjsnjns  skdjnfjskdnfjk sdknfjnsd";}
  31.         }
  32.     }
  33. ?>
  34. <?php include('includes/header.php'); ?>
  35.  
  36. <br><br><br><br><br>
  37. <div class="col-sm-offset-3 col-sm-2 col-xs-offset-3" style="margin-top:5px;">
  38.     <form method="POST" action="">
  39.         <button type="submit" name="mydata" class="btn btn-info btn-lg" data-toggle="modal" data-target="#myModal">View My Data</button>
  40.      </form>
  41. </div>
  42.  
  43. <!-- Modal -->
  44. <div id="myModal" class="modal fade" role="dialog">
  45.   <div class="modal-dialog">
  46.   <!-- Modal content-->
  47.     <div class="modal-content">
  48.       <div class="modal-header">
  49.         <button type="button" class="close" data-dismiss="modal">&times;</button>
  50.         <h4 class="modal-title">Your Data</h4>
  51.       </div>
  52.       <div class="modal-body">
  53.         <?php  
  54.         echo "name: $viewusername"; ?>
  55.       </div>
  56.       <div class="modal-footer">
  57.         <input type="button" name="close" value="close" class="btn btn-default" data-dismiss="modal">  
  58.       </div>
  59.     </div>
  60.  
  61.   </div>
  62. </div>
Add Comment
Please, Sign In to add comment