Ditutup

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

Kemahiran: PHP, MySQL, Regular Expressions

Lihat lagi: 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

Tentang Majikan:
( 18 ulasan ) Kennesaw, United States

ID Projek: #20119152

57 pekerja bebas membida secara purata $174 untuk pekerjaan ini

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 Lagi

$250 USD dalam 30 hari
(728 Ulasan)
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 Lagi

$350 USD dalam 3 hari
(114 Ulasan)
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, Lagi

$140 USD dalam 7 hari
(81 Ulasan)
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 Lagi

$150 USD dalam 7 hari
(62 Ulasan)
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. Lagi

$140 USD dalam 7 hari
(262 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(86 Ulasan)
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 Lagi

$150 USD dalam 2 hari
(119 Ulasan)
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 dalam 2 hari
(116 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(244 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(158 Ulasan)
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] Lagi

$100 USD dalam 3 hari
(88 Ulasan)
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 dalam 5 hari
(22 Ulasan)
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 Lagi

$200 USD dalam 4 hari
(15 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(37 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(97 Ulasan)
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 Lagi

$148 USD dalam 3 hari
(41 Ulasan)
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. Lagi

$67 USD dalam 2 hari
(112 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(17 Ulasan)
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 Lagi

$50 USD dalam sehari
(96 Ulasan)
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 Lagi

$140 USD dalam 2 hari
(14 Ulasan)
5.0