View Single Post
  #1 (permalink)  
Old March 23rd, 2007, 04:51 PM
Beebs Beebs is offline
Authorized User
 
Join Date: May 2006
Location: , , Australia.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Beebs
Default Adding regular expression (email+URL)

Chapter 16 :

Here's the forum_bbcode table :
[code

CREATE TABLE IF NOT EXISTS forum_bbcode (
id int(11) NOT NULL auto_increment,
template varchar(255) NOT NULL default '',
replacement varchar(255) NOT NULL default '',
PRIMARY KEY (id)
)ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `forum_bbcode`
--

INSERT INTO `forum_bbcode` VALUES (1,'\[b\]([^[]+?)\[\/b\]','<b>$1</b>');
INSERT INTO `forum_bbcode` VALUES (2,'\[i\]([^[]+?)\[\/i\]','<i>$1</i>');
INSERT INTO `forum_bbcode` VALUES (3,'\[u\]([^[]+?)\[\/u\]','[u]$1</u>');
INSERT INTO `forum_bbcode` VALUES (4,'\[url\]([^[]+?)\[\/url\]','<a href="$1" target="_blank">$1</a>');
INSERT INTO `forum_bbcode` VALUES (5,'\[url=(]+?)\]','<a href="$1" target="_blank">');
INSERT INTO `forum_bbcode` VALUES (6,'\[\/url\]','</a>');

[/code]

I need your help for :

1. How to add email regular expression ? This is my effort which give an error message :
Code:
INSERT INTO `forum_bbcode` VALUES (7,'\[email\](([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)?[\w]+))\[\/email\]','<a href=\"mailto:$1\">$1</a>');
2. How to change the style that was set from chapter 16 set for adding URL and email? I am talking about this style of email and URL :
Code:
<a href="mailto:myemail@mail.com">myemailtitle</a>
.

So that when user click on the email & URL icon they will be prompted to add their email/URL title and then the link.

3. I'll appreciate if you can help me to add regular expression for ordered amd unordered list
Reply With Quote