使用PHP和MySQL的小型CRM项目

此项目是使用PHP和MySQL的小型CRM项目。介绍了如何运行小型CRM项目:1.下载压缩文件,2.解压缩文件并复制crm文件夹,3.在根目录下粘贴(用于xampp xampp / htdocs,用于wamp wamp / www,用于灯var / www / html),4.打开PHPMyAdmin(http:// localhost / phpmyadmin),5.创建一个名称为CRM的数据库,6.导入crm.sql文件(在SQL文件夹的zip包中提供).......等等。

应用介绍

此项目是使用PHP和MySQL的小型CRM项目。使用的技术有PHP 5.6或更高版本,MYSQL,HTML,CSS,JAVASCRIPT,JQUERY,AJAX。用户模块的功能有用户注册(首次用户可以注册)、个人资料管理、请求报价、票务系统。管理面板的凭证:用户名:admin、密码:admin。用户面板的凭证:用户名:demo@gmail.com,密码:Test @ 123。本人只展示了一小部分代码,想了解更多请下载附件。

<?php
session_start();
//echo $_SESSION['id'];
//$_SESSION['msg'];
include("dbconnection.php");
include("checklogin.php");
check_login();
if(isset($_POST['send']))
{
$count_my_page = ("hitcounter.txt");
$hits = file($count_my_page);
$hits[0] ++;
$fp = fopen($count_my_page , "w");
fputs($fp , "$hits[0]");
fclose($fp);
$tid=$hits[0];
$email=$_SESSION['login'];
$subject=$_POST['subject'];
$tt=$_POST['tasktype'];
$priority=$_POST['priority'];
$ticket=$_POST['description'];
//$ticfile=$_FILES["tfile'"]["name"];
$st="Open";
$pdate=date('Y-m-d');
//move_uploaded_file($_FILES["tfile"]["tmp_name"],"ticketfiles/".$_FILES["tfile"]["name"]);
$a=mysqli_query($con,"insert into ticket(ticket_id,email_id,subject,task_type,prioprity,ticket,status,posting_date)  values('$tid','$email','$subject','$tt','$priority','$ticket','$st','$pdate')");
if($a)
{
echo "<script>alert('Ticket Genrated');</script>";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<meta charset="utf-8" />
<title>CRM | Create  ticket</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<meta content="" name="description" />
<meta content="" name="author" />
<link href="assets/plugins/pace/pace-theme-flash.css" rel="stylesheet" type="text/css" media="screen"/>
<link href="assets/plugins/boostrapv3/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
<link href="assets/plugins/boostrapv3/css/bootstrap-theme.min.css" rel="stylesheet" type="text/css"/>
<link href="assets/plugins/font-awesome/css/font-awesome.css" rel="stylesheet" type="text/css"/>
<link href="assets/css/animate.min.css" rel="stylesheet" type="text/css"/>
<link href="assets/plugins/jquery-scrollbar/jquery.scrollbar.css" rel="stylesheet" type="text/css"/>
<link href="assets/css/style.css" rel="stylesheet" type="text/css"/>
<link href="assets/css/responsive.css" rel="stylesheet" type="text/css"/>
<link href="assets/css/custom-icon-set.css" rel="stylesheet" type="text/css"/>
</head>
<body class="">
<?php include("header.php");?>
<div class="page-container row-fluid"> 
 <?php include("leftbar.php");?>
 <div class="clearfix"></div>
    <!-- END SIDEBAR MENU --> 
  </div>
  </div>
  <a href="#" class="scrollup">Scroll</a>
   <div class="footer-widget">  
 <div class="progress transparent progress-small no-radius no-margin">
  <div data-percentage="79%" class="progress-bar progress-bar-success animate-progress-bar" ></div>  
 </div>
 <div class="pull-right">
 </div>
  </div>
  <!-- END SIDEBAR --> 
  <!-- BEGIN PAGE CONTAINER-->
  <div class="page-content"> 
    <!-- BEGIN SAMPLE PORTLET CONFIGURATION MODAL FORM-->
    <div id="portlet-config" class="modal hide">
      <div class="modal-header">
        <button data-dismiss="modal" class="close" type="button"></button>
        <h3>Widget Settings</h3>
      </div>
      <div class="modal-body"> Widget settings form goes here </div>
    </div>
    <div class="clearfix"></div>
    <div class="content">  
  <div class="page-title"> 
   <h3>Create ticket</h3>
     
 
             <div class="row">
                        <div class="col-md-12">
                            
                            <form class="form-horizontal" name="form1" method="post" action="" onSubmit="return valid();">
                            <div class="panel panel-default">
                             
                                <div class="panel-body">                                                                        
                                    <p align="center" style="color:#FF0000"><?=$_SESSION['msg1'];?><?=$_SESSION['msg1']="";?></p>
                               <div class="form-group">                                        
                                        <label class="col-md-3 col-xs-12 control-label">Subject</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-pencil"></span></span>
                                                <input type="text" name="subject" id="subject" value="" required class="form-control"/>
                                            </div>            
                                        
                                        </div>
                                    </div>
         
         
          <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Task Type</label>
                                        <div class="col-md-6 col-xs-12">                                                                                            
                                            <select  name="tasktype" class="form-control select" required>
                                                <option> Select your Task Type</option>
                                                <option value="billing">Billing</option>
                                                <option value="ot1">Option 1</option>
                                                <option value="ot2">Option 2</option>
                                                <option value="ot3">Option 3</option>
                                            </select>
                                           </div>
                                    </div>
         
           <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Priority</label>
                                        <div class="col-md-6 col-xs-12">                                                                                            
                                            <select name="priority" class="form-control select">
                                                <option value="">Choose your Priority</option>
                                                <option value="important">Important</option>
                                                <option value="urgent(functional problem)">Urgent (Functional Problem)</option>
                                                <option value="non-urgent">Non-Urgent</option>
                                                <option value="question">Question</option>
                                            </select>
                                           </div>
                                    </div>
         
           
                                    <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Description</label>
                                        <div class="col-md-6 col-xs-12">                                            
                                            <textarea name="description" required class="form-control" rows="5"></textarea>
                                            
                                        </div>
                                    </div>
         
        
                                    </div>
                                
                                    
                                    
                                </div>
        
                                <div class="panel-footer">
                                    <button class="btn btn-default">Clear Form</button>                                    
                                    <input type="submit" value="Send" name="send" class="btn btn-primary pull-right">
                                </div>
                            </div>
                            </form>
                            
                        </div>
                    </div>                          
  </div>
    </div>
  </div>
 </div>
<script src="assets/plugins/jquery-1.8.3.min.js" type="text/javascript"></script> 
<script src="assets/plugins/jquery-ui/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script> 
<script src="assets/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script> 
<script src="assets/plugins/breakpoints.js" type="text/javascript"></script> 
<script src="assets/plugins/jquery-unveil/jquery.unveil.min.js" type="text/javascript"></script> 
<script src="assets/plugins/jquery-block-ui/jqueryblockui.js" type="text/javascript"></script> 
<script src="assets/plugins/jquery-scrollbar/jquery.scrollbar.min.js" type="text/javascript"></script>
<script src="assets/plugins/pace/pace.min.js" type="text/javascript"></script>  
<script src="assets/plugins/jquery-numberAnimate/jquery.animateNumbers.js" type="text/javascript"></script>
<script src="assets/js/core.js" type="text/javascript"></script> 
<script src="assets/js/chat.js" type="text/javascript"></script> 
<script src="assets/js/demo.js" type="text/javascript"></script> 
</body>
</html>

文件列表(部分)

名称 大小 修改日期
Small CRM Projects Using PHP and MySQL0.00 KB2019-08-24
crm0.00 KB2019-08-24
admin0.00 KB2019-08-26
assets0.00 KB2019-08-32
css0.00 KB2019-08-30
animate.min.css40.65 KB2014-08-40
bootstrap-table-responsive.css1.16 KB2014-08-40
custom-icon-set.css2.66 KB2014-09-24
large_screen_tweak.css5.19 KB2014-08-40
magic_space.css5.26 KB2014-08-40
print.css0.26 KB2014-08-40
responsive.css36.21 KB2014-09-52
rtl0.00 KB2019-08-30
responsive.css36.25 KB2014-09-42
style.css164.65 KB2014-09-28
style.css164.64 KB2014-09-54
style.css.map67.17 KB2014-08-40
themes0.00 KB2019-08-30
coporate0.00 KB2019-08-30
responsive.css36.79 KB2014-09-02
style.css165.17 KB2014-09-30
default0.00 KB2019-08-30
responsive.css36.21 KB2014-09-50
style.css164.61 KB2014-09-04
elegant0.00 KB2019-08-30
responsive.css36.25 KB2014-09-48
style.css164.64 KB2014-09-10
simple0.00 KB2019-08-30
responsive.css36.26 KB2014-09-58
style.css164.64 KB2014-09-18
fonts0.00 KB2019-08-30
custom-set.dev.svg14.06 KB2014-08-40

立即下载

相关下载

[使用PHP和MySQL的小型CRM项目] 此项目是使用PHP和MySQL的小型CRM项目。介绍了如何运行小型CRM项目:1.下载压缩文件,2.解压缩文件并复制crm文件夹,3.在根目录下粘贴(用于xampp xampp / htdocs,用于wamp wamp / www,用于灯var / www / html),4.打开PHPMyAdmin(http:// localhost / phpmyadmin),5.创建一个名称为CRM的数据库,6.导入crm.sql文件(在SQL文件夹的zip包中提供).......等等。

评论列表 共有 1 条评论

暂无评论

微信捐赠

微信扫一扫体验

立即
上传
发表
评论
返回
顶部