Update php/mysqli procedural to mysqli prepared statements

Closed Posted Feb 2, 2016 Paid on delivery
Closed Paid on delivery

I require a php mysqli registration, forgot password and submit scores script to be updated to mysqli prepared statements. I’ve included the minimum code required for the job. Once it’s completed I can convert the rest (login and update password scripts) myself .

I also require the password to use a salt in addition to the hash algorithm.

Am not sure if the email variable requires a sanitise function or whether using prepared statements is enough. I’ll leave that up to you. Either way I need as much security as possible.

Please note I need to retain the error strings in the php as they are called by my flash air application. If they need to be written differently then please do so in a form that I can easily include in my actionscript. For instance in php I have ...

else if (mysqli_num_rows($result)>0) {

$msg = ((is_object($connect)) ? mysqli_error($connect) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));

$string = 'valid=0&err=double data';

}

and in actionscript ....

var err:Array = new Array();

err[0] = "Error. Username is not unique or invalid/incomplete form (username/password must be a mininum of 6 characters).";

function completeHandler(e:Event):void

{

var res:String = [login to view URL];

if(res == "0") fillErrorText(error, err[0]);

}

You may not know actionscript but you can see I need those strings.

I figure this would take an experience php/mysqli coder less than an hour to complete. I would learn myself as in the past but I just don’t have the time right now.

Please note... my application is fully functionional. I do not need the code to be changed in any way other than making it more secure against hackers. I've learned that prepared statements prevents sql injection. As mentioned, I would also like a salt function added to password database input.

MySQL PHP

Project ID: #9544686

About the project

27 proposals Remote project Active Mar 11, 2016

27 freelancers are bidding on average $184 for this job

graphicaa

Greetings, This is GOPAL for STALLIONi, Let me assist in this. Best results & optimum cost guaranteed here. Now, I am available for live chat. If you are convenient - now we can discuss more about this project. More

$294 AUD in 10 days
(570 Reviews)
9.0
toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor More

$200 AUD in 3 days
(770 Reviews)
8.3
sismaster

Greetings for the day This is poonam FULL TIME FREELANCER having 5+ YEARS of experience in PHP development. I have reviewed and analyzed your requirement. If you are really interested this to done ON TIME and ON More

$50 AUD in 1 day
(597 Reviews)
7.8
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo More

$226 AUD in 8 days
(509 Reviews)
8.3
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$257 AUD in 12 days
(452 Reviews)
8.2
mrinalbhuyan

Hi I have read your project and got your requirement . I have done similar work lots of time. I have some questions regarding the project . Let me know if you have some time to discuss the details further . Plea More

$147 AUD in 3 days
(144 Reviews)
7.3
letshappy

hello, i have more then 5 year experience in this field i easily can do this have a look to my reviews ready to start now thanks

$189 AUD in 2 days
(159 Reviews)
7.1
BitLabs

Hello, I have gone through your outsourced requirements "Update php/mysqli procedural to mysqli prepared statements" and have analyzed that I have right credentials (Skills required MySQL, PHP) to execute your este More

$185 AUD in 1 day
(115 Reviews)
6.7
harsh075

Hello I have read the complete project and have understood the requirement. I have 7+ years of experience in developing and managing big applications. Kindly ping me in PM to discuss further. Thank you

$50 AUD in 1 day
(80 Reviews)
5.7
robinkhurana

Hi, I am Robin. i have 5+ years experience. I have read your job post, and i am sure i can do that right now... ..... Thanks

$147 AUD in 3 days
(8 Reviews)
3.5
sandaruwanasanka

Dear Sir I am a software engineer from Sri Lanka with a degree in Information technology from the university of Colombo. I have experienced in web application development using ajax, php And mysql . and also have a More

$88 AUD in 3 days
(6 Reviews)
2.7
KevinZC

Hello! Give me chance to prove my ability and also quality work i am waiting your positive replay from your side i am highly interested to work with you We have 8 years experience in this field and completed many proj More

$144 AUD in 3 days
(1 Review)
3.0