php, mysql, update variable with particular id [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 10 years ago.

Improve this question

So i have this database with registering. And in the backend i want to be able to change their status of payment.

I want a basic textarea where i can paste the ID of the user, and then an okay button to send the method, and then i click okay, i want it to update the users status with the particular id.

Can anyone help how to make connection to the database, where i only update their status if they have that id?

I now the html, i just need the php part.

I don't have any idea on how to do it, so i haven't tried anything yet.

Please try to use the search; stackoverflow.com/questions/23945476/php-sql-update-array — BBQ.
– BBQ., Commented Aug 13, 2015 at 13:30
If you're wondering why you got dowvoted , then consider reading this. We expect your attempt for the problem you're trying to search, provided input, expected output and errors if any. Consider adding this stuff and we will glad to help. — Dipen Shah
– Dipen Shah, Commented Aug 13, 2015 at 13:31
possible duplicate of Best way to write PHP SQL Update Statement — BBQ.
– BBQ., Commented Aug 13, 2015 at 13:32

gbestard · Accepted Answer · 2015-08-13 13:39:48Z

0

For database connection, use this:

database.php

<?php
try{
    $db = new PDO('mysql:host=localhost;dbname=your db name', "username" , "password");
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


}catch(PDOException $e){
    print "error in connection" . $e->getMessage();
}

update-Id.php

for udating/changing the value of user Id stored in database

<?php
    require_once 'database.php';
    $userId = $_POST['userId'];

$stmt = $db->prepare("UPDATE tablename SET userId  = ?");
        $stmt->execute(array($userId));

edited Aug 13, 2015 at 13:39

gbestard

1,17713 silver badges30 bronze badges

answered Aug 13, 2015 at 13:36

Itz Raghu

4572 gold badges6 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

php, mysql, update variable with particular id [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related