php code for multiple search box after connecting to mysql [closed]

by

So you can try change it to something like this:

<form method="post" action="example.php" id="searchform">
    <input type="text" name="keyword">
    <input type="submit" name="submit" value="submit">
</form>


if(isset($_POST['submit'])){
    $name=$_POST['keyword'];
    $statement = $myconnection->prepare("SELECT * FROM OL_trans  WHERE (ort LIKE '%$name%') OR (plz LIKE '%$name%') OR (vorname LIKE '%$name%')");
    $statement->execute();
    $key = $statement->fetchall();
    foreach($key as $value){
        echo '<br/>'.$value['vorname'].
            ' - '.$value['nachname'].
            ' - '.$value['strasse'].
            ' - '.$value['plz'].
            ' - '.$value['ort'].
            ' - '.$value['email'].
            ' - '.$value['telefon'].
            ' - '.$value['mobil'].'<br/><br/>';
    }
}
else{
    echo"enter correct name again";
}

More Related Contents:

  1. If number have inside number string [closed]
  2. Php date() Date and time is stuck [closed]
  3. Cannot modify header information [duplicate]
  4. Create the timestamp of an hour ago [duplicate]
  5. How to convert the json image url string into Bitmap image to display images in android application
  6. simple PHP to MYsql filtering
  7. i have stored array in database as a string how can retrieve that array?
  8. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  9. How can I do ‘insert if not exists’ in MySQL?
  10. How to use multiple databases in Laravel
  11. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  12. MySQL returns only one row
  13. Why doesn’t MySQL support millisecond / microsecond precision?
  14. Real escape string and PDO [duplicate]
  15. Populate a Drop down box from a mySQL table in PHP
  16. Run a mySQL query as a cron job?
  17. PHP PDO vs normal mysql_connect
  18. Can I create a database using PDO in PHP?
  19. Doing a while / loop to get 10 random results
  20. PHP PDO and MySQLi [duplicate]
  21. php file upload, how to restrict file upload type
  22. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  23. MySQL Error “Too many connections”
  24. Warning: mysql_num_rows() expects parameter 1 to be resource, object given [duplicate]
  25. Error 1148 MySQL The used command is not allowed with this MySQL version
  26. MySQL error when inserting data containing apostrophes (single quotes)?
  27. Connect to remote MySQL server with SSL from PHP
  28. Using MySQL’s TIMESTAMP vs storing timestamps directly
  29. how to execute mysql command DELIMITER
  30. PDO and MySQL ‘between’

Leave a Comment