PHP - Moved: Only Use Preg_replace In Between Quotations...

This topic has been moved to PHP Regex.

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

This topic has been moved to PHP Regex.

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

This topic has been moved to PHP Regex.

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

This topic has been moved to PHP Regex.

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

i dont understand why the it gives me a syntax error when i type this:

Code: [Select]
echo '<h2> <?php echo $_POST['firstname'] ?> gelukt!</h2>';
Apparently, i have to do this:

Code: [Select]
echo '<h2> <?php echo $_POST["firstname"] ?> gelukt!</h2>';

Hello,

I get the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEEN '1800-01-01' AND '2200-01-01'' at line 1

Here is the code:

// building query

Code: [Select]
$where = array();

if ( $_GET['sex'] != '') {$where[] = " geslacht = '$sex'"; }

if( $_GET['minAge'] != '' && is_numeric($_GET['minAge'])){ $where[] = " geboortedatum < '$minAge'"; }

if( $_GET['maxAge'] != '' && is_numeric($_GET['maxAge'])) {$where[] = " geboortedatum >= '$maxAge'"; }

$where[] = " TijdRegistratie BETWEEN '$minDatum' AND '$maxDatum'";

// glueing query

$sql = "SELECT * FROM respondenten";
if (count($where) > 0){   $sql .= "WHERE ".implode(" AND ", $where);}
Can somebody tell me where i've put the wrong quotations? *confused*

What's the best way for putting actual quotations into a database?

I was using...

$quote = htmlspecialchars(mysqli_real_escape_string($dbc, $_POST['quote']));

Should I be?

Does/can php reconize quotations beyond the simple example I have below:



$quote = "\"";

if(strstr($test, $quote)){
 echo "quote found";
}



I'd like to detect any instance of a quote. Should I be including html such as &quot; and/or other html quote symbols? Or does the simple example I have above suffice?

Hi There,

I am putting a form together that when submitted, pumps data in to an SQL DB. However I am having problems with quotation marks - for example, it's and her's and thier's cause an error, because the insert statement takes the quote as the end of the row.

How can PHP handle this so that it either removes, or replaces that quote?

Thanks
Matt

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 have:


$msg = ereg_replace("[^A-z0-9]"," ",$msg);
$msg = ereg_replace("  "," ",$msg);
$msg = ereg_replace("    "," ",$msg);


how will i apply preg_replace please???
thank you

Hi there!

I need to echo some text from a database table, this text should be linked to a url stored in the same database. I am trying to do this with preg_replace but I am terrible at it! I keep getting this error:

Warning: Wrong parameter count for preg_replace()

while($row = mysql_fetch_array( $result ))
 {

$reg_exUrl = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/";

echo preg_replace ($reg_exUrl, $row['title');


Any suggestion?

Thanks

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