我的需求是这样的,使用workerman 来做前后端的长链接,然后mysql的一张表一旦有了新的数据,就把新的数据发送到前端,发送的数据是个数组,我该怎么实现?如果我的描述不够清楚,请再问,本人在线等,谢谢大神帮忙解决了.
回复内容:
我的需求是这样的,使用workerman 来做前后端的长链接,然后mysql的一张表一旦有了新的数据,就把新的数据发送到前端,发送的数据是个数组,我该怎么实现?如果我的描述不够清楚,请再问,本人在线等,谢谢大神帮忙解决了.
http://www.workerman.net/web-sender
可以通过workerman的phpsocket.io推送
http://wenda.workerman.net/?/question/508
可以在Worker中开一个text端口推送
http://workerman.net/gatewaydoc/advanced/push.html
利用workerman的gatewayWorker推送,使用GatewayClient
什么时候触发以及怎么触发需要自己控制
我一般使用redis来解决。
在插入表的地方进行判断,是否需要把数据发送给前端
使用触发器吧,先创建自定义函数,函数会访问你需要回调的程序的端口,然后触发器里面调用该函数----我说的是mysql触发器,mysql diy函数可以直接用c来写,方便又快捷,php装一个多线程模块,监听两个端口,一个用于与前端websocket进行交互,一个用于接收mysql触发器发送过来的数据,可以在数据库中建立一个socketid表用来关联各个线程,其实这种破事用.net会比较好写
可以定时查下数据库,如果有数据,就调workerman的接口发过去
我当年遇到这个需求,需要数据库主动推送数据给应用程序通知,然并未发现啥解决方案,这个要问dba是不是有这种手段,我解决方案当时用的定时任务,轮训的数据库~
另外,数据的录入过程那里能不能给你系统个通知啥的,具体可以聊聊设计
没接触过workerman,代码也写得少,仅仅提供一种思路:
<code>在写入数据 的代码那里加一个 拦截函数,起到通知workerman的作用</code>
这个有个局限性,就是数据库有多个写入口的话,这样就很蛋疼。
尽量不要与mysql结合

Setting session cookie parameters in PHP can be achieved through the session_set_cookie_params() function. 1) Use this function to set parameters, such as expiration time, path, domain name, security flag, etc.; 2) Call session_start() to make the parameters take effect; 3) Dynamically adjust parameters according to needs, such as user login status; 4) Pay attention to setting secure and httponly flags to improve security.

The main purpose of using sessions in PHP is to maintain the status of the user between different pages. 1) The session is started through the session_start() function, creating a unique session ID and storing it in the user cookie. 2) Session data is saved on the server, allowing data to be passed between different requests, such as login status and shopping cart content.

How to share a session between subdomains? Implemented by setting session cookies for common domain names. 1. Set the domain of the session cookie to .example.com on the server side. 2. Choose the appropriate session storage method, such as memory, database or distributed cache. 3. Pass the session ID through cookies, and the server retrieves and updates the session data based on the ID.

HTTPS significantly improves the security of sessions by encrypting data transmission, preventing man-in-the-middle attacks and providing authentication. 1) Encrypted data transmission: HTTPS uses SSL/TLS protocol to encrypt data to ensure that the data is not stolen or tampered during transmission. 2) Prevent man-in-the-middle attacks: Through the SSL/TLS handshake process, the client verifies the server certificate to ensure the connection legitimacy. 3) Provide authentication: HTTPS ensures that the connection is a legitimate server and protects data integrity and confidentiality.

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

PHP and Python are both high-level programming languages that are widely used in web development, data processing and automation tasks. 1.PHP is often used to build dynamic websites and content management systems, while Python is often used to build web frameworks and data science. 2.PHP uses echo to output content, Python uses print. 3. Both support object-oriented programming, but the syntax and keywords are different. 4. PHP supports weak type conversion, while Python is more stringent. 5. PHP performance optimization includes using OPcache and asynchronous programming, while Python uses cProfile and asynchronous programming.

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Atom editor mac version download
The most popular open source editor

SublimeText3 English version
Recommended: Win version, supports code prompts!

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.