PHP MYSQL Date Range Search with Jquery Datepicker -


i've tried few different solutions problem can't seem find 1 works. trying search date range datetime field in mysql database. here's jquery before form:

  <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>

heres simple form:

<form method="post" action="search.php"> <p>select date range: </p><label style="color:#fff;" for="from">from</label> from:<input type="text" id="from" name="from" /> <label style="color:#fff;" for="to" >to</label> to:<input type="text" id="to" name="to" /> <input name="export" type="submit" value="search" /> </form>

and here's sql statement:

        $hostname = ""; //set server/hostname     $dbusername = ""; //set database username     $dbname = ""; //set database name     $dbpassword = ""; //set database username     $link = mysqli_connect($hostname, $dbusername, $dbpassword, $dbname);      if (!$link) {      die('connect error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());      }  $sql = "select * log call_date >= date_format('" . $from . "', '%y%m%d') , call_date <=  date_format('" . $to . "', '%y%m%d')"; //$sql = "select * log call_date >= '".date("y-m-d", strtotime($from))."' , call_date <=  '".date("y-m-d", strtotime($to))."'";    //$sql = "select * log call_date >= '$from' , 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']; }

...then outputting results. can see tried few different sql statements i've commented out. know can connect database, know getting dates in format yyyy-mm-dd, , datetime field has format yyyy-mm-dd hh:mm:ss. appreciated. thank you.

change 

   $sql = "select * log call_date >= date_format('" . $from . "', '%y%m%d') , call_date <=  date_format('" . $to . "', '%y%m%d')";

to 

   $sql = "select * log call_date >= date_format('" . $from . "', '%y/%m/%d') , call_date <=  date_format('" . $to . "', '%y/%m/%d')";

Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more