How to remove spaces and symbols in php

php method to remove spaces and symbols: 1. Use str_replace to replace, with syntax such as "str_replace(array("\r\n", "\r", "\n"), "", $ str);"; 2. Use regular replacement, the syntax is "preg_replace('//s*/', '', $str);" 3. Use variables defined by PHP, the syntax is "str_replace(PHP_EOL, ' ', $str);".

The operating environment of this tutorial: windows10 system, php8.1.3 version, DELL G3 computer.

#How to remove spaces and symbols in php?

The specific method is as follows:

1. Use str_replace to replace

$str = str_replace(array("\r\n", "\r", "\n"), "", $str);

2. Use regular replacement

$str = preg_replace('//s*/', '', $str);

3. Use variables defined by php (recommended)

$str = str_replace(PHP_EOL, '', $str);

Of course we can define it as a function and replace it together, so that we can reuse this code segment.

function trimall($str){
    $qian=array(" ","　","\t","\n","\r");
    return str_replace($qian, '', $str);  
}

As shown above, we first need to establish a connection to the database and use "LIMIT 5" in the query to specify the first five records that need to be read. Finally, we use a while loop to iterate through the result set and output the contents of each row. If you need to read more records from the database, just change the number in the "LIMIT" keyword.

Using PHP Functions

Another way to read the first few records from a MySQL database is to use a PHP function. In this case, we need to use the "()" function in MySQL to get the first few records. Here is a sample code:

//连接到数据库
$connection = 
mysqli_connect("localhost","username","password","database");
//查询前五条记录
$query = "SELECT * FROM table_name";
//将结果集存储到数组中
$result_array = mysqli_fetch_array(mysqli_query($connection, $query));
//输出结果
for($i=0;$i<5;$i++){
echo $result_array[$i]."
";
}

As shown above, we first store the query results in an array, and then use a for loop to traverse the array and output the first five elements. Using this method you are free to change the range in the for loop to read the required number of records.

Using PDO

PDO is a database extension in PHP that can be used to read records from a MySQL database. In this case, we can use the "fetchAll()" method to retrieve the first few records from the result set. Additionally, we can use the “bindParam()” function to bind variables for safer query execution. Here is a sample code:

//连接到数据库
$dsn = 'mysql:host=localhost;dbname=database';
$username = 'username';
$password = 'password';
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
//创建PDO连接
$dbh = new PDO($dsn, $username, $password, $options);
//查询前五条记录
$query = "SELECT * FROM table_name";
//准备查询语句
$statement = $dbh->prepare($query);
//绑定变量
$statement->bindParam(':id', $id, PDO::PARAM_INT);
//执行查询
$statement->execute();
//获取结果
$results_array = $statement->fetchAll(PDO::FETCH_ASSOC);
//输出结果
foreach ($results_array as $result) {
echo $result['column_name']."
";
}

As shown above, we first create a PDO connection to the database and omit the "LIMIT" keyword in the query. We then use the "bindParam()" function to bind the variables and the "fetch()" method to fetch all the rows from the result set. Finally, we use a foreach loop to iterate through the returned array and output the contents of each row.

Summary

In PHP, there are multiple ways to read the first few records in the database. By using SQL statements, PHP functions and PDO, you can easily retrieve and display the required data from the database. These methods are useful in improving performance and reducing overhead when you only need to read a small number of records.

The above is the detailed content of How to remove spaces and symbols in php. For more information, please follow other related articles on the PHP Chinese website!