Ditutup

Write PHP script to fix deleted column in MySQL Table

A column in a Mysql table was accidently deleted today... and the only backup was 1 year old... A PHP and MySQL script should be written to fix the missing data which can be calculated from the remaining data as described here..

The columns are:

ID, CustID, PackagID, StartDate, EndDate, Paid, Qty, ExtraInfo, Cost, Invoiceno, nextno

The field called NextNo was accidently deleted for all rows in the database.

A PHP script should scan through the table and work out the ID of the next billed entry and then update the table to repopulate the field called 'nextno'

E.G.

| 9960 | 712 | 49 | 2011-11-09 23:00:00 | 2011-12-08 23:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4622 | 10054 |

| 10054 | 712 | 49 | 2011-12-09 23:00:00 | 2012-01-07 23:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4680 | 10115 |

| 10115 | 712 | 49 | 2012-01-08 23:00:00 | 2012-02-06 23:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4714 | 10335 |

| 10335 | 712 | 49 | 2012-02-07 23:00:00 | 2012-03-07 23:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4787 | |

| 10403 | 712 | 49 | 2012-03-08 23:00:00 | 2012-04-08 00:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4813 | |

| 10525 | 712 | 49 | 2012-04-09 15:39:41 | 2012-05-09 15:39:41 | pending | 1 | Bespoke Hosting | 530.00 | 4835 | |

| 10555 | 712 | 49 | 2012-04-08 00:00:00 | 2012-05-08 00:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4842 | |

| 10638 | 712 | 49 | 2012-05-09 00:00:00 | 2012-06-09 00:00:00 | pending | 1 | Bespoke hosting | 530.00 | 4948 | |

| 10807 | 712 | 49 | 2012-05-10 15:39:41 | 2012-06-09 15:39:41 | pending | 1 | Bespoke Hosting | 530.00 | 4985 | |

| 10894 | 712 | 49 | 2012-06-10 00:00:00 | 2012-07-10 00:00:00 | pending | 1 | Bespoke hosting | 530.00 | 5014 | |

| 10957 | 712 | 49 | 2012-06-10 15:39:41 | 2012-07-10 15:39:41 | pending | 1 | Bespoke Hosting | 530.00 | 5053 | |

| 11082 | 712 | 49 | 2012-07-10 15:39:41 | 2012-08-10 15:39:41 | pending | 1 | Bespoke Hosting | 530.00 | 5152 | |

| 11499 | 712 | 49 | 2012-08-11 15:39:41 | 2012-09-11 15:39:41 | pending | 1 | Bespoke Hosting | 530.00 | 5405 | |

| 11629 | 712 | 49 | 2012-09-12 15:39:41 | 2012-10-12 15:39:41 | pending | 1 | Bespoke Hosting | 530.00 | 5548 | |

E.G. in the above 10403 is clearly the 'nextno' for 10335

Not all the rows are that simple because Sometimes the purchasedate is the same date as the expires date, sometimes it is the day after and sometimes it is a day before.. So the script will need some kind of tolerance to work this out. Some examples of this in PHP are:

foreach ($list as $r) {

$current = $r;

foreach ($list as $a) {

if ($a[id] != $r[id]) {

if ($r[expiresdate] <= $a[purchasedate]) {

if ($a[extrainfo] == $r[extrainfo]) {

if ($a[packagid] == $r[packagid]) {

if ($a[cost] == $r[cost]) {

echo "Possible Match: $a[id] nextno for $r[id]\n";

$s="UPDATE purchased_packages set nextno = '$a[id]' where id = $r[id]";

//$g=mysql_query($s);

echo $s."\n";

break;

}

} } }

}

}

}

I will provide a full copy of the MySQL Table to the person who takes this on.

Kemahiran: MySQL, PHP

Lihat lebih lanjut: to fix it, foreach in php and mysql, bespoke data entry, write php and mysql, write a simple php script, mysql backup, Column, database copy script, php backup mysql, mysql update field, missing columns data, mysql backup table, mysql date field, mysql copy database, missing table, year date column, missing database table, php mysql field list, backup mysql php, php script echo, write script data entry, fix match, mysql update table, script entry database entry, echo script php

Tentang Majikan:
( 11 ulasan ) London, United Kingdom

ID Projek: #4313674

40 pekerja bebas membida secara purata $127 untuk pekerjaan ini

toinnisfree

quick pro help. ftp and milestone required.

$200 USD dalam 3 hari
(520 Ulasan)
7.8
cevouk

Hi there Please find my bid, I've allowed for several hours encase there is any difficulties but we should be fine. Thanks James

$135 USD dalam 4 hari
(172 Ulasan)
7.3
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$300 USD dalam sehari
(368 Ulasan)
6.9
zeke

Expert PHP/MySQL developer. Available to start immediately and finish today.

$100 USD dalam sehari
(145 Ulasan)
6.8
rinsadsl

please refer to my private message

$150 USD dalam 4 hari
(187 Ulasan)
6.7
mitrasubir

Hi, Please check PMB for details. Thanks KD

$250 USD dalam 7 hari
(38 Ulasan)
6.6
DrTech76

Hi! Actually a walk-through algorithm won't be that much difficult to implement. I have some questions though. Sending you message in a sec. Kind Regards

$50 USD dalam 0 hari
(240 Ulasan)
6.5
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below [url removed, login to view] Lagi

$250 USD dalam 15 hari
(62 Ulasan)
5.7
diegou

hi i can do this

$90 USD dalam sehari
(35 Ulasan)
5.7
weonlydo

Hi, I am interested in this project and would like to discuss further.

$150 USD dalam 3 hari
(33 Ulasan)
5.4
seekdeveloper

Hi, Consider its done! I would love to get this opportunity of working with you. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Thanks

$230 USD dalam 2 hari
(13 Ulasan)
5.3
D3SolutionsIndia

please check private message

$130 USD dalam 3 hari
(18 Ulasan)
5.2
Eliteprog

Hi, First of all thanks for posting this project, I am available to provide you economical services for bug fixing on web model, I have read and understood all of project details. I am expert in opensource developm Lagi

$131 USD dalam 6 hari
(22 Ulasan)
5.0
abanipatra

Hi, I would like to work on your project.

$60 USD dalam 2 hari
(43 Ulasan)
4.7
pixecs

Dear sir, i can help you with this project. I have over 7 years of experience in mysql database programming, and over 3 years of experience in Php development.

$40 USD dalam 3 hari
(25 Ulasan)
4.7
pollux1er

------- Hi, this is a 01 hour Job! I can do this for you!!! -----------

$50 USD dalam 0 hari
(26 Ulasan)
4.5
svipl7

Hello we are 8+ years old web-development company. please check our portfolio for more details. thanks

$160 USD dalam 2 hari
(9 Ulasan)
4.5
trongtd1988

I can do it for you, I'm professional in PHP, MySql. You can give me this project. i will do it for you. Thank you.

$50 USD dalam 2 hari
(1 Ulasan)
4.5
freelancerbuzzo

Check PM, please.

$90 USD dalam sehari
(12 Ulasan)
4.4
apbsystems

Hi, I can help you to fix the deleted column. Thanks for considering my bid. Patrik.

$100 USD dalam 2 hari
(8 Ulasan)
4.3