₦airaland Forum

I created this function to update a database
when the submit button is click but it seems not to work.

please I need help debugging it.

<?php
include_once('libraries.php'); // contains the database function

function update(){
db(); // database function
$pname = $_POST['pname'];
$categoryid = $_POST['categoryid'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$user = $_POST['users'];
$pass = $_POST['pass'];

function createSalt()
{
$string = md5(uniqid(rand(), true));
return substr($string, 0, 3);
};
$salt = createSalt();
$hash = hash('sha256', $salt . $pass);

$sql = "UPDATE users SET user=?,pass=?,salt=?,pname=?,email=?,phone=? WHERE categoryid=?";
$q = $conn->prepare($sql);
$q->execute(array($user,$hash,$salt,$pname,$email,$phone,$categoryid));
}

?>

I think you should have something like

if (isset($_POST["name of Your Submit Button"]){
        update();
}

and the createSalt() function should be declared outside the update function....

itz nt working?...whatz d error?..nothin seems 2 b wrong with this code snippet..if this is the action file of ur form, and all field names are correct, then there shuld be no bug or even mosquitoe...