Various fixes to online system for retail shops

Job ID: 33013090

Budget: $250 – $750 AUD

I’ve got a system working and I do a lot of the work on it, but as I’m self-taught sometimes I get stuck and need help. I have various challenges that I need help on:

1. I have a function where people can submit an item for review with multiple photos. It has two issues:
a. The ajax script has to be modified to handle multiple photos and I haven’t been able to get it to work. I’ve done what I think is the coding but it isn’t working.
b. When multiple photos are selected (not that it handles this anyway but it isn’t blocked), two input fields are not sent to the ajax script via formData so the field validation throws up errors, such as “Please enter item brand”, even though the brand has been entered.

2. I have autocomplete working in a few pages but have three issues:
a. In one page, selection of brand clears all other items below it. That’s because it does a filter by brand which refreshes the page. I need this done through a different mechanism so that this doesn’t occur.
b. In another page, once you’ve modified and saved brand once, the autocomplete no longer works until you go out and back into the page. Even if you refresh page, it doesn’t work.
c. I have to press ‘Enter’ or the search button to submit an autocomplete entry. I’d like it changed so that you can just select the item from the autocomplete list.

3. I have a page with two instances of lightbox showing an image. In one instance, it works fine. But in the other, it just shows the image with the path to the image in the url (i.e., the lightbox functionality is not working).
4. I have a cron job which works fine from the browser, but when run as cron job I get an unexpected PHP error.
5. I’d like some assistance in one page to put an image to the right of a numbered or bulleted list.
6. I’d like to be able to make a confirm message box with Yes/No instead of OK/Cancel
7. I’ve got a bit of work I’m doing that requires me to get a list of items within an ajax script and get it into a calling script. Getting the items is easy – and I’ve modified the ajax script to pass back results as an array – I’m sure that’s working. I just can’t seem to work out how to get the script to read this array
8. I’d like to get a stylized E (eftpos symbol) in a button but font-awesome doesn’t support it so I need to get it from elsewhere.
9. I’m modifying all my SQL to use prepared statements so that the code is not subject to SQL injection. Updates, deletes and inserts are all easy but I’d like some assistance in setting up the SELECTS. I’d like some assistance on a basic select statement as in the attached file

The freelancer needs to be able to have a screenshare session so that ) I can introduce you to the show you the system and the code. I’ll show you the basic code structure of the system as well as point you to the specific areas of code that I’ve been working on and where I’m having trouble. This will make it a lot easier for you to fix these problems.
Related categories: PHP JavaScript Website Design HTML jQuery