Reader small image

You're reading from  Sphinx Search Beginner's Guide

Product typeBook
Published inMar 2011
Reading LevelIntermediate
Publisher
ISBN-139781849512541
Edition1st Edition
Languages
Right arrow
Author (1)
Abbas Ali
Abbas Ali
author image
Abbas Ali

Abbas Ali has over 15 years of experience in Web Development and is a Zend Certified PHP 5 Engineer. A Mechanical Engineer by education, Abbas turned to software development just after finishing his engineering degree. He is a member of the core development team for the Coppermine Photo Gallery, an open source project which is one of the most popular photo gallery applications in the world. Fascinated with both machines and knowledge, Abbas is always learning new programming techniques and technologies. Amongst various technologies, some of his favorites are Laravel, VueJS, and Sphinx. He got acquainted with Sphinx in 2009 and has been using it in most of his commercial projects ever since. He loves open source and believes in contributing back to the community. Abbas is married to Tasneem and has two daughters, Munira and Zahra. He has lived in Nagpur (India) all his life and is in no rush to move to any other city in the world. In his free time he loves to watch movies and television. He is also an amateur photographer and cricketer. Abbas founded Ranium Systems, a web and mobile development company in 2012 and is currently working as its Chief Executive Officer. The company specializes in development of enterprise level, high performance and scalable web and mobile applications
Read more about Abbas Ali

Right arrow

Time for action - adding code to save feed


  1. 1. Add the code to save form data in /path/to/webroot/feeds/add.php as shown in the following highlighted code:

    <?php
    /**
    * File: /path/to/webroot/feeds/add.php
    */
    include('init.php');
    // If we have data in POST then get it from there else initialize
    // to empty strings
    $viewVars['name'] = !empty($_POST['name']) ? $_POST['name'] : '';
    $viewVars['url'] = !empty($_POST['url']) ? $_POST['url'] : '';
    // Check if form is submitted and if we have a feed name and url
    // then save the data
    if (!empty($_POST['name']) && !empty($_POST['url'])) {
    // First check if the feed being added is already in our database
    $stmt = $dbh->prepare("SELECT id FROM feeds WHERE url = :url");
    $stmt->bindParam(':url', strip_tags(
    $viewVars['url']),
    PDO::PARAM_STR);
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    // If this is not a duplicate item then only add it
    if (empty($result)) {
    $stmt = $dbh->prepare("INSERT INTO feeds SET name = ...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Sphinx Search Beginner's Guide
Published in: Mar 2011Publisher: ISBN-13: 9781849512541

Author (1)

author image
Abbas Ali

Abbas Ali has over 15 years of experience in Web Development and is a Zend Certified PHP 5 Engineer. A Mechanical Engineer by education, Abbas turned to software development just after finishing his engineering degree. He is a member of the core development team for the Coppermine Photo Gallery, an open source project which is one of the most popular photo gallery applications in the world. Fascinated with both machines and knowledge, Abbas is always learning new programming techniques and technologies. Amongst various technologies, some of his favorites are Laravel, VueJS, and Sphinx. He got acquainted with Sphinx in 2009 and has been using it in most of his commercial projects ever since. He loves open source and believes in contributing back to the community. Abbas is married to Tasneem and has two daughters, Munira and Zahra. He has lived in Nagpur (India) all his life and is in no rush to move to any other city in the world. In his free time he loves to watch movies and television. He is also an amateur photographer and cricketer. Abbas founded Ranium Systems, a web and mobile development company in 2012 and is currently working as its Chief Executive Officer. The company specializes in development of enterprise level, high performance and scalable web and mobile applications
Read more about Abbas Ali