How to work with Add-To-Cart functionality?

How to work with Add-To-Cart functionality?
My code about filterable audio searching, here how can i add Add-To-Cart functionality?

code :

index.php

Expand|Select|Wrap|Line Numbers

 <?php 
 
//index.php
 
include('database_connection.php');
 
?>
 
<!DOCTYPE html>

<html lang="en">
 
<head>
 
    <meta charset="utf-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1">

    <meta name="description" content="">

    <meta name="author" content="">
 
    <title>Voice Repository</title>
 
    <script src="js/jquery-1.10.2.min.js"></script>

    <script src="js/jquery-ui.js"></script>

    <script src="js/bootstrap.min.js"></script>

    <link rel="stylesheet" href="css/bootstrap.min.css">

    <link href = "css/jquery-ui.css" rel = "stylesheet">

    <!-- Custom CSS -->

    <link href="css/style.css" rel="stylesheet">

</head>
 
<body>

    <!-- Page Content -->

    <div class="container">

        <div class="row">

            <br />

            <div class="col-md-12">

                <h2 align="center">Voice Repository Bank</h2>

            </div>

            <div class="col-md-3">
 
                <!-- Price -->

                <!-- <div class="list-group">

                    <h3>Price</h3>

                    <input type="hidden" id="hidden_minimum_price" value="0" />

                    <input type="hidden" id="hidden_maximum_price" value="65000" />

                    <p id="price_show">1000 - 65000</p>

                    <div id="price_range"></div>

                </div> -->
 
                <!-- Languages  -->

                <div class="list-group">

                    <h3>Languages</h3>

                    <?php

                    $query = "

                    SELECT DISTINCT(voice_languages) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_languages DESC

                    ";

                    $statement = $connect->prepare($query);

                    $statement->execute();

                    $result = $statement->fetchAll();

                    foreach($result as $row)

                    {

                    ?>

                    <div class="list-group-item checkbox">

                        <label><input type="checkbox" class="common_selector languages" value="<?php echo $row['voice_languages']; ?>"  > <?php echo $row['voice_languages']; ?> </label>

                    </div>

                    <?php

                    }

                    ?>    

                </div>
 
                <!-- Genres  -->

                <div class="list-group">

                    <h3>Genres</h3>

                    <?php
 
                    $query = "

                    SELECT DISTINCT(voice_genres) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_genres DESC

                    ";

                    $statement = $connect->prepare($query);

                    $statement->execute();

                    $result = $statement->fetchAll();

                    foreach($result as $row)

                    {

                    ?>

                    <div class="list-group-item checkbox">

                        <label><input type="checkbox" class="common_selector genres" value="<?php echo $row['voice_genres']; ?>" > <?php echo $row['voice_genres']; ?> </label>

                    </div>

                    <?php    

                    }
 
                    ?>

                </div>
 
                <!-- Voice Modulation -->

                <div class="list-group">

                    <h3>Voice Modulation</h3>

                    <?php

                    $query = "

                    SELECT DISTINCT(voice_voice_modulation) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_voice_modulation DESC

                    ";

                    $statement = $connect->prepare($query);

                    $statement->execute();

                    $result = $statement->fetchAll();

                    foreach($result as $row)

                    {

                    ?>

                    <div class="list-group-item checkbox">

                        <label><input type="checkbox" class="common_selector voice_modulation" value="<?php echo $row['voice_voice_modulation']; ?>"  > <?php echo $row['voice_voice_modulation']; ?> </label>

                    </div>

                    <?php

                    }

                    ?>    

                </div> 

                <!-- Gender  -->

                <div class="list-group">

                    <h3>Gender</h3>

                    <div style="height: 180px; overflow-y: auto; overflow-x: hidden;">

                    <?php
 
                    $query = "SELECT DISTINCT(voice_gender) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_id DESC";

                    $statement = $connect->prepare($query);

                    $statement->execute();

                    $result = $statement->fetchAll();

                    foreach($result as $row)

                    {

                    ?>

                    <div class="list-group-item checkbox">

                        <label><input type="checkbox" class="common_selector gender" value="<?php echo $row['voice_gender']; ?>"  > <?php echo $row['voice_gender']; ?></label>

                    </div>

                    <?php

                    }
 
                    ?>

                    </div>

                </div>
 
                <!-- Jingle Moods -->

                <div class="list-group">

                    <h3>Jingle Moods</h3>

                    <?php

                    $query = "

                    SELECT DISTINCT(voice_jingle_moods) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_jingle_moods DESC

                    ";

                    $statement = $connect->prepare($query);

                    $statement->execute();

                    $result = $statement->fetchAll();

                    foreach($result as $row)

                    {

                    ?>

                    <div class="list-group-item checkbox">

                        <label><input type="checkbox" class="common_selector jingle_moods" value="<?php echo $row['voice_jingle_moods']; ?>"  > <?php echo $row['voice_jingle_moods']; ?> </label>

                    </div>

                    <?php

                    }

                    ?>    

                </div>
 
                <!-- IVR -->

                <div class="list-group">

                    <h3>Ivr</h3>

                    <?php

                    $query = "

                    SELECT DISTINCT(voice_ivr) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_ivr DESC

                    ";

                    $statement = $connect->prepare($query);

                    $statement->execute();

                    $result = $statement->fetchAll();

                    foreach($result as $row)

                    {

                    ?>

                    <div class="list-group-item checkbox">

                        <label><input type="checkbox" class="common_selector ivr" value="<?php echo $row['voice_ivr']; ?>"  > <?php echo $row['voice_ivr']; ?> </label>

                    </div>

                    <?php

                    }

                    ?>    

                </div>

            </div>
 
            <div class="col-md-9">

                <br />

                <div class="row filter_data">
 
                </div>

            </div>

        </div>
 
    </div>

<style>

#loading

{

    text-align:center; 

    background: url('loader.gif') no-repeat center; 

    height: 150px;

}

</style>
 
<script>

$(document).ready(function(){
 
    filter_data();
 
    function filter_data()

    {

        $('.filter_data').html('<div id="loading" style="" ></div>');

        var action = 'fetch_data';
 
        // var minimum_price = $('#hidden_minimum_price').val();

        // var maximum_price = $('#hidden_maximum_price').val();
 
        var gender = get_filter('gender');

        var genres = get_filter('genres');

        var voice_modulation = get_filter('voice_modulation');

        var languages = get_filter('languages');

        var jingle_moods = get_filter('jingle_moods');

        var ivr = get_filter('ivr');

        $.ajax({

            url:"fetch_data.php",

            method:"POST",

            data:

            {

                action:action, 

                // minimum_price:minimum_price, 

                // maximum_price:maximum_price,

                gender:gender,

                genres:genres, 

                voice_modulation:voice_modulation,

                languages:languages,

                jingle_moods:jingle_moods,

                ivr:ivr

            },

                success:function(data)

                {

                $('.filter_data').html(data);

                }

        });

    }
 
    function get_filter(class_name)

    {

        var filter = [];

        $('.'+class_name+':checked').each(function(){

            filter.push($(this).val());

        });

        return filter;

    }
 
    $('.common_selector').click(function(){

        filter_data();

    });
 
    // $('#price_range').slider({

    //     range:true,

    //     min:1000,

    //     max:65000,

    //     values:[1000, 65000],

    //     step:500,

    //     stop:function(event, ui)

    //     {

    //         $('#price_show').html(ui.values[0] + ' - ' + ui.values[1]);

    //         $('#hidden_minimum_price').val(ui.values[0]);

    //         $('#hidden_maximum_price').val(ui.values[1]);

    //         filter_data();

    //     }

    // });
 
});

</script>

</body>

</html>

and my

data fetching file,

data_fetch.php

Expand|Select|Wrap|Line Numbers

 <?php
 
//fetch_data.php
 
include('database_connection.php');
 
if(isset($_POST["action"]))

{

    $query = "

        SELECT * FROM voice_bank_data WHERE voice_status = '1'

    ";
 
    // if(isset($_POST["minimum_price"], $_POST["maximum_price"]) && !empty($_POST["minimum_price"]) && !empty($_POST["maximum_price"]))

    // {

    //     $query .= "

    //      AND product_price BETWEEN '".$_POST["minimum_price"]."' AND '".$_POST["maximum_price"]."'

    //     ";

    // }
 
    // Gender

    if(isset($_POST["gender"]))

    {

        $gender_filter = implode("','", $_POST["gender"]);

        $query .= "

         AND voice_gender IN('".$gender_filter."')

        ";

    }
 
    // Genres

    if(isset($_POST["genres"]))

    {

        $genres_filter = implode("','", $_POST["genres"]);

        $query .= "

         AND voice_genres IN('".$genres_filter."')

        ";

    }
 
    // Voice Modulation

    if(isset($_POST["voice_modulation"]))

    {

        $voice_modulation_filter = implode("','", $_POST["voice_modulation"]);

        $query .= "

         AND voice_voice_modulation IN('".$voice_modulation_filter."')

        ";

    }
 
    // Languages

    if(isset($_POST["languages"]))

    {

        $languages_filter = implode("','", $_POST["languages"]);

        $query .= "

         AND voice_languages IN('".$languages_filter."')

        ";

    }
 
    // Jingle Moods

    if(isset($_POST["jingle_moods"]))

    {

        $jingle_moods_filter = implode("','", $_POST["jingle_moods"]);

        $query .= "

         AND voice_jingle_moods IN('".$jingle_moods_filter."')

        ";

    }
 
    // IVR

    if(isset($_POST["ivr"]))

    {

        $ivr_filter = implode("','", $_POST["ivr"]);

        $query .= "

         AND voice_ivr IN('".$ivr_filter."')

        ";

    }
 
    $statement = $connect->prepare($query);

    $statement->execute();

    $result = $statement->fetchAll();

    $total_row = $statement->rowCount();

    $output = '';

    if($total_row > 0)

    {

        foreach($result as $row)

        {

            $output .= '

            <div class="col-sm-3 col-lg-4 col-md-3">

                <div style="border:1px solid #ccc; border-radius:5px; padding:10px; margin-bottom:16px; height:300px;">

                    <audio controls controlsList="nodownload" style="padding: 10px 10px 10px 10px;margin-left: -21px;">

                        <source src="audio_sample/'. $row['voice_audio_file'] .'" alt="" class="img-responsive">

                    </audio>

                    <p align="center"><strong> '. $row['voice_name'] .'</strong></p>
 
                    <p style="font-size: 12px;">

                    Gender              : '. $row['voice_gender'].' <br />

                    Genres               : '. $row['voice_genres'].' <br />

                    Voice Modulation  : '. $row['voice_voice_modulation'].' <br />

                    Languages          : '. $row['voice_languages'].' <br />

                    Jingle Moods      : '. $row['voice_jingle_moods'].' <br />

                    Ivr               : '. $row['voice_ivr'].' <br /> </p>

                    <button class="btn btn-primary" type="submit" style="padding: 5px 83px 5px 83px;"> Add to PlayList </button>

                </div>
 
            </div>

            ';

        } 

    }

    else 

    {

        $output = '<h3>No Data Found</h3>';

    }

    echo $output;

}

?>

How can i add add-to-cart functionality.

Note : In the cart just voice_id, voice_name, not necessary qty & price.

My current output:

Jun 10 '19 #1

Subscribe Post Reply

1104

Similar topics

Back button functionality

by: KK | last post by:

Hi, I am using history.go(-1) for implementing the back button functionality. Its working fine but with this exception. 1. The page which is having back button has some hyperlinks on it. ...

HTML / CSS

How does C work on non-unix?

by: Ryan M | last post by:

I've been programming for a while, but most of my experience is on unix. How do C compilers work on operating systems that weren't written in C? And that have no libc? Compiling C on unix seems...

C / C++

Server side functionality

by: Reetu | last post by:

Hi All, I have an html button on .aspx page. <INPUT class="sbttn" id="btnComplete0" onclick="onComplete ()" type="button" value="Mark Completed" name="btnComplete0"> When the user clicks...

ASP.NET

AddToCart, Refresh issue (form variables)

by: John | last post by:

I get the feeling this is a pretty classic problem, but I'm a bit of an uber newber. Apologies! Products page, user enters a quantity and clicks one of my "Add to Cart" buttons, which bubbles up...

ASP.NET

Protecting my work

by: Hogan's Goat | last post by:

OK, I've written a pretty cool little app that I think would be broadly interesting. Now I'd like to make money from it! Here are my options, as I see them: 1) Advertise it heavily, then sell...

Visual Basic .NET

Multiple Listboxes on page won't work...

by: sheldongold | last post by:

Hi, I'm coding in PHP4 and MYSQL4 and there is a teensy bit of JS in there as well. I'm haveing trouble with my dropdown lists as when there is more than one on the page it just says 'error on...

Javascript

Late Payment For Work

by: Wayne | last post by:

I have just experienced my first late paying client. By "late" I mean that the invoice is now almost 2 months overdue. I don't think that the client is maliciously withholding payment - rather...

Microsoft Access / VBA

create a GUI with drag and drop functionality for the user...

by: Bogus Exception | last post by:

Forgive me if this group is for the discussion of pure VB.NET language topics. My question may be more about add-on components to VB.NET that will allow the functionality I'm looking for. I'm very...

Visual Basic .NET

adding class functionality, nested scoping

by: jholg | last post by:

Hi, regarding automatically adding functionality to a class (basically taken from the cookbook recipee) and Python's lexical nested scoping I have a question wrt this code: #-----------------...

Python

How do *you* use Python in non-GUI work?

by: John Salerno | last post by:

Hey all. Just thought I'd ask a general question for my own interest. Every time I think of something I might do in Python, it usually involves creating a GUI interface, so I was wondering what kind...

Python

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General