DaniWeb Forum Index > Web Development > PHP

how to save TAB delimited list

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2005

Posts: 92

Reputation: michael123 is an unknown quantity at this point

Solved Threads: 0

michael123 michael123 is offline

Offline

Junior Poster in Training

how to save TAB delimited list

Jun 20th, 2008

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.

Help with Code Tags

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:

Help with Code Tags

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)

•

Join Date: Jun 2008

Posts: 849

Reputation: R0bb0b is on a distinguished road

Solved Threads: 67

R0bb0b

Offline

Practically a Posting Shark

Re: how to save TAB delimited list

Jun 20th, 2008

you could try:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
str_replace("	", "\t" $string);
str_replace("	", "\t" $string);

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

•

Join Date: Nov 2007

Posts: 3,748

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: how to save TAB delimited list

Jun 20th, 2008

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

 Help with Code Tags 
 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..