Jump to content

BBcode help!


Flare Boards

Recommended Posts

Ok i have everything but i'm putting it into an php tag and the > keeps on closing it. Why is it doing this.

 

Script:

 

<META HTTP-EQUIV="Refresh"
      CONTENT="0; URL=main_forum.php">

<?php
$host="**************"; // Host name 
$username="**************"; // Mysql username 
$password="**************"; // Mysql password 
$db_name="**************"; // Database name
$tbl_name="**************"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Get value of id that sent from hidden field 
$id=$_POST['id'];

// Find highest answer number. 
$sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'";
$result=mysql_query($sql)or die(mysql_error());
$rows=mysql_fetch_array($result);

// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1 
if ($rows) {
$Max_id = $rows['Maxa_id']+1;
}
else {
$Max_id = 1;
}

// get values that sent from form 
$a_name=$_POST['a_name'];
$a_email=$_POST['a_email'];
$a_answer=$_POST['a_answer']; 

$a_answer=strip_tags($a_answer);
$a_answer=strip_tags($a_name);
$a_answer=strip_tags($a_email);




//BBCODE

// convert [url=URL]link_title[/url]

$pattern[] = '/\[url=(.*?)\](.*?)\[\/url\]/i';

$replace[] = '<a href="$1">$2</a>';



// convert [url]url_link[/url]

$pattern[] = '/\[url\](.*?)\[\/url\]/i';

$replace[] = '<a href="$1">$1</a>';



// convert [img=image_link]

$pattern[] = '/\[img\](.*?)\[\/img\]/i';

$replace[] = '<img src="$1">';



// convert [b]text[/b]

$pattern[] = '/\[b\](.*?)\[\/b\]/i';

$replace[] = '<b>$1</b>';



// convert [code]CODE

 

$pattern[] = '/\

[code\](.*?)\[\/code\]/i';

$replace[] = '<xmp>$1</xmp>';



$html = preg_replace($pattern, $replace, $a_answer);




$datetime=date("d/m/y H:i:s"); // create date and time

// Insert answer
$sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')";


$tbl_name2="forum_question"; // Switch to table "forum_question"

// Insert last post
$sqlmas="UPDATE $tbl_name2 SET lastpost=$datetime, lastpostname=$a_name";

$result2=mysql_query($sql2)or die(mysql_error());

if($result2){
// If added new answer, add value +1 in reply column
$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
$result3=mysql_query($sql3)or die(mysql_error());
}
else {
echo "ERROR";
}

mysql_close();
?>
[/code]

Link to comment
Share on other sites

Ignroe the above posted scipt. It messed up.

 

<META HTTP-EQUIV="Refresh"

      CONTENT="0; URL=main_forum.php">

 

<?php

$host="**************"; // Host name

$username="**************"; // Mysql username

$password="**************"; // Mysql password

$db_name="**************"; // Database name

$tbl_name="**************"; // Table name

 

// Connect to server and select databse.

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

 

// Get value of id that sent from hidden field

$id=$_POST['id'];

 

// Find highest answer number.

$sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'";

$result=mysql_query($sql)or die(mysql_error());

$rows=mysql_fetch_array($result);

 

// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1

if ($rows) {

$Max_id = $rows['Maxa_id']+1;

}

else {

$Max_id = 1;

}

 

// get values that sent from form

$a_name=$_POST['a_name'];

$a_email=$_POST['a_email'];

$a_answer=$_POST['a_answer'];

 

$a_answer=strip_tags($a_answer);

$a_answer=strip_tags($a_name);

$a_answer=strip_tags($a_email);

 

 

 

 

//BBCODE

 

// convert link_title

 

$pattern[] = '/\(.*?)\[\/url\]/i';

 

$replace[] = '<a href="$1">$2</a>';

 

 

 

// convert url_link

 

$pattern[] = '/\[url\](.*?)\[\/url\]/i';

 

$replace[] = '<a href="$1">$1</a>';

 

 

 

// convert image_link

 

$pattern[] = '/\[img\](.*?)\[\/img\]/i';

 

$replace[] = '<img src="$1">';

 

 

 

// convert text

 

$pattern[] = '/\[b\](.*?)\[\/b\]/i';

 

$replace[] = '<b>$1</b>';

 

 

 

// convert

CODE

 

$pattern[] = '/\[code\](.*?)\[\/code\]/i';

 

$replace[] = '<xmp>$1</xmp>';

 

 

 

$html = preg_replace($pattern, $replace, $a_answer);

 

 

 

 

$datetime=date("d/m/y H:i:s"); // create date and time

 

// Insert answer

$sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')";

 

 

$tbl_name2="forum_question"; // Switch to table "forum_question"

 

// Insert last post

$sqlmas="UPDATE $tbl_name2 SET lastpost=$datetime, lastpostname=$a_name";

 

$result2=mysql_query($sql2)or die(mysql_error());

 

if($result2){

// If added new answer, add value +1 in reply column

$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";

$result3=mysql_query($sql3)or die(mysql_error());

}

else {

echo "ERROR";

}

 

mysql_close();

?>

Link to comment
Share on other sites

1) Post only relevant parts of your code; there is no reason to post parts that have nothing to do with the problem you're having.

2) Include one or two test scenarios that show the problem you're having.

3) Try to explain you're problem more clearly; a single sentence in most cases is not enough information.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.