Skip to content

Latest commit

 

History

History
97 lines (86 loc) · 2.31 KB

README.md

File metadata and controls

97 lines (86 loc) · 2.31 KB

live-search-php-ajax

Contains simple search form which searches and displays the rows from the database.

Written in simple PHP and ajax suitable for smaller applications

How to use?

  • Copy the following line to the page you are working on

<input type="text" id="ls_search_text" placeholder="Type any keyword to search"/>

  • Copy the folder live_search_assets to your project folder.
  • Include the following lines in the page where you want the search bar

<script src="live_search_assets/js/ls.js"></script>

<link href="live_search_assets/css/ls.css" rel="stylesheet" />

  • Edit the config.php file in the live-search-assets folder according to your needs.

config.php usage

Name Type Required Description
servername String Yes Database host. Ex.localhost.
username String Yes MySQL database username.
password String Yes MySQL database password.
db_name String Yes MySQL database name.
table_name String Yes MySQL database tablename.
search_columns array optional Enter the name of the columns to be searched (or) Leave as it is for searching all columns.Separate columns by comma's enclosed within quotes Ex.==> $search_columns=array('eid','ename')
output_columns array optional Enter the name of the columns to be displayed (or) Leave as it is for displaying all columns.Separate columns by comma's enclosed within quotes Ex.==> $output_columns=array('eid','ename')
output_columns_name array optional Name of the output columns Ex.==>$output_columns_name=array('Employee ID','Employee Name'); or leave it empty for using the db columns name
use_sno Boolean Yes Displays the serial number. Make it to false if you dont need serial numbers

Browser Support

  • IE 8+
  • Chrome
  • Firefox
  • Opera
  • Safari

License

MIT License