#insert record

[anuragsinghce]

Insert records in a Database table with MySQLi (object-oriented)

$add = “INSERT INTO users (name, email, msg, gender, opinion) VALUES (?,?,?,?,?)”; if ($stmt = $conn->prepare($add)) { $stmt->bind_param(‘sssss’, $name, $email, $msg, $gender, $opinion); } else { die (“Error : ” . $conn->error); }

$name = ‘DEU'; $email = ‘Bavarian'; $msg = “F”; $gender = “male”; $opinion = “yes”;

/* execute prepared statement */ $stmt->execute();

$stmt->close();

View On WordPress