Adding regular expression (email+URL)

Beebs · March 23rd, 2007, 04:51 PM

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\]','$1');
INSERT INTO `forum_bbcode` VALUES (2,'\[i\]([^[]+?)\[\/i\]','$1');
INSERT INTO `forum_bbcode` VALUES (3,'\[u\]([^[]+?)\[\/u\]','[u]$1');
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