Php > Miscellaneous

Text To Smilies

Text To Smilies

<?php 
/* 
This script has been written for mysql but the code shouldnt be too different to this. The table required is a table called: smilies below the sql query to create such a table. 

CREATE TABLE smilies ( 
id INT( 10 ) NOT NULL AUTO_INCREMENT , 
smilie VARCHAR( 10 ) NOT NULL , 
image VARCHAR( 30 ) NOT NULL , 
PRIMARY KEY ( id ) 
); 

example usage: 
After pulling information from the database call the function smilies eg: 
smilies($row['somedate']); would replace all instances of the smilies from the database with the appropriate html/image. 

*/ 
function smilies($text){ 
$path="image"; //Specify the direcory in which images are stored 
$sql = "SELECT smilie, image FROM smilies"; //Select the smilies from the database 
//along with the names of the image files to 
//replace them 
$rs = mysql_query($sql); //Run the query 
while($row = mysql_fetch_array($rs)) { //Loop through the results creating two arrays 
$smilies[] = $row['smilie']; //Create array of smilie texts 
$images[] = "<img src='" . $path . "/" . $row['image'] . "'>"; //create array of image replacments with the html in it. 
} 
$text=str_replace($smilies, $images, $text);//Replace the smilies with the images. 
} 
?>