Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db ='sanjeev'; $host ='localhost'; $user='root'; $pass='';
- $pdo = new PDO('mysql:dbname='.$db.'; host='.$host,$user,$pass);
- if(isset($_POST['search'])){
- $key=$_POST['key'];
- $result = $pdo->query("SELECT * FROM tbl_person WHERE surname LIKE '%$key%'");
- echo "<ul>";
- foreach ($result as $row) {
- echo '<li>'.$row['firstname'].' '.$row['surname'].' was born in '.$row['birthdate'].' has email id '. $row['email']. '</li>';
- }
- echo '</ul>';
- }
- ?>
- <form action="" method="POST">
- <input type="text" name="key"><br><br>
- <input type="submit" name="search" value="Search">
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement