title: How do I get events to show up in calendar using php sql query?
body: <p>Edit* I have found the issue. The date is being converted to this format: <strong>Mar 1 2018 12:00AM</strong> I have posted my solution below.</p>
  
  <p>My query returns the appropriate results, however none of the events are showing up on the calendar. </p>
  
  <p>Here's what the data looks like in SQL in case there's format issues I don't know about:</p>
  
  <p><strong>Name:</strong> Test</p>
  
  <p><strong>Start:</strong> 2009-09-23 00:00:00.000</p>
  
  <p><strong>End:</strong>  2010-04-05 00:00:00.000</p>
  
  <p>PHP:</p>
  
  <pre><code>$query = mssql_query("select [NAME], [Start], [End] from [database] where [Name] = 'Test'");
  
         $result = array();
  
          if (mssql_num_rows($query)) {
  
              while ($row = mssql_fetch_assoc($query)) {
  
                  $result[] = $row;
              }
          } 
  
          $data = array();
  
          foreach($result as $i =&gt; $item)
          {
           $data[] = array(
            'title'   =&gt; $item["Name"],
            'start'   =&gt; $item["Start"],
            'end'   =&gt; $item["End"]
           );
          }
  </code></pre>
  
  <p>JSON/JS:</p>
  
  <pre><code>&lt;script type="text/javascript"&gt;
   $(document).ready(function() {
   var calendar = $('#calendar').fullCalendar({
   editable:true,
   header:{
   left: 'prev,next today',
    center: 'title',
    right: 'month,agendaWeek,agendaDay,listMonth'
  },
  events: &lt;?php echo json_encode($data); ?&gt; ,
  selectable:true,
  selectHelper:true,
  
  })
  
  });
  &lt;/script&gt;
  </code></pre>