How to change a variable in mysql database on click of a button.

Question

I want to change the variables in the column ->completedstatus in my mysql database to 1 with a click on a button. Those variables are 0 now. i only have an echo now of the Completed variable value.

<?if ($row->Completed == 1)
{
    echo "Afgerond";
}
else {
    echo "Niet afgerond";
}      
?>

this will output the right thing. But how do i change the variable in the mysql database with an click on a button?

If you want to update value in database, you need at least basic knowlege about managing mysql in php. — MSadura
– MSadura, Commented Feb 14, 2014 at 8:31

STP38 · Accepted Answer · 2014-02-14 09:20:21Z

2

Try it like this (Not tested), but it should be like this

 <input type="text" name="halo"/>
        <input type="button" value="submit"/>
        <?php
            if(isset($_POST['halo']))
            {
                $hoi = $_POST['halo'];
                mysqli_query("INSERT INTO 'db_name' . 'table_name' 'row_name')
                    VALUES('{$hoi}')");     
            }
        ?>

answered Feb 14, 2014 at 9:20

STP38

3312 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

S.. · Accepted Answer · 2014-02-14 08:32:40Z

0

You need to write a MySQL query white updates the row and execute it seperately.

If you don't want to do raw database operations I'd recommend using an ORM library to bind your php objects to DB.

answered Feb 14, 2014 at 8:32

S..

5,8083 gold badges40 silver badges44 bronze badges

Comments

Valter · Accepted Answer · 2014-02-14 08:35:18Z

0

See this for connecting to database: http://php.net/manual/en/pdo.exec.php

and this for an MYSQL update syntax: http://dev.mysql.com/doc/refman/5.0/en/update.html

answered Feb 14, 2014 at 8:35

Valter

893 bronze badges

2 Comments

Rene Over a year ago

My connection to the database works. because the echo works. but i dont know how to update the syntax with an html button. is it even possible?

Valter Over a year ago

do you use active record or SQL? Here are some examples of them: ellislab.com/codeigniter/user-guide/database/examples.html

Collectives™ on Stack Overflow

How to change a variable in mysql database on click of a button.

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related