PHP/MySQL count script

freeflow · Apr 27, 2009

How can I count the number of times http appears in a table space entry?
I would like to use that number for an if statement to delete automated spam
entries from my forum when http appears more than 10 times.

Peter · Apr 27, 2009

you could for example do :-

PHP:

<?php
$a = 'this is my http test which has a few http in it http';
$expression = '/http/';
preg_match_all($expression, $a, $matches);
$count = count($matches[0]);
echo $count;
?>

Eric · Apr 27, 2009

Simpler way:

PHP:

<?php

$text = 'this is my http test which has a few http in it http';

echo substr_count($text, 'http'); // 3

?>

chadsmith · Apr 28, 2009

What forum are you using? Also, are you wanting it to check retroactively (existing posts) or just have it check them from now on?

freeflow · Apr 28, 2009

Thanks everyone for your help! The spam filter works now. :D

fleetmanagement-senseri.co.nz

cybervideo.guru

bzheartbeat.it

scripsy.ai

kyoto-japan.de

bordesmarrakech.nl

dripcorner.co

77v.plus

maschinenlagerung.de

holylucks.nl

PHP/MySQL count script

Established Member

VIP Member

VIP Member

Established Member

Established Member

QueenSheba.com

Piddle.com

Coded.co

relate.io

HDDoctor.Com

Ceee.com

Euro.org

NSFY.com

Rocket.me

Realm.co

Similar threads

We're social

QueenSheba.com

Piddle.com

Coded.co

relate.io

HDDoctor.Com

Ceee.com

Euro.org

NSFY.com

Rocket.me

Realm.co

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy