
Need php program to count matching records in mysql
- or -
Post a project like this2776
$
- Posted:
- Proposals: 6
- Remote
- #1795937
- Awarded
Description
Experience Level: Entry
General information for the business: We operate websites
Kind of development: New program from scratch
Num. of modules: 1
Description of requirements/functionality: I have a mysql database with two columns, first column is individual names, second column contains hundreds of names separated by commas. The database has thousands of rows
I need to populate a third column with the total number of appearances of the first column name in the second column array of names in any row
Here is simple example
Count Calculated
joe | jim, nancy, mary, peter | 2
peter | joe, nancy, mary | 1
mary | nancy, jim, joe, susie | 3
danny | mary, nick, john | 0
I normally do this with a spreadsheet countif statement but the file is too large now
CMS and Admin requirements: I just need to be able to execute a php script via command line specifying the database to process
For example if the php script is process.php
I will issue a command something like "php process.php database_name" and let it run
The processing should continue running after I close ssh connection
Processing should restart automatically if the server is rebooted, can use a cron to trigger, the app just needs to be smart enough to pick up where processing was stopped
Specific technologies required: php
OS requirements: Linux
Extra notes:
Kind of development: New program from scratch
Num. of modules: 1
Description of requirements/functionality: I have a mysql database with two columns, first column is individual names, second column contains hundreds of names separated by commas. The database has thousands of rows
I need to populate a third column with the total number of appearances of the first column name in the second column array of names in any row
Here is simple example
Count Calculated
joe | jim, nancy, mary, peter | 2
peter | joe, nancy, mary | 1
mary | nancy, jim, joe, susie | 3
danny | mary, nick, john | 0
I normally do this with a spreadsheet countif statement but the file is too large now
CMS and Admin requirements: I just need to be able to execute a php script via command line specifying the database to process
For example if the php script is process.php
I will issue a command something like "php process.php database_name" and let it run
The processing should continue running after I close ssh connection
Processing should restart automatically if the server is rebooted, can use a cron to trigger, the app just needs to be smart enough to pick up where processing was stopped
Specific technologies required: php
OS requirements: Linux
Extra notes:

Joseph D.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
5 Feb 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies