Experienced and patient php programmer with session and cookie expertise needed to sweep up cookie crumbs and messy session table in otherwise nice custom ecommerce site. Most programmers want to rewrite code from scratch. I’m looking for that special individual that will put in the effort to understand existing cookies and session variables and fix any problems with them while keeping essentially the same page structure and code logic. The code is fairly well commented and procedural, not object oriented. It’s a pretty basic, few frills, php/sql site but reads more like an old style basic program than oscommerce.
Currently the site is working great but with two major issues you will need to address.
Although users check out through a secure server to protect credit card information, they cannot login or register a new account on the secure server. Currently the program keeps track of logins and username with cookies. Moving the login and registration pages to the secure site, makes the rest of the program unable to see the cookies. I don’t know if there is a trick for being able to go back and forth or if I need to move away from using cookies altogether.
Figure out why the session table in the database is growing so fast and fix this problem. It appears that every time php assigns a new session number, an entry is made in the session table. It is supposed to keep track of shopping decisions until a user logs in as a registered user. But for the most part this session number isn’t needed and just fills up the table causing it to grow very quickly.
I’d like to hire someone with their own workspace and who can set up an ftp account I can use to send you the files and backups of the database. There are only a few php files (header, functions, login and registration) using cookies or session variables but I’ll send you all critical files so you can run the whole thing. I use four small sql databases to run the program. If you are limited to one, you will need to know how to combine them.
I’m OK with putting payment in an escrow account but I’d ask you please not to bid on this project just to ignore it. I’m looking for someone who can do this in a timely manner and trying to avoid those who tie up projects in escrow while trolling for easier projects. I’d also like to delay putting money in an escrow account until you have retrieved the files and had time to take a look at the actual work to minimize hassle if the project has to be cancelled in the first few hours due to some unforeseen problem.
When you know what you need to do to fix this problem I’d like a written description of what the problem was and what you did to fix it as well letting me run through it while it is on your server. That is because for this project I won’t be able to tell that the problems were fixed or that the cookies and sessions are better just from a quick demonstration. So in this case, I’d also like you to say in words what is going on and then I’ll pay you to see the actual code.
Ask me any questions about the code, the cookies or whatever and I’ll try hard to tell you anything you need to know for you to be sure you can do this. I'll post the most problematic of the files so you can see what you are getting into.