Home / Questions / 169769
Accepted
ProgramadorJunior
Asked: 2020-06-01 19:58:20 +0800 CST 2020-06-01 19:58:20 +0800 CST

Update statement mysql php row in database

  • 772

Could you please help me what is the error in the following php code to update a record where the mail is taken from the record in the database... when executing it, I get the automatic error "noUpdate". I appreciate your help so that the sentence is executed correctly and take "updates". here is the code of my script:

<?php
$hostname_localhost="mysql.webcindario.com";
$database_localhost="android";
$username_localhost="android";
$password_localhost="0000";

$conexion=mysqli_connect($hostname_localhost,$username_localhost,$password_localhost,$database_localhost);

    $nombre = $_POST["nombre"];
    $correo = $_POST["correo"];
    $telefono = $_POST["telefono"];
    $direccion = $_POST["direccion"];
    $clave = $_POST["clave"];
    $ciudad = $_POST["ciudad"];


    $sql="UPDATE registro SET nombre_apellido= ? , correo= ?, telefono=?, direccion=?, clave=? , ciudad=? WHERE correo=?";
    $stm=$conexion->prepare($sql);
    $stm->bind_param('ssssi',$nombre,$correo,$telefono,$direccion,$clave,$ciudad);

    if($stm->execute()){
        echo "actualiza";
    }else{
        echo "noActualiza";
    }
    mysqli_close($conexion);
?>

enter image description here

php

1 Answers

  1. Best Answer

    The problem is in your SQL query and in the use ofbind_param

    Let's first look at the query:

    $sql="UPDATE registro SET nombre_apellido= ? , correo= ?, telefono=?, direccion=?, clave=? , ciudad=? WHERE correo=?";

    We have 7 markers (?) :

    1    nombre_apellido= ? , 
2    correo= ?, 
3    telefono=?, 
4    direccion=?, 
5    clave=? , 
6    ciudad=? WHERE 
7    correo=?

    So the query to be executed correctly will wait for 7 parameters to be executed correctly that we will assign through bind_param.

    So let's review thebind_param

    $stm->bind_param('ssssi',$nombre,$correo,$telefono,$direccion,$clave,$ciudad);

    bind_paramit receives a first parameter that will be a String indicating the type of data that will be assigned to the marker from left to right and then receives as indicated in first and in the prepared query.

    The first thing we see is that the number of types is incorrect. You are $stm->bind_param('ssssi', ...)only passing 5 types in the String when in the query you have 7 parameters declared with ?.

    Regarding the data (variables) that you pass, you are bind_paramonly passing 6 of the 7 that would be expected.

    In summary it should be like this:

    $sql="UPDATE registro SET nombre_apellido= ? , correo= ?, telefono=?, direccion=?, clave=? , ciudad=? WHERE correo=?";
$stm=$conexion->prepare($sql);
$stm->bind_param('sssssss', $nombre, $correo, $telefono, $direccion, $clave, $ciudad, $correo);

    We use 7 sto indicate the types of the 7 parameters since according to the image you put they are all of type varcharand then we pass the 7 variables, in this case 2 times the variable $correo, following the order of the markers.

    • 0