PHP Projects | Projects Inventory

PHP Projects

PHP Source code of Online Automobile workshop Management system

Projects Inventory8 months ago8 months ago01 mins

main.php

<?php
	switch ($page) {
		
		case 'services':
				require 'services.php';
			break;
		
		case 'service_page':
				require 'service_page.php';
			break;
		
		case 'shop':
				require 'shop.php';
			break;
		
		case 'contact_us':
				require 'contact_us.php';
			break;
		
		case 'about_us':
				require 'about_us.php';
			break;
		
		case 'engineer':
				require 'engineer.php';
			break;
		
		case 'cart':
				require 'cart.php';
			break;
		
		case 'checkout':
				require 'checkout.php';
			break;
		
		case 'sign_up':
				require 'sign_up.php';
			break;
		
		case 'sign_in':
				require 'sign_in.php';
			break;
		
		case 'my_account':
				require 'my_account.php';
			break;
		
		case 'home':
		default:
				require 'home.php';
			break;
	}
?>

<?php

switch ($page) {

case 'services':

require 'services.php';

break;

case 'service_page':

require 'service_page.php';

break;

case 'shop':

require 'shop.php';

break;

case 'contact_us':

require 'contact_us.php';

break;

case 'about_us':

require 'about_us.php';

break;

case 'engineer':

require 'engineer.php';

break;

case 'cart':

require 'cart.php';

break;

case 'checkout':

require 'checkout.php';

break;

case 'sign_up':

require 'sign_up.php';

break;

case 'sign_in':

require 'sign_in.php';

break;

case 'my_account':

require 'my_account.php';

break;

case 'home':

default:

require 'home.php';

break;

}

my_account.php

<?php

	if ( !$_SESSION[ 'logged' ] )
		{
			$_SESSION[ 'logged' ] = false;
		}

?>

<div class="page-title-area"> <img src="assets/img/home-one/footer-car.png" alt="Title">
	<div class="container">
		<div class="page-title-content">
			<h2>My Account</h2>
			<ul>
				<li> <a href="index.php?p=home">Home</a> </li>
				<li> <i class='bx bx-chevron-right'></i> </li>
				<li>My Account</li>
			</ul>
		</div>
	</div>
</div>
<section class="parts-area pt-100 pb-70">
	<div class="container">
		<div class="section-title">
			<h2>Client Account Page</h2>
		</div>
		<div id="Container" class="row">
			<?php

				if ( !$_SESSION[ 'logged' ] )
				{
					echo 'You are not register kindly register then visit this page.';
				}
				else
				{
					echo 'Welcome user your email address is: '.$_SESSION[ 'email' ];
				}

			?>
			<a href="sign_out.php">Sign Out</a>
			<table class="table table-hover table-striped">
			    <thead>
			      <tr>
			        <th>Dated</th>
			        <th>Vehicle</th>
			        <th>Services</th>
			        <th>Additional Services</th>
			      </tr>
			    </thead>
			    <tbody>
			    	<?php
			    		$selectQuery = "SELECT * FROM ".Config::tbI." WHERE ".Config::tbIUUID."=:".Config::tbIUUID;
						$selectResult = $db->Select($selectQuery, [ Config::tbIUUID => $_SESSION[ 'uid' ] ]);

						foreach( $selectResult as $idx=>$val )
						{
							echo '
									<tr>
								        <td>'.$val[Config::tbCreated].'</td>
								        <td>'.$val[Config::tbIVehicle].'</td>
								        <td>
								        	<ol>
							    ';


							    $selectQuery = "SELECT * FROM ".Config::tbIs." WHERE ".Config::tbIsIUID."=:".Config::tbIsIUID;
								$selectResult = $db->Select($selectQuery, [ Config::tbIsIUID => $val[Config::tbIUID] ]);
								foreach( $selectResult as $idx2=>$val2 )
								{
									$selectQuery = "SELECT * FROM ".Config::tbS." WHERE ".Config::tbSUID."=:".Config::tbSUID;
									$selectResult = $db->Select($selectQuery, [ Config::tbSUID => $val2[Config::tbIsSUID] ]);
									echo '
											<li>
									        	<ul>
											        <li>'.$selectResult[0][Config::tbSName].'</li>
											        <li>'.$selectResult[0][Config::tbSPrice].' RS</li>
												</ul>
											</li>
									    ';
								}

							echo '
											</ol>
										</td>
								        <td>
								        	<ol>							    ';

							    $selectQuery = "SELECT * FROM ".Config::tbIas." WHERE ".Config::tbIasIUID."=:".Config::tbIasIUID;
								$selectResult = $db->Select($selectQuery, [ Config::tbIasIUID => $val[Config::tbIUID] ]);
								foreach( $selectResult as $idx2=>$val2 )
								{
									echo '
											<li>
									        	<ul>
											        <li>'.$val2[Config::tbIasName].'</li>
											        <li>'.$val2[Config::tbIasPrice].' RS</li>
												</ul>
											</li>
									    ';
								}

							echo '
											</ol>
										</td>
								    </tr>
							    ';
						}
			    	?>
			    </tbody>
		    </table>
		    <div style="padding:70px;"></div>
		</div>
	</div>
</section>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

<?php

if ( !$_SESSION[ 'logged' ] )

{

$_SESSION[ 'logged' ] = false;

}

<h2>My Account</h2>

<ul>

<li>My Account</li>

</ul>

</div>

<h2>Client Account Page</h2>

</div>

<?php

if ( !$_SESSION[ 'logged' ] )

{

echo 'You are not register kindly register then visit this page.';

}

else

{

echo 'Welcome user your email address is: '.$_SESSION[ 'email' ];

}

<thead>

<tr>

<th>Dated</th>

<th>Vehicle</th>

<th>Services</th>

<th>Additional Services</th>

</tr>

</thead>

<tbody>

<?php

$selectQuery = "SELECT * FROM ".Config::tbI." WHERE ".Config::tbIUUID."=:".Config::tbIUUID;

$selectResult = $db->Select($selectQuery, [ Config::tbIUUID => $_SESSION[ 'uid' ] ]);

foreach( $selectResult as $idx=>$val )

{

echo '

<tr>

<td>'.$val[Config::tbCreated].'</td>

<td>'.$val[Config::tbIVehicle].'</td>

<td>

<ol>

$selectQuery = "SELECT * FROM ".Config::tbIs." WHERE ".Config::tbIsIUID."=:".Config::tbIsIUID;

$selectResult = $db->Select($selectQuery, [ Config::tbIsIUID => $val[Config::tbIUID] ]);

foreach( $selectResult as $idx2=>$val2 )

{

$selectQuery = "SELECT * FROM ".Config::tbS." WHERE ".Config::tbSUID."=:".Config::tbSUID;

$selectResult = $db->Select($selectQuery, [ Config::tbSUID => $val2[Config::tbIsSUID] ]);

echo '

<li>

<ul>

<li>'.$selectResult[0][Config::tbSName].'</li>

<li>'.$selectResult[0][Config::tbSPrice].' RS</li>

</ul>

</li>

}

echo '

</ol>

</td>

<td>

<ol> ';

$selectQuery = "SELECT * FROM ".Config::tbIas." WHERE ".Config::tbIasIUID."=:".Config::tbIasIUID;

$selectResult = $db->Select($selectQuery, [ Config::tbIasIUID => $val[Config::tbIUID] ]);

foreach( $selectResult as $idx2=>$val2 )

{

echo '

<li>

<ul>

<li>'.$val2[Config::tbIasName].'</li>

<li>'.$val2[Config::tbIasPrice].' RS</li>

</ul>

</li>

}

echo '

</ol>

</td>

</tr>

}

</tbody>

</table>

</div>

</section>

services.php

<?php
	$uid = $_GET['uid'];

	$query = "SELECT * FROM ".Config::tbSC." WHERE ".Config::tbSCUID."=:".Config::tbSCUID."";
	$result = $db->Select( $query,	[
										Config::tbSCUID => $uid
									] );

	if ( $result )
	{
		$tbSCName = $result[0][Config::tbSCName];
	}
	else
	{
		header("location:index.php?p=home");
		return;
	}
?>


<div class="page-title-area"> <img src="assets/img/home-one/footer-car.png" alt="Title">
	<div class="container">
		<div class="page-title-content">
			<h2><?php echo $tbSCName; ?></h2>
			<ul>
				<li> <a href="index.php?p=home">Home</a> </li>
				<li> <i class='bx bx-chevron-right'></i> </li>
				<li><?php echo $tbSCName; ?></li>
			</ul>
		</div>
	</div>
</div>

<section class="pt-100 pb-70">
	<div class="container">
		<div class="row">


			<?php
				$query = "SELECT * FROM ".Config::tbS." WHERE ".Config::tbSSCUID."=:".Config::tbSSCUID." ORDER BY ".Config::tbSUID." ASC";
				$result = $db->Select( $query,	[
													Config::tbSSCUID => $uid
												] );

				if ( $result )
				{
					foreach ( $result as $key => $data )
					{
						echo'
							<div class="col-sm-6 col-lg-4">
								<a href="index.php?p=service_page&uid='.$data[Config::tbSUID].'">
									<div class="service-item">
										<div class="service-img">
											<img style="height: 320px;" src="'.Config::serverStoragePath.''.$data[Config::tbSImage].'" alt="Service">
										</div>
										<div class="service-content">
											<i class="bx bx-car"></i> <i class="'.$data[Config::tbSIcon].' service-icon"></i>
											<h3>'.$data[Config::tbSName].'</h3>
											<p>'.substr_replace(strip_tags($data[Config::tbSInfo]), "...", 50).'</p>
										</div>
									</div>
								</a>
							</div>
						';
					}
				}
			?>


		</div>
	</div>
</section>
<div style="padding:70px;"></div>

<?php

$uid = $_GET['uid'];

$query = "SELECT * FROM ".Config::tbSC." WHERE ".Config::tbSCUID."=:".Config::tbSCUID."";

$result = $db->Select( $query, [

Config::tbSCUID => $uid

] );

if ( $result )

{

$tbSCName = $result[0][Config::tbSCName];

}

else

{

header("location:index.php?p=home");

return;

}

<ul>

</ul>

</div>

<?php

$query = "SELECT * FROM ".Config::tbS." WHERE ".Config::tbSSCUID."=:".Config::tbSSCUID." ORDER BY ".Config::tbSUID." ASC";

$result = $db->Select( $query, [

Config::tbSSCUID => $uid

] );

if ( $result )

{

foreach ( $result as $key => $data )

{

echo'

</div>

<h3>'.$data[Config::tbSName].'</h3>

<p>'.substr_replace(strip_tags($data[Config::tbSInfo]), "...", 50).'</p>

</div>

</a>

</div>

}

</div>

</section>

Download Full code of PHP Source code of Automobile workshop Management system More helping material of Automobile workshop Project SRS Document of Online Automobile workshop Management system Final Year Project Functional Non-Functional Requirements of Automobile workshop Management system ERD of Online Automobile workshop Management system [Entity relationship diagram]…

PHP Projects

PHP Project On Online Food Ordering System

Projects Inventory10 months ago01 mins

PHP Project On Online Food Ordering System. view-ticket.php

<?php
include 'includes/connect.php';
include 'includes/wallet.php';
$continue=0;
if($_SESSION['customer_sid']==session_id())
{
		$ticket_id = $_GET['id'];
		$sql1 = "SELECT * FROM tickets where poster_id = $user_id AND id = $ticket_id AND not deleted;";
		if(mysqli_num_rows(mysqli_query($con,$sql1))>0){
			$row  = $con->query($sql1)->fetch_assoc();
			$type = $row['type'];
			$subject = $row['subject'];
			$description = $row['description'];
			$date = $row['date'];
			$status = $row['status'];
			$continue=1;
		}
		else
			$continue = 0;	
}
if($continue){
?>

<!DOCTYPE html>
<html lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="msapplication-tap-highlight" content="no">
  <title>Ticket No. <?php echo $ticket_id.' - '. $type;?></title>

  <!-- Favicons-->
  <link rel="icon" href="images/favicon/favicon-32x32.png" sizes="32x32">
  <!-- Favicons-->
  <link rel="apple-touch-icon-precomposed" href="images/favicon/apple-touch-icon-152x152.png">
  <!-- For iPhone -->
  <meta name="msapplication-TileColor" content="#00bcd4">
  <meta name="msapplication-TileImage" content="images/favicon/mstile-144x144.png">
  <!-- For Windows Phone -->


  <!-- CORE CSS-->
  <link href="css/materialize.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <link href="css/style.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <!-- Custome CSS-->    
  <link href="css/custom/custom.min.css" type="text/css" rel="stylesheet" media="screen,projection">

  <link href="js/plugins/perfect-scrollbar/perfect-scrollbar.css" type="text/css" rel="stylesheet" media="screen,projection">
   <style type="text/css">
  .input-field div.error{
    position: relative;
    top: -1rem;
    left: 0rem;
    font-size: 0.8rem;
    color:#FF4081;
    -webkit-transform: translateY(0%);
    -ms-transform: translateY(0%);
    -o-transform: translateY(0%);
    transform: translateY(0%);
  }
  .input-field label.active{
      width:100%;
  }
  .left-alert input[type=text] + label:after, 
  .left-alert input[type=password] + label:after, 
  .left-alert input[type=email] + label:after, 
  .left-alert input[type=url] + label:after, 
  .left-alert input[type=time] + label:after,
  .left-alert input[type=date] + label:after, 
  .left-alert input[type=datetime-local] + label:after, 
  .left-alert input[type=tel] + label:after, 
  .left-alert input[type=number] + label:after, 
  .left-alert input[type=search] + label:after, 
  .left-alert textarea.materialize-textarea + label:after{
      left:0px;
  }
  .right-alert input[type=text] + label:after, 
  .right-alert input[type=password] + label:after, 
  .right-alert input[type=email] + label:after, 
  .right-alert input[type=url] + label:after, 
  .right-alert input[type=time] + label:after,
  .right-alert input[type=date] + label:after, 
  .right-alert input[type=datetime-local] + label:after, 
  .right-alert input[type=tel] + label:after, 
  .right-alert input[type=number] + label:after, 
  .right-alert input[type=search] + label:after, 
  .right-alert textarea.materialize-textarea + label:after{
      right:70px;
  }
  </style> 
</head>

<body>
  <!-- Start Page Loading -->
  <div id="loader-wrapper">
      <div id="loader"></div>        
      <div class="loader-section section-left"></div>
      <div class="loader-section section-right"></div>
  </div>
  <!-- End Page Loading -->

  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START HEADER -->
  <header id="header" class="page-topbar">
        <!-- start header nav-->
        <div class="navbar-fixed">
            <nav class="navbar-color">
                <div class="nav-wrapper">
                    <ul class="left">                      
                      <li><h1 class="logo-wrapper"><a href="index.php" class="brand-logo darken-1"><img src="images/materialize-logo.png" alt="logo"></a> <span class="logo-text">Logo</span></h1></li>
                    </ul>
                    <ul class="right hide-on-med-and-down">                        
                       
                        </li>
                    </ul>					
                </div>
            </nav>
        </div>
        <!-- end header nav-->
  </header>
  <!-- END HEADER -->

  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START MAIN -->
  <div id="main">
    <!-- START WRAPPER -->
    <div class="wrapper">

      <!-- START LEFT SIDEBAR NAV-->
      <aside id="left-sidebar-nav">
        <ul id="slide-out" class="side-nav fixed leftside-navigation">
            <li class="user-details cyan darken-2">
            <div class="row">
                <div class="col col s4 m4 l4">
                    <img src="images/avatar.jpg" alt="" class="circle responsive-img valign profile-image">
                </div>
				<div class="col col s8 m8 l8">
                    <ul id="profile-dropdown" class="dropdown-content">
                        <li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>
                        </li>
                    </ul>
                </div>
                <div class="col col s8 m8 l8">
                    <a class="btn-flat dropdown-button waves-effect waves-light white-text profile-btn" href="#" data-activates="profile-dropdown"><?php echo $name;?> <i class="mdi-navigation-arrow-drop-down right"></i></a>
                    <p class="user-roal"><?php echo $role;?></p>
                </div>
            </div>
            </li>
            <li class="bold"><a href="index.php" class="waves-effect waves-cyan"><i class="mdi-editor-border-color"></i> Order Food</a>
            </li>
                <li class="no-padding">
                    <ul class="collapsible collapsible-accordion">
                        <li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-editor-insert-invitation"></i> Orders</a>
                            <div class="collapsible-body">
                                <ul>
								<li><a href="orders.php">All Orders</a>
                                </li>
								<?php
									$sql = mysqli_query($con, "SELECT DISTINCT status FROM orders WHERE customer_id = $user_id;");
									while($row = mysqli_fetch_array($sql)){
                                    echo '<li><a href="orders.php?status='.$row['status'].'">'.$row['status'].'</a>
                                    </li>';
									}
									?>
                                </ul>
                            </div>
                        </li>
                    </ul>
                </li>
                <li class="no-padding">
                    <ul class="collapsible collapsible-accordion">
                        <li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-action-question-answer"></i> Tickets</a>
                            <div class="collapsible-body">
                                <ul>
								<li><a href="tickets.php">All Tickets</a>
                                </li>
								<?php
									$sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets WHERE poster_id = $user_id;");
									while($row = mysqli_fetch_array($sql)){
                                    echo '<li><a href="tickets.php?status='.$row['status'].'">'.$row['status'].'</a>
                                    </li>';
									}
									?>
                                </ul>
                            </div>
                        </li>
                    </ul>
                </li>				
            <li class="bold"><a href="details.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Edit Details</a>
            </li>				
        </ul>
        <a href="#" data-activates="slide-out" class="sidebar-collapse btn-floating btn-medium waves-effect waves-light hide-on-large-only cyan"><i class="mdi-navigation-menu"></i></a>
        </aside>
      <!-- END LEFT SIDEBAR NAV-->

      <!-- //////////////////////////////////////////////////////////////////////////// -->

      <!-- START CONTENT -->
      <section id="content">

        <!--breadcrumbs start-->
        <div id="breadcrumbs-wrapper">
          <div class="container">
            <div class="row">
              <div class="col s12 m12 l12">
                <h5 class="breadcrumbs-title">Provide Order Details</h5>
              </div>
            </div>
          </div>
        </div>
        <!--breadcrumbs end-->


        <!--start container-->
        <div class="container">
          <p class="caption">Receipt</p>
          <div class="divider"></div>
          <!--editableTable-->
<div class="section">
                                <?php 
								echo '<ul id="task-card" class="collection with-header">
									<div id="card-alert" class="card cyan">
										<div class="card-content white-text">
										<span class="card-title white-text darken-1">Ticket No. '.$ticket_id.'</span>
										<p><strong>Subject: </strong>'.$subject.'</p>
										<p><strong>Status: </strong>'.$status.'</p>	
										<p><strong>Type: </strong>'.$type.'</p>											
										</div>
										<div class="card-action cyan">
										<form method="post" action="routers/ticket-status.php">
										<input type="hidden" name="ticket_id" value="'.$ticket_id.'">										
										<input type="hidden" name="status" value="'.($status != 'Closed' ? 'Closed' : 'Open').'">
										<button class="waves-effect waves-light deep-orange btn white-text" type="submit" name="action">'
										.($status != 'Closed' ? 'Close<i class="mdi-navigation-close"></i>' : 'Reopen<i class="mdi-navigation-check"></i>').'
										</button>
										</form>
										</div>
									</div>										
                                </ul>';
								echo '<ul id="issues-collection" class="collection">';
								$sql1 = mysqli_query($con, "SELECT * from ticket_details WHERE ticket_id = $ticket_id;");
								while($row1 = mysqli_fetch_array($sql1)){
									$sql2 = "SELECT * FROM users WHERE id = ".$row1['user_id'].";";
									if(mysqli_num_rows(mysqli_query($con,$sql2))>0){
										$row2  = $con->query($sql2)->fetch_assoc();
										$name = $row2['name'];
										$role1 = $row2['role'];										
									}
								  echo '
								  <li class="collection-item avatar">
									  <i class="'.($role1=='Administrator' ? 'mdi-action-star-rate' : 'mdi-social-person').' cyan circle"></i>
									  <span class="collection-header"> '.$name.'</span>
									  <p><strong>Date:</strong> '.$row1['date'].'</p>
									  <p><strong>Role:</strong> '.$role1.'</p>					                               
									  <a href="#" class="secondary-content">
									  <i class="mdi-action-grade"></i></a>
								  </li>
								  <li class="collection-item">
									  <div class="row">
									  <p class="caption">'.$row1['description'].'</p>
									  </div>
									  </li>';
								}
							  echo '</ul>';
							  if($status != 'Closed'){
							  echo '
							  <div class="card-panel">
                  <div class="row">
                    <form class="formValidate" id="formValidate" method="post" action="routers/ticket-message.php" novalidate="novalidate" class="col s12">					  
                      <div class="row">
					  <input type="hidden" name="role" value="'.$role.'">
					  <input type="hidden" name="ticket_id" value="'.$ticket_id.'">
                        <div class="input-field col s12">
                          <i class="mdi-action-home prefix"></i>
                          <textarea name="message" id="message" class="materialize-textarea validate" data-error=".errorTxt1"></textarea>
                          <label for="message" class="">Add a reply</label>
						  <div class="errorTxt1"></div>
                        </div>
                        <div class="row">
                          <div class="input-field col s12">
                            <button class="btn cyan waves-effect waves-light right" type="submit" name="action">Reply
                              <i class="mdi-content-send right"></i>
                            </button>
                          </div>
                        </div>
                      </div>
                    </form>
                  </div>
                </div>';
							  }
								?>
          </div>
              </div>
            </div>
        </div>
        <!--end container-->

      </section>
      <!-- END CONTENT -->
    </div>
    <!-- END WRAPPER -->

  </div>
  <!-- END MAIN -->



  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START FOOTER -->
  <footer class="page-footer">
    <div class="footer-copyright">
      <div class="container">
        <span>Copyright © 2017 <a class="grey-text text-lighten-4" href="#" target="_blank">Students</a> All rights reserved.</span>
        <span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>
        </div>
    </div>
  </footer>
    <!-- END FOOTER -->



    <!-- ================================================
    Scripts
    ================================================ -->
    
    <!-- jQuery Library -->
    <script type="text/javascript" src="js/plugins/jquery-1.11.2.min.js"></script>    
    <!--angularjs-->
    <script type="text/javascript" src="js/plugins/angular.min.js"></script>
    <!--materialize js-->
    <script type="text/javascript" src="js/materialize.min.js"></script>
    <script type="text/javascript" src="js/plugins/jquery-validation/jquery.validate.min.js"></script>
    <script type="text/javascript" src="js/plugins/jquery-validation/additional-methods.min.js"></script>
    
    <!--scrollbar-->
    <script type="text/javascript" src="js/plugins/perfect-scrollbar/perfect-scrollbar.min.js"></script> 
    <!--plugins.js - Some Specific JS codes for Plugin Settings-->
    <script type="text/javascript" src="js/plugins.min.js"></script>
    <!--custom-script.js - Add your own theme custom JS-->
    <script type="text/javascript" src="js/custom-script.js"></script>
    <script type="text/javascript">
    $("#formValidate").validate({
        rules: {
            message: {
                required: true,
                minlength: 5,
				maxlength: 300	
            },		
        },
        messages: {
            message: {
                required: "Please provide a reply.",
                minlength: "Minimum 5 characters are required.",
                maxlength: "Maximum 3000 characters are required."				
            },			
        },
        errorElement : 'div',
        errorPlacement: function(error, element) {
          var placement = $(element).data('error');
          if (placement) {
            $(placement).append(error)
          } else {
            error.insertAfter(element);
          }
        }
     });
    </script>	
</body>

</html>
<?php
	}
	else
	{
		if($_SESSION['admin_sid']==session_id())
		{
			header("location:view-ticket-admin.php?id=".$_GET['id']);		
		}
		else{
			header("location:login.php");
		}
	}
?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

<?php

include 'includes/connect.php';

include 'includes/wallet.php';

$continue=0;

if($_SESSION['customer_sid']==session_id())

{

$ticket_id = $_GET['id'];

$sql1 = "SELECT * FROM tickets where poster_id = $user_id AND id = $ticket_id AND not deleted;";

if(mysqli_num_rows(mysqli_query($con,$sql1))>0){

$row = $con->query($sql1)->fetch_assoc();

$type = $row['type'];

$subject = $row['subject'];

$description = $row['description'];

$date = $row['date'];

$status = $row['status'];

$continue=1;

}

else

$continue = 0;

}

if($continue){

<!DOCTYPE html>

<head>

<title>Ticket No. <?php echo $ticket_id.' - '. $type;?></title>

.input-field div.error{

position: relative;

top: -1rem;

left: 0rem;

font-size: 0.8rem;

color:#FF4081;

-webkit-transform: translateY(0%);

-ms-transform: translateY(0%);

-o-transform: translateY(0%);

transform: translateY(0%);

}

.input-field label.active{

width:100%;

}

.left-alert input[type=text] + label:after,

.left-alert input[type=password] + label:after,

.left-alert input[type=email] + label:after,

.left-alert input[type=url] + label:after,

.left-alert input[type=time] + label:after,

.left-alert input[type=date] + label:after,

.left-alert input[type=datetime-local] + label:after,

.left-alert input[type=tel] + label:after,

.left-alert input[type=number] + label:after,

.left-alert input[type=search] + label:after,

.left-alert textarea.materialize-textarea + label:after{

left:0px;

}

.right-alert input[type=text] + label:after,

.right-alert input[type=password] + label:after,

.right-alert input[type=email] + label:after,

.right-alert input[type=url] + label:after,

.right-alert input[type=time] + label:after,

.right-alert input[type=date] + label:after,

.right-alert input[type=datetime-local] + label:after,

.right-alert input[type=tel] + label:after,

.right-alert input[type=number] + label:after,

.right-alert input[type=search] + label:after,

.right-alert textarea.materialize-textarea + label:after{

right:70px;

}

</style>

</head>

<body>

</div>

</ul>

</li>

</ul>

</div>

</nav>

</div>

</header>

</div>

<li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>

</li>

</ul>

</div>

</div>

</li>

<li class="bold"><a href="index.php" class="waves-effect waves-cyan"><i class="mdi-editor-border-color"></i> Order Food</a>

</li>

<li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-editor-insert-invitation"></i> Orders</a>

<ul>

<li><a href="orders.php">All Orders</a>

</li>

<?php

$sql = mysqli_query($con, "SELECT DISTINCT status FROM orders WHERE customer_id = $user_id;");

while($row = mysqli_fetch_array($sql)){

echo '<li><a href="orders.php?status='.$row['status'].'">'.$row['status'].'</a>

</li>';

}

</ul>

</div>

</li>

</ul>

</li>

<li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-action-question-answer"></i> Tickets</a>

<ul>

<li><a href="tickets.php">All Tickets</a>

</li>

<?php

$sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets WHERE poster_id = $user_id;");

while($row = mysqli_fetch_array($sql)){

echo '<li><a href="tickets.php?status='.$row['status'].'">'.$row['status'].'</a>

</li>';

}

</ul>

</div>

</li>

</ul>

</li>

<li class="bold"><a href="details.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Edit Details</a>

</li>

</ul>

</aside>

<h5 class="breadcrumbs-title">Provide Order Details</h5>

</div>

<p class="caption">Receipt</p>

<?php

echo '<ul id="task-card" class="collection with-header">

<span class="card-title white-text darken-1">Ticket No. '.$ticket_id.'</span>

<p><strong>Subject: </strong>'.$subject.'</p>

<p><strong>Status: </strong>'.$status.'</p>

</div>

<button class="waves-effect waves-light deep-orange btn white-text" type="submit" name="action">'

.($status != 'Closed' ? 'Close<i class="mdi-navigation-close"></i>' : 'Reopen<i class="mdi-navigation-check"></i>').'

</button>

</form>

</div>

</ul>';

echo '<ul id="issues-collection" class="collection">';

$sql1 = mysqli_query($con, "SELECT * from ticket_details WHERE ticket_id = $ticket_id;");

while($row1 = mysqli_fetch_array($sql1)){

$sql2 = "SELECT * FROM users WHERE id = ".$row1['user_id'].";";

if(mysqli_num_rows(mysqli_query($con,$sql2))>0){

$row2 = $con->query($sql2)->fetch_assoc();

$name = $row2['name'];

$role1 = $row2['role'];

}

echo '

</li>

<p class="caption">'.$row1['description'].'</p>

</div>

</li>';

}

echo '</ul>';

if($status != 'Closed'){

echo '

<label for="message" class="">Add a reply</label>

</div>

<button class="btn cyan waves-effect waves-light right" type="submit" name="action">Reply

</button>

</div>

</form>

</div>

</div>';

}

</div>

</section>

</div>

</div>

<span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>

</div>

</footer>

<!-- ================================================

Scripts

================================================ -->

$("#formValidate").validate({

rules: {

message: {

required: true,

minlength: 5,

maxlength: 300

messages: {

message: {

required: "Please provide a reply.",

minlength: "Minimum 5 characters are required.",

maxlength: "Maximum 3000 characters are required."

errorElement : 'div',

errorPlacement: function(error, element) {

var placement = $(element).data('error');

if (placement) {

$(placement).append(error)

} else {

error.insertAfter(element);

}

});

</script>

</body>

</html>

<?php

}

else

{

if($_SESSION['admin_sid']==session_id())

{

header("location:view-ticket-admin.php?id=".$_GET['id']);

}

else{

header("location:login.php");

}

all-orders.php

<?php
include 'includes/connect.php';
	if($_SESSION['admin_sid']==session_id())
	{
		?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="msapplication-tap-highlight" content="no">
  <title>All orders</title>

  <!-- Favicons-->
  <link rel="icon" href="images/favicon/favicon-32x32.png" sizes="32x32">
  <!-- Favicons-->
  <link rel="apple-touch-icon-precomposed" href="images/favicon/apple-touch-icon-152x152.png">
  <!-- For iPhone -->
  <meta name="msapplication-TileColor" content="#00bcd4">
  <meta name="msapplication-TileImage" content="images/favicon/mstile-144x144.png">
  <!-- For Windows Phone -->


  <!-- CORE CSS-->
  <link href="css/materialize.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <link href="css/style.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <!-- Custome CSS-->    
  <link href="css/custom/custom.min.css" type="text/css" rel="stylesheet" media="screen,projection">

  <!-- INCLUDED PLUGIN CSS ON THIS PAGE -->
  <link href="js/plugins/perfect-scrollbar/perfect-scrollbar.css" type="text/css" rel="stylesheet" media="screen,projection">
 
</head>

<body>
  <!-- Start Page Loading -->
  <div id="loader-wrapper">
      <div id="loader"></div>        
      <div class="loader-section section-left"></div>
      <div class="loader-section section-right"></div>
  </div>
  <!-- End Page Loading -->

  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START HEADER -->
  <header id="header" class="page-topbar">
        <!-- start header nav-->
        <div class="navbar-fixed">
            <nav class="navbar-color">
                <div class="nav-wrapper">
                    <ul class="left">                      
                      <li><h1 class="logo-wrapper"><a href="index.php" class="brand-logo darken-1"><img src="images/materialize-logo.png" alt="logo"></a> <span class="logo-text">Logo</span></h1></li>
                    </ul>
                </div>
            </nav>
        </div>
        <!-- end header nav-->
  </header>
  <!-- END HEADER -->

  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START MAIN -->
  <div id="main">
    <!-- START WRAPPER -->
    <div class="wrapper">

      <!-- START LEFT SIDEBAR NAV-->
      <aside id="left-sidebar-nav">
        <ul id="slide-out" class="side-nav fixed leftside-navigation">
            <li class="user-details cyan darken-2">
            <div class="row">
                <div class="col col s4 m4 l4">
                    <img src="images/avatar.jpg" alt="" class="circle responsive-img valign profile-image">
                </div>
				<div class="col col s8 m8 l8">
                    <ul id="profile-dropdown" class="dropdown-content">
                        <li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>
                        </li>
                    </ul>
                </div>
                <div class="col col s8 m8 l8">
                    <a class="btn-flat dropdown-button waves-effect waves-light white-text profile-btn" href="#" data-activates="profile-dropdown"><?php echo $name;?> <i class="mdi-navigation-arrow-drop-down right"></i></a>
                    <p class="user-roal"><?php echo $role;?></p>
                </div>
            </div>
            </li>
            <li class="bold"><a href="index.php" class="waves-effect waves-cyan"><i class="mdi-editor-border-color"></i> Food Menu</a>
            </li>
                <li class="no-padding">
                    <ul class="collapsible collapsible-accordion">
                        <li class="bold"><a class="collapsible-header waves-effect waves-cyan active"><i class="mdi-editor-insert-invitation"></i> Orders</a>
                            <div class="collapsible-body">
                                <ul>
								<li class="<?php
								if(!isset($_GET['status'])){
										echo 'active';
									}?>
									"><a href="all-orders.php">All Orders</a>
                                </li>
								<?php
									$sql = mysqli_query($con, "SELECT DISTINCT status FROM orders;");
									while($row = mysqli_fetch_array($sql)){
									if(isset($_GET['status'])){
										$status = $row['status'];
									}
                                    echo '<li class='.(isset($_GET['status'])?($status == $_GET['status'] ? 'active' : ''): '').'><a href="all-orders.php?status='.$row['status'].'">'.$row['status'].'</a>
                                    </li>';
									}
									?>
                                </ul>
                            </div>
                        </li>
                    </ul>
                </li>
                 <li class="no-padding">
                    <ul class="collapsible collapsible-accordion">
                        <li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-action-question-answer"></i> Tickets</a>
                            <div class="collapsible-body">
                                <ul>
								<li><a href="all-tickets.php">All Tickets</a>
                                </li>
								<?php
									$sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets;");
									while($row = mysqli_fetch_array($sql)){
                                    echo '<li><a href="all-tickets.php?status='.$row['status'].'">'.$row['status'].'</a>
                                    </li>';
									}
									?>
                                </ul>
                            </div>
                        </li>
                    </ul>
                </li>			
            <li class="bold"><a href="users.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Users</a>
            </li>				
        </ul>
        <a href="#" data-activates="slide-out" class="sidebar-collapse btn-floating btn-medium waves-effect waves-light hide-on-large-only cyan"><i class="mdi-navigation-menu"></i></a>
        </aside>
      <!-- END LEFT SIDEBAR NAV-->

      <!-- //////////////////////////////////////////////////////////////////////////// -->

      <!-- START CONTENT -->
      <section id="content">

        <!--breadcrumbs start-->
        <div id="breadcrumbs-wrapper">
          <div class="container">
            <div class="row">
              <div class="col s12 m12 l12">
                <h5 class="breadcrumbs-title">All Orders</h5>
              </div>
            </div>
          </div>
        </div>
        <!--breadcrumbs end-->


        <!--start container-->
        <div class="container">
          <p class="caption">List of orders by customers with details</p>
          <div class="divider"></div>
          <!--editableTable-->
<div id="work-collections" class="seaction">
             
					<?php
					if(isset($_GET['status'])){
						$status = $_GET['status'];
					}
					else{
						$status = '%';
					}
					$sql = mysqli_query($con, "SELECT * FROM orders WHERE status LIKE '$status';");
					echo '<div class="row">
                <div>
                    <h4 class="header">List</h4>
                    <ul id="issues-collection" class="collection">';
					while($row = mysqli_fetch_array($sql))
					{
						$status = $row['status'];
						$deleted = $row['deleted'];
						echo '<li class="collection-item avatar">
                              <i class="mdi-content-content-paste red circle"></i>
                              <span class="collection-header">Order No. '.$row['id'].'</span>
                              <p><strong>Date:</strong> '.$row['date'].'</p>
                              <p><strong>Payment Type:</strong> '.$row['payment_type'].'</p>							  
							  <p><strong>Status:</strong> '.($deleted ? $status : '
							  <form method="post" action="routers/edit-orders.php">
							    <input type="hidden" value="'.$row['id'].'" name="id">
								<select name="status">
								<option value="Yet to be delivered" '.($status=='Yet to be delivered' ? 'selected' : '').'>Yet to be delivered</option>
								<option value="Delivered" '.($status=='Delivered' ? 'selected' : '').'>Delivered</option>
								<option value="Cancelled by Admin" '.($status=='Cancelled by Admin' ? 'selected' : '').'>Cancelled by Admin</option>
								<option value="Paused" '.($status=='Paused' ? 'selected' : '').'>Paused</option>								
								</select>
							  ').'</p>
                              <a href="#" class="secondary-content"><i class="mdi-action-grade"></i></a>
                              </li>';
						$order_id = $row['id'];
						$customer_id = $row['customer_id'];
						$sql1 = mysqli_query($con, "SELECT * FROM order_details WHERE order_id = $order_id;");
						$sql3 = mysqli_query($con, "SELECT * FROM users WHERE id = $customer_id;");
							while($row3 = mysqli_fetch_array($sql3))
							{
							echo '<li class="collection-item">
                            <div class="row">
							<p><strong>Name: </strong>'.$row3['name'].'</p>
							<p><strong>Address: </strong>'.$row['address'].'</p>
							'.($row3['contact'] == '' ? '' : '<p><strong>Contact: </strong>'.$row3['contact'].'</p>').'	
							'.($row3['email'] == '' ? '' : '<p><strong>Email: </strong>'.$row3['email'].'</p>').'		
							'.(!empty($row['description']) ? '<p><strong>Note: </strong>'.$row['description'].'</p>' : '').'								
                            </li>';							
							}
						while($row1 = mysqli_fetch_array($sql1))
						{
							$item_id = $row1['item_id'];
							$sql2 = mysqli_query($con, "SELECT * FROM items WHERE id = $item_id;");
							while($row2 = mysqli_fetch_array($sql2))
								$item_name = $row2['name'];
							echo '<li class="collection-item">
                            <div class="row">
                            <div class="col s7">
                            <p class="collections-title"><strong>#'.$row1['item_id'].'</strong> '.$item_name.'</p>
                            </div>
                            <div class="col s2">
                            <span>'.$row1['quantity'].' Pieces</span>
                            </div>
                            <div class="col s3">
                            <span>Rs. '.$row1['price'].'</span>
                            </div>
                            </div>
                            </li>';
						}
								echo'<li class="collection-item">
                                        <div class="row">
                                            <div class="col s7">
                                                <p class="collections-title"> Total</p>
                                            </div>
                                            <div class="col s2">
											<span> </span>
                                            </div>
                                            <div class="col s3">
                                                <span><strong>Rs. '.$row['total'].'</strong></span>
                                            </div>';										
								if(!$deleted){
								echo '<button class="btn waves-effect waves-light right submit" type="submit" name="action">Change Status
                                              <i class="mdi-content-clear right"></i> 
										</button>
										</form>';
								}
								echo'</div></li>';
					}
					?>
					</ul>
                </div>
              </div>
            </div>
        </div>
        <!--end container-->

      </section>
      <!-- END CONTENT -->
    </div>
    <!-- END WRAPPER -->

  </div>
  <!-- END MAIN -->



  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START FOOTER -->
  <footer class="page-footer">
    <div class="footer-copyright">
      <div class="container">
        <span>Copyright © 2017 <a class="grey-text text-lighten-4" href="#" target="_blank">Students</a> All rights reserved.</span>
        <span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>
        </div>
    </div>
  </footer>
    <!-- END FOOTER -->



    <!-- ================================================
    Scripts
    ================================================ -->
    
    <!-- jQuery Library -->
    <script type="text/javascript" src="js/plugins/jquery-1.11.2.min.js"></script>    
    <!--angularjs-->
    <script type="text/javascript" src="js/plugins/angular.min.js"></script>
    <!--materialize js-->
    <script type="text/javascript" src="js/materialize.min.js"></script>
    <!--scrollbar-->
    <script type="text/javascript" src="js/plugins/perfect-scrollbar/perfect-scrollbar.min.js"></script>       
    <!--plugins.js - Some Specific JS codes for Plugin Settings-->
    <script type="text/javascript" src="js/plugins.min.js"></script>
    <!--custom-script.js - Add your own theme custom JS-->
    <script type="text/javascript" src="js/custom-script.js"></script>
</body>

</html>
<?php
	}
	else
	{
		if($_SESSION['customer_id']==session_id())
		{
			header("location:orders.php");		
		}
		else{
			header("location:login.php");
		}
	}
?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

<?php

include 'includes/connect.php';

if($_SESSION['admin_sid']==session_id())

{

<!DOCTYPE html>

<head>

<title>All orders</title>

</head>

<body>

</div>

</ul>

</div>

</nav>

</div>

</header>

</div>

<li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>

</li>

</ul>

</div>

</div>

</li>

</li>

<li class="bold"><a class="collapsible-header waves-effect waves-cyan active"><i class="mdi-editor-insert-invitation"></i> Orders</a>

<ul>

<li class="<?php

if(!isset($_GET['status'])){

echo 'active';

}?>

"><a href="all-orders.php">All Orders</a>

</li>

<?php

$sql = mysqli_query($con, "SELECT DISTINCT status FROM orders;");

while($row = mysqli_fetch_array($sql)){

if(isset($_GET['status'])){

$status = $row['status'];

}

echo '<li class='.(isset($_GET['status'])?($status == $_GET['status'] ? 'active' : ''): '').'><a href="all-orders.php?status='.$row['status'].'">'.$row['status'].'</a>

</li>';

}

</ul>

</div>

</li>

</ul>

</li>

<li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-action-question-answer"></i> Tickets</a>

<ul>

<li><a href="all-tickets.php">All Tickets</a>

</li>

<?php

$sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets;");

while($row = mysqli_fetch_array($sql)){

echo '<li><a href="all-tickets.php?status='.$row['status'].'">'.$row['status'].'</a>

</li>';

}

</ul>

</div>

</li>

</ul>

</li>

<li class="bold"><a href="users.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Users</a>

</li>

</ul>

</aside>

<h5 class="breadcrumbs-title">All Orders</h5>

</div>

<p class="caption">List of orders by customers with details</p>

<?php

if(isset($_GET['status'])){

$status = $_GET['status'];

}

else{

$status = '%';

}

$sql = mysqli_query($con, "SELECT * FROM orders WHERE status LIKE '$status';");

echo '<div class="row">

<div>

<ul id="issues-collection" class="collection">';

while($row = mysqli_fetch_array($sql))

{

$status = $row['status'];

$deleted = $row['deleted'];

echo '<li class="collection-item avatar">

<span class="collection-header">Order No. '.$row['id'].'</span>

<p><strong>Payment Type:</strong> '.$row['payment_type'].'</p>

<p><strong>Status:</strong> '.($deleted ? $status : '

<option value="Yet to be delivered" '.($status=='Yet to be delivered' ? 'selected' : '').'>Yet to be delivered</option>

<option value="Delivered" '.($status=='Delivered' ? 'selected' : '').'>Delivered</option>

<option value="Cancelled by Admin" '.($status=='Cancelled by Admin' ? 'selected' : '').'>Cancelled by Admin</option>

<option value="Paused" '.($status=='Paused' ? 'selected' : '').'>Paused</option>

</select>

').'</p>

</li>';

$order_id = $row['id'];

$customer_id = $row['customer_id'];

$sql1 = mysqli_query($con, "SELECT * FROM order_details WHERE order_id = $order_id;");

$sql3 = mysqli_query($con, "SELECT * FROM users WHERE id = $customer_id;");

while($row3 = mysqli_fetch_array($sql3))

{

echo '<li class="collection-item">

<p><strong>Address: </strong>'.$row['address'].'</p>

'.($row3['contact'] == '' ? '' : '<p><strong>Contact: </strong>'.$row3['contact'].'</p>').'

'.($row3['email'] == '' ? '' : '<p><strong>Email: </strong>'.$row3['email'].'</p>').'

'.(!empty($row['description']) ? '<p><strong>Note: </strong>'.$row['description'].'</p>' : '').'

</li>';

}

while($row1 = mysqli_fetch_array($sql1))

{

$item_id = $row1['item_id'];

$sql2 = mysqli_query($con, "SELECT * FROM items WHERE id = $item_id;");

while($row2 = mysqli_fetch_array($sql2))

$item_name = $row2['name'];

echo '<li class="collection-item">

</div>

<span>'.$row1['quantity'].' Pieces</span>

</div>

<span>Rs. '.$row1['price'].'</span>

</div>

</li>';

}

echo'<li class="collection-item">

<p class="collections-title"> Total</p>

</div>

</div>

<span><strong>Rs. '.$row['total'].'</strong></span>

</div>';

if(!$deleted){

echo '<button class="btn waves-effect waves-light right submit" type="submit" name="action">Change Status

</button>

</form>';

}

echo'</div></li>';

}

</ul>

</div>

</section>

</div>

</div>

<span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>

</div>

</footer>

<!-- ================================================

Scripts

================================================ -->

</body>

</html>

<?php

}

else

{

if($_SESSION['customer_id']==session_id())

{

header("location:orders.php");

}

else{

header("location:login.php");

}

all-tickets.php

<?php
include 'includes/connect.php';
include 'includes/wallet.php';

	if($_SESSION['admin_sid']==session_id())
	{
		?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="msapplication-tap-highlight" content="no">
  <title>Tickets</title>

  <!-- Favicons-->
  <link rel="icon" href="images/favicon/favicon-32x32.png" sizes="32x32">
  <!-- Favicons-->
  <link rel="apple-touch-icon-precomposed" href="images/favicon/apple-touch-icon-152x152.png">
  <!-- For iPhone -->
  <meta name="msapplication-TileColor" content="#00bcd4">
  <meta name="msapplication-TileImage" content="images/favicon/mstile-144x144.png">
  <!-- For Windows Phone -->


  <!-- CORE CSS-->
  <link href="css/materialize.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <link href="css/style.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <!-- Custome CSS-->    
  <link href="css/custom/custom.min.css" type="text/css" rel="stylesheet" media="screen,projection">
  <!-- INCLUDED PLUGIN CSS ON THIS PAGE -->
  <link href="js/plugins/perfect-scrollbar/perfect-scrollbar.css" type="text/css" rel="stylesheet" media="screen,projection">
  <link href="js/plugins/data-tables/css/jquery.dataTables.min.css" type="text/css" rel="stylesheet" media="screen,projection">
</head>

<body>
  <!-- Start Page Loading -->
  <div id="loader-wrapper">
      <div id="loader"></div>        
      <div class="loader-section section-left"></div>
      <div class="loader-section section-right"></div>
  </div>
  <!-- End Page Loading -->

  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START HEADER -->
  <header id="header" class="page-topbar">
        <!-- start header nav-->
        <div class="navbar-fixed">
            <nav class="navbar-color">
                <div class="nav-wrapper">
                    <ul class="left">                      
                      <li><h1 class="logo-wrapper"><a href="index.php" class="brand-logo darken-1"><img src="images/materialize-logo.png" alt="logo"></a> <span class="logo-text">Logo</span></h1></li>
                    </ul>
                    <ul class="right hide-on-med-and-down">                        
                       
                        </li>
                    </ul>					
                </div>
            </nav>
        </div>
        <!-- end header nav-->
  </header>
  <!-- END HEADER -->

  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START MAIN -->
  <div id="main">
    <!-- START WRAPPER -->
    <div class="wrapper">

      <!-- START LEFT SIDEBAR NAV-->
      <aside id="left-sidebar-nav">
        <ul id="slide-out" class="side-nav fixed leftside-navigation">
            <li class="user-details cyan darken-2">
            <div class="row">
                <div class="col col s4 m4 l4">
                    <img src="images/avatar.jpg" alt="" class="circle responsive-img valign profile-image">
                </div>
				 <div class="col col s8 m8 l8">
                    <ul id="profile-dropdown" class="dropdown-content">
                        <li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>
                        </li>
                    </ul>
                </div>
                <div class="col col s8 m8 l8">
                    <a class="btn-flat dropdown-button waves-effect waves-light white-text profile-btn" href="#" data-activates="profile-dropdown"><?php echo $name;?> <i class="mdi-navigation-arrow-drop-down right"></i></a>
                    <p class="user-roal"><?php echo $role;?></p>
                </div>
            </div>
            </li>
            <li class="bold"><a href="index.php" class="waves-effect waves-cyan"><i class="mdi-editor-border-color"></i> Order Food</a>
            </li>
                <li class="no-padding">
                    <ul class="collapsible collapsible-accordion">
                        <li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-editor-insert-invitation"></i> Orders</a>
                            <div class="collapsible-body">
                                <ul>
								<li><a href="all-orders.php">All Orders</a>
                                </li>
								<?php
									$sql = mysqli_query($con, "SELECT DISTINCT status FROM orders;");
									while($row = mysqli_fetch_array($sql)){
                                    echo '<li><a href="all-orders.php?status='.$row['status'].'">'.$row['status'].'</a>
                                    </li>';
									}
									?>
                                </ul>
                            </div>
                        </li>
                    </ul>
                </li>
                <li class="no-padding">
                    <ul class="collapsible collapsible-accordion">
                        <li class="bold"><a class="collapsible-header waves-effect waves-cyan active"><i class="mdi-action-question-answer"></i> Tickets</a>
                            <div class="collapsible-body">
                                <ul>
								<li class="<?php
								if(!isset($_GET['status'])){
										echo 'active';
									}?>
									"><a href="all-tickets.php">All Tickets</a>
                                </li>
								<?php
									$sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets;");
									while($row = mysqli_fetch_array($sql)){
									if(isset($_GET['status'])){
										$status = $row['status'];
									}
                                    echo '<li class='.(isset($_GET['status'])?($status == $_GET['status'] ? 'active' : ''): '').'><a href="all-tickets.php?status='.$row['status'].'">'.$row['status'].'</a>
                                    </li>';
									}
									?>
                                </ul>
                            </div>
                        </li>
                    </ul>
                </li>			
            <li class="bold"><a href="details.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Edit Details</a>
            </li>				
        </ul>
        <a href="#" data-activates="slide-out" class="sidebar-collapse btn-floating btn-medium waves-effect waves-light hide-on-large-only cyan"><i class="mdi-navigation-menu"></i></a>
        </aside>
      <!-- END LEFT SIDEBAR NAV-->

      <!-- //////////////////////////////////////////////////////////////////////////// -->

      <!-- START CONTENT -->
      <section id="content">

        <!--breadcrumbs start-->
        <div id="breadcrumbs-wrapper">
          <div class="container">
            <div class="row">
              <div class="col s12 m12 l12">
                <h5 class="breadcrumbs-title">Tickets</h5>
              </div>
            </div>
          </div>
        </div>
        <!--breadcrumbs end-->
		
	        <!--start container-->
        <div class="container">
          <p class="caption">List of tickets by all customers</p>
          <div class="divider"></div>
									<div id="work-collections">
									<ul id="projects-collection" class="collection">
								<?php
									if(isset($_GET['status'])){
										$status = $_GET['status'];
									}
									else{
										$status = '%';
									}			
									$sql = mysqli_query($con, "SELECT * FROM tickets WHERE status LIKE '$status';");
									while($row = mysqli_fetch_array($sql)){								                                
									echo'<a href="view-ticket-admin.php?id='.$row['id'].'"class="collection-item">
                                        <div class="row">
                                            <div class="col s6">
                                                <p class="collections-title">'.$row['subject'].'</p>                                              
                                            </div>
                                            <div class="col s2">
                                            <span class="task-cat cyan">'.$row['status'].'</span></div>											
                                            <div class="col s2">
                                            <span class="task-cat grey darken-3">'.$row['type'].'</span></div>
                                            <div class="col s2">
                                            <span class="badge">'.$row['date'].'</span></div>
                                        </div>
                                    </a>';
									}
									?>
									</ul>
									</div>
            <div class="divider"></div>
            
          </div>
        <!--end container-->


      <!-- END CONTENT -->
    </div>
  <!-- END MAIN -->
      </section>


  <!-- //////////////////////////////////////////////////////////////////////////// -->

  <!-- START FOOTER -->
  <footer class="page-footer">
    <div class="footer-copyright">
      <div class="container">
        <span>Copyright © 2017 <a class="grey-text text-lighten-4" href="#" target="_blank">Students</a> All rights reserved.</span>
        <span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>
        </div>
    </div>
  </footer>
    <!-- END FOOTER -->



    <!-- ================================================
    Scripts
    ================================================ -->
    
    <!-- jQuery Library -->
    <script type="text/javascript" src="js/plugins/jquery-1.11.2.min.js"></script>    
    <!--angularjs-->
    <script type="text/javascript" src="js/plugins/angular.min.js"></script>
    <!--materialize js-->
    <script type="text/javascript" src="js/materialize.min.js"></script>
    <!--scrollbar-->
    <script type="text/javascript" src="js/plugins/perfect-scrollbar/perfect-scrollbar.min.js"></script>
    <!-- data-tables -->
    <script type="text/javascript" src="js/plugins/data-tables/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" src="js/plugins/data-tables/data-tables-script.js"></script>
    
    <!--plugins.js - Some Specific JS codes for Plugin Settings-->
    <script type="text/javascript" src="js/plugins.min.js"></script>
    <!--custom-script.js - Add your own theme custom JS-->
    <script type="text/javascript" src="js/custom-script.js"></script>
</body>

</html>
<?php
	}
	else
	{
		if($_SESSION['customer_sid']==session_id())
		{
			header("location:tickets.php");		
		}
		else{
			header("location:login.php");
		}
	}
?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

<?php

include 'includes/connect.php';

include 'includes/wallet.php';

if($_SESSION['admin_sid']==session_id())

{

<!DOCTYPE html>

<head>

<title>Tickets</title>

</head>

<body>

</div>

</ul>

</li>

</ul>

</div>

</nav>

</div>

</header>

</div>

<li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>

</li>

</ul>

</div>

</div>

</li>

<li class="bold"><a href="index.php" class="waves-effect waves-cyan"><i class="mdi-editor-border-color"></i> Order Food</a>

</li>

<li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-editor-insert-invitation"></i> Orders</a>

<ul>

<li><a href="all-orders.php">All Orders</a>

</li>

<?php

$sql = mysqli_query($con, "SELECT DISTINCT status FROM orders;");

while($row = mysqli_fetch_array($sql)){

echo '<li><a href="all-orders.php?status='.$row['status'].'">'.$row['status'].'</a>

</li>';

}

</ul>

</div>

</li>

</ul>

</li>

<li class="bold"><a class="collapsible-header waves-effect waves-cyan active"><i class="mdi-action-question-answer"></i> Tickets</a>

<ul>

<li class="<?php

if(!isset($_GET['status'])){

echo 'active';

}?>

"><a href="all-tickets.php">All Tickets</a>

</li>

<?php

$sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets;");

while($row = mysqli_fetch_array($sql)){

if(isset($_GET['status'])){

$status = $row['status'];

}

echo '<li class='.(isset($_GET['status'])?($status == $_GET['status'] ? 'active' : ''): '').'><a href="all-tickets.php?status='.$row['status'].'">'.$row['status'].'</a>

</li>';

}

</ul>

</div>

</li>

</ul>

</li>

<li class="bold"><a href="details.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Edit Details</a>

</li>

</ul>

</aside>

<h5 class="breadcrumbs-title">Tickets</h5>

</div>

<p class="caption">List of tickets by all customers</p>

<?php

if(isset($_GET['status'])){

$status = $_GET['status'];

}

else{

$status = '%';

}

$sql = mysqli_query($con, "SELECT * FROM tickets WHERE status LIKE '$status';");

while($row = mysqli_fetch_array($sql)){

echo'<a href="view-ticket-admin.php?id='.$row['id'].'"class="collection-item">

<p class="collections-title">'.$row['subject'].'</p>

</div>

<span class="task-cat cyan">'.$row['status'].'</span></div>

</div>

</a>';

}

</ul>

</div>

</div>

</div>

</section>

<span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>

</div>

</footer>

<!-- ================================================

Scripts

================================================ -->

</body>

</html>

<?php

}

else

{

if($_SESSION['customer_sid']==session_id())

{

header("location:tickets.php");

}

else{

header("location:login.php");

}

Download full code of Online food ordering system

PHP Projects

Online doctor appointment system Project using PHP

Projects Inventory11 months ago01 mins

patient.php

<?php
require_once("common/config.php");
require_once("common/database.php");
require_once("common/functions.php");
require_once("common/messages.php");
require_once("common/initialize.php");

if (isset($_POST["email"]) && $_POST["email"] != "") {
    $email = trim($_POST['email']);
    $pwd = md5(trim($_POST['pwd']));
    if (!$email == "" && !$pwd == "") {
        $query = "SELECT * FROM users WHERE email='$email' AND password='$pwd'";
        $result = db::getRecord($query);

        if (!empty($result)) {
            $user = true;
        } else {
            $user = false;
        }
        //$pwd = md5($pwd);
        //$query = "select u.*, ut.refcode as userrole from users u left join usertypes as ut on ut.typeid=u.usertype where email='" . $email . "' and password='". $pwd ."'" ;
        //$user = db::getRecord($query);
        if ($user) {
            //saveLastActiveTime($user['id']);
            $_SESSION["loggedInUserRole"] = $result['role'];
            $_SESSION['firstname'] = $result['first_name'];
            $_SESSION['lastname'] = $result['last_name'];
            $_SESSION['email'] = $result['email'];
            $_SESSION["isAdminloggedin"] = true;
            $_SESSION['adminid'] = $result['id'];

            if ($result['role'] == 'Admin') {
                header('Location: ' . $site_root . 'admin/index.php');
            }

            /* if (trim($user["usertype"])=="1"){ //Administrator
              $_SESSION["isAdminloggedin"]=true;
              $_SESSION['adminid'] = $user['id'];
              header('Location: '.$site_root.'admin/index.php');
              } */
        } else {
            $_SESSION['error'] = "incorrect_login";
            $_SESSION["msgType"] = "danger";
        }
    } else {
        $_SESSION['error'] = "incorrect_login";
        $_SESSION["msgType"] = "danger";
    }
}
$disease_list = db::getRecords("select id,title as name from diseas");
//print_r($disease_list);
//exit;
?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <meta charset="utf-8">
        <!-- Title and other stuffs -->
        <title>FSO ODA PATIENT <?php @showTitle($title); ?></title>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link href="style/bootstrap.css" rel="stylesheet">
        <link rel="stylesheet" href="style/font-awesome.css"> 
        <link rel="stylesheet" href="style/jquery-ui-1.9.2.custom.min.css"> 
        <link rel="stylesheet" href="style/fullcalendar.css">
        <link rel="stylesheet" href="style/prettyPhoto.css">  
        <link rel="stylesheet" href="style/rateit.css">
        <link rel="stylesheet" href="style/bootstrap-datetimepicker.min.css">
        <link rel="stylesheet" href="style/jquery.cleditor.css"> 
        <link rel="stylesheet" href="style/uniform.default.html"> 
        <link rel="stylesheet" href="style/daterangepicker-bs3.css" />
        <link rel="stylesheet" href="style/bootstrap-switch.css">
        <link href="style/style.css" rel="stylesheet">
        <link href="style/widgets.css" rel="stylesheet">   
        <link href="style/jquery.gritter.css" rel="stylesheet">   
        <link href="style/validationEngine.jquery.css" rel="stylesheet">
        <link href="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.css" rel="stylesheet">
        <link href="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.min.css" rel="stylesheet">
        <!-- HTML5 Support for IE -->
        <!--[if lt IE 9]>
        <script src="js/html5shim.js"></script>
        <![endif]-->

        <!-- Favicon -->
        <link rel="shortcut icon" href="../img/favicon.png"> 
    </head>
    <style>
        .container{max-width: 100%!important}
    </style>


    <body>


        <!-- Form area -->
        <div class="container">

            <div class="row">
                <div class="col-sm-12">
                    <!-- Widget starts -->
                    <div class="widget">
                        <!-- Widget head -->
                        <div class="widget-head">
                            <i class="icon-lock"></i> Sign up 
                        </div>


                        <div class="widget-content">
                            <!-- Login form -->
                            <?php if ($_GET["id"] != 1) { ?>
                                <form class="validate form-horizontal" role="form" id="formLogin" action='actions.php' method="post" enctype="multipart/form-data">
                                    <!-- Email -->
                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2" >First Name</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="first_name" class="validate[required] form-control" placeholder="first name" onChange="checkemail(this.value);"/>                        
                                        </div>
                                        <label class="control-label col-sm-2" for="inputEmail">Last Name</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="last_name" class="validate[required] form-control" placeholder="last Name" onChange="checkemail(this.value);"/>                        
                                        </div>

                                    </div>
                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2">Email</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="email" class="validate[required, custom[email]] form-control" placeholder="email" onChange="checkemail(this.value);"/>                        
                                        </div>
                                        <label class="control-label col-sm-2">Contact</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="contact" class="validate[required,custom[integer]] form-control" placeholder="contact" onChange="checkemail(this.value);"/>                        
                                        </div>

                                    </div>

                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2">Adress</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="adress" class="validate[required] form-control" placeholder="adress" onChange="checkemail(this.value);"/>                        
                                        </div>
                                        <label class="control-label col-sm-2">City</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="city" class="validate[required] form-control" placeholder="city" onChange="checkemail(this.value);"/>                        
                                        </div>

                                    </div>
                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2">Disease</label>
                                        <div class="col-sm-4">
                                            <select name="diseas[]" id="diseas" class="form-control" multiple>
                                                <?php echo displayDropDown($disease_list, '') ?> 
                                            </select>                       
                                        </div>
                                        <label class="control-label col-sm-2">Doctor</label>
                                        <div class="col-sm-4">
                                            <select name="doctor" id="doctor" class="form-control" >
                                            </select>                        
                                        </div>

                                    </div>



                                    <div class="col-sm-9 col-sm-offset-3">
                                        <button type="submit" class="btn btn-danger">Register</button>
                                        <!--<button type="reset" class="btn btn-default">Reset</button>-->
                                    </div>
                                    <br />
                                    <input type="hidden" name="j" value="1">
                                </form>
                            <?php } else { ?>
                                <div class="well">YOU ARE SUCCESSFULLY REGISTERED</div>
                                <?php } ?>
                            </div>
                        </div>  
                    </div>
                </div>
            </div> 
            <?php require_once("common/scripts.php"); ?>	
        <script src="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.jquery.js"></script> 
        <script src="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.jquery.min.js"></script> 
        <script type="text/javascript">
                                            function checkemail(emailval) {
                                                $.post('admin/checkemail.php', {'emailid': emailval}, function (data) {
                                                    $('#logcheck').html(data);
                                                });
                                            }
                                            $("#diseas").chosen();
                                            $("body").on("change", "#diseas", function (e) {
//                                                alert($(this).val());



                                                $.ajax({
                                                    type: "POST",
                                                    url: '../common/service.php?j=4',
                                                    data: {diseas: $(this).val()}, // serializes the form's elements.
                                                    dataType: 'json',
                                                    success: function (data) {
                                                        $("#doctor").html("");
                                                        $('#doctor').append('<option value="0">Select Doctor</option>');
                                                        if (data.doctors) {
                                                            $.each(data.doctors, function (index, value) {
                                                                $('#doctor').append('<option value="' + value['id'] + '">' + value['name'] + '</option>');
                                                            });
                                                        } else {
                                                            $('#doctor').append('<option value="">No Doctor Found</option>');
                                                        }
                                                    }
                                                });
                                            });
        </script>
    </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

<?php

require_once("common/config.php");

require_once("common/database.php");

require_once("common/functions.php");

require_once("common/messages.php");

require_once("common/initialize.php");

if (isset($_POST["email"]) && $_POST["email"] != "") {

$email = trim($_POST['email']);

$pwd = md5(trim($_POST['pwd']));

if (!$email == "" && !$pwd == "") {

$query = "SELECT * FROM users WHERE email='$email' AND password='$pwd'";

$result = db::getRecord($query);

if (!empty($result)) {

$user = true;

} else {

$user = false;

}

//$pwd = md5($pwd);

//$query = "select u.*, ut.refcode as userrole from users u left join usertypes as ut on ut.typeid=u.usertype where email='" . $email . "' and password='". $pwd ."'" ;

//$user = db::getRecord($query);

if ($user) {

//saveLastActiveTime($user['id']);

$_SESSION["loggedInUserRole"] = $result['role'];

$_SESSION['firstname'] = $result['first_name'];

$_SESSION['lastname'] = $result['last_name'];

$_SESSION['email'] = $result['email'];

$_SESSION["isAdminloggedin"] = true;

$_SESSION['adminid'] = $result['id'];

if ($result['role'] == 'Admin') {

header('Location: ' . $site_root . 'admin/index.php');

}

/* if (trim($user["usertype"])=="1"){ //Administrator

$_SESSION["isAdminloggedin"]=true;

$_SESSION['adminid'] = $user['id'];

header('Location: '.$site_root.'admin/index.php');

} */

} else {

$_SESSION['error'] = "incorrect_login";

$_SESSION["msgType"] = "danger";

}

} else {

$_SESSION['error'] = "incorrect_login";

$_SESSION["msgType"] = "danger";

}

$disease_list = db::getRecords("select id,title as name from diseas");

//print_r($disease_list);

//exit;

<!DOCTYPE html>

<head>

<title>FSO ODA PATIENT <?php @showTitle($title); ?></title>

<!--[if lt IE 9]>

<![endif]-->

</head>

<style>

.container{max-width: 100%!important}

</style>

<body>

<i class="icon-lock"></i> Sign up

</div>

<?php if ($_GET["id"] != 1) { ?>

<label class="control-label col-sm-2" >First Name</label>

</div>

</div>

<label class="control-label col-sm-2">Email</label>

</div>

<label class="control-label col-sm-2">Contact</label>

</div>

<label class="control-label col-sm-2">Adress</label>

</div>

</div>

<label class="control-label col-sm-2">Disease</label>

<?php echo displayDropDown($disease_list, '') ?>

</select>

</div>

<label class="control-label col-sm-2">Doctor</label>

</select>

</div>

<button type="submit" class="btn btn-danger">Register</button>

</div>

<br />

</form>

<?php } else { ?>

<div class="well">YOU ARE SUCCESSFULLY REGISTERED</div>

<?php } ?>

</div>

<?php require_once("common/scripts.php"); ?>

function checkemail(emailval) {

$.post('admin/checkemail.php', {'emailid': emailval}, function (data) {

$('#logcheck').html(data);

});

}

$("#diseas").chosen();

$("body").on("change", "#diseas", function (e) {

// alert($(this).val());

$.ajax({

type: "POST",

url: '../common/service.php?j=4',

data: {diseas: $(this).val()}, // serializes the form's elements.

dataType: 'json',

success: function (data) {

$("#doctor").html("");

$('#doctor').append('<option value="0">Select Doctor</option>');

if (data.doctors) {

$.each(data.doctors, function (index, value) {

$('#doctor').append('<option value="' + value['id'] + '">' + value['name'] + '</option>');

});

} else {

$('#doctor').append('<option value="">No Doctor Found</option>');

}

});

</script>

</body>

</html>

doctor.php

<?php
require_once("common/config.php");
require_once("common/database.php");
require_once("common/functions.php");
require_once("common/messages.php");
require_once("common/initialize.php");

if (isset($_POST["email"]) && $_POST["email"] != "") {
    $email = trim($_POST['email']);
    $pwd = md5(trim($_POST['pwd']));
    if (!$email == "" && !$pwd == "") {
        $query = "SELECT * FROM users WHERE email='$email' AND password='$pwd'";
        $result = db::getRecord($query);

        if (!empty($result)) {
            $user = true;
        } else {
            $user = false;
        }
        //$pwd = md5($pwd);
        //$query = "select u.*, ut.refcode as userrole from users u left join usertypes as ut on ut.typeid=u.usertype where email='" . $email . "' and password='". $pwd ."'" ;
        //$user = db::getRecord($query);
        if ($user) {
            //saveLastActiveTime($user['id']);
            $_SESSION["loggedInUserRole"] = $result['role'];
            $_SESSION['firstname'] = $result['first_name'];
            $_SESSION['lastname'] = $result['last_name'];
            $_SESSION['email'] = $result['email'];
            $_SESSION["isAdminloggedin"] = true;
            $_SESSION['adminid'] = $result['id'];

            if ($result['role'] == 'Admin') {
                header('Location: ' . $site_root . 'admin/index.php');
            }

            /* if (trim($user["usertype"])=="1"){ //Administrator
              $_SESSION["isAdminloggedin"]=true;
              $_SESSION['adminid'] = $user['id'];
              header('Location: '.$site_root.'admin/index.php');
              } */
        } else {
            $_SESSION['error'] = "incorrect_login";
            $_SESSION["msgType"] = "danger";
        }
    } else {
        $_SESSION['error'] = "incorrect_login";
        $_SESSION["msgType"] = "danger";
    }
}
$disease_list = db::getRecords("select id,title as name from diseas");
//print_r($disease_list);
//exit;
?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <meta charset="utf-8">
        <!-- Title and other stuffs -->
        <title>FSOODADOCTOR <?php @showTitle($title); ?></title>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link href="style/bootstrap.css" rel="stylesheet">
        <link rel="stylesheet" href="style/font-awesome.css"> 
        <link rel="stylesheet" href="style/jquery-ui-1.9.2.custom.min.css"> 
        <link rel="stylesheet" href="style/fullcalendar.css">
        <link rel="stylesheet" href="style/prettyPhoto.css">  
        <link rel="stylesheet" href="style/rateit.css">
        <link rel="stylesheet" href="style/bootstrap-datetimepicker.min.css">
        <link rel="stylesheet" href="style/jquery.cleditor.css"> 
        <link rel="stylesheet" href="style/uniform.default.html"> 
        <link rel="stylesheet" href="style/daterangepicker-bs3.css" />
        <link rel="stylesheet" href="style/bootstrap-switch.css">
        <link href="style/style.css" rel="stylesheet">
        <link href="style/widgets.css" rel="stylesheet">   
        <link href="style/jquery.gritter.css" rel="stylesheet">   
        <link href="style/validationEngine.jquery.css" rel="stylesheet">
        <link href="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.css" rel="stylesheet">
        <link href="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.min.css" rel="stylesheet">
        <!-- HTML5 Support for IE -->
        <!--[if lt IE 9]>
        <script src="js/html5shim.js"></script>
        <![endif]-->

        <!-- Favicon -->
       <link rel="shortcut icon" href="../img/favicon.png"> 
    </head>
    <style>
        .container{max-width: 100%!important}
    </style>


    <body>


        <!-- Form area -->
        <div class="container">

            <div class="row">
                <div class="col-sm-12">
                    <!-- Widget starts -->
                    <div class="widget">
                        <!-- Widget head -->
                        <div class="widget-head">
                            <i class="icon-lock"></i> Sign up 
                        </div>


                        <div class="widget-content">
                            <!-- Login form -->
                            <?php if ($_GET["id"] != 1) { ?>
                                <form class="validate form-horizontal" role="form" id="formLogin" action='actions.php' method="post" enctype="multipart/form-data">
                                    <!-- Email -->
                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2" >First Name</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="first_name" class="validate[required] form-control" placeholder="first name" onChange="checkemail(this.value);"/>                        
                                        </div>
                                        <label class="control-label col-sm-2" for="inputEmail">Last Name</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="last_name" class="validate[required] form-control" placeholder="last Name" onChange="checkemail(this.value);"/>                        
                                        </div>

                                    </div>
                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2">Email</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="email" class="validate[required, custom[email]] form-control" placeholder="email" onChange="checkemail(this.value);"/>                        
                                        </div>
                                        <label class="control-label col-sm-2">Contact</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="contact" class="validate[required,custom[integer]] form-control" placeholder="contact" onChange="checkemail(this.value);"/>                        
                                        </div>

                                    </div>

                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2">Adress</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="adress" class="validate[required] form-control" placeholder="adress" onChange="checkemail(this.value);"/>                        
                                        </div>
                                        <label class="control-label col-sm-2">City</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="city" class="validate[required] form-control" placeholder="city" onChange="checkemail(this.value);"/>                        
                                        </div>

                                    </div>
                                    <div class="form-group padd">
                                        <label class="control-label col-sm-2">Disease</label>
                                        <div class="col-sm-4">
                                            <select name="diseas[]" id="diseas" class="form-control" multiple>
                                                <?php echo displayDropDown($disease_list, '') ?> 
                                            </select>                       
                                        </div>   
                                        <label class="control-label col-sm-2">Registration Number</label>
                                        <div class="col-sm-4">
                                            <input type="text" name="reg_no" class="validate[required] form-control" placeholder="Enter Reg No"/>                        
                                        </div>
                                    </div>



                                    <div class="col-sm-9 col-sm-offset-3">
                                        <button type="submit" class="btn btn-danger">Register</button>
                                        <!--<button type="reset" class="btn btn-default">Reset</button>-->
                                    </div>
                                    <br />
                                    <input type="hidden" name="j" value="4">
                                </form>
                            <?php } else { ?>
                                <div class="well">asdf</div>
                            <?php } ?>
                        </div>
                    </div>  
                </div>
            </div>
        </div> 
        <?php require_once("common/scripts.php"); ?>	
        <script src="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.jquery.js"></script> 
        <script src="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.jquery.min.js"></script> 
        <script type="text/javascript">

                                                $("#diseas").chosen();

        </script>
    </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

<?php

require_once("common/config.php");

require_once("common/database.php");

require_once("common/functions.php");

require_once("common/messages.php");

require_once("common/initialize.php");

if (isset($_POST["email"]) && $_POST["email"] != "") {

$email = trim($_POST['email']);

$pwd = md5(trim($_POST['pwd']));

if (!$email == "" && !$pwd == "") {

$query = "SELECT * FROM users WHERE email='$email' AND password='$pwd'";

$result = db::getRecord($query);

if (!empty($result)) {

$user = true;

} else {

$user = false;

}

//$pwd = md5($pwd);

//$query = "select u.*, ut.refcode as userrole from users u left join usertypes as ut on ut.typeid=u.usertype where email='" . $email . "' and password='". $pwd ."'" ;

//$user = db::getRecord($query);

if ($user) {

//saveLastActiveTime($user['id']);

$_SESSION["loggedInUserRole"] = $result['role'];

$_SESSION['firstname'] = $result['first_name'];

$_SESSION['lastname'] = $result['last_name'];

$_SESSION['email'] = $result['email'];

$_SESSION["isAdminloggedin"] = true;

$_SESSION['adminid'] = $result['id'];

if ($result['role'] == 'Admin') {

header('Location: ' . $site_root . 'admin/index.php');

}

/* if (trim($user["usertype"])=="1"){ //Administrator

$_SESSION["isAdminloggedin"]=true;

$_SESSION['adminid'] = $user['id'];

header('Location: '.$site_root.'admin/index.php');

} */

} else {

$_SESSION['error'] = "incorrect_login";

$_SESSION["msgType"] = "danger";

}

} else {

$_SESSION['error'] = "incorrect_login";

$_SESSION["msgType"] = "danger";

}

$disease_list = db::getRecords("select id,title as name from diseas");

//print_r($disease_list);

//exit;

<!DOCTYPE html>

<head>

<title>FSOODADOCTOR <?php @showTitle($title); ?></title>

<!--[if lt IE 9]>

<![endif]-->

</head>

<style>

.container{max-width: 100%!important}

</style>

<body>

<i class="icon-lock"></i> Sign up

</div>

<?php if ($_GET["id"] != 1) { ?>

<label class="control-label col-sm-2" >First Name</label>

</div>

</div>

<label class="control-label col-sm-2">Email</label>

</div>

<label class="control-label col-sm-2">Contact</label>

</div>

<label class="control-label col-sm-2">Adress</label>

</div>

</div>

<label class="control-label col-sm-2">Disease</label>

<?php echo displayDropDown($disease_list, '') ?>

</select>

</div>

<label class="control-label col-sm-2">Registration Number</label>

</div>

<button type="submit" class="btn btn-danger">Register</button>

</div>

<br />

</form>

<?php } else { ?>

<?php } ?>

</div>

<?php require_once("common/scripts.php"); ?>

$("#diseas").chosen();

</script>

</body>

</html>

actions.php

<?php include ("common/config.php"); ?>
<?php include ("common/initialize.php"); ?>
<?php include ("common/database.php"); ?>
<?php include ("common/imageprocessing.php"); ?>
<?php include ("common/functions.php"); ?>
<?php include ("common/mail.php"); ?>
<?php

secureIt("Admin");

if (!isset($_POST["j"]) && !isset($_GET['j'])) {
    $_SESSION['error'] = "901";
    $_SESSION["msgType"] = "danger";
    header("location: " . $site_root . "index.php?m=901");
} else {
    $task = trim($_REQUEST['j']);
}
switch ($task) {
    case 2: //Logout
        logout();
        header('Location: ' . $site_root . 'index.php');
        break;
    case 3: //send mail


        break;

    case 1: //Update Account        
        $id = $_SESSION["adminid"];
        $firstname = escape(trim($_POST['first_name']));
        $obj['first_name'] = $firstname;
        $obj['last_name'] = escape(trim($_POST['last_name']));
        $email = escape(trim($_POST['email']));
        $obj['email'] = $email;

        $obj['contact_number'] = escape(trim($_POST['contact']));
        $obj['adress'] = escape(trim($_POST['adress']));
        $obj['role'] = "Patient";

        $password = unique_id();

        $obj['password'] = md5(trim($password));


        $query = db::prepInsertQuery($obj, "users"); //(Associative array, table name, record id)
//        echo $query;
//        exit;
        $result = db::InsertRecord($query);
        $obj = null;
        foreach ($_POST['diseas'] as $disease) {
            $obj['user_id'] = $result;
            $obj['d_id'] = $disease;
            $obj['type'] = 0;

            $query = db::prepInsertQuery($obj, "user_disease");
//echo $query;
            db::InsertRecord($query);
            $obj = null;
        }
//        exit;
        $obj['p_id'] = $result;
        $obj['doc_id'] = $_POST['doctor'];
        $obj['created_by'] = 0;
        $obj['created'] = strtotime(date(date_format, time()));
        $query = db::prepInsertQuery($obj, "appointment");
//        echo $query;
//        exit;
        $result = db::InsertRecord($query);
        $subject = "Welcome to Future Scope Of online Appointment";
        $message = "Dear " . ucfirst($firstname) . ",
                Welcome to Future Scope Of online Appointment - The largest online appointment system of pakistan. 
                <p>Your registration form for the doctor has been received.</P>
                <p>Our team shall contact you shortly.</P>
                <p>Please find your account credentials below:</P>
                <p><strong>User:</strong> " . $email . "<br>
                <strong>Password:</strong> " . $password . "</p>";
        sendSMTP($message, $subject, 'umairmuhammad063@gmail.com', $toname = "", 'onlineappointment@axiomsoft.net', $fromname = "", $attachment = "");
        adminRedirect("patient", $result, 1, 2); // (filename, true/false, record id, [update=1, insert=2, del=3])
        break;
    case 4: //Update Account        
        $id = $_SESSION["adminid"];
        $firstname = escape(trim($_POST['first_name']));
        $obj['first_name'] = $firstname;
        $obj['last_name'] = escape(trim($_POST['last_name']));
        $email = escape(trim($_POST['email']));
        $obj['email'] = $email;
        $obj['reg_no'] = $_POST['reg_no'];

        $obj['contact_number'] = escape(trim($_POST['contact']));
        $obj['adress'] = escape(trim($_POST['adress']));
        $obj['role'] = "Doctor";

        $password = unique_id();

        $obj['password'] = md5(trim($password));
        $obj['created'] = strtotime(date(date_format, time()));

        $query = db::prepInsertQuery($obj, "users"); //(Associative array, table name, record id)
//        echo $query;
//        exit;
        $result = db::InsertRecord($query);
        $obj = null;
        foreach ($_POST['diseas'] as $disease) {
            $obj['user_id'] = $result;
            $obj['d_id'] = $disease;
            $obj['type'] = 1;

            $query = db::prepInsertQuery($obj, "user_disease");
//echo $query;
            db::InsertRecord($query);
            $obj = null;
        }
//        exit;

        $subject = "Welcome to Future Scope Of online Appointment";
        $message = "Dear " . ucfirst($firstname) . ",
                Welcome to Future Scope Of online Appointment - The largest online appointment system of pakistan. 
                <p>Your registration form for the doctor has been received.</P>
                <p>Our team shall contact you shortly.</P>
                <p>Please find your account credentials below:</P>
                <p><strong>User:</strong> " . $email . "<br>
                <strong>Password:</strong> " . $password . "</p>";
        sendSMTP($message, $subject, 'umairmuhammad063@gmail.com', $toname = "", 'onlineappointment@axiomsoft.net', $fromname = "", $attachment = "");
        adminRedirect("doctor", $result, 1, 2); // (filename, true/false, record id, [update=1, insert=2, del=3])
        break;
}
?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

<?php include ("common/config.php"); ?>

<?php include ("common/initialize.php"); ?>

<?php include ("common/database.php"); ?>

<?php include ("common/imageprocessing.php"); ?>

<?php include ("common/functions.php"); ?>

<?php include ("common/mail.php"); ?>

<?php

secureIt("Admin");

if (!isset($_POST["j"]) && !isset($_GET['j'])) {

$_SESSION['error'] = "901";

$_SESSION["msgType"] = "danger";

header("location: " . $site_root . "index.php?m=901");

} else {

$task = trim($_REQUEST['j']);

}

switch ($task) {

case 2: //Logout

logout();

&nbs