Insert/Update

[Gamerholic]

Can someone please help me interpret this format as an insert and update statement. I'm use to writing php the old way.

//insert gameid,player_id,starttime,submitted values :gameid, //layer_id,now(),'N'

//insert statement will send the insert id back as json

Update statement will get the update as ending_score_id and update that table id.

PHP Code:

        $db = new PDO('mysql:host=localhost;dbname=xxxx', 'xxxx', 'xxxxx');
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

//insert gameid,player_id,starttime,submitted values :gameid, //:player_id,now(),'N'

//insert statement will send the insert id back as json

        $st = $db->prepare("SELECT * FROM `ttourmember` WHERE `player_token` = :player_token AND `isactive`='Y'"); // need to filter for next auction
        $st->bindParam(':player_token', $_GET['player_token']); // filter

        $st->execute();
        $r = $st->fetch(PDO::FETCH_ASSOC);
        
               if(empty($_GET['token']) || $_GET['token'] == '0000' || $st->rowCount() == 0 ): // Return Error if Token Doesn't exist or no db result
            $return = array('DBA_id'=>'0000');
            echo json_encode($return);
        else:
           
            $return = array(
                'DBA_pending_score_id'=>$r['insert_id'],
                );
            echo json_encode($return); 


[Fumigator]

Inserts and Updates are more simple than Selects, because you don't have to fetch anything. Just call the prepare method:

http://us3.php.net/manual/en/pdo.prepare.php

Be sure to bind the parameters (values) that you will be inserting or updating:

http://us3.php.net/manual/en/pdostatement.bindparam.php

And then call the execute method:

http://us3.php.net/manual/en/pdostatement.execute.php

And finally you can grab the inserted ID using the lastinsertid method:

http://us3.php.net/manual/en/pdo.lastinsertid.php