Multiple MySQL updates from a string using PHP

Question

I need some help putting together this PHP SQL update. I am pretty sure I need a foreach loop to post this query, but I am not sure how to write it.

Basically it needs to match ticketID from the string to ticketID in the database and update that row with the following developer.

The query string will look something like:

ticketID=1483&developer=Reme&ticketID=1484&developer=Reme&ticketID=1485&developer=Reme&isActive=1

Although there could be as many as 30/40 pairs with isActive being a variable to end it all. DBConn and all that is already set up, this is the last thing I need to solve before moving onto sessions.

This is being posted over using an Ajax call. Everything I need is arriving at its destination; it's just getting each pair and update in the database accordingly that I am stumped on.

Peter Mortensen · Accepted Answer · 2016-12-11 08:39:02Z

1

You can't use the same parameter (ticketID) twice in a query string, because the second will overwrite the first.

In this case you have to use an array:

ticketID[]=1483&developer[]=Reme&ticketID[]=1484&developer[]=Reme&ticketID[]=1485&developer[]=Reme&isActive=1

And then you could use a foreach to loop.

edited Dec 11, 2016 at 8:39

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jul 10, 2014 at 10:50

webmonkey

1,0931 gold badge17 silver badges35 bronze badges

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

6 Comments

nl-x Over a year ago

Yes he can. He just won't be able to access the variables through $_REQUEST/$_GET/$_POST. He can access them however from the raw input.

webmonkey Over a year ago

@nl-x yes, you're right, but as he posted he will do this with an ajax post request, I assumed that he will access thie string with $_REQUEST (or similar).

RemeJuan Over a year ago

I am actually using $_POST, never used $_REQUEST.

ilpaijin Over a year ago

@nl-x sorry, but you mean that he can't get all the values in an array by using $_GET?

RemeJuan Over a year ago

@ilpaijin not when posting it no. I can access my test sample using foreach ($_POST["ticketID"] as $ticket_id) { echo $ticket_id.','; }

|

Peter Mortensen · Accepted Answer · 2016-12-11 08:35:55Z

0

It depends on how you want to update them, but I would suggest using JSON or some other more defined structure.

If you do

ticketID[]=1483&developer[]=Reme&ticketID[]=1484&developer[]=Reme&ticketID[]=1485&developer[]=Reme&isActive=1

you will have one array for ticketID, one array for developer, etc. Which means that you should be really careful with the other on which you are placing the parameters.

Instead of that I would prefer structure like this:

["isActive":1,
 "tickets":{"ticketID" :1483
            "developer": "Reme"},
           {"ticketID": 1484
            "developer": "Reme"},
           {"ticketID": 1485,
           "developer": "Reme"}]

On that you are confident that you are updating the right properties on the right object.

edited Dec 11, 2016 at 8:35

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jul 10, 2014 at 11:04

Kalina Todorova

691 silver badge3 bronze badges

Collectives™ on Stack Overflow

Multiple MySQL updates from a string using PHP

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related