Change Mysql column information with UPDATE

Question

In summary through PHP below I can send the specific information already recorded in the column in the BD, only that, in addition to just "sending" the data there, I would like a function that changes such information without the page being changed. I have an idea how to do this using the following code:

if ($action == 'okay') {
$conexao = mysql_query("update settingsMDP set name='$name', version='$version', startacp='$startacp' WHERE id='1'") or die ("Eita.. Deu errado!");
}

If they go to see, if the form action is "okay" then, it runs the UPDATE, but... This does not occur I don’t know why.

This is the PHP.

<?php
// definições de host, database, usuário e senha
$server = "";
$usuario = "";
$banco   = "";
$senha = "";
// conecta ao banco de dados
$conexao = mysql_connect($server, $usuario, $senha);
$conexao = mysql_select_db("$banco",$conexao);
if(!$conexao) {
    echo mysql_error();
    exit;
}

$conexao = mysql_query("select * from settingsMDP");

//********************************************mudei aqui*****************************
$exibe = mysql_fetch_assoc($conexao);

 if (empty($_REQUEST['action'])) $action = ''; else $action = $_REQUEST['action'];
 if ($action == 'okay') {
 $conexao = mysql_query("update settingsMDP set name='$name', version='$version', startacp='$startacp' WHERE id='1'") or die(mysql_error());
}
?>

<form method="post" action="<?php $_PHP_SELF ?>">
    <table width="400" border="0" cellspacing="1" cellpadding="2">
        <tr>
            <td width="100">Nome do MDP: </td>
            <td><input name="name" type="text" id="name" value="<?php echo $exibe["name"]; ?>"></td>
        </tr>
        <tr>
            <td width="100">Versão: </td>
            <td><input name="name" type="text" id="name" value="<?php echo $exibe["version"]; ?>"></td>
        </tr>
        <tr>
            <td width="100">Abertura do painel:</td>
            <td><input name="start_acp" type="text" id="startacp" value="<?php echo $exibe["startacp"]; ?>"></td>
        </tr>
        <tr>
            <td width="100"> </td>
            <td> </td>
        </tr>
        <tr>
            <td width="100"> </td>
            <td><input name="update" type="submit" id="update" value="Salvar"></td>
        </tr>
    </table>
</form>

Answer 1

I will tinker with what I think is what you want. I will avail to solve some other problems but not all.

<?php
// definições de host, database, usuário e senha
$server = "";
$usuario = "";
$banco   = "";
$senha = "";
// conecta ao banco de dados
$conexao = mysqli_connect($server, $usuario, $senha);
mysqli_select_db($conexao, $banco);
if(!$conexao) {
    echo mysqli_error();
    exit;
}

if ($_POST["update"] == "Salvar") {
    $name = mysqli_real_escape_string($conexao, $_POST["name"]);
    $version = mysqli_real_escape_string($conexao, $_POST["version"]);
    $startacp = mysqli_real_escape_string($conexao, $_POST["startacp"]);
    $resultado = mysqli_query($conexao, "update settingsMDP set name='$name', version='$version', startacp='$startacp' WHERE id='1'") or die (mysqli_error());
    echo "Gravou";
} else {
    $resultado = mysqli_query($conexao, "select * from settingsMDP");
    $exibe = mysqli_fetch_array($resultado, MYSQLI_ASSOC);
?>

<form method="post">
    <table width="400" border="0" cellspacing="1" cellpadding="2">
        <tr>
            <td width="100">Nome do MDP: </td>
            <td><input name="name" type="text" id="name" value="<?php echo $exibe["name"]; ?>"></td>
        </tr>
        <tr>
            <td width="100">Versão: </td>
            <td><input name="version" type="text" id="version" value="<?php echo $exibe["version"]; ?>"></td>
        </tr>
        <tr>
            <td width="100">Abertura do painel:</td>
            <td><input name="startacp" type="text" id="startacp" value="<?php echo $exibe["startacp"]; ?>"></td>
        </tr>
        <tr>
            <td width="100"> </td>
            <td> </td>
        </tr>
        <tr>
            <td width="100"> </td>
            <td><input name="update" type="submit" id="update" value="Salvar"></td>
        </tr>
    </table>
</form>
<?php
}
?>

I put in the Github for future reference.

I can’t test it but it’s something like this.

Since you are using the same page to grab the data and refresh you need to decide which of the two will do. This can be done if the Submit is present or not.

I made the so-called sanitization of the contents that came to avoid SQL Injection.

I switched to Myslqi which is a more modern function and which is recommended.

I fixed an inattention error in the name of HTML fields.

There was also confusion with the variable $conexao that caused the loss of the reference to the connection. You can’t reuse the variable like this.

I left the flame of form no parameter that will call its own URL.

And I got a few more details. I would still change a lot of things in that code but I better not mess around too much with what you’re able to do or you’ll get lost. A quality code for use in production would have to be much better than this. Although I’ve seen a lot website running around with even worse :P