...

View Full Version : Insert/Update



Gamerholic
11-15-2012, 01:50 AM
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.


$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
11-15-2012, 03:54 PM
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum