Devam Ediyor

Need PHP programmer to make script to update MySQL database

FIELDS: ID, Column1, Column2, etc.

1. I need a PHP script for my MySQL database that will update a field (Column1) in all rows found with a text that I will define.

2. The rows to appear in the results are rows that have duplicate content with other rows regarding a field (Column1)

3. The script will need to search all tables containing a specific text (for exemple, search all tables in a database containing the word "data" in the table's name)

4. Moreover, within the duplicated rows, all of them must be updated (as stated in point 1.) ...except the row with the oldest datetime date within the same table (between the rows with the same duplicate content)

5. The search must only take into consideration rows where Column1 have at least x number of character (for example... 3... in this example below)

6. I would like options in a config file to: set if i want to run in test mode (showing all results found without updating the data), set the number of character minimum to consider, set the table's name keyword to consider, set the number of rows NOT to be updated (see point 4.)

7. I would like another search option that does the following: update all the row's field (Column1) if a string that I provide is found exactly or within other rows' field (Column1)... including all tables with a specific keyword (like in point 3.) I would also like a test mode for point 7.

EXAMPLE: (for points 1 to 5)

table_house (column with the date related to table "table_house_data" below) ...the date table is a table without the "_data" suffix

ID | Date (datetime type)

1 | 2005-07-15 16:32:54

2 | 2005-04-20 16:32:54

3 | 2005-12-30 16:32:54

4 | 2005-08-08 16:32:54

table_car

ID | Date

1 | 2001-07-15 16:32:54

2 | 2005-04-20 16:32:54

3 | 2003-12-30 16:32:54

4 | 2007-08-08 16:32:54

table_monkey

ID | Date

1 | 2006-05-15 16:32:54

2 | 2000-03-20 16:32:54

table_house_data

ID | Column1

1 | hey you yada

2 | money

3 | plane

4 | money

table_car_data

ID | Column1

1 | money

2 | hi

3 | hi

4 | plane

table_monkey_someothertable

ID | Column1

1 | money

2 | plane

The script would output (to show the duplicates):

DUPLICATE | TABLENAME | ID | DATE

money | table_house_data | 2 | 2005-04-20 16:32:54

money | table_house_data | 4 | 2005-08-08 16:32:54

money | table_car_data | 1 | 2001-07-15 16:32:54

plane | table_house_data | 3 | 2005-12-30 16:32:54

plane | table_car_data | 4 | 2007-08-08 16:32:54

And it will only update

money | table_house_data | 2 | 2005-04-20 16:32:54

money | table_house_data | 4 | 2005-08-08 16:32:54

plane | table_car_data | 4 | 2007-08-08 16:32:54

...and replace "money", "plane" or any other string in the result by a text that a would decide.

Beceriler: Veri İşleme, PHP, Betik Yükleme

Daha fazlasını görün: text string, text string search, search text string, search php programmer, search character string, programmer mysql, need money programmer, make set, found programmer, be programmer, mysql searchalltables, update mysql field script, php shopping database plane, php update, scripts update tables database, updater php script, php update fields, php script updating mysql, update php script example, word script, update mysql, plane, need php, need database programmer, it programmer

İşveren Hakkında:
( 14 değerlendirme ) Montreal, Canada

Proje NO: #201092

Seçilen:

ErsanJSano

Hi, I can do this fast and for a fair price. Best regards, -Ersan

1 gün içinde 30$ USD
(6 Değerlendirme)
3.2

19 freelancer bu iş için ortalamada 80$ teklif veriyor

e3d

Can be done

in 2 gün içinde99$ USD
(76 Değerlendirme)
7.8
becomeexpert

Let's start :)

in 5 gün içinde100$ USD
(159 Değerlendirme)
7.6
BirdWatcher

Hello! I can do it for You for only $95. It will take me no longer than 24-48 hours. If You choose me I will do my best to do it as soon as possible. thanks Birdwatcher

in 0 gün içinde95$ USD
(62 Değerlendirme)
7.4
aamirpitafi

Hi, Please check pm. Thanks

in 5 gün içinde65$ USD
(39 Değerlendirme)
6.4
bsoist

Please see PMB.

in 2 gün içinde100$ USD
(42 Değerlendirme)
6.5
contentguru

Escrow required to start. Thanks.

in 3 gün içinde100$ USD
(29 Değerlendirme)
6.3
kopila123

please view pm

in 2 gün içinde100$ USD
(110 Değerlendirme)
6.3
milliard

Hello, We can do this project. Thank you

in 2 gün içinde50$ USD
(12 Değerlendirme)
5.6
rasaintnet

Can be done.

in 2 gün içinde70$ USD
(18 Değerlendirme)
5.5
dreamcorner

can be done sir.

1 gün içinde 100$ USD
(28 Değerlendirme)
4.9
alkweb

can do ASAP

in 3 gün içinde75$ USD
(2 Değerlendirme)
2.2
etindore

Can be done in 1 day. 6 yrs of experience in PHP

1 gün içinde 40$ USD
(1 Değerlendirme)
1.0
Xtremelogique

Our organisation Xtreme Logique is the brainchild of talents blended with Experience and Expertise of multi-dimensioned personalities in various technologies. Xtreme Logique is being headed by a person who has more Daha fazlası

in 7 gün içinde50$ USD
(0 Değerlendirme)
0.0
krissauquillo

I can do this for you. The description sounds simple enough and I can get a sample page up tomorrow after my finals. http://www.vilegaming.com is a sample of my quality work.

in 3 gün içinde75$ USD
(0 Değerlendirme)
0.0
thiyagu12

Well and wish you the same. I am 4+ years experinced programmer in PHP, MYSQL and also having sound knowledge on Ajax, Smarty, Javascript, Ecommerce Technologies. I had listed few of my sample sites on various technolo Daha fazlası

in 5 gün içinde90$ USD
(0 Değerlendirme)
0.0
j2ane

Good day sir, im a php/mysql programmer i would like to get this project. im very interested in this project hope to be considered Thanks

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
kafan

hi, we are future designers. we can complete the project within the time schedule. Waiting for your reply

in 5 gün içinde79$ USD
(0 Değerlendirme)
0.0
studentfree98

hi, we are available now thank you

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0