PHP Session with MySQL Insert Into using bind_parm

Question

I am simply trying to insert the variable from a session into a MySQL database and it causes it to fail. var_dump shows SESSIONS all there. No problem there. Why doesn't this work?

$job = $_SESSION['job'];

$user_id = '1';
$name = 'allie';

$stmt = $mysqli->prepare("INSERT INTO
                        requests(name,job_info,user_id) 
                        VALUES (?,?,?)");

$stmt->bind_param('sss', $name, $job, $user_id);
$stmt->execute();

Add error reporting to the top of your file(s) right after your opening PHP tag for example `execute();` with `if(!$stmt->execute()){trigger_error("there was an error....".$mysqli->error, E_USER_WARNING);}` that will help you out. — Funk Forty Niner, Apr 20 '15 at 20:20
so, where are we at with this? two comments but nothing from you yet. — Funk Forty Niner, Apr 20 '15 at 20:32

score 1 · Answer 1 · answered Apr 23 '15 at 07:37

see pdo bind_param

your parameter is incorrect: change this:

$stmt->bind_param('sss', $name, $job, $user_id);

with this:

$stmt->bind_param(1, $name, PDO::PARAM_STR);
$stmt->bind_param(2, $job, PDO::PARAM_STR);
$stmt->bind_param(3, intval($user_id), PDO::PARAM_INT);

PHP Session with MySQL Insert Into using bind_parm

1 Answers1