Kan også ske det bare er en tilpasning af mit mysqli script der skal til for at det virker:
-----------
function getRefArray($a){
if (strnatcmp(phpversion(),'5.3')>=0) {
$ret = array();
foreach($a as $key => $val) {
$ret[$key] = &$a[$key];
}
return $ret;
}
return $a;
}
function iQuery($sql, $arrParams, $arrBindNames=false) {
$result = new stdClass();
/* Udvidelse af første version - START */
$result->num_rows = 0;
$result->affected_rows = 0;
$result->insert_id = 0;
$result->error = '';
$result->errno = 0;
/* Udvidelse af første version - END */
$mysqli = @new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DEFAULT_DB);
if (mysqli_connect_errno()) {
$result->error = 'Connection failed: '.mysqli_connect_error();
$result->errno = mysqli_connect_errno(); // Udvidelse af første version
return $result;
}
if ($stmt = $mysqli->prepare($sql)) {
$arrParams = getRefArray($arrParams); // <-- Added due to changes since PHP 5.3
$method = new ReflectionMethod('mysqli_stmt', 'bind_param');
$method->invokeArgs($stmt, $arrParams);
$stmt->execute();
$meta = $stmt->result_metadata();
if (mysqli_errno($mysqli)) {
$result->error = mysqli_error($mysqli);
$result->errno = mysqli_errno($mysqli); // Udvidelse af første version
}
if (!$meta) {
$result->affected_rows = $stmt->affected_rows;
$result->insert_id = $stmt->insert_id;
} else {
$stmt->store_result();
$params = array();
$row = array();
if ($arrBindNames) {
for ($i=0,$j=count($arrBindNames); $i<$j; $i++) {
$params[$i] = &$row[$arrBindNames[$i]];
}
} else {
while ($field = $meta->fetch_field()) {
$params[] = &$row[$field->name];
}
}
$meta->close();
$method = new ReflectionMethod('mysqli_stmt', 'bind_result');
$method->invokeArgs($stmt, $params);
$result->rows = array();
while ($stmt->fetch()) {
$obj = new stdClass();
foreach($row as $key => $val) {
$obj->{$key} = $val;
}
$result->rows[] = $obj;
}
$result->num_rows = count($result->rows); // Udvidelse af første version
$stmt->free_result();
}
$stmt->close();
}
else {
$result->error = mysqli_error($mysqli);
$result->errno = mysqli_errno($mysqli); // Udvidelse af første version
}
$mysqli->close();
return $result;
}
// Check if users email exist in the database at currect day
$sql = 'SELECT `id` FROM '.$tbl_name.' WHERE `emailaddress`=? AND `date`=CURDATE()';
$result = iQuery($sql, array('s', $_POST['emailaddress']));
if (count($result->rows)>0) {
// Output
header('Location:
http://www.domain.dk?success=2');
} else {
// Get values from form
$arrParams = array('sssss', $_POST['firstname'], $_POST['lastname'], $_POST['emailaddress'], $_POST['answer'], $_POST['newsletter']);
// Insert data into table
$sql = "INSERT INTO $tbl_name (firstname, lastname, emailaddress, answer, newsletter, date) VALUES (?, ?, ?, ?, ?, CURDATE())";
$result = iQuery($sql, $arrParams);
// Output
header('Location:
http://www.domain.dk?success=1');
}
