简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)
Home > Backend Development > PHP Tutorial > body text

php判断输入不超过mysql的varchar字段的长度范围_php技巧

WBOY
Release： 2016-05-17 09:18:08
Original
890 people have browsed it

但是如果在utf-8编码下，一个汉字是占3个字符长度的，比如字符串$str=”你好啊!!”;

如果你用strlen函数来判断，长度是11，正好超过了varchar的长度，但实际上确不是这样，如果直接到phpmyadmin里面执行insert语句,这条字符串是可以插入的！

对于数据库来说，它的长度是5，那么我们如何用PHP来得到这个长度呢？使用iconv_strlen()函数！

echo iconv_strlen($str,'utf-8′);

注意第二个参数，是当前字符集，这样根据不同的字符集你得到的结果都是根据一个字符占一个长度计算来的！

上面的语句，将输出5，怎么样，你会判断了吗？

Related labels：
mysql varchar
source：php.cn
Previous article：php设计模式 Prototype (原型模式)代码_php技巧 Next article：PHP如何解决网站大流量与高并发的问题_php文摘
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact [email protected]
Latest Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0 1 290
Using triggers and constraints to limit the number of records in MySQL I have a table called BFFs that stores user IDs and best friends' user IDs, and I want to ...
From 2023-11-14 13:35:02
0 4 434
Resolving django.db.utils.NotSupportedError error in Django I'm getting an error when running a project in Django. The problem is unfortunately I upgr...
From 2023-11-14 11:59:20
0 1 246
Retrieve MySql rows with the same column value Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, b...
From 2023-11-10 21:53:39
0 2 331
How to publish SQLite database data to an online MySQL database in Flutter? How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?
From 2023-11-10 12:36:40
0 2 247
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！