Php-mysql Course

This is a completly Free and Open Source Site Search engine script that uses MySQL to store your website's indexed pages, to create and add Search Functionality to Your Web Site. It is build with PHP and JavaScript (search results are loaded via Ajax).
The search system combine MySQL full text with SQL regexp, and words weight according to their location in the HTML elements, to determine the relevance of the search results.
- Can be included in any web site to create search engine for your website.

• You can download the script from this link: Download SSEP - Version 1.9 (81 KB).

• To test this Site Search Engine script, click: Demo
For comments, questions, or any issue related to this application, write on Forum, in the "Scripts from Website" category.

SSEP Features

- Intuitive and easy to use Admin Panel, with a simple adminstration interface, and info mark description to each function.
- Suports both PDO and MySQLi for accessing MySQL databases in PHP.
- Crawl and index web site pages automatically (can follow redirects).
- Option to Include Subdomains.
- Options to control indexed URLs: by link's Depth, by Maximum number of URLs to crawl, by URL Must-Include, or Must-Exclude "strings".
- Crawl and index the links in the XML Sitemap.
- You can register to Crawl and Index multiple domains.
- Stop words excluded from searches.
- Option to remove parts of the page / HTML elements from being indexed.
- Keeps in the indexed content the text added in the "alt" attribute of the <img> tags (which are outside the removed parts).
- Option to Build XML Sitemap with the indexed pages.
- Posibility to Crawl and index domain automatically with Cron Jobs.
- Easy to translate in other languages.
- It can work with characters with diacritics.
- The Search results are loaded via Ajax (without refreshing the search page). This option can also be disabled.
- Paginated serch results.
- Option to choose Infinite or Standard pagination.
- Search Suggestions.
- List with last and top searches.
- The search results are ordered by a Score calculated according to the HTML elements in which the searched word is located (Title, Description, H1, Strong, ... and other tags, eaven the URL page address).
- Cache files system for the search results.
- Search Page with valid HTML5 format, and Responsive design (working on Mobile Device too).
- CSS and HTML template easy to customize it, to add new elements in search page, and to change the design.

Requirements

- PHP 5.4+ (with cUrl enabled)
- MySQL 5.2+
- Modern Browser with JavaScript enabled (Mozilla-Firefox, Google-Chrome, Opera, Internet-Explorer 9+).

Usage

1. Download the SSEP - Site Search Engine PHP-Ajax (from the link above), and extract the archive.
2. Open the "readme.html" file (in the "ssep/" folder) and follow the instructions.
- You just have to edit the config.php file (in the "ssep/php/" folder).

Screenshoots

- Click on images:
Admin Panel
SSEP - DashboardSSEP - Dashboard
SSEP - Crawl and IndexSSEP - Crawl and Index
SSEP - Only IndexationSSEP - Only Indexation
SSEP - Advanced SettingsSSEP - Advanced Settings
Search Page
Search PageSearch Page
Search PageSearch Suggestions
Search Page - Mobile 1Search Page - Mobile 1
Search Page - Mobile 2Search Page - Mobile 2
• This script is Free, you can use, modify and publish it freely.

Changes Log

- (v: 1.9) Fixed SSEP to set the base path correctly, and it works with omission of trailing slashes.
- (v: 1.8) Search words can contain characters with diacritics.
- (v: 1.7) Link to Log-Out.
- (v: 1.6) New Feature: Php file that can be used to index registered domain automatically with Cron Jobs.
- (v: 1.5) New Feature: Option to include Subdomains.
- (v: 1.4) SSEP checks PHP version. Posibility to create the main tables by accesing a specified URL (see in "readme.php").
- (v: 1.3) Added Search Suggestions feature.
- (v: 1.2) Added list of files (extensions) that must be excluded from indexing.

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which HTML element can be used to embed a SWF flash content?
<object> <div> <script>
<object type="application/x-shockwave-flash" data="file.swf" width="500" height="250">
 <param name="src" value="file.swf" />
 Your browser not support SWF.
</object>
Which CSS pseudo-class adds a style to an input form field that has keyboard input focus?
:active :focus :hover
input:focus {
  background-color: #88fe88;
}
Click on the instruction which converts a JSON string into a JavaScript object.
JSON.stringify(javascript_object) object.toString() JSON.parse(json_string)
var jsnstr = '{"url": "http://coursesweb.net/", "title": "Web Development Courses"}';
var obj = JSON.parse(jsnstr);
alert(obj.url);
Indicate the PHP function which can be used to create or write a file on server.
fopen() file_put_contents() file_get_contents()
if (file_put_contents("file.txt", "content")) echo "The file was created";
else echo "The file can not be created";
SSEP - Site Search Engine PHP-Ajax

Last accessed pages

  1. JavaScript Course - Free lessons (31647)
  2. Volume and Surface Area Calculator for 3D objects (11276)
  3. Using v-model in form input fields (1051)
  4. jQuery UI draggable - Drag elements (11445)
  5. Display data from PHP Array, or MySQL in HTML table (26980)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (310)
  2. The Mastery of Love (48)
  3. CSS cursor property - Custom Cursors (36)
  4. Read Excel file data in PHP - PhpExcelReader (35)
  5. PHP-MySQL free course, online tutorials PHP MySQL code (31)