Web Development

<div class="row">
    <div class="col-md-12">
        <div id="ttpImageCarousel" class="carousel slide" data-ride="carousel">
            <div class="carousel-inner" role="listbox">
                <div class="carousel-item active">
                    <img class="d-block img-fluid" src="data:image/jpg;base64,[image data]" alt="" />

                    <div class="carousel-caption d-none d-md-block">
                        <span style="display:inline-block;">Image 1 of 4</span>
                    </div>
                </div>
                <div class="carousel-item">[image 2 of 4]</div>
                <div class="carousel-item">[image 3 of 4]</div>
                <div class="carousel-item">
                    <img class="d-block img-fluid" src="data:image/jpg;base64,[image data]" alt="" />
                    <div class="carousel-caption d-none d-md-block">
                            <span style="display:inline-block;">Image 4 of 4</span>
                    </div>
                </div>
            </div>
            <a class="carousel-control-prev" href="#carouselExampleControls" role="button" data-slide="prev">
                
                Previous
            </a>
            <a class="carousel-control-next" href="#carouselExampleControls" role="button" data-slide="next">
                
                Next
            </a>
        </div>
    </div>
</div>

<?php echo $map['javascript'];?>

<?php echo $map['mapdiv']

function googlemaps($serial)
	{
		
		$return=array();
		$query=$this->db->select('cycle_serial,cycle_19_INT,cycle_20_INT,cycle_21_INT,cycle_22_INT,cycle_23_INT,cycle_24_INT')->from('cycles')->where(array('cycle_serial'=>$serial))->limit(1)->order_by('cycle_timestamp','DESC')->get();
		
		if($query->num_rows()>0)
		{
			foreach($query->result_array() as $row)
			{
				array_push($return,$row);
			}
		}
		return $return;	
	}

function Googlemaps($serial)
	{
		// Load the library
			$this->load->library('googlemaps'); 
			$config['minifyJS'] = TRUE; //When adding lots of markers, overlays and other functionality to the map this JavaScript can get quite large so recommend that minify this code.
			//$config['cluster'] = TRUE; 
			$config['center'] =  '1600 Amphitheatre Parkway in Mountain View';//37.4419, -122.1419
			$config['zoom'] = '15';    		
																
		 //Activate the library configuration option $geocodeCaching by setting it to TRUE:
				$config['geocodeCaching'] = TRUE;
				 
		// Initialize our map. Here you can also pass in additional parameters for customising the map
				$this->googlemaps->initialize($config);
			

			$coords=$this->dashboard_model->googlemaps($serial);
			//Loop through the coordinates we obtained above and add them to the map
			//if (is_array($coords) || is_object($coords))
			//{ 		
			 
				foreach($coords as $coordinate)
				{
						
					$marker=array();
						
					$lat1=$coordinate['cycle_19_INT'].(substr($coordinate['cycle_20_INT'], 0, 2)+(substr($coordinate['cycle_20_INT'], 2).".".$coordinate['cycle_21_INT'])/60);
					$lat2=str_replace($coordinate['cycle_22_INT'],'-',$coordinate['cycle_22_INT']).(substr($coordinate['cycle_23_INT'], 0, 2)+substr((substr($coordinate['cycle_23_INT'], 2).".".$coordinate['cycle_24_INT'])/60,0,7));				
					$lat=$lat1.','.$lat2;
					//$marker['id']=$coordinate->cycle_serial;	
					
					$marker['position']=$lat;var_dump($marker['position']);
					$this->googlemaps->add_marker($marker);										
				}
			//}
			
		// Create the map 
			$data=array();
			$data['map'] = $this->googlemaps->create_map();	

							
		// Load our view, passing the map data that has just been created
			
			$this->load->view('dashboard/dashboard_googlemap_view', $data);
			
	}

controller/action?param1=a&param2=b&param3=c

<ASP:DropDownList ID="DropDownList1" runat="server">
  ListItem Value="Pastorsname">PastorName</ListItem>
</ASP:DropDownList>

DropDownList1.SelectedItem.Text

 //Markup
       <table id="dataTable">
                      <tbody>
                    <tr>
                     <td>
                      <?php
						$conn=mysqli_connect("localhost","xphiasuser","xphiasadmin","xphias_sermon");
						 // Check connection
						 if (mysqli_connect_errno())
						   {
						   echo "Failed to connect to MySQL: " . mysqli_connect_error();
				         }
                        $select_query="Select pastorname, ministryname from xphias_clients";
						$select_query = mysqli_query( $conn,$select_query);
						echo "<select name='pastorsname' id='pastorsname' class='form-control'>";
						echo "<option value=' '></option>";
						while ($rc=   mysqli_fetch_array($select_query) )
						{
						   echo "<option value='" .$rc['ministryname'] . "'>" . $rc['pastorname'] . "</option>";
						}
						echo "</select>"; ?></td>
                     <td><INPUT TYPE="TEXT" class="form-control" NAME="ministriesname" id="ministriesname" SIZE="16"></td>
                     <td><INPUT TYPE="TEXT" class="form-control" NAME="sermondate" SIZE="10"></td>
                     <td><INPUT TYPE="TEXT" class="form-control" NAME="sermonname" SIZE="16"></td>
                     <td><INPUT INPUT="TEXT" class="form-control" NAME="scriptures" SIZE="16"></td>
                     <td><INPUT INPUT="TEXT" class="form-control" NAME="videoname" SIZE="10"></td>
                     <td><INPUT INPUT="TEXT" class="form-control" NAME="sermonnotes" SIZE="16"></td>
                    </tr>
                   </table>
                   <table>
                    <tr>
                     <td><INPUT type="file" class="form-control" name="fileToUpload" /></td>
                     <td><INPUT TYPE="submit" value="Save" SIZE="14" name="upd"></td>
                    </tr>
                  </tbody>
                 </table>
                 
		   <script type="text/javascript">
		      $(document).ready(function(){
		      $('#pastorsname').change(function(){
		      var ministriesname = $(this).val();
		      $('#ministriesname').val(ministriesname);
		    });
	          });
	         </script> 
	         
	   //  process.php

if ($_SERVER['REQUEST_METHOD'] == 'POST')
    {

    $sql = "INSERT INTO xphias_sermons (pastorname, ministriesname, sermon_name, scripture, video_name, sermon_notes,sermon_date)
    SELECT ministryname, pastorname, ?, ?, ?, ?, ? FROM xphias_clients WHERE ministryname = ?;
//    VALUES (?, ?, ?, ?, ?, ?, ?)";
    $stmt = $conn->prepare($sql);

    $stmt->bind_param('sssssss', $pastorname, $ministriesname, $sermonname, $scriptures, $videoname, $sermonnotes, $sermondate);
}

//$video_path=$_FILES['fileToUpload']['name'];

//$ministriesname = isset($_POST['pastorsname']) ? $_POST['pastorsname'] : false;
$pastorname = $_POST['pastorsname'];
$ministriesname= $_POST['ministriesname'];
$sermondate = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $_POST['sermondate'])));
//echo "Input: {$_POST['xstartdate'][$i]}, Start date: {$startdate}<br>\n"; //For debugging
$sermonname= $_POST['sermonname'];
$scriptures= $_POST['scriptures'];
$videoname= $_POST['videoname'];
$sermonnotes= $_POST['sermonnotes'];