Use PHP to output part of the text in the database

How to output part of the text in the database under php

Owner, don’t listen to other people’s nonsense. Every time there are people who don’t know how to pretend to understand,

If substr is used and the number happens to be in Chinese, garbled characters will appear

Because numbers and letters count as 1 byte, and Chinese counts as 2 bytes,

substr is not cut by numbers but by bytes

you can use it

echo mb_substr('I am very happy today', 0, 5, 'utf-8');

echo mb_strcut ('I am very happy today', 0,5, 'utf-8');

The first one is output by number,

The second one is output by bytes,

The most important thing is that there will be no garbled characters

If your page is gb2312, you can change the utf-8 on the back yourself

But the first few words you want to extract from your article, if it is edited with an editor

may contain HTML, which needs to be processed separately.

Reference materials, my own space:

How PHP outputs each piece of data in the database

$link=mysql_connect("localhost","","");

MySQL_query("SET NAMES 'gbk'");

$sql = "select * from books";

$result = mysql_query($sql, $link); //Execute query statement

while ($bookInfo = mysql_fetch_array($result)){ //Return the query results to the array

$name = $bookInfo["name"]; //Remove data from the array

$price = $bookInfo[＂price＂];

$isbn = $bookInfo[＂ISBN＂];

echo ＂

《＂.$name.＂》Price:＂.$price.＂ISBN:＂.$isbn.＂

＂; //Output data

}

mysql_free_result($result);

mysql_close($link);

?>

Do you understand? Use while to output all data.

How does php get the value from the database and output it on the html page

Use PHP to determine whether the query array is empty. If it is not empty, it will assign a value to the html and control whether to display the image.

$sql = "select * from '_goods_attr' where 'attr_value'=' '"; PHP query, $res=mysql_query($sql); PHP processing, $arr = mysql_fetch_assoc($res); Convert to array, The next step is to determine whether the array is empty and assign values ​​to the html template.

$selv=array(1,2,3,4,5); //Drop-down list value

$dbv=3;

foreach($selv as $s){

$issl='';

if($s==$dbv) $issl='selected';

$str.=＂-＂.$s.＂-＂;

}

echo ''.$str.'';

?>

The above is the detailed content of Use PHP to output part of the text in the database. For more information, please follow other related articles on the PHP Chinese website!