String Formatting - I think...

Lord_Vance

I have recently decided to recode my webpage, webarooski.com using CSS as apposed to the tables I had been using. edit oh yea - the one I am working on is at http://www.webarooski.com/css-php/index.htm edit However, half way through a few classmates approached me and told me they would like to host their literature/images on my page - which I said would be fine. Thinking about it - it would be a real cumbersome task for everyone to have to e-mail everything they do to me, have me html it up and upload it...so...I decided to learn a bit of php.

So far - I have a mysql database setup with only one table - literature (easiest place for me to start). I made a simple form that asks

Author

Title

Text

(eventually type, for poem/short story/editorial/whatnot)

This worked fine, and gave me all the information I needed. However, a problem quickly came to surface - the php output did not like spaces, and the javascript did not like them either :-(

I needed 3 different versions of the title to use my nifty div-change-script-thingy I wrote for a previous version (it allows people to scroll through content, in this case poetry, without having to reload any page - it just changes the content of a couple divs).

What I need is a way for the user to type

'This is THE titLe to My PoEM!'

and have it save three values to the database

'This is THE titLe to My PoEM!'
'This%20is%20THE%20titLe%20to%20My%20PoEM!'
'thisisthetitletomypoem!'

or even better yet - when it reads from the database have it output in those two fasions (the first would be in the D😎

For now I have the forum just asking extra questions

JS Title
Variable Title

A second - very related issue I have is with how it saves the article itself to the database. I am going to post the source code to the litadd.php file and the processlit.php file as a reply - but heres the problem.

If sombody types the following into the article box:

Ashes to ashes
Dust to Dust
Live to learn
Learn to trust
and so on and so forth...

it saves it directly to my database as such - however, because of the way I have it outputting the javascript variables (Ill post a few pages of source as replies actually) I need it to be stored like this

Ashes to ashes<br>Dust to dust<br>Live to learn<br>Learn to trust<br>and so on and so forth...

all on one line with breaks like that.

Thanks in advance for any help - I tried searching google for 'string php formatting' but did not really come up with anything useful, and I am not even sure thats what I am looking for :-)

Lord_Vance

Below is the form for adding a new article thingamajigger

<form action="processlit.php" method="post" enctype="multipart/form-data" name="tutinfo">
<h1>Add tutorial information</h1>
<p>Author<br>
<input name="author" type="text" id="author" size="50"><br>
Title<br>
<input name="title" type="text" id="title" size="50"><br>
Javascript Title: Please use %20 instead of space. <br>
<input name="titlejs" type="text" id="titlejs" size="50"><br>
Variable Title: Please use all lowercase and no spaces. <br>
<input name="vartitle" type="text" id="vartitle" size="50"><br>
Text<br>
<textarea name="article" cols="50" rows="5" id="article"></textarea>
</p>
<p>
<input name="Add Literature" type="submit" value="Submit">
</p>
</form>

And here is where I process it

<?php
// set your information.
$dbhost='localhost';
$dbusername='';
$dbuserpass='';
$dbname='';

// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);

if (!mysql_select_db($dbname)) die(mysql_error());

$query1 = "INSERT INTO literature (date,author,title,titlejs,vartitle,article) VALUES (now(),'".$author."','".$title."','".$titlejs."','".$vartitle."','".$article."')";
mysql_query($query1)or die(mysql_error());
?>

and here is where I display it - this ones the biggy

<!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=iso-8859-1" />
<title>.: Webarooski - Home :.</title>

<link rel="stylesheet" type="text/css" href="css/global.css">
<link rel="stylesheet" type="text/css" href="css/indexpage.css">

<script language="javascript">
<?php
$dbhost='localhost';
$dbusername='';
$dbuserpass='';
$dbname='';

// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die('Cannot select database');

$query = "SELECT * FROM literature ORDER BY id DESC ";
$result = mysql_query($query) or die('Error, query failed');
while ($row = mysql_fetch_array($result)) {
echo "

var ".$row['vartitle']." = '".$row['article']."';";
}
?>

</script>

<script language="javascript">
function litchange(title,variable) {
   if (document.getElementById || document.all) {
      var partone = document.getElementById? document.getElementById("sub-container-long-title"): document.all["sub-container-long-title"];
      if (partone && typeof partone.innerHTML != "undefined") partone.innerHTML = title;
	  var parttwo = document.getElementById? document.getElementById("sub-container-long-body"): document.all["sub-container-long-body"];
      if (parttwo && typeof parttwo.innerHTML != "undefined") parttwo.innerHTML = variable;
   }
}
</script>

</head>

<body>
<div id="orangebar1"><img src="images/orange-star.gif" width="9" height="10" /></div>
<div id="orangebar2"></div>
<div id="container">
  <div id="header-buffer"></div>
  <div id="header">Webarooski.com</div>
  <div id="banner"></div>
  <div id="navigation" class="nav">
    <div id="nav-gray"><a href="index.htm">home</a></div>
	<div id="nav-space"></div>
    <div id="nav-gray"><a href="literature.php">literature</a></div>
	<div id="nav-space"></div>
	<div id="nav-gray">tutorials</div>
	<div id="nav-space"></div>
	<div id="nav-gray">gallery</div>
	<div id="nav-space"></div>
	<div id="nav-orange">recent events</div>
  </div>
  <div id="middle-content">
  <div id="sub-container-short">
    <div id="sub-container-short-title">Vance <span class="orangefont">Poetry</span> </div>
	<div id="sub-container-short-body">
	<?php
	$dbhost='localhost';
	$dbusername='webaroos';
	$dbuserpass='jodzilla';
	$dbname='webarooski_com_-_web2006';

// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die('Cannot select database');

$query = "SELECT * FROM literature ORDER BY id DESC ";
$result = mysql_query($query) or die('Error, query failed');
while ($row = mysql_fetch_array($result)) {
echo "<a href=javascript:litchange('".$row['titlejs']."',".$row['vartitle'].")>".$row['title']."</a><br>";
}
?>
</div>
<div id="sub-container-short-footer"></div>
  </div>
  <div id="nav-space-2"></div>
    <div id="sub-container-long">
    <div id="sub-container-long-title">Literature <span class="orangefont">Title</span> </div>
	<div id="sub-container-long-body">If all goes according to plan - your selection should appear in this div.</div>
	<div id="sub-container-long-footer"></div>
  </div>
  </div>
</div>

</body>
</html>

That last one you can view at www.webarooski.com/css-php/literature.php

thorpe

to get this....
This%20is%20THE%20titLe%20to%20My%20PoEM!
use...

echo urlencode('This is THE titLe to My PoEM!');

to get this...
thisisthetitletomypoem!
use...

echo str_replace(' ','','This is THE titLe to My PoEM!');

Lord_Vance

Thank you very much! That was exactly what I was looking to do.

It took me way too long to get it working :-( - so easy, but I was so stupid :-)

At first I couldnt figure out how to get the text argument to be a variable instead, after I figured that one out It still didnt work. Took me like 20 minutes to realize the ! was breaking the variable and killing the whole js script :-( - so I just went into phpmyadmin and edited that entry.

Is there any easy way to replace multiple things? so I could make ' ' = '' and '!' = '' and 'whateverelsebreakscrap' = ''?

Thanks again in advance - if not I can probably write a small remove everything bad script and just call that :-) You have been a huge help thus far - I had to use

str_replace(' ','',strtolower($row['title']))

to make it all lowercase and replace the space with nothing, but it works fine for me :-)

edit
if anyone has any thoughts on the second, very related issue - I would greatly appriciate it!
edit

edit
a quick google and I found this script - should work fine for the compound removal

function replaceMessage($message) {
   $message    = strip_tags($message, '<b></b><i></i><u></u><a></a><img>');

   $message    = str_replace ("\n", "<BR>", "$message");
   // When you store the $message in a database you might get errors cause of the quotes
   $message    = str_replace("[singleQuote]", "'", $message);
   $message    = str_replace("[doubleQuote]", "\"", $message);

   $message    = str_replace ("[U]", "<U>", "$message");
   $message    = str_replace ("[/U]", "</U>", "$message");
   $message    = str_replace ("[I]", "<I>", "$message");
   $message    = str_replace ("[/I]", "</I>", "$message");
   $message    = str_replace ("[B]", "<B>", "$message");
   $message    = str_replace ("[/B]", "</B>", "$message");

   $message    = replaceUrl($message);
   $message    = replaceImg($message);

   return $message;
}

edit