Kapalı

php mysql regex project

script language: PHP standard procedural (non object oriented). NO FRAME WORKS.

database: mysql

table structure:

table A

url

html

runid

table B

id

regex

url

forall (boolean)

table C

runid

url

matchtext

matchregexid

table D

runid

matches

newmatches

startdatetime

enddatetime

urlcheckedcount

The php script will be run from the command line, and cron tabbed.

It will:

1

identify the max runid value from tableD

query [login to view URL] and compare it against the select count(url) from tableA where runid= max run id just captured.

if the two counts are a match, increment the run id upward 1

if the two counts do not match, do not increment the run id

2

insert a single record into table D, with the runid, urlcheckedcount =0, matches=0, and newmatches=0, and startdatetime, unless it already exists, then do an update to reflect the same values. This will allow restarting a previously aborted script in a error situation. It will be simpler to restart from the start instead of continuing from the middle.

3

run a query "select * from table B where forall is true"

and then it will run another query like "select * from table A where runid = max runid and html like [login to view URL] or regex or regex" with the where clause containing the different regex entries as OR statements

3.A do another query like "count(url) from table A where runid = max runid" and increment [login to view URL] by the count

4

run a query "select * from table B where forall is false"

and then it will run another query like "select * from table A where runid = max runid and url = [login to view URL] and [login to view URL]"

4.A increment [login to view URL] upward one

5

it will essentially be comparing the html text field to see if any records matches the where clause with regex. You can concatenate together multiple matches where the url is the same.

6

for each match, extract the text output of the match. This should only return "Jill ok one two Smith" if the pattern is 'JILL(.*?)smith/mi'

7

for each match, it will check table C to see if a perfect match already exists.

update the record in table D for the run id, to increment the matches field upward 1

update the record in table D for the run id, to increment the newmatches field upward 1 if a perfect match does not exist

8

if a perfect match does not exist, insert a record into table C with [login to view URL] populating [login to view URL], [login to view URL] populating [login to view URL], [login to view URL] populating [login to view URL], and the output pattern of the regex match populating [login to view URL]

9

repeat the loop of logic to repeat steps 3-8 until all of the records returned from steps 3 and 4 are handled with steps 3.a, 4.a, and 5-8

10

update the record in table D for the given run id, to populate the enddatetime

11

You can use these urls as your test case, to populate into tableA, with the runid=1

record id 1 url = [login to view URL]

record id 2 url = [login to view URL]

you can use these rows as your test case to populate tableB

record id 1

url = [login to view URL]

regex = 'business(.*?)nursing/mi'

forall=false

record id 2

url = [login to view URL]

regex = '250(.*?)150/mi'

forall=false

record id 3

regex = 'michigan(.*?)acres/mi'

forall=true

record id 4

url = [login to view URL]

regex = 'ann arbor(.*?)flint/mi'

forall=false

Beceriler: PHP, MySQL, Regular Expressions

Daha fazlasını gör: php mysql simple project database, php mysql template project, php mysql cms ajax multi language, php mysql gsmarena project, php mysql sample project coding, website security php mysql application project, php mysql symple project sample, simple php mysql free project, php mysql gnu project, php mysql library project, outsourcing php mysql small project, php mysql manager project file document, php mysql complete project, php mysql apache project website development, php mysql gwt project

İşveren Hakkında:
( 18 değerlendirme ) Kennesaw, United States

Proje NO: #20119152

Bu iş için 57 freelancer ortalamada $174 teklif veriyor

Yknox

Dear, I am Jin S, WEB developer in China. I've just read your job posting and I’m very interested. I'm a certificated freelancer with almost 1000 good reviews from clients. I have experienced knowledge in every part of Daha Fazla

$250 USD in 30 gün içinde
(728 Değerlendirme)
9.1
A2Design

Hello! We're a full-cycle team of 30+ web developers. Having the required skills, we will be glad to help you with your project. We have some questions for you to clear up before we start. Please message us, so we Daha Fazla

$350 USD in 3 gün içinde
(114 Değerlendirme)
8.6
extreamcode

Hi there, I can assist you with php mysql regex project. I’d like to be considered for your Project. I’m a designer and developer with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, Wordpress, Daha Fazla

$140 USD in 7 gün içinde
(81 Değerlendirme)
7.6
idragon712

Hello Client. I am a senior web developer with 7 years of rich experiences. I have strong skills in Core php and mysql query. I have checked your 11 requirements and regular expressions. I am sure I can complete all re Daha Fazla

$150 USD in 7 gün içinde
(62 Değerlendirme)
7.5
liangjongai

Hello, sir I am web developer. I have a detail look to your project, I have a great skill in mysql and php. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via chat. Daha Fazla

$140 USD in 7 gün içinde
(262 Değerlendirme)
7.9
widadsaghir1993

Dear client, It's good to see another serious job posting here! I have read your project skill requirement and potentially found this job is highly good match with me for experience and skills hence I would like Daha Fazla

$250 USD in 7 gün içinde
(86 Değerlendirme)
7.3
bjrupani

Hello hiring member i hope you are doing well i am bhavika i have 3+years experience in php, laravel , ajax , jquery , javascript , html ,css boostrap and many things we have done with this all skill we can mak e you Daha Fazla

$150 USD in 2 gün içinde
(119 Değerlendirme)
6.4
babitabubu

Hi, such an interesting job. I have read your specifications and understand what you have asked and I have checked WIKIPEDIA links. I can done the work in 2 days for you. Thank you.

$250 USD in 2 gün içinde
(116 Değerlendirme)
6.7
urmate

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and requ Daha Fazla

$250 USD in 7 gün içinde
(244 Değerlendirme)
6.7
michealperfect

Hello.! I'm a full stack web developer. I'm a great command on PHP. I have so many years of experience in core PHP. Please check my recently done project for PHP https://surmawala.pk. I'll do fast work and quality work Daha Fazla

$250 USD in 7 gün içinde
(158 Değerlendirme)
6.8
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] Daha Fazla

$100 USD in 3 gün içinde
(88 Değerlendirme)
6.7
appbank888

Hello, How are you? I have checked your project descriptions in detail. I would like to work for you in this project. Please feel free to contact me. Thank you. Kim

$200 USD in 5 gün içinde
(22 Değerlendirme)
6.0
DaniilSpasov

Hello. How are you today? I've read your job post carefully. This job really attracts me and also your required skills are completely matched with my major skills. I have good knowledge and rich experience with it. I b Daha Fazla

$200 USD in 4 gün içinde
(15 Değerlendirme)
5.9
ZhangXH

Hello. I have read your project description and very interested in your project. I have developed web sites for five years, including web scraps, shopping sites, business web apps, and web API integration. Especially I Daha Fazla

$140 USD in 7 gün içinde
(37 Değerlendirme)
6.1
techplusintl

Hi there, Greetings from TechPlus! I've reviewed requirements & ready to develop the web on php. 5+ Years Expertise in : CMS (Wordpress, Magento, Shopify, OpenCart, Joomla, Drupal, Prestashop) PHP Frameworks (Larave Daha Fazla

$250 USD in 7 gün içinde
(97 Değerlendirme)
6.1
MyAwesomeTeam

Dear Sir/Madam, Because good at those skills: PHP, Regular Expressions, MySQL. I would like apply for this job I always: - Do project fast as possible. - Charge a reasonable cost. - Provide Quality Produc Daha Fazla

$148 USD in 3 gün içinde
(41 Değerlendirme)
5.8
jamesmartin81

I have experience of Website in PHP, Laravel, CodeIgnitor, Wordpress, Opencart, Woocommerce, Photoshop, Adobe Illustrator . We also have experience of making Android,Window and iphone application with ionic & phonegap. Daha Fazla

$67 USD in 2 gün içinde
(112 Değerlendirme)
5.9
TakaAlex

Dear sir! I've read all of your requirements extremely carefully. This is the one experienced in HTML, PHP, MySQL and Javascript. It will be pleasure to work with this project. So I'd like to discuss in detail over cha Daha Fazla

$140 USD in 7 gün içinde
(17 Değerlendirme)
5.6
tiwariraushan71

Hi There, I am PHP experts having combined experience of more Than 5-6 years in PHP Framework :- Prestashop,Magento, Wordpress, & BIgcommerce and already completed more than 100 projects successfully. We offer the f Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(96 Değerlendirme)
5.9
sevenstarservice

Hello, I'm a full time freelancer and am free now. I have read your project description I am very interested in this project. I have a lot of experience in this type of work. I'm sure I can complete it on time with Daha Fazla

$140 USD in 2 gün içinde
(14 Değerlendirme)
5.0