How to work with Add-To-Cart functionality?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aveeva
    New Member
    • Apr 2019
    • 33

    #1

    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

    Code:
    <?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

    Code:
    <?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:

Working...