Ich experimentiere gerade mit MySQLi, doch wenn ich folgenden Code einsetze, folgt immer ein Fehler:
Code: Alles auswählen
<?php
$mtime = microtime(1);
$sid = '123412341234';
$ip = '123.412.341.234';
$user_id = 0;
require('./../general/includes/inc.db.php');
$db = mysqli_init();
$db->real_connect($dbhost, $dbuser, $dbpasswd, $dbname);
$stmt = $db->prepare('INSERT INTO web_sessions (session_id, time_stamp, user_ip, user_agent, user_id) VALUES (?, ?, ?, ?, 0)');
$stmt->bind_param('sdss',
$sid,
$mtime,
$ip,
$_SERVER['HTTP_USER_AGENT']
);
?>Warning: mysqli_stmt::bind_param() [function.mysqli-stmt-bind-param]: Number of variables doesn't match number of parameters in prepared statement in /www/htdocs/********/web/general/test.php on line 21
