Guest User

Untitled

a guest
Feb 13th, 2019
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.63 KB | None | 0 0
  1. <script>
  2. $(function() {
  3. $(“#datepicker”).datepicker({
  4. changeMonth: true,
  5. changeYear: true,
  6.  
  7. beforeShowDay: // need help here!
  8.  
  9. onSelect: function(selectedDate) {
  10. var mydate;
  11. fecha = $(“#datepicker”).attr(“value”);
  12. $.ajax({
  13. type: “GET”,
  14. url: “news.php”,
  15. data: ‘datepicker=’+mydate,
  16. success: function(data) {
  17. $(‘#result’).html(data);
  18. }
  19. });
  20. }
  21.  
  22. });
  23. });
  24. </script>
  25.  
  26. <?php
  27.  
  28. $Host = "localhost";
  29. $User = "root";
  30. $Password = "";
  31. $Base = "mydatabase";
  32.  
  33.  
  34. $Link = mysql_connect($Host, $User, $Password) or die("error");
  35.  
  36.  
  37. $db = mysql_select_db($Base) or die("Ha fallado la seleccion de la base de datos");
  38.  
  39. $return_arr = array();
  40.  
  41. $fetch = mysql_query("SELECT id, mydate, text FROM news");
  42.  
  43. while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
  44. $row_array['id'] = $row['id'];
  45. $row_array['mydate'] = $row['mydate'];
  46. $row_array['text'] = $row['text'];
  47.  
  48. array_push($return_arr,$row_array);
  49. }
  50.  
  51. echo json_encode($return_arr);
  52. ?>
  53.  
  54. $date=date in database;
  55. $newdate=explode("-",$date);
  56.  
  57. $row['date']=$newdate[0];
  58. $row['month']=$newdate[1];
  59. $row['year']=$newdate[2];
  60.  
  61. $.ajax({
  62. type: “GET”,
  63. url: “news.php”,
  64. data: ‘datepicker=’+mydate,
  65. success: function(data) {
  66. var newdata=$.parseJSON[data];
  67.  
  68. //use a loop foreach (datepicker.date as date)
  69. // if keyexixts(newdata);
  70. // $(this).css("whatever you want");
  71.  
  72. // this is not a exact loop you should do something like that
  73. //change all css using a ajax call
  74. }
  75.  
  76. <script type="text/javascript">
  77. var daysData = <?= json_encode($news) ?>; // here you convert your array from PHP to JS
  78. $(function() {
  79. $('#your_date_picker').datepicker({
  80. showButtonPanel: true,
  81. dateFormat: 'dd/mm/yy',
  82. numberOfMonths: 3,
  83. regional: 'es',
  84. onSelect: function(dateText, inst) {
  85. var url = '<?=$url_to_go?>/';
  86. $(location).attr('href', url + dateText); // I use the select event to do a redirect
  87. },
  88. beforeShowDay: function(date) { // date is the day you are formatting, on a DateTime JS object
  89. //alert( date.getFullYear() + '-' + date.getMonth() + '-' + date.getDay() );
  90. var year = date.getFullYear();
  91. // JS returns months from 0 to 11
  92. var month = date.getMonth() + 1;
  93. var day = date.getDate();
  94. var daySettings = new Array(); // day settings are the settings for the DatePicker plugin to apply to that day's cell // default settings
  95. daySettings[0] = true; // show the day
  96. daySettings[1] = 'day_green'; // default css class
  97. daySettings[2] = ''; // default tooltip
  98. if(typeof daysData[year] != 'undefined'){
  99. if(typeof daysData[year][month] != 'undefined'){
  100. if(typeof daysData[year][month][day] != 'undefined'){
  101. dayData = daysData[year][month][day];
  102. //alert( year + '-' + month + '-' + day + '-' + dayType);
  103. if (dayData['news'] == true){
  104. daySettings[1] = 'day_red';
  105. }
  106. }
  107. }
  108. }
  109. return daySettings;
  110. }
  111. });</script>
  112.  
  113. while($row = mysql_fetch_array($fetch, MYSQL_ASSOC)){
  114. $news[$row['year']][$row['month']][$row['day']] = array('news' => 1);
  115. }
  116.  
  117. <?php
  118. // local
  119. $Host = "localhost";
  120. $User = "root";
  121. $Password = "";
  122. $Base = "mybase";
  123.  
  124. $Link = mysql_connect($Host, $User, $Password) or die("error");
  125.  
  126. $db = mysql_select_db($Base) or die("error");
  127.  
  128. $fetch = mysql_query("SELECT * FROM news");
  129.  
  130. while($row = mysql_fetch_array($fetch, MYSQL_ASSOC)){
  131. $news[$row['year']][$row['month']][$row['day']] = array('news' => 1);
  132. }
  133.  
  134. ?>
Add Comment
Please, Sign In to add comment