Data change problem in the database

Asked

Viewed 40 times

1

I am trying to change the data of the database, however, when sending it does not present error message and it does not change the data. What can be happening?

if (isset($_POST['enviar'])) {
    //Slide
    $novo_slide1 = mysqli_escape_string($connect, $_POST['tituloslide']);
    $novo_subslide1 = mysqli_escape_string($connect, $_POST['subslide']);

    $novo_slide2 = mysqli_escape_string($connect, $_POST['tituloslide2']);
    $novo_subslide2 = mysqli_escape_string($connect,$_POST['subslide2']);

    $novo_slide3 = mysqli_escape_string($connect, $_POST['tituloslide3']);
    $novo_subslide3 = mysqli_escape_string($connect,$_POST['subslide3']);

    //Introduçao
    $novo_intro = mysqli_escape_string($connect, $_POST['intro']);
    $novo_introsub = mysqli_escape_string($connect,$_POST['introsub']);

    //Informativos
    $infor1 = mysqli_escape_string($connect, $_POST['infor1']);
    $textinfor1 = mysqli_escape_string($connect,$_POST['textinfor1']);

    $infor2 = mysqli_escape_string($connect, $_POST['infor2']);
    $textinfor2 = mysqli_escape_string($connect,$_POST['textinfor2']);

    $infor3 = mysqli_escape_string($connect, $_POST['infor3']);
    $textinfor3 = mysqli_escape_string($connect,$_POST['textinfor3']);

    //Serviços

    $serv1 = mysqli_escape_string($connect, $_POST['serv1']);
    $textserv = mysqli_escape_string($connect,$_POST['textserv']);

    //Lado Direito Horizontal
    $lado1 = mysqli_escape_string($connect, $_POST['lado1']);
    $ladotext1 = mysqli_escape_string($connect,$_POST['ladotext1']);


    $lado2 = mysqli_escape_string($connect, $_POST['lado2']);
    $ladotext2 = mysqli_escape_string($connect,$_POST['ladotext2']);

    $lado3 = mysqli_escape_string($connect, $_POST['lado3']);
    $ladotext3 = mysqli_escape_string($connect,$_POST['ladotext3']);

     //Frase
    $frase = mysqli_escape_string($connect, $_POST['frase']);
    $autor = mysqli_escape_string($connect,$_POST['autor']);

     //Pequeno Texto
    $smalltitle = mysqli_escape_string($connect, $_POST['smalltitle']);
    $smalltext = mysqli_escape_string($connect,$_POST['smalltext']);

     //Rede Social
    $facebook = mysqli_escape_string($connect, $_POST['facebook']);
    $instagram = mysqli_escape_string($connect,$_POST['instagram']);


    $result_update = "UPDATE editor SET slide1 = '$novo_slide1', slide2 = '$novo_slide2',slide3 = '$novo_slide3', subtext1 = '$novo_subslide1',subtext2 = '$novo_subslide2' ,subtext3 = '$novo_subslide3', titulo1 = '$novo_intro', subtitulo1 ='$novo_introsub', infor2 = '$infor2', textinfor2 = '$textinfor2', infor3 = '$infor3', textinfor3 = '$textinfor3',servicos = '$serv1', textservicos = '$textserv',iconsorriso = '$lado1', textsorriso = '$ladotext1', iconsujeira = '$lado2', textsujeira = '$ladotext2', iconpreco = '$lado3', textpreco = '$ladotext3', frase='$frase', autofrase = '$autor',fraseredesocial = '$smalltitle', textfraseredesocial = '$smalltext', linkfacebook = '$facebook', linkinstagra ='$instagram' WHERE id = '".$linha['id']."'";

     $resultado_usuario = mysqli_query($connect,$result_update);

     echo "Adicionado";
 }
php mysql

  • Are you making a mistake? Nothing back? Explain the problem better.

  • I put the information to be changed in the database, but it is not changing, nor giving error, does not change anything,

1 answer

0

It may be that it is not entering the if, because the

$_POST['send']

is not set. Put on an Else, make sure it’s coming in and doing nothing.

Another thing, force the presentation of errors with:

ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(E_ALL);

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.