Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script>
- $(function() {
- $(“#datepicker”).datepicker({
- changeMonth: true,
- changeYear: true,
- beforeShowDay: // need help here!
- onSelect: function(selectedDate) {
- var mydate;
- fecha = $(“#datepicker”).attr(“value”);
- $.ajax({
- type: “GET”,
- url: “news.php”,
- data: ‘datepicker=’+mydate,
- success: function(data) {
- $(‘#result’).html(data);
- }
- });
- }
- });
- });
- </script>
- <?php
- $Host = "localhost";
- $User = "root";
- $Password = "";
- $Base = "mydatabase";
- $Link = mysql_connect($Host, $User, $Password) or die("error");
- $db = mysql_select_db($Base) or die("Ha fallado la seleccion de la base de datos");
- $return_arr = array();
- $fetch = mysql_query("SELECT id, mydate, text FROM news");
- while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
- $row_array['id'] = $row['id'];
- $row_array['mydate'] = $row['mydate'];
- $row_array['text'] = $row['text'];
- array_push($return_arr,$row_array);
- }
- echo json_encode($return_arr);
- ?>
- $date=date in database;
- $newdate=explode("-",$date);
- $row['date']=$newdate[0];
- $row['month']=$newdate[1];
- $row['year']=$newdate[2];
- $.ajax({
- type: “GET”,
- url: “news.php”,
- data: ‘datepicker=’+mydate,
- success: function(data) {
- var newdata=$.parseJSON[data];
- //use a loop foreach (datepicker.date as date)
- // if keyexixts(newdata);
- // $(this).css("whatever you want");
- // this is not a exact loop you should do something like that
- //change all css using a ajax call
- }
- <script type="text/javascript">
- var daysData = <?= json_encode($news) ?>; // here you convert your array from PHP to JS
- $(function() {
- $('#your_date_picker').datepicker({
- showButtonPanel: true,
- dateFormat: 'dd/mm/yy',
- numberOfMonths: 3,
- regional: 'es',
- onSelect: function(dateText, inst) {
- var url = '<?=$url_to_go?>/';
- $(location).attr('href', url + dateText); // I use the select event to do a redirect
- },
- beforeShowDay: function(date) { // date is the day you are formatting, on a DateTime JS object
- //alert( date.getFullYear() + '-' + date.getMonth() + '-' + date.getDay() );
- var year = date.getFullYear();
- // JS returns months from 0 to 11
- var month = date.getMonth() + 1;
- var day = date.getDate();
- var daySettings = new Array(); // day settings are the settings for the DatePicker plugin to apply to that day's cell // default settings
- daySettings[0] = true; // show the day
- daySettings[1] = 'day_green'; // default css class
- daySettings[2] = ''; // default tooltip
- if(typeof daysData[year] != 'undefined'){
- if(typeof daysData[year][month] != 'undefined'){
- if(typeof daysData[year][month][day] != 'undefined'){
- dayData = daysData[year][month][day];
- //alert( year + '-' + month + '-' + day + '-' + dayType);
- if (dayData['news'] == true){
- daySettings[1] = 'day_red';
- }
- }
- }
- }
- return daySettings;
- }
- });</script>
- while($row = mysql_fetch_array($fetch, MYSQL_ASSOC)){
- $news[$row['year']][$row['month']][$row['day']] = array('news' => 1);
- }
- <?php
- // local
- $Host = "localhost";
- $User = "root";
- $Password = "";
- $Base = "mybase";
- $Link = mysql_connect($Host, $User, $Password) or die("error");
- $db = mysql_select_db($Base) or die("error");
- $fetch = mysql_query("SELECT * FROM news");
- while($row = mysql_fetch_array($fetch, MYSQL_ASSOC)){
- $news[$row['year']][$row['month']][$row['day']] = array('news' => 1);
- }
- ?>
Add Comment
Please, Sign In to add comment