ÕªÒª
Ëæ×ÅÍøÂçÉç»áµÄ²»¶Î·¢Õ¹£¬Öб±É̳ÇÍøÉ϶©µ¥¿Í»§Ô½À´Ô½¶à£¬Ç°À´×ÉѯµÄ¿Í»§Ò²ÊDz»¼ÆÆäÊý£¬Í¬Ê±ÊÛÇ°×Éѯ¹¤×÷µÄЯ´ø¶ø´øÀ´µÄÊÛºóÎÊÌâÒ²ÊÇÈÕ¼ûµÄÃ÷ÏÔ£¬¿ª·¢Öб±É̳ÇÊÛÇ°ÊÛºó¹ÜÀíϵͳҲÊDZØÔÚ±ØÐУ¬±¾ÏµÍ³Ö÷Òª¿ÉÒÔÌṩÐÅÏ¢µÄ×ÉѯºÍÊÛºóºÍ´¦Àí£¬¿Í»§¿ÉÒÔͨ¹ýϵͳǰ̨²éѯÏà¹Ø¹ºÂòÐÅÏ¢ºÍ×Éѯ¿Í·þÈËÔ±£¬Í¬Ê±Ò²¿ÉÒÔ½øÐÐÁôÑÔÌá½»ºÍ¶©µ¥µÄÊÛºó´¦Àí£¬¹ÜÀíÔ±¿ÉÒÔ·¢²¼É̳ǵÄÏà¹Ø×ÉѯÐÅÏ¢£¬Ìṩ24СʱÔÚÏß¿Í·þºÍ¿Í»§ÁôÑԵĴ¦Àí¹¤×÷£¬»¹¿ÉÒÔ´¦Àí¿Í»§Ìá½»µÄÊÛºó¹¤×÷¡£
±¾ÎÄÖ÷ÒªÑо¿»ùÓÚPHPµÄÖб±É̳ÇÊÛÇ°ÊÛºó¹ÜÀíϵͳµÄϵͳ½á¹¹Éè¼Æ¡¢ÊµÏÖ·½·¨ºÍ²Ù×÷Á÷³Ì£¬²¢½éÉÜÁËϵͳ¸÷¸öÄ£¿éµÄÖ÷Òª¹¦ÄܺÍÊý¾Ý¿âÉè¼Æ¼°¹¦ÄÜ¡£¸Ãϵͳ²ÉÓÃB/S½á¹¹£¬²ÉÓÃPHP¼¼Êõ½øÐж¯Ì¬´°ÌåÒ³ÃæµÄÉè¼Æ¡£ºǫ́Êý¾Ý¿âÑ¡ÓÃMySQL Êý¾Ý¿â¡£ÏµÍ³Éè¼Æ²¢ÊµÏÖÁËǰ̨¿Í»§¿ÉÒÔ×Éѯ¹ºÎïÐÅÏ¢¡¢²éѯ×ÉѯÐÅÏ¢¡¢Ìá½»ÁôÑÔÐÅÏ¢¡¢Ìá½»ÊÛºó´¦Àí£¬ºǫ́¹ÜÀíÈËÔ±¿ÉÒÔµØÁôÑÔÐÅÏ¢¡¢ÊÛºó´¦ÀíÐÅÏ¢ºÍ×ÉѯÐÅÏ¢½øÐйÜÀí²Ù×÷¡£
¹Ø¼ü´Ê£ºMYSQL £»¹ÜÀíϵͳ£»PHP;
Abstract
With the development of network society not paragraph development, North mall online orders more and more customers come to the consultation, the customer is too many to count, and pre-sales consulting work to carry and customer service problems is more obvious, the development of the North mall pre-sales customer service management system also will need, the system can provide information consulting and customer service and processing through the system, customers can purchase the inquiry related information and consulting service personnel, but also customer service processing message submission and order, the administrator can publish mall related consulting information, provide 24 hours online customer service and customer message, can also handle customer to customer service work.
This thesis focuses on the system structure design, the North mall pre-sales customer service management system PHP implementation method and operation process, and introduces the main function and the database design and the function of each module of the system. The system uses B/S structure design, dynamic form page by PHP technology. Background database using MySQL database. The system designs and realizes customer can consult shopping information, query information, submit the message information, submit customer service process, the administrator can message processing, customer service information and consulting information management operations.
Keywords: MYSQL; management system; PHP;
¼
µÚ1Õ Ð÷ÂÛ 4
1.1¿ÎÌâ±³¾° 4
1.2Ñ¡ÌâÒâÒå 4
1.3¹úÄÚÍâÑо¿ÏÖ×´ 4
µÚ2Õ ϵͳ·ÖÎö 5
2.1¿ÉÐÐÐÔ·ÖÎö 5
2.1.1¼¼Êõ¿ÉÐÐÐÔ·ÖÎö 5
2.1.2¾¼Ã¿ÉÐÐÐÔ·ÖÎö 5
2.1.2²Ù×÷¿ÉÐÐÐÔ·ÖÎö 6
2.2¹¦ÄÜÐèÇó·ÖÎö 6
2.3ÒµÎñÁ÷³Ì·ÖÎö 7
2.4Êý¾ÝÁ÷³Ì·ÖÎö 9
µÚ3Õ ϵͳÉè¼Æ 10
3.1ϵͳÉè¼ÆÔÔò 10
3.2ϵͳ½á¹¹Éè¼Æ 10
3.3ϵͳ¿ª·¢¹¤¾ß 11
3.2.1 PHP¼¼Êõ 11
3.2.2 MySQL Server 11
3.2.3 Macromedia Dreamweaver 8 13
3.3.4 IIS¹ÜÀíÆ÷ 14
µÚ4Õ Êý¾Ý¿âÉè¼Æ 15
4.1Êý¾Ý¿âÉè¼ÆµÄÔÔò 15
4.2Êý¾Ý¿â¸ÅÄîÉè¼Æ£¨E-Rͼ£© 15
4.3Êý¾Ý±íÉè¼Æ 17
µÚ5Õ ϵͳҳÃæ²Ù×÷˵Ã÷ 17
5.1ǰ̨²Ù×÷˵Ã÷ 17
5.1.1ÍøÕ¾Ê×Ò³Ò³Ãæ 17
5.1.2Óû§×¢²áÒ³Ãæ 18
5.1.3ÔÚÏßÁôÑÔÒ³Ãæ 20
5.1.4Ìí¼ÓÔÚÏß×ÉѯҳÃæ 24
5.2ºǫ́²Ù×÷˵Ã÷ 28
5.2.1¹ÜÀíÔ±ºǫ́µÇ½ҳÃæ 28
5.2.2¿Í»§ÐÅÏ¢²éѯҳÃæ 29
5.2.3Õ¾ÄÚÐÂÎÅÌí¼ÓÒ³Ãæ 30
5.2.4»Ø¸´ÔÚÏß×ÉѯҳÃæ 30
µÚ6Õ ×Ü ½á 31
Ö л 32
²Î¿¼ÎÄÏ× 33
µÚ1Õ Ð÷ÂÛ
1.1¿ÎÌâ±³¾°
׿ÆËã»ú¼¼ÊõÔÚ¸÷Ðи÷ÒµÈÕÒæ¹ã·ººÍÉîÈëµÄÓ¦Óã¬ÍøÂçµÄ¸ÅÄîÔçÒÑÉîÈëÈËÐÄ¡£ÍøÂçÔÚ¸÷Ðи÷ÒµµÄ·¢Õ¹Õ½ÂÔÖÐÕ¼¾ÝÁËÖØÒªµÄλÖ㬳ÉΪÉ̼Ҳ»¿É·Ö¸îµÄ²¿·Ö¡£ÉÌÆ·µÄÐû´«ÒѲ»Ö»¾ÖÏÞÓÚµçÊÓÓ뱨ֽ£¬ÍøÂçÒѳÉΪÉ̼Òչʾ×Ô¼ºµÄÁíÒ»¸öÎę̀¡£É̼ҽ¨Á¢ÍøÕ¾£¬½«É̼Ҹ÷·½ÃæµÄÐû´«Óë·þÎñÕ¹ÏÖÓÚÍøÂçÖУ¬Í¨¹ýÍøÂç¸ü¿ÉʵÏÖÈçÍøÉϹºÎï¡¢ÐÅÏ¢²éÑ°µÈ¹¦ÄÜ£¬ÕâЩÔڸıäÎÒÃÇÔÓоӪ·½Ê½Óë¾ÓªÀíÄîµÄͬʱ£¬Ò²ÎªÉ̼ҴøÀ´Á˸ü¸ßµÄЧÒæ¡£Òò´Ë£¬¶ÔÓÚÉ̼ÒÀ´Ëµ£¬ÓµÓÐÒ»¸öÊôÓÚ×Ô¼ºµÄÍøÕ¾ÊÇÖÁ¹ØÖØÒªµÄ¡£¡°ÍøÉÏÉ̳ǡ±Êµ¼ÊÉÏÊÇÔËÐÐÔÚWeb·þÎñÆ÷ÖеÄÒ»¸öWebÔËÓóÌÐò¡£¡°ÍøÉÏÉ̵ꡱģÄâÒ»°ãµÄÉ̵êµÄ¾ÓªÄ£Ê½¡£ÀûÓÃÒ³Ãæ¡¢½Å±¾³ÌÐòÀ´ÊµÏÖ¡°ÍøÉÏÉ̳ǡ±µÄ½ø»õ¹ÜÀí¡¢ÏúÊÛ¹ÜÀí¡¢¿â´æ¹ÜÀí¡£»¥ÁªÍø¼¼ÊõÌṩµÄ²»½ö½öÖ»Êǹ©ÐèË«·½¼äµÄ½ÏµÍµÄ½»Ò׳ɱ¾£¬»¹Óнϵ͵ÄÑ¡Ôñ·ÑÓú͸ü¶à¿É¹©Ñ¡ÔñµÄÉÌÆ·¡£ÕâЩÌصã´ÙʹÉ̼Ҹü¶àµØͨ¹ýʹÓÃÍøÕ¾À´ÊµÏÖµç×ÓÉÌÎñ,Öб±É̳ÇÍøվƽ̨¿Í»§Á¿·Ç³£´ó,ÿÌìµç»°×Éѯ¹ºÎïÓû§·Ç³£¶à,×ÉѯÈÈÏßÓÐʱ»áµÈºÜ¾Ãʱ¼ä²Å»áÓй¤×÷ÈËÔ±»Ø´ð,½çÓÚ´Ë,¹«Ë¾¾ö¶Ô¿ª·¢Ò»Ì×ÔÚÉ̳ÇÉϵÄÒ»¸öÐÅÏ¢×Éѯƽ̨¡ª¡ªÖб±É̳ÇÊÛÇ°ÊÛºó¹ÜÀíϵͳ¡£