line breaks

[sabret00the]

how do i make sure that when inserting this code into the database it adds any line breaks that may be typed out by the users?

PHP Code:

         $DB_site->query("INSERT INTO project SET
         text  = '".addslashes($message)."',
         timestamp   = '".time()."'"); 


[Xenon]

well, it automatically adds linebreaks by the users into the DB.

just when you output the msg, you have to make sure they are parsed (nl2br())

[sabret00the]

oh ok, so it's on the output side i have to worry about the line breaks, ok then, would i put the (nl2br()) around the query to select the date from the database ala

PHP Code:

            (nl2br($project = $DB_site->query("SELECT projectid, text, timestamp FROM project $clause ORDER BY projectid DESC $limit"))); 


or something else?

[high]* sabret00the thinks he might have to dig out his php book :nervous:[/high]

[Xenon]

nope, not around the query.

lets say

you have this:

PHP Code:

$field =$DB_site->query_first("SELECT projectid, text, timestamp FROM project $clause ORDER BY projectid DESC $limit")));
echo $field['text']; 


then it would show up all in one line.
but if you use

PHP Code:

echo nl2br($field['text']); 


then the linebreaks will be visible.

btw. if you use parse_bbcode it will automatically use nl2br

[sabret00the]

sorry to be a pain stefan, but i don't think i'm getting this, so heres the code that outputs what i'm trying to show up with line breaks

PHP Code:

            $projects = $DB_site->query_first("SELECT projectid, text, timestamp FROM projects $clause ORDER BY projectid DESC $limit");
             $projects = nl2br($projects['text']);
             
             if (!$DB_site->num_rows($projects)) {
                   eval("\$projects_bits = \"".fetch_template("projects_error",1,0)."\";");
             } else {
                 while ($project_info = $DB_site->fetch_array($projects)) {
                 extract($project_info);
                 
                $totalconf = number_format($DB_site->num_rows($projects));
                 $time_posted = vbdate('n-j-y, g:i:s a', $timestamp);
 
                 if ($bbuserinfo[usergroupid] == 6) {
                     eval("\$adminoptions = \"".fetch_template("projects_adminoptions",1,0)."\";");
                 }
             eval("\$projects_bits .= \"".fetch_template("projects_bit")."\";");
             } 


it's all called in the templates via a simple $text inside the $projects_bit template

[Xenon]

just put a $text = nl2br($text); before the evel project bits part

[sabret00the]

thanks xenon you're a great help

[Xenon]

you're always welcome

[sabret00the]

sorry to be a pain xenon but it didn't work

[Xenon]

i suggest to use this code, that should work

PHP Code:

$projects = $DB_site->query("
    SELECT projectid, text, timestamp
    FROM projects
    $clause
    ORDER BY projectid DESC
    $limit
");

if (!$DB_site->num_rows($projects))
{
    eval('$projects_bits = "' . fetch_template("projects_error") . '";');
}
else
{
    $totalconf = number_format($DB_site->num_rows($projects));
    while ($project_info = $DB_site->fetch_array($projects))
    {
        $project_info['text'] = nl2br($project_info['text']);
        extract($project_info);
                $time_posted = vbdate('n-j-y, g:i:s a', $timestamp);

                if ($bbuserinfo['usergroupid'] == 6)
                {
                    eval('$adminoptions = "' . fetch_template("projects_adminoptions") . '";');
                }
                eval('$projects_bits .= "' . fetch_template("projects_bit") . '";');
    }