How to update mysql data by clicking a button?

Question

I am currently doing a school course project.It requires us to code out a website.We designed a website which provides online food ordering service to our school community.

I want to know how to change a data in a specific filed in mysql server by just clicking one button.

I designed a user profile page which shows the information of the users. They can see their previous orders by clicking "show orders" button. Then a table which contains the ordering information will be displayed.

I added a button behind each row called "Delivered". I wish that the Ordering_status can be changed from "ordering" to "delivered" when user click the "Delivered" button. I attached my layout page below.

https://www.dropbox.com/s/lyfjn9hed1zfjyd/user_profile.png

Could anyone kindly help me with this?

I cannot attach my code here. It will display in a mess manner. Please use the link below https://www.dropbox.com/s/u1h73lx07hrsr78/profile.php

Thank you!

<script>

function myfunction(int id)     
    {   
        $link=mysqli_connect("localhost","f34s25","f34s25","f34s25");
        $a="UPDATE orders SET Ordering_status="delivered" where order_id=id;
        $b=mysqli_query($a);
    }
</script>

To post the code, Please Use stackoverflow code format styling, in ASK question you can find ? symbol, you can click that to know the format and styling — Krish R
– Krish R, Commented Nov 8, 2013 at 4:30
I cannot post my codes correctly here. Anyone can help with this? — user2967538
– user2967538, Commented Nov 8, 2013 at 6:40

R R · Accepted Answer · 2013-11-08 04:31:36Z

2

one easy solution is that you assign a name to the button delivered.like this

<input type="submit" value="delivered" name="delivered">

and when the user will click this submit button take the value in the php part.and check whether it is clicked or not,like this

if(isset($_POST['delivered']))
{
$a="update yourtablename set Ordering_status="deleivered" where name="$name";
$b=mysqli_query($a);
}

answered Nov 8, 2013 at 4:31

R R

2,9562 gold badges27 silver badges43 bronze badges

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

7 Comments

user2967538 Over a year ago

I believe your solution works.However the problem for me is that there might be a number of orders appearing. Thus, I need to echo out one button at the end of each order(row) to change the delivery status of each specific order(row). I think I may need to use the primary id in table to decide which to row to change. But I do not know how to implement it.

R R Over a year ago

u mean u want to change the button.please be more specific about your doubt so that i can help you.

user2967538 Over a year ago

The fact is that when there is a new order showing, there should be a "delivered" button behind.(you can see the picture through my attached link). Each "delivered" button is to change one delivery status of one row(order). I do not know how to do this. Because there are multiple status which need be changed.

R R Over a year ago

the above query which i wrote will update only one row the others will remain unaffected.use your unique id in where condition.please let me know if i am not clear at what i am saying.

R R Over a year ago

i think email will be unique in your case so in update where condition take where email=$email than it will update the row having that particular email only.

|

Collectives™ on Stack Overflow

How to update mysql data by clicking a button?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related