Update php/mysqli procedural script to php/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. I've managed to include a salt during registration but have struggled on getting the data back to flash on login. Eh... that's another story. If you complete this job and also know flash we can discuss that part later. So maybe just leave the salt if it's going to be complicated implementing it with as3. Right now I just need prepared statements.

Also, 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 a decent amount of security.

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 = [url removed, login to view];

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 way less than an hour to complete. I would learn myself as in the past but I just don’t have the time right now.

Taidot: MySQL, PHP

Näytä lisää: string hash, php job application form code, learn algorithm, invalid email error, hash strings, hash string, err login, complicated algorithm, code for update in php, actionscript 3 job, php script csv update table sql, script update php, php script copy update database, php script execute update, stock update php script, pricing update php script, php script automatically update, update php script, run php script data update, update php script example

Tietoa työnantajasta:
( 0 arvostelua ) Griffin, Australia

Projektin tunnus: #9544451

1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön

$25 AUD 3 päivässä
(3 arvostelua)