Home / Questions / 3776
Accepted
Augusto Herbel
Asked: 2020-02-06 18:17:07 +0800 CST 2020-02-06 18:17:07 +0800 CST

PHP code to update data in DB not working

  • 772

I have an application that is to handle favorites (my favorite internet pages) and the code in charge of updating the users does not update me, it only changes the name to a 0 and the rest is left as it is. I put some images and tell me if you need me to upload something else.

This is the table to manage the users, the 3rd , 4th and 5th users show what I told them:

User management table

And this is the code in charge of updating the users:

<?php

session_start();

$db = new SQLite3('favoritos.db');

$usuarioantiguo = $_SESSION['usuario'];

$usuario = $_POST['usuario'];
$contrasena = $_POST['contrasena'];
$nombre = $_POST['nombre'];
$apellido = $_POST['apellido'];
$edad = $_POST['edad'];

$resultado = $db->query("UPDATE usuarios SET usuario='".$usuario."' AND contrasena='".$contrasena."' AND nombre='".$nombre."' AND apellido='".$apellido."' AND edad=".$edad." WHERE usuario='".$usuarioantiguo."'");

$db->close();

//Vuelvo a gestionusuarios.php
echo "
<html>
    <head>
        <meta http-equiv='REFRESH' content='0;url=gestionusuarios.php'>
    </head>
</html>
";

?>
php

1 Answers

  1. Best Answer

    The failure occurs because there is an error in your SQL. The fields that are updated are not separated by ANDbut by a comma ( ,). The syntax of a UPDATEshould be like this:

    UPDATE nombre_de_tabla
SET columna1 = valor1, columna2 = valor2 ..., columnaN = valorN
WHERE [condición];

    When you put a ANDwhat you are doing is assigning usuariothe value of the logical operation to the field:

    '".$usuario."' AND contrasena='".$contrasena."' AND nombre='".$nombre."' AND apellido='".$apellido."' AND edad=".$edad." WHERE usuario='".$usuarioantiguo."'"

    You have to change the code to be something like this:

    $resultado = $db->query("UPDATE usuarios SET usuario='".$usuario."', contrasena='".$contrasena."', nombre='".$nombre."', apellido='".$apellido."', edad=".$edad." WHERE usuario='".$usuarioantiguo."'");

    and then the UPDATEshould work without problems.

    • 2