Need some problems fixed and a modification on existing php/mysql site

[patrickmathews]

I am in need of some help with an existing website.  The site was custom built about 4 years ago.  It was coded without using any sort of framework.  I have had some of these problems for a while and the hosting I was on made it difficult to get work done on it.  I have recently migrated to Godaddy so I now have complete access to it.   In the text below I have replaced the domain name with junk to avoid this page coming up on any searches.   I am experiencing error messages in several areas:

 

1.  When customer buys a product - the page that is output after a sucsessful authorize.net transaction contains the following:

 

Thank you for signing up! You should receive an e-mail confirmation of your purchase soon. You may start right away by logging in here: http://www.^&%$#@.com/driving/. Table 'sfdsomni.configs' doesn't exist
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in/home/content/90/11644390/html/%$#@/includes/config.inc.php on line 296
Table 'sfdsomni.configs' doesn't existTable 'sfdsomni.configs' doesn't existTable 'sfdsomni.coupons' doesn't exist

 

I don't see any table called configs in the sfdsomni database.  I am unsure if this is the cause of the error or if it is an error with the parameter for mysql_fetch_array() or both.

 

2.  When a customer signs up, an email is generated (welcome to our company - here is your login info kind of thing).  The email that is being sent is blank and seems to have an unknown sender some of the time.  There is an email text file that is editable by admins on the back end system - this seems to be fine and has not changed in years.  This was a problem on the previous hosting company as well.

 

3. Some of the products include an online driver education course - I am receiving errors when I sign on to that as a new student:

 

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/90/11644390/html/%$#@/driving/classes/config/courses.conf.php:155) in /home/content/90/11644390/html/%$#@/driving/classes/session.inc.php on line 70

 

4.  As I mentioned in another post (http://forums.phpfreaks.com/topic/284998-how-do-i-keep-form-data-from-disappearing/) - I have a page used for purchases (buynow.php) - there is an "Apply Coupon" entry button on it.  The coupon button currently links to another page which processes the coupon then take you back to a now blank (buynow.php).  I'd like to add the coupon field to the buynow.php page and have the apply coupon button simply run through the coupon logic (this is already there and working) without leaving the buynow.php page.  In other words - if a customer is buying something with a coupon - they fill out all there into (name, address etc.) add the coupon and hit "apply coupon" - when this button is pressed, if the coupon is valid - it adjusts the price.  If it is not, it displays the error message without emptying the rest of the fields on the buynow.php page.

 

5.  I would like to get the code documented so I have an idea of what file is calling what other file and where variables are being delcared.  I have a feeling that there is a lot of superfluous junk lying around that is confusing me  - I'd like to clean it up.  

 

 

 

Bid requirements:

 

I need this to be a fixed cost bid for each of or a combination of the 5 problems listed,  If you are confident that you can fix 1, 2 and 4 for $50 and you have no idea how much 3 will cost, please say so instead of guessing.  As for the documentation - for each of the problems and mods I need to know exactly what you changed in what files and I need comments with your name and date in the code for future reference (ie /* changed by john doe on 1/12/2014 to fix apply coupon problem */)  For the overall documentation mentioned in item 5 - I am looking for a document that will illustrate the relationship between the files - this can be graphical (I'd prefer it that way).  

 

Other work:

 

I have plans to do some additional modifications to the structure of the site to increase usability.  I also plan on a graphical face lift as well.  I am hoping to find someone I can go back to for these jobs in the near future. 

 

I was hoping to take the time to figure these out on my own, but I have too much stuff going on and I don't want to expose my customers to these errors any longer than necessary.  I am a novice at php - I feel like I could get a lot further if I could figure out how to turn on some sort of debug feature that would show me whats happening where and when.  For right now, I need to get these problems fixed ASAP.