验证和数据添加到数据库表 [英] validation and data add to a db table

问题描述

我之前问过的问题 pdo检索数据并填充记录关于输入掩码，现在我需要验证用户输入并将已输入的内容添加到db表中，这是最后一步.

the questions I have asked earlier pdo to retrieve data and populate a record was about the input mask now i need to validate the user input and add what has been entered to a db table and this is the very last step.

我的错误是，如您在下面的代码中看到的那样，我使用 PDO 误解了 INSERT INTO 和 UPDATE SET .

My mistake is as you can see in the below code that I misinterpret the INSERT INTO and UPDATE SET using PDO.

此外，关于INSERT INTO我确实使用bindParam来尝试输入数据，而关于UPDATE SET我则使用execute(array).实际上，此代码可验证用户数据输入，以及该输入是否正确，php会尝试连接到db，并应插入或更新表.奇怪的是，没有错误返回，也没有添加数据

Furthermore as far as concerned with INSERT INTO I do use bindParam in order to attempt a data entry, while about the UPDATE SET I use execute(array). As a matter of fact this code validates the user data input and whether that input is correct php attempts to connect to db and should insert into or update a table. The strange part is that no error is returned and no data is added

<?php
error_reporting(-1);
ini_set('display_errors', 'On');
?>
<?php
$servername = "xxx";
$username = "xx";
$password = "xxx";
$dbname = "xxxx";

try {
    $dbh = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	echo 'Connected to database<br />';
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
	$sth = $dbh->prepare("use accessibilita");
?>
<?php
switch ($_GET['action']) {
case 'add':
switch ($_GET['type']) {
case 'tages':
    $error = array();
    $nome = isset($_POST['nome']) ?
        trim($_POST['nome']) : '';
    if (empty($nome)) {
        $error[] = urlencode('Si prega di inserire un nome.');
    }
    $cognome = isset($_POST['cognome']) ?
        trim($_POST['cognome']) : '';
    if (empty($cognome)) {
        $error[] = urlencode('Si prega di inserire un cognome.');
    }
    $indirizzo = isset($_POST['indirizzo']) ?
        trim($_POST['indirizzo']) : '';
    if (empty($indirizzo)) {
        $error[] = urlencode('Si prega di inserire un indirizzo.');
    }
    $civico = isset($_POST['civico']) ?
        trim($_POST['civico']) : '';
    if (empty($civico)) {
        $error[] = urlencode('Si prega di inserire un numero civico.');
    }
	$citta = isset($_POST['citta']) ?
        trim($_POST['citta']) : '';
    if (empty($citta)) {
        $error[] = urlencode('Si prega di inserire una citta valida.');
    }
    $prov = isset($_POST['prov']) ?
        trim($_POST['prov']) : '';
    if (empty($prov)) {
        $error[] = urlencode('Si prega di inserire una provincia.');
    }
    if (empty($error)) {
        $stmt = $dbh->prepare("INSERT INTO tagesroma(nome, cognome, indirizzo, civico, citta, prov)
            VALUES (:nome, :cognome, :indirizzo, :civico, :citta, :prov)");
			$stmt->bindParam(':nome', $nome);
			$stmt->bindParam(':cognome', $cognome);
			$stmt->bindParam(':indirizzo', $indirizzo);
			$stmt->bindParam(':civico', $civico);
			$stmt->bindParam(':citta', $citta);
			$stmt->bindParam(':prov', $prov);
    } else {
      header('Location:tages.php?action=add' .
          '&error=' . join($error, urlencode('<br/>')));
    }
    break;
}
break;
case 'edit':
switch ($_GET['type']) {
case 'tages':
    $error = array();
    $nome = isset($_POST['nome']) ?
        trim($_POST['nome']) : '';
    if (empty($nome)) {
        $error[] = urlencode('Si prega di inserire un nome.');
    }
    $cognome = isset($_POST['cognome']) ?
        trim($_POST['cognome']) : '';
    if (empty($cognome)) {
        $error[] = urlencode('Si prega di inserire un cognome.');
    }
    $indirizzo = isset($_POST['indirizzo']) ?
        trim($_POST['indirizzo']) : '';
    if (empty($indirizzo)) {
        $error[] = urlencode('Si prega di inserire un indirizzo.');
    }
    $civico = isset($_POST['civico']) ?
        trim($_POST['civico']) : '';
    if (empty($civico)) {
        $error[] = urlencode('Si prega di inserire un numero civico.');
    }
	$citta = isset($_POST['citta']) ?
        trim($_POST['citta']) : '';
    if (empty($citta)) {
        $error[] = urlencode('Si prega di inserire una citta valida.');
    }
    $prov = isset($_POST['prov']) ?
        trim($_POST['prov']) : '';
    if (empty($prov)) {
        $error[] = urlencode('Si prega di inserire una provincia.');
    }
    if (empty($error)) {
     //SYNTAX ERROR CORRECTION 
      $stmt = $dbh->prepare("UPDATE tagesroma SET nome=?, cognome=?, indirizzo=?, civico=?, citta=?, prov=?)");
	  $stmt->execute(array($nome, $cognome, $indirizzo, $civico, $citta, $prov));	
    } else {
      header('Location:tages.php?action=edit&id=' . $_POST['id'] .
          '&error=' . join($error, urlencode('<br/>')));
    }
    break;
}
break;
}
?>

<html>
 <head>
  <title>Commit</title>
  <meta charset="UTF-8">
 </head>
 <body>
  <p>Done!</p>
 </body>
</html>

更新/

我确实纠正了UPDATE SET部分，但仍然没有添加数据

I did correct the UPDATE SET part but still no data is added

推荐答案

此处的问题是您从未执行过INSERT操作

The problem here is that you never executed for the INSERT

将此添加到它:

$stmt -> execute();

这就是为什么没有错误返回的原因，因为没有错误；只是一些缺失"；-)

which is why no errors return, because there are none; just something "missing" ;-)

参考:

• http://php.net/pdo.prepared-statements

这篇关于验证和数据添加到数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！