displaying queries

robsgaming

i am trying to make a script that does a data dump of the table.

so, based on a query it will show something similar to:

INSERT INTO onlinegames VALUES (4, 'Billiards', 'SPORTS - BILLIARDS', '<SCRIPT LANGUAGE="javascript" SRC="http://www.candystand.com/common/popup.js"></SCRIPT>\r\n <script language="javascript">\r\n PrintGameTag(getHyperloadDcr("http://www.candystand.com/shock/csplhlload.dcr"), 608, 395, "#FFFFFF", "http://www.candystand.com/games/cat_arcade.htm", "Copyright2002NabiscoInc", "", "", "", "", "http://www.candystand.com/games/cs_shock_cspl.htm", "http://www.candystand.com/shock/hyperLoad/cspl.sit", "http://www.candystand.com/shock/hyperLoad/cspl.exe", "");\r\n </script>', 'http://www.candystand.com/games/cs_shock_cspl.htm?');

IN ONE SOLID LINE

If the data is entered into the table with space, i want \n or whatever to represent spaces.

hopefully somebody understand what im trying to say as it is confusing for me.

thanks in advance for any help.

diego25

Well, to replace newlines with a string literal '\n' you can just do a str_replace:

$string = str_replace("\n", '\n', $string);

Note the use of single and double quotes. In this case it does matter where you use each.

Diego

robsgaming

ahh i never make sense, sorry 🙁

all i want to do is show a table dump of data, similar to what php myadmin does

it will show the complete query "INSERT INTO blah balh blah" automatically show any line returns as \n \r whatever so that it is displayed all in one line.

the reason for doing this is that i will have checkboxes... boxes that are checked, it will run a query and insert the data correctly, WITH ALL LINE SPACING, etc

diego25

Ok, you've told us what you want to do, but you haven't told us what part you're having trouble with...

Diego

robsgaming

$id = $myrow[0];
$gametitle = $myrow[1];
$code = $myrow[2];
$name = $myrow[3];
$timepost = $myrow[4];
$system = $myrow[5];
$gameid = $myrow[7];
$cheattype = $myrow[8];



$ssql = "INSERT INTO cheats (gametitle,code,name,timepost,system,gameid,cheattype) VALUES ('$gametitle','$code','$name','$timepost','$system','$gameid','$cheattype')";  

$ssql = htmlspecialchars($ssql);
$ssql = str_replace("\n", '\n', $ssql); 

echo "$ssql\n";

which is apparently the wrong way to code it...

not sure how to do it.

thanks again, sorry for the troubles.

diego25

Well, I don't see anything wrong with that code....why are you saying that that's not the way to code it?

Diego