ho creato questo metodo per inserire dati tramite PDO:
Codice PHP:
<?php
class Config {
private $pdo;
public function __construct() {
try {
$this->pdo = new PDO(.........);
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "
";
die();
}
}
public function insert($nome, $cognome, $data_nascita, $cel, $tel, $fax, $soc, $carica, $email1, $email2, $sito, $casa, $uff) {
$sql = "INSERT INTO contatti (nome, cognome, data_nascita, cellulare, telefono, fax, societa, carica, email_1, email_2, sito_web, indirizzo_casa, indirizzo_uff) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)";
$prepare = $this->pdo->prepare($sql);
$prepare->execute(array(
$nome,
$cognome,
$data_nascita,
$cel,
$tel,
$fax,
$soc,
$carica,
$email1,
$email2,
$sito,
$casa,
$uff
));
}
}
i dati glieli passo così:
Codice PHP:
<?php
require_once 'config.php';
$obj = new Config();
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$insert = $obj->insert(htmlentities($_POST['txtName'], ENT_QUOTES), $_POST['txtSurname'], $_POST['txtData'], $_POST['txtCell'], $_POST['txtTel'], $_POST['txtFax'], $_POST['txtSocieta'], $_POST['txtCarica'], $_POST['email1'], $_POST['email2'], $_POST['sito'], $_POST['indirizzoCasa'], $_POST['indirizzoUff']);
if ($insert) {
echo "Utente inserito: " . $_POST['txtName'];
header("location:index.php");
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert</title>
</head>
<body>
<?php
include_once 'menu.html';
?>
<table>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<tr>
<td>Nome:</td>
<td><input type="text" name="txtName" value="" /></td>
</tr>
<tr>
<td>Cognome:</td>
<td><input type="text" name="txtSurname" value="" /></td>
</tr>
<tr>
<td>Data di nascita:</td>
<td><input type="text" name="txtData" value="gg/mm/aaaa" /></td>
</tr>
<tr>
<td>Cellulare:</td>
<td><input type="text" name="txtCell" value="" /></td>
</tr>
<tr>
<td>Telefono:</td>
<td><input type="text" name="txtTel" value="" /></td>
</tr>
<tr>
<td>Fax:</td>
<td><input type="text" name="txtFax" value="" /></td>
</tr>
<tr>
<td>Società</td>
<td><input type="text" name="txtSocieta" value="" /></td>
</tr>
<tr>
<td>Carica:</td>
<td><input type="text" name="txtCarica" value="" /></td>
</tr>
<tr>
<td>Email 1:</td>
<td><input type="text" name="email1" value="" /></td>
</tr>
<tr>
<td>Email 2:</td>
<td><input type="text" name="email2" value="" /></td>
</tr>
<tr>
<td>Sito web:</td>
<td><input type="text" name="sito" value="" /></td>
</tr>
<tr>
<td>Indirizzo casa:</td>
<td><input type="text" name="indirizzoCasa" value="" /></td>
</tr>
<tr>
<td>Indirizzo ufficio:</td>
<td><input type="text" name="indirizzoUff" value="" /></td>
</tr>
<tr>
<td>
<input type="submit" value="submit" name="Submit" />
</td>
</tr>
</form>
</table>
</body>
</html>
ma i dati nn li inserisce.
il metodo PDO l'ho ripreso da un libro.