[qie]

hi, help me please....

PHP Code:

/***** smilies *****/
$smilies = array(
    ':)' => 'smile.gif',
    ':(' => 'sad.gif',
    ';)' => 'wink.gif'
);


/***** view data *****/
$query = mysql_query("SELECT * FROM table ORDER BY date DESC");
while($data = mysql_num_rows($query)) {
    $view.= "name: ".$data[1]."<br />";
    $view.= "subject: ".$data[2]."<br />";
    
    // i want to use $smilies below
    // :) replaced with <img src="smile.gif" />
    // and more smilies...
    // how to do it?
    $view.= "message: ".$data[3];
} 

[Wuiqed]

PHP Code:

// smilies

$smilies = array(

    ':)', 

    ':(', 

    ';)'

);



//html replacement

$paths   = array(

    '<img src="smile.gif" alt="" />', 

    '<img src="sad.gif" alt="" />', 

    '<img src="wink.gif" alt="" />'

);



//notice that I changed your mysql_num_rows() to mysql_fetch_array()

//this is because mysql_num_rows() only returns HOW MANY rows was

//fetched but doesn't return the actual rows

$query = mysql_query("SELECT * FROM table ORDER BY date DESC");

while($data = mysql_fetch_array($query)) {

    $view.= "name: ".$data[1]."<br />";

    $view.= "subject: ".$data[2]."<br />";

    

    str_replace($smilies, $paths, $data[3]);

    $view.= "message: ".$data[3];

} 

[Nico]

^^ Either this or that:

PHP Code:

$smilies = array(

    ':)' => '<img src="smile.gif" alt="" />', 

    ':(' => '<img src="sad.gif" alt="" />', 

    ';)' => '<img src="wink.gif" alt="" />'

                );



$query = mysql_query("SELECT * FROM table ORDER BY date DESC");

while($data = mysql_fetch_row($query)) {

    $view.= "name: ".$data[1]."<br />";

    $view.= "subject: ".$data[2]."<br />";

    

    str_replace(array_keys($smilies), array_values($smilies), $data[3]);

    $view.= "message: ".$data[3];

} 

[qie]

hi, thanks. i've try the script before. but it's not effective. more effective way?

Originally Posted by Wuiqed

PHP Code:

$smilies = array(
    ':)', 
    ':(', 
    ';)'
);

$paths   = array(
    '<img src="smile.gif" alt="" />', 
    '<img src="sad.gif" alt="" />', 
    '<img src="wink.gif" alt="" />'
);

$query = mysql_query("SELECT * FROM table ORDER BY date DESC");
while($data = mysql_fetch_array($query)) {
    $view.= "name: ".$data[1]."<br />";
    $view.= "subject: ".$data[2]."<br />";
    
    str_replace($smilies, $paths, $data[3]);
    $view.= "message: ".$data[3];
} 

[Wuiqed]

Not effective? How did you come to that conclusion?

[mab]

Actually, both of the above will work with a minor correction. The str_replace does not modify the source, but instead returns a result. The following is needed -

PHP Code:

    $data[3] = str_replace... 

Here is a third way that keeps the original form of the $smilies array -

PHP Code:

    foreach ($smilies as $key => $value) {

        $data[3] = str_replace($key, "<img src='$value' />", $data[3]);

    } 

Yah I know, it could probably use the addition of the alt text...

[qie]

hi, thanks friends......
it's works....
i've modified ....

thanks to nico_swd for:

str_replace(array_keys($smilies), array_values($smilies), $data[3]);

thanks to Wuiqed for:

//notice that I changed your mysql_num_rows() to mysql_fetch_array()
//this is because mysql_num_rows() only returns HOW MANY rows was
//fetched but doesn't return the actual rows

now the script like below:

PHP Code:

@mysql_pconnect('localhost','root','root');
@mysql_select_db('database');

$smilies = array(
    ':)' => '<img src="images/smile.gif" />', 
    ':(' => '<img src="images/sad.gif" />', 
    ';)' => '<img src="images/wink.gif" />'
);

$query = mysql_query("SELECT * FROM table");
while($data = mysql_fetch_array($query)) {
    $view.= "name: ".$data[1]."<br />";
    $view.= "subject: ".$data[2]."<br />";
    
    //;
    $view.= "message: ".str_replace(array_keys($smilies), array_values($smilies), $data[3])."<hr />";
}

echo $view;