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
https://forums.phpfreaks.com/topic/74955-bbcode-help/#findComment-379038
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
https://forums.phpfreaks.com/topic/74955-bbcode-help/#findComment-379055
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
https://forums.phpfreaks.com/topic/74955-bbcode-help/#findComment-379422
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.