trim function delete all more spaces but when try to save data in database it was save with more spaces why pleas help me i but down all code and database construction to help be
CREATE TABLE `test`.`user` (
`id` INT( 11 ) NOT NULL AUTO_INCREME开发者_JAVA技巧NT PRIMARY KEY ,
`username` VARCHAR( 30 ) NOT NULL
) ENGINE = MYISAM ;
////////////////////////
<?php
$conn = mysql_connect("localhost","root","");
if(!$conn){
die("there is problem in" .mysql_error());
}
$select_db = mysql_select_db("test",$conn);
if(!$select_db){
die("there is problem in" .mysql_error());
}
?>
<?php
if(isset($_POST["submit"])){
$fname = trim($_POST["text"]);
$name = trim($fname);
$insert = mysql_query("insert into user(username)values('{$name}')");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<form action="" method="post">
<input type="text" name="text" value=""/>
<input type="submit" name="submit" value="submit"/>
</form>
<body>
</body>
</html>
The trim function only removes leading and trailing spaces, not double spaces within the text. You can use preg_replace for that, e.g.:
$output = preg_replace('!\s+!', ' ', $input);Source: php Replacing multiple spaces with a single space
Even simpler than using regex
$without_spaces = str_replace(" ", "", $_POST["text"]);
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......
精彩评论