2. PHPRunner General questions
  3. [SOLVED] Addng Database info into multiple databases
This topic is locked
[SOLVED]

Addng Database info into multiple databases

 		2/7/2022 1:48:42 AM
PHPRunner General questions
D
 Dynamiccomp author

Hi there,

I am trying to add values into multiple databases at once, and I am having issues with trying to enter the info into the second database. I am not sure what is going wrong, since there are o errors, and was hoping that someone could help me out, please.

Add events page:

this code works;

$data = array();
$keyvalues = array();
$data["Number"] = $values['Number'];
$data["Rider Name"] = $values['Rider Name'];
$data["Horse Name"] = $values['Horse Name'];
$data["Division Name"] = $values['Division Name'];
$data["Level"] = $values['Level'];
$data["Division Type"] = $values['Division Type'];
$data["Show Type"] = $values['Show Type'];
$data["Dressage Test"] = $values['Dressage Test'];
$keyvalues["Number"] = $values['Number'];

if ($values['Number'] = $values['Number']){

DB::Insert("Scoring", $data, $keyvalues );
}

return true;

then i wanted to have some of the fields be added into a different database, so I added the following before 'return true;

$data = array();
$keyvalues = array();
$data["Number"] = $values['Number'];
$data["Rider Name"] = $values['Rider Name'];
$data["Horse Name"] = $values['Horse Name'];
$data["Division Name"] = $values['Division Name'];
$keyvalues["Division Name"] = $values['Division Name'];

if ($values['Division Name'] = $values['Division Name']){

DB::Insert("Ride Times", $data, $keyvalues);
}

I tried adding an entry, and the info was entered into the "Scoring" DB, but not the "Ride Time" DB. So i tried adding a "1" to all of the $data and $keyvalues to see if that worked, but that didnt.

Can someone please give me some pointers?
Sergey Kornilov admin 2/7/2022

Your IF statement is incorrect. You are using an assignment operator = instead of comparison ==

Also, these are tables, not databases.

D
 		Dynamiccomp author 2/20/2022

Thank you, I have corrected that IF statement to use == instead of =, however I am still having issues with adding to this 2nd table named "Ride Times" so I have tried multple scenarios.

I have a table named "Registration" where I am entering this data, and then in the Registration > add > before recorded added event page I have been using this code to add to the Scoring table, which works without issues, but now I would like a few of the fields to also be added to the "Ride Times" table, so I have tried the following scenarios:

$soringdata = array();
$scoringkeyvalues = array();
$scoringdata["Number"] = $values['Number'];
$scoringdata["Rider Name"] = $values['Rider Name'];
$scoringdata["Horse Name"] = $values['Horse Name'];
$scoringdata["Division Name"] = $values['Division Name'];
$scoringdata["Level"] = $values['Level'];
$scoringdata["Division Type"] = $values['Division Type'];
$scoringdata["Show Type"] = $values['Show Type'];
$scoringdata["Dressage Test"] = $values['Dressage Test'];
$scoringkeyvalues["Number"] = $values['Number'];

if ($values['Number'] == $values['Number']){

DB::Insert("Ride Times", $scoringdata, $scoringkeyvalues );
DB::Insert("Scoring", $scoringdata, $scoringkeyvalues );
}

return true;$soringdata = array();
$scoringkeyvalues = array();
$scoringdata["Number"] = $values['Number'];
$scoringdata["Rider Name"] = $values['Rider Name'];
$scoringdata["Horse Name"] = $values['Horse Name'];
$scoringdata["Division Name"] = $values['Division Name'];
$scoringdata["Level"] = $values['Level'];
$scoringdata["Division Type"] = $values['Division Type'];
$scoringdata["Show Type"] = $values['Show Type'];
$scoringdata["Dressage Test"] = $values['Dressage Test'];
$scoringkeyvalues["Number"] = $values['Number'];

if ($values['Number'] == $values['Number']){

DB::Insert("Scoring", $scoringdata, $scoringkeyvalues );
}

$timedata = array();
$timekeyvalues = array();
$timedata["Number"] = $values['Number'];
$timedata["Rider Name"] = $values['Rider Name'];
$timedata["Horse Name"] = $values['Horse Name'];
$timedata["Division Name"] = $values['Division Name'];
$timekeyvalues["Number"] = $values['Number'];

if ($values['Number'] == $values['Number']){

DB::Insert("Ride Times", $timedata, $timekeyvalues );
}

return true;

And I even tried just using the 2nd array, by itself, like below, to see if it would atleast just enter the code into that table by itself, but, it didn't, and I am not sure why.

$soringdata = array();
$scoringkeyvalues = array();
$scoringdata["Number"] = $values['Number'];
$scoringdata["Rider Name"] = $values['Rider Name'];
$scoringdata["Horse Name"] = $values['Horse Name'];
$scoringdata["Division Name"] = $values['Division Name'];
$scoringkeyvalues["Number"] = $values['Number'];

if ($values['Number'] == $values['Number']){

DB::Insert("Ride Times", $scoringdata, $scoringkeyvalues );
}

return true;
A
 		Andrew S 2/21/2022

You may have a typing error $soringdata = array();

Should this not be $scoringdata = array();