Can't insert into DB
Not sure why, I can't process the PHP. The script connects fine but I can't insert the entries in to the DB:
$fullname = mysql_escape_string($_POST['name']);
$title = mysql_escape_string($_POST['title']);
$email = mysql_escape_string($_POST['email']);
$uname = mysql_escape_string($_POST['username']);
$password = mysql_escape_string($_POST['password']);
$insert = "INSERT INTO human_network (Employee_id, Name, Title, Email, Username,
Password, Date_time_created)
VALUES ('".$eid."','".$_POST['name']."', '".$title."', '".$email."',
'".$uname."', '".$password."', '".$createddate."')";
$add_member = mysql_query($insert);
Upon checking further this 开发者_运维问答is the error I get:
Invalid query: Access denied for user 'www-data'@'localhost' (using password: NO)
as of the error: check your mysql user permissions. user www-data
seems not to have the permission to execute INSERT
精彩评论