PHP - Preg_replace Question

I'm trying to search a string for all occurences of a pattern, then append text after that pattern.  The example is:   SUM("foo") as "bar"   and have it display as:   SUM("foo") over() as "bar"   The "SUM" could be any SQL aggregate and be case insensitive.  So For bonus points, let's say the valid aggregates are  array('SUM', 'MAX', 'MIN', 'AVG').  My plan right now is to figure it out for SUM, then loop it replacing the aggregate.   This is what I have so far... and it is not working.   $l= 'SUM("foo") as "bar"'; $l=preg_replace('/([^"]+")/','\0 over()',$l);   Thanks,   Ryan

Hi,

I'm kind of new to PHP and very new to Regular Expressions and I was wondering if someone could help run through this code snippet from a callback function in a Joomla plugin called Affliates Feed.

So far I have this
is passed a pointer to variable item (I understand this is effectively the same as passing the variable but a lot less CPU intensive.
Creates an array with keys and values

Now the for loop I am stuck with, I understand the interation through the array. But what is preg_replace returning and why pass it back that way hasn't it already done its job?

Can any one help? And please feel free to be as basic as possible :help:

Thanks,
Adam


Code: [Select]
function gardening(&$item) {
   #renaming categories, not the most efficient use for example strtolower first, and use only lowercase in the rename array
   $rename=array(
      ' Gardening?' => '',
      'Climber Plants' => 'Climbing Plants',
      'Seeds.*Bulbs' => 'Seeds Bulbs',
      'Plant protection' => 'Horticultural goods',
      'Garden structures' => 'Garden buildings',);
   foreach ( $rename as $k => $v ) {
      list($item['menu_1'],$item['menu_2'])=preg_replace("#$k#",$v,array($item['menu_1'],$item['menu_2']));
   }
   $item['menu_1']=ucfirst(strtolower($item['menu_1']));
   $item['menu_2']=ucfirst(strtolower($item['menu_2']));
   $item['menu_3']=ucfirst(strtolower($item['menu_3']));
   $item['menu_4']=ucfirst(strtolower($item['menu_4']));
}

Hello ppl,
I have this website link http://www.somesite.com/anotherpage/yetotherpage.html what i want to make is using preg_replace that the final result will be www.somesite.com

Hi everyone,

how do i add and ampersand symbol into preg_replace

preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/"

where do i place the symbol? &

I am trying to pull out the image HTML tag but its not working as expected.
Here is what I am doing
   $removeimagetag='/<a href/';
   $replacwith = "illegal";
$_POST['descr']=preg_replace($removeimagetag,$replacwith,$_POST['descr']);

in the 'descr' there is a <a href="http://s635.photobucket.com......
When it post it does not strip out the <a href
So the image is displayed.

I tried a modified version to test to see if it work that looked like this.

   $removeimagetag='/goofy/';
   $replacwith = "illegal";
$_POST['descr']=preg_replace($removeimagetag,$replacwith,$_POST['descr']);

When the word goofy appears in the text then its replaced with the word illegal,

Also I would like to make it so that it replaces the entire line from the <a href....... to the </a> with a phrase that says "this feature is not allowed"  rather than just the part in the front...the <a href.

Any help you can be will be greatly appreciated.

i want to remove any links which get pulled  out in my general information query.

Code: [Select]
$general_info = $row['general_info'];
$general= preg_replace('/<a href="([^<]*)">([^<]*)<\/a>/', '', $general_info);

echo '<h2>General Information : <img src="images/mag.png"></h2>';
echo '<div id="featurecontent">';
echo '<p>'. ucfirst($general).'</p>';
echo '</div>';
But the above code doesnt seem to be stripping out links.

Can anyone see what i am doing wrong.

Kind Regards

Dean

I'm working with the youtube API and the function Code: [Select]
$relatedVideo->watchURL returns a video url

However when I use Code: [Select]
preg_replace("youtube","test",$relatedVideo->watchURL); it gives me the following error
Code: [Select]
preg_replace() [<a href='function.preg-replace'>function.preg-replace</a>]: Delimiter must not be alphanumeric or backslash in <b>C:\wamp\www\site\test.php</b> on line <b>317
Help please?

I have no idea what the problem is with preg_replace and strings smaller than 3 characters. I'm writing to do a pattern search of abreviations(array) and replacements (array)... tried word boundries, which seems not to work at all. (it is VITAL that im able to match the whole word)
here is a quick example which I cannot understand maybe someone could explain to me:
1. why repitions of certain abrevs do not get replaced.
2. why '/\bs.\b/' wont get matched (where there is a space before  the b. - hense the word boundry)

here is a snippet of code could someone please explain why this happens:

Code: [Select]
<?php
  $string='de d. s. pres. div. de de d. s.';
 
//DEFINE PATTERN
$patterns = array();
$patterns[0] = '/ s. /';
$patterns[1] = '/ b. /';
$patterns[2] = '/ pres./';
$patterns[3] = '/ Ind./';
$patterns[4] = '/ Mar./';
$patterns[5] = '/ Agt./';  
$patterns[6] = '/ Agy./';  
$patterns[7] = '/ Indpls./';                            
$patterns[8] = '/ Chgo./';
$patterns[9] = '/ Corp./';
$patterns[10] = '/ U./';    
$patterns[11] = '/ Fin./';          
$patterns[12] = '/ ls./';   
$patterns[13] = '/ Pres. /';    
$patterns[14] = '/ Internat. /';   
$patterns[15] = '/ m. /';
$patterns[16] = '/ N.Y.C./';   
$patterns[17] = '/ div. /';   
$patterns[18] = '/ de /';  
$patterns[19] = '/ d. /';    


//DEFINE PATTERN REPLACE
$replacements = array();
$replacements[0] = ' son of ';
$replacements[1] = ' born in ';
$replacements[2] = ' president';
$replacements[3] = ' Indiana ';
$replacements[4] = ' March ';
$replacements[5] = ' Agent ';  
$replacements[6] = ' Agency ';  
$replacements[7] = ' Indianapolis ';                            
$replacements[8] = ' Chicago';
$replacements[9] = ' Corporation ';
$replacements[10] = ' U '; 
$replacements[11] = ' Financial ';       
$replacements[12] = ' Island';   
$replacements[13] = ' President '; 
$replacements[14] = ' International ';  
$replacements[15] = ' married to ';
$replacements[16] = ' New York City ';   
$replacements[17] = ' divorced';    
$replacements[18] = ' de '; 
$replacements[19] = ' daughter of ';    

 echo '------ Original ---------<br>'.$string.'<br>';
$data = preg_replace($patterns, $replacements, $string);
 echo '<br>------ Abbreviation Replace ---------<br>'.$data.'<br>';  
?>

OUTPUT: ------ Original ---------
de d. s. pres. div. de de d. s.

------ Abbreviation Replace ---------
de daughter of son of president divorcedde daughter of d. s.

any help is appriciated thanks.

Hey, I am trying to write a sort of replace function where {user:1} is converted into a set of information from a database using preg_replace. So I have created the following preg_replace:

$patterns = array();
$patterns[1] = '/\{user:([0-9]+)\}/';

$replacements = array();
$replacements[1] = UserCredit('$1');

ksort($patterns);
ksort($replacements);

$content_show = preg_replace($patterns, $replacements, $content);

echo $content_show;


and then the function UserCredit which is just above that on the page:

function UserCredit($user_id) {
require 'connect.php';
$user_lookup = mysql_query("SELECT * FROM prop_users WHERE ID = '$user_id'");
while($row = mysql_fetch_array($user_lookup)) {
$user_name = $row['full_name'];
$user_file = $row['credit_file'];
$user_url = $row['link_url'];
$user_url_alt = $row['link_alt'];
}
if(mysql_num_rows($user_lookup)==0){
  die("An error has occured, Sorry for any Inconvenience Caused! User ID=".$user_id);
}
require 'close.php';
$output = "<li class=\"clearfix\"><div class=\"credimg\"><img src=\"".$user_file."\" width=\"75px\" height=\"75px\" alt=\"".$user_name."\" /></div><p><strong><a href=\"".$user_url."\" title=\"".$user_url_alt."\">".$user_name."</a></strong><br /><em>Writing / Code</em></p></li>";
return $output;
}


I have tested the function and it works when I echo UserCredit('1');

And the preg_replace works at simply extracting the value for the user.

The only problem is that I can't figure a way for the preg_replace to carry the value of $1 into the function it just literally carries "$1"

Is there something obvious that I am missing or am I going around this the wrong way?

Hi all.

I'm having a bit of an issue with preg_replace and I'm not sure how to solve it.  I'm having preg_replace find a "bus" (short for business) prefix in a file name and then print "Business Management" instead of "bus".  I also have another prefix of "bus_it_requests".  When preg_replace finds that prefix, it prints "Business Management It Requests" but I need it to print "Business It Requests".  How do I have preg_replace make the distinction in the prefix matches?

$titleurl = preg_replace('/[^a-zA-Z0-9_ -%]/', '-', $d);
$titleurl = preg_replace('/[ ]/', '-', $titleurl);


How do you add to this to replace

---- with -
--- with -
-- with -

and remove quotes?

How do you remove a - if it's at the very end of $titleurl. For example, replace My-iPhone- with My-iPhone

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=347057.0

What I'm trying to do is replace message_tags to links and web addresses to links in facebook json data, the problem is I need to do these in 2 steps, first do the message tags then then web addresses. The message_tags need to be done first because they rely on offset and length of the message to do the replace.     To code to first replace the message_tags is

// convert message tags to links
if($post->message_tags) {
     usort($post->message_tags, 'mySort');
     foreach($post->message_tags as $message_tag) {
          foreach($message_tag as $link) {
               $post_text = substr_replace($post_text,"<a href=\"https://www.facebook.com/".$link->id."\" target=\"_blank\">".$link->name."</a>",$link->offset,$link->length);
          }
     }
}

The second part is to convert any web address (http://example.com) to a link (<a href ="http://example.com" title="http://example.com" target="_blank">http://example.com</a>)

// check if any entites exist and if so, replace them with hyperlinked versions
$post_text = preg_replace("/((http:\/\/|https:\/\/)[^ )]+)/e", "'<a href=\"$1\" title=\"$1\" target=\"_blank\">'. ((strlen('$1')>=250 ? substr('$1',0,250).'...':'$1')).'</a>'", $post_text);

So now to the problem, the second part now rewrites the first part and completely destroys the link because it just looks for http: and https: so in my preg_replace I need a way to not include anything that has already been converted, so not include anything that already has href="http

Quote

Hi Guys,
I have a small issue with doing a preg_replace on a string.
Here is the string I wish to use preg_replace on




Code: [Select]
<?php
$mystring = "This is my test string that has {['site_info']} and some more stuff {['taste']} then nothing"
?>

Quote

I want to do a preg_replace and replace {['site_info']} with  $stuff['major']['site_info'] through the string

Quote

I want to replace the placeholder with real variables from the array
Any help would be great

Hi, I've got a little problem at the moment with how to replace varying amounts of hyphens in a  browser url.

scenario:
I have a borwser url mydomain.com/location/foo-bar/ where "foo-bar" is actually "foo bar" in the database (no hyphen).
I also have urls where the entry in the database does have the hyphens e.g. "foo-bar"

Now im not quite sure how to go about writing these urls, and how to manipulate the GET values from them.

what I've tried

My first thought was to add a secondary hyphen to the url so that the database entires that equal "foo-bar" would be "foo--bar" in the browser url and the entries in the database that equal "foo bar" would have the single hyphen "foo-bar".

Then i would use preg_replace to deal with the single hyphens by removing them and replacing with a space, and after that finding the double hyphens and replacing them with only one.

In theory this should work (I think), but I've only recently got into using regex, this is what I've tried;

$CNE = preg_replace("/[-]{1}/", " ", $CNE);
$CNE = preg_replace("/[-]{2}/", "-", $CNE);


so I've tired to match the single hyphen and then the double, but even before I tested this I didn't think it was going to work with this code.


Can anyone correct me, or maybe suggest a better way to go about this issue.
(note: using a different character to replace spaces is NOT an option in this case)

Thanks