Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Additional insert for yesterday's page that we worked on

Additional insert for yesterday's page that we worked on

Thread began 1/22/2022 4:21 am by birdscreen398247 | Last modified 1/22/2022 9:50 am by Ray Borduin | 79 views | 1 replies |

1/22/2022 4:21 am | #1 birdscreen398247

Additional insert for yesterday's page that we worked on

I have one more insert to add to the page we worked on yesterday.

After Line 55, I want to store the new record_number (from line 49) into a variable.

Then insert a new record into the PORC_decisions table with PORC_decisions.record_number equal to the new variable and PORC_decisions.ebird_expedited equal to 1.

1/22/2022 9:50 am | #2 Ray BorduinWebAssist

Add this after line 55:

php:

<?php

if ($data[0]) {

  $InsertQuery = new WA_MySQLi_Query($siteguide2018);

  $InsertQuery->Action = "insert";

  $InsertQuery->Table = "PORC_decisions";

  $InsertQuery->bindColumn("record_number", "s", "". $data[2].$insertID  ."", "WA_DEFAULT");

  $InsertQuery->bindColumn("ebird_expedited", "i", "1", "WA_DEFAULT");

  $InsertQuery->saveInSession("");

  $InsertQuery->execute();

  $InsertGoTo = "";

  if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";

  $InsertQuery->redirect($InsertGoTo);

}

?>

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.