Closed

Update php/mysqli procedural to mysqli prepared statements

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.

Skills: MySQL, PHP

See more: string hash, php job application form code, making an algorithm, php, html, learn algorithm, invalid email error, hash strings, hash string, flash sql php, err login, code for update in php, actionscript 3 job, update php csv, onchange update php, form update php, update php page, update php mysql, php multi byte cut string, post dynamic entries update php

About the Employer:
( 0 reviews ) Griffin, Australia

Project ID: #9544686

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
$157 AUD in 3 days
(1035 Reviews)
8.8
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
webqueue

Hi, I think you just need the script with database , so anyone can register. Please let me know if I'm wrong. OUR DEVELOPED RECENT SITE LINKS: ------------------------------------------------------------- More

$352 AUD in 2 days
(382 Reviews)
8.5
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
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
maysaxena

Hi there , I AM READY TO START YOUR WORK RIGHT NOW HAVE A LOOK ON MY REVIEW ME AND MY TEAM IS READY TO COMPLETE YOUR WORK WITH A QUALITY WORK I have gone through your project requirement specification and as pe More

$200 AUD in 5 days
(382 Reviews)
7.9
AxonTech

Hello , Ready to start immediately . We are interested to work with you, as we have expertise in Responsive Web Design, PHP, MySQL, WordPress Development and Customization . Our Company Portfolio: http://thea More

$84 AUD in 1 day
(112 Reviews)
7.4
malviyamanish

Dear Client , We gone through project description We are Really intrested to do work with you , We are Web & Software development company having more than 8 year experience in Software development we totally commit More

$588 AUD in 3 days
(220 Reviews)
7.7
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
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
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
leomedina01

Hi sir, My name is Leonardo Medina, and I'm from Brazil. I have lots of experience in PHP, Wordpress, Graphic and Web Design. I'm an experienced Web Developer/Designer working since 1996 in this field, with: * More

$164 AUD in 3 days
(150 Reviews)
6.9
$250 AUD in 5 days
(90 Reviews)
6.4
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
supersuntech

Wordpress/PHP/Website Proposal Links Our Recent Work: Wordpress Website: [login to view URL]://[login to view URL] [login to view URL]://[login to view URL] [login to view URL]://[login to view URL] Bootstrap: [login to view URL]://[login to view URL] [login to view URL] More

$144 AUD in 3 days
(18 Reviews)
5.2
leonappdevphp

We solve this half working day. Dear Client, Thank you for allowing us to place a bid on your project. We have very good hands on experience in working with the LAMP stack especially with PHP frameworks such as Smart More

$222 AUD in 2 days
(28 Reviews)
5.3
sushmakargwal

Hi, Greetings of the Day! We have read carefully & analysis of your php/mysqli requirements. Our Expert PHP Developers & Designers can provide it you just with in 3 days maximum with cheapest [login to view URL] know about More

$147 AUD in 3 days
(19 Reviews)
5.0
$155 AUD in 3 days
(16 Reviews)
4.4