Created
June 18, 2019 11:29
-
-
Save aveevan/f14299f12e12aad63781186262c41672 to your computer and use it in GitHub Desktop.
Audio File - Add to Cart
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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;"> | |
Id : '. $row['voice_id'].' <br /> | |
Name : '. $row['voice_name'].' <br /> | |
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 type="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; | |
} | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment