Ad:

PHP Discussion Thread
Unsolved
Views: 2406

Jun 20th, 2008

how to save TAB delimited list

Expand Post »

I try to copy and paste TAB delimited list into html text area, then save it to database, however when I retrieve it from DB, all TAB space are gone, does anyone can give me advice is there a way to keep these TAB?
Thanks in advance.

PHP Syntax (Toggle Plain Text)

test     test     test                       <----regular space
==============
test	test	test                            <----one TAB space
test		test		test            <----two TAB spaces

when I retrieve from DB, it shows:

PHP Syntax (Toggle Plain Text)

test test test
==============
test test test
test test test

P.S. The DB field is TEXT datatype (I use MSSQL)

michael123

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

93 posts
since Jun 2005

Permalink

Jun 20th, 2008

Re: how to save TAB delimited list

you could try:

php Syntax (Toggle Plain Text)
str_replace("	", "\t" $string);
str_replace("	", "\t" $string);

Last edited by R0bb0b; Jun 20th, 2008 at 2:13 pm.

R0bb0b

Reputation Points: 358

Solved Threads: 89

Posting Shark

Offline

986 posts
since Jun 2008

Permalink

Jun 20th, 2008

Re: how to save TAB delimited list

You can also use <pre> tag.
http://www.w3schools.com/TAGS/tag_pre.asp

php Syntax (Toggle Plain Text)
<?php
mysql_connect("localhost","root");
mysql_select_db("test");
if(isset($_POST['submit'])) {
	mysql_query("insert into tst (name) values ('".$_POST['tarea']."')");
}
?>
<html>
<body>
<form method="post">
<textarea name="tarea" cols="30" rows="20"></textarea>
<input type='submit' name="submit" value="submit">
</form>
</body>
</html>
<?php
$q = "select * from tst";
$r = mysql_query($q);
if(mysql_num_rows($r) > 0 ) {
while($row = mysql_fetch_array($r)) {
	echo "<pre>";
	echo $row['name'];
	echo "</pre>";
	echo "<br>";
}
}
?>
<?php
mysql_connect("localhost","root");
mysql_select_db("test");
if(isset($_POST['submit'])) {
	mysql_query("insert into tst (name) values ('".$_POST['tarea']."')");
}
?>
<html>
<body>
<form method="post">
<textarea name="tarea" cols="30" rows="20"></textarea>
<input type='submit' name="submit" value="submit">
</form>
</body>
</html>
<?php
$q = "select * from tst";
$r = mysql_query($q);
if(mysql_num_rows($r) > 0 ) {
while($row = mysql_fetch_array($r)) {
	echo "<pre>";
	echo $row['name'];
	echo "</pre>";
	echo "<br>";
}
}
?>

Just did a quick check to see if it works and it does..

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Jun 20th, 2008

Re: how to save TAB delimited list

Click to Expand / Collapse Quote originally posted by R0bb0b ...

you could try:
php Syntax (Toggle Plain Text)
str_replace("	", "\t",$string);
str_replace(" ", "\t",$string);

I think that doesn't work..

Last edited by nav33n; Jun 20th, 2008 at 2:26 pm.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Please help in coding

Next Thread in PHP Forum Timeline: Form in one iFrame refreshes another iFrame

DaniWeb Message

Cancel Changes

User Name
Password