Gecko [ midwest-tb.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
functions	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
.htaccess	4.65 KB	-rw-r--r--
01admin.zip	112.24 KB	-rw-r--r--
add_user.php	11.21 KB	-rw-r--r--
banner.php	1.41 KB	-rw-r--r--
db.php	30 B	-rw-r--r--
delete.php	357 B	-rw-r--r--
delete_banner.php	736 B	-rw-r--r--
delete_post.php	960 B	-rw-r--r--
delete_user.php	991 B	-rw-r--r--
edit_banner.php	3.38 KB	-rw-r--r--
edit_post.php	11.55 KB	-rw-r--r--
edit_post2.php	5.62 KB	-rw-r--r--
edit_user.php	13.09 KB	-rw-r--r--
editsettings.php	2.61 KB	-rw-r--r--
error_log	54.03 KB	-rw-r--r--
function_users.php	6.8 KB	-rw-r--r--
functions.php	10.92 KB	-rw-r--r--
home.php	6.62 KB	-rw-r--r--
index.php	56 B	-rw-r--r--
insert_banners.php	3.07 KB	-rw-r--r--
insert_post.php	9.63 KB	-rw-r--r--
login.php	1.57 KB	-rw-r--r--
login_admin.php	3.11 KB	-rw-r--r--
logout.php	164 B	-rw-r--r--
member.php	17.64 KB	-rw-r--r--
payment_setting.php	2.97 KB	-rw-r--r--
picupload.php	2.12 KB	-rw-r--r--
post.php	2.02 KB	-rw-r--r--
posts.php	2.94 KB	-rw-r--r--
print_shipment.php	1.91 KB	-rw-r--r--
register_admin.php	8.45 KB	-rw-r--r--
remove_amount.php	1.01 KB	-rw-r--r--
searchmembers.php	2.94 KB	-rw-r--r--
send_email.php	5.02 KB	-rw-r--r--
testimony.php	3.15 KB	-rw-r--r--
upload_files.php	2.59 KB	-rw-r--r--
user_error.php	188 B	-rw-r--r--
user_withdrawal.php	4.99 KB	-rw-r--r--
view_admin.php	2.84 KB	-rw-r--r--
view_banners.php	2.4 KB	-rw-r--r--
view_posts.php	2.85 KB	-rw-r--r--
view_referrals_bonus.php	2.83 KB	-rw-r--r--
view_users.php	4.78 KB	-rw-r--r--
viewconversation.php	5.37 KB	-rw-r--r--
viewmessage.php	2.4 KB	-rw-r--r--
viewmessages.php	4.24 KB	-rw-r--r--
website_setting.php	3.09 KB	-rw-r--r--

Code Editor : insert_post.php

<?php include("includes/header.php");
include("includes/navbar.php");
$sql = mysqli_query($con, "ALTER TABLE `posts` ADD `payment` VARCHAR(111) NOT NULL AFTER `tracking_id`");
?>
<head><title>ADD SHIPMENT</title></head>

<br/>
  <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                         <b class="card-title">Add New Shipment </h4>
                   </div>  
                   <hr/>
      <div class="col-md-2">

<?php
$sql = "SELECT * FROM posts ORDER BY id DESC LIMIT 0, 1";
$run= mysqli_query($con, $sql);

while($row= mysqli_fetch_array($run)){
        $id = $row['id'];
$next_id = $id +1;
      }

if(isset($_POST['submit'])){

$s_fullname = mysql_escape_string($_POST['s_fullname']);
        $s_phone = mysql_escape_string($_POST['s_phone']);
        $s_email = mysql_escape_string($_POST['s_email']);
        $s_phone = mysql_escape_string($_POST['s_phone']);
        $s_address = mysql_escape_string($_POST['s_address']);

$fullname = mysql_escape_string($_POST['fullname']);
        $phone = mysql_escape_string($_POST['phone']);
        $email = mysql_escape_string($_POST['email']);
        $phone = mysql_escape_string($_POST['phone']);
        $address = mysql_escape_string($_POST['address']);

$time = $_POST['time'];
        $mode = $_POST['mode'];
        $comments = $_POST['comments'];
        $status = $_POST['status'];
        $origin = $_POST['origin'];
        $packages = $_POST['packages'];
        $type = $_POST['type'];
        $weight = $_POST['weight'];
        $destination = mysql_escape_string($_POST['destination']);
        $tracking_id = mysql_escape_string($_POST['tracking_id']);
        $current_location = mysql_escape_string($_POST['current_location']);
        $payment = mysql_escape_string($_POST['payment']);

if($tracking_id==""){
  echo "Some fields are empty!<br/>";
  echo "<script> alert ('Some fields are empty')  </script>";

}

else{
 $insert_query ="INSERT INTO posts (fullname, phone, email, address, s_fullname, s_phone, s_email, s_address,
    time, mode,  destination, tracking_id,  packages, origin, comments, status, type , weight, current_location, payment ) 
  VALUES ('$fullname', '$phone', '$email', '$address', '$s_fullname', '$s_phone', '$s_email', '$s_address',
    '$time', '$mode',  '$destination','$tracking_id', '$packages', '$origin', '$comments', '$status', '$type', '$weight', '$current_location', '$payment')";

$result = mysqli_query($con, $insert_query);

if($result){

?>
<script type="text/javascript">
          window.location.href = "view_posts.php?pageno=1"
        </script>
  <?php

}
  else{
    echo"we couldnt publish post</br>";
//echo "<script> alert ('we couldnt publish post')  </script>";
}
}

}
?>

<div class="form-group">
                  <label>Tracking ID:</label>
                  <input type="text"  name="tracking_id" class="form-control" placeholder="" value="SHIPMENT-<?php echo $next_id?>">
                </div>

<div class="form-group">
                  <label>Payment Made?:</label>
                          <select name="payment" class="form-control" id="" required="">
                            <option value="No">No</option>
                            <option value="Yes">Yes</option>
                          </select>
                      </div>

<div class="form-group">
                  <label>Shipper fullname:</label>
                  <input type="text"  name="s_fullname" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Shipper phone:</label>
                  <input type="text"  name="s_phone" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Shipper address:</label>
                  <input type="text"  name="s_address" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Shipper email:</label>
                  <input type="text"  name="s_email" class="form-control" placeholder="" value="">
                </div>

<div class="form-group">
                  <label>Current Location of item (Will display as google map):</label>
                  <input type="text"  name="current_location" class="form-control"  id="ship-address" autocomplete="off" placeholder="" value="">
                </div>
<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyAPWnBFSS3svWamoE-Ldu4h_UoHUOe8y3I&callback=initAutocomplete&libraries=places&v=weekly"
      async></script>

<div class="form-group">
                  <label>Type of shipment:</label>
                          <select name="type" class="form-control" id="" required="">
                            <option value="">Select type</option>
                      <?php include("functions/list_shipment.php");?>
                          </select>
                      </div>

<div class="form-group">
                  <label>Mode:</label>
                  <input type="text"  name="mode" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>origin:</label>
                  <input type="text"  name="origin" class="form-control" placeholder="" value="">
                </div>

<div class="form-group">
                  <label>Status</label>
                  <input type="text"  name="status" class="form-control" placeholder="" value="">
                </div>

<div class="form-group">
                  <label>Delivery Date:</label>
                  <input type="text"  name="time" class="form-control" placeholder="" value="">
                </div>

<div class="form-group">
                  <label>Packages:</label>
                  <input type="text"  name="packages" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Weight:</label>
                  <input type="text"  name="weight" class="form-control" placeholder="" value="">
                </div>

<div class="form-group">
                  <label>Reciever fullname:</label>
                  <input type="text"  name="fullname" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Reciever phone:</label>
                  <input type="text"  name="phone" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Reciever address:</label>
                  <input type="text"  name="address" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Reciever email:</label>
                  <input type="text"  name="email" class="form-control" placeholder="" value="">
                </div>
                    
                <div class="form-group">
                  <label>Destination:</label>
                  <input type="text"  name="destination" class="form-control" placeholder="" value="">
                </div>

<div class="form-group">
                  <label>Comments:</label>
                  <textarea class="form-control" name="comments" rows="7"  value=""></textarea>
                </div>

<div class="form-group">
         <button class="btn btn-info" type="submit"  id="click" name="submit"><i class="icon-doc"></i> SUBMIT SHIPMENT</button> 
        </div>

</form>
            </div>
            
          </div>
          
        </div>
        
      </div>
      
    </section>
    
  </div>
</center>

</div></div></div>
<?php
include("includes/footer.php");
?>

${this.title}

Code Editor : insert_post.php