Title: Calling data to database
Last modified: August 31, 2016

---

# Calling data to database

 *  [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/)
 * I have this addon in my plugin…And I customize one of the functionalities of 
   it..My problem is that, I can’t connect my date to my own table…Can someone send
   me the correct syntax??
    Here is my code: 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 }); });

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/#post-7263224)
 * jQuery, and JavaScript in general, can’t connect to your database by itself. 
   To do that you’d need to set up a PHP script that does all of the database processing,
   and use AJAX in your JavaScript to call that PHP file.
 * [http://codex.wordpress.org/AJAX_in_Plugins](http://codex.wordpress.org/AJAX_in_Plugins)
 *  Thread Starter [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/#post-7263247)
 * 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?
 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/#post-7263310)
 * How do you get the product name? The code that you’ve shown so far is only to
   set up a datePicker on an input field – it doesn’t have anything to do with getting
   or setting any data at all.
 *  Thread Starter [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/#post-7263323)
 * Hi **catacaustic**Actually 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’]; }
 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/#post-7263324)
 * Do you mean [this plugin](https://profisearchform.com/)?
 * If so, I’d ask for support form the vendor that you purchased it from. They’ll
   be able to tell you how to integrate your own parts in with their code. As that’s
   a [commercial plugin](https://codex.wordpress.org/Forum_Welcome#Commercial_Products),
   no one here knows how it works, or what it does internally as we can’t go and
   grab it from the plugins repository to have a look through it.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Calling data to database’ is closed to new replies.

## Tags

 * [call](https://wordpress.org/support/topic-tag/call/)
 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 5 replies
 * 2 participants
 * Last reply from: [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/calling-data-to-database/#post-7263324)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics