Write PHP script to fix deleted column in MySQL Table
$30-250 USD
Ditutup
Disiarkan sekitar 11 tahun yang lalu
$30-250 USD
Dibayar semasa penghantaran
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.
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
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
https://www.freelancer.com/projects/Linux-Bulk-Marketing/Interspire-Geolocalization.html
https://www.freelancer.com/projects/PHP-HTML.1/Seamless-billing-login-website.html
https://www.freelancer.com/projects/Linux-Bulk-Marketing/Interspire-Geolocalization.html
https://www.freelancer.com/projects/PHP-Linux/Script-Cron-FTP-files.html
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 development and completed nice big projects on freelancer with good rating, you can see on my profile on freelancer.
References are also given.
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.