CodingForums.com - Insert/Update

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, //:player_id,now(),'N'

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

Update statement will get the update as :pending_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);