mae48

okay sir..thanks

Oww.. I’m sorry @matthew ,,yeah, I’m using a plugin…is there any tendency that the plugin author can access their plugin using the customer site?

I got it Andrew….I changed all the database of my m.abc.com, and it works like charm….thanks..

Hi Andrew, I created a new subdomain…What is the best solution on this???

Thank you so much

Yes sir @doubleedesign … but I want to make my own function out of it..Is that possible?

Thank you @bcworkz and @catacaustic for your response..I’m so sorry for this post…

Hi catacausticActually I installed this plugin called profi search filter..and I want to edit some functionalities to it…The provider gave me an addon for the datepicker…

Here is the addon…

addon.php
add_action( ‘wp_enqueue_scripts’, ‘psf_addon_scripts’ );
function psf_addon_scripts(){

wp_enqueue_script( ‘jquery-touch’, ‘//cdnjs.cloudflare.com/ajax/libs/jqueryui-touch-punch/0.2.3/jquery.ui.touch-punch.min.js’, array( ‘jquery-ui-slider’ ) );

wp_enqueue_script( ‘sf-date’, plugins_url( ‘/script.js’, __FILE__ ), array( ‘sf-script’, ‘jquery-ui-datepicker’ ) );

wp_enqueue_style( ‘sf-ui-datepicker’, ‘//code.jquery.com/ui/1.9.2/themes/base/jquery-ui.css’ );
}

script.php
jQuery( document ).ready( function(){

var data_id = 2;
var data_id_2 = 3;

var format = ‘mm-dd-yy’;
jQuery( ‘fieldset[data-id=”‘ + data_id + ‘”] input’ ).datepicker({ dateFormat: format });
jQuery( ‘fieldset[data-id=”‘ + data_id_2 + ‘”] input’ ).datepicker({ dateFormat: format });
});

and I want this code to be integrated on my code..
<script type=”text/javascript” language=”javascript”>
jQuery(function() {
jQuery( “#from” ).datepicker({
defaultDate: “+1w”,
changeMonth: true,
numberOfMonths: 1,
dateFormat: “yy-mm-dd”,
onClose: function( selectedDate ) {
$( “#to” ).datepicker( “option”, “minDate”, selectedDate );
}
});
jQuery( “#to” ).datepicker({
defaultDate: “+1w”,
changeMonth: true,
numberOfMonths: 1,
dateFormat: “yy-mm-dd”,
onClose: function( selectedDate ) {
jQuery( “#from” ).datepicker( “option”, “maxDate”, selectedDate );
}
});
});
</script>

with my own datatable: I don’t know how to call them on wordpress…

$sql = “SELECT * FROM log WHERE call_date >= DATE_FORMAT(‘” . $from . “‘, ‘%Y/%m/%d’) AND call_date <= DATE_FORMAT(‘” . $to . “‘, ‘%Y/%m/%d’)”;

//$sql = “SELECT * FROM log WHERE call_date >= ‘”.date(“Y-m-d”, strtotime($from)).”‘ AND call_date <= ‘”.date(“Y-m-d”, strtotime($to)).”‘”;

//$sql = “SELECT * FROM log WHERE call_date >= ‘$from’ AND call_date <= ‘$to'”;
$result = mysqli_query($link, $sql, MYSQLI_STORE_RESULT);
while($row = $result->fetch_assoc()){
$name= $row[‘name’];
$disposition = $row[‘did_id’];
$date = $row[‘call_date’];
}

How can I do that catacaustic?

Can you help me with this??

My only problem is the “from date” and “to date”…I only got my product name but not in my range dates…I have my own table to get that dates…Can you help me?

oops, let me rephrase it. How can I search only for simple products?

add_action( ‘after_setup_theme’, ‘dazzling_setup’ );
function exclude_category( $query ) {
if ( $query->is_search() && $query->is_main_query() ) {
$query->set( ‘cat’, ‘71,6,69,68,73,75,74’ );
}
}
add_action( ‘pre_get_posts’, ‘exclude_category’ );

is this the correct setup??

Thank you so much for your response bcworks…I have a solution to my problem..I used search all plugin to search the products I need. But I have several problems on my search form, I think I will search the solution on the internet or else I will go back here and ask question again…
??

Thanks for your response anyway…

This is actually how I call it….I don’t know if I’m doing the right syntax.

<?php

require_once( $_SERVER[‘DOCUMENT_ROOT’] . ‘/wp-load.php’ );

global $wpdb;

$sql = “SELECT * FROM rates”;

if(isset($_POST[‘destination’])){
$search_term = mysql_real_escape_string($_POST[‘destination’]);
$sql .=”WHERE location = ‘{search_term}'”;
$sql .=” OR level ='{search_term}’ “;

$query = mysql_query($sql) or die(mysql_error());
}
echo “your search term” . $query;
?>

Hi bcworkz, thanks for your response…what do you mean by that??That code I wrote in there is a sample to call from phpmyadmin, that’s not actually the code to “search form submit” from my own created table in wp database.

Where is your results.php placed? Theme folder? And it contains the above code? How is this page requested and/or where does your form submit to?

I placed my result.php on my theme folder and yeah, it contains the code stated above to test if my result.php calls phpmyadmin. My form submits to results.php.

here is my codes: https://drive.google.com/folderview?id=0B0Je1_NFqcfXNUdPMU1Udm9qRnM&usp=sharing

…

Hope to hear from you soon..!