Mixing
How do i use PDO to accept array with parameters?
0
So I have a bit of working code, but I'm trying to rewrite that. I was told PDO was a nice way to get parameters out of an array.
try{
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$inventorylocationID = $INVENTORY_LOCATIONS->ID;
$inventorylocationsItemCode = $INVENTORY_LOCATIONS->ItemCode;
$inventoryStorageLocationsCode = $INVENTORY_LOCATIONS->StorageLocationCode;
$inventorylocationsItemDescription = $INVENTORY_LOCATIONS->ItemDescription;
$inventorylocationsCurrenctStock = $INVENTORY_LOCATIONS->Stock;
$INVENTORY_LOCATIONS_SQL = "INSERT IGNORE INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES ('$inventorylocationID','$inventorylocationsItemCode','$inventoryStorageLocationsCode','$inventorylocationsItemDescription','$inventorylocationsCurrenctStock')";
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_LOCATIONS_SQL);
$INVENTORY_STMT->execute();
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
Rewriten code:
try{
$INVENTORY_LOCATIONS_TRUNCATE = $conn->query("TRUNCATE `data_exact_inventory_locations`");
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
$INVENTORY_SQL = "INSERT INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES (:ID, :Code, :StorageLocationCode, :ItemDescription, :Stock)";
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_SQL);
$INVENTORY_STMT->execute(array($INVENTORY_LOCATIONS));
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
I don't know what's wrong in the rewritten code, but i keep getting the error
Object of class PicqerFinancialsExactItemWarehouseStorageLocation could not be converted to string on line 99
php pdo
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
add a comment |
0
So I have a bit of working code, but I'm trying to rewrite that. I was told PDO was a nice way to get parameters out of an array.
try{
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$inventorylocationID = $INVENTORY_LOCATIONS->ID;
$inventorylocationsItemCode = $INVENTORY_LOCATIONS->ItemCode;
$inventoryStorageLocationsCode = $INVENTORY_LOCATIONS->StorageLocationCode;
$inventorylocationsItemDescription = $INVENTORY_LOCATIONS->ItemDescription;
$inventorylocationsCurrenctStock = $INVENTORY_LOCATIONS->Stock;
$INVENTORY_LOCATIONS_SQL = "INSERT IGNORE INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES ('$inventorylocationID','$inventorylocationsItemCode','$inventoryStorageLocationsCode','$inventorylocationsItemDescription','$inventorylocationsCurrenctStock')";
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_LOCATIONS_SQL);
$INVENTORY_STMT->execute();
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
Rewriten code:
try{
$INVENTORY_LOCATIONS_TRUNCATE = $conn->query("TRUNCATE `data_exact_inventory_locations`");
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
$INVENTORY_SQL = "INSERT INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES (:ID, :Code, :StorageLocationCode, :ItemDescription, :Stock)";
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_SQL);
$INVENTORY_STMT->execute(array($INVENTORY_LOCATIONS));
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
I don't know what's wrong in the rewritten code, but i keep getting the error
Object of class PicqerFinancialsExactItemWarehouseStorageLocation could not be converted to string on line 99
php pdo
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
add a comment |
0
0
0
So I have a bit of working code, but I'm trying to rewrite that. I was told PDO was a nice way to get parameters out of an array.
try{
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$inventorylocationID = $INVENTORY_LOCATIONS->ID;
$inventorylocationsItemCode = $INVENTORY_LOCATIONS->ItemCode;
$inventoryStorageLocationsCode = $INVENTORY_LOCATIONS->StorageLocationCode;
$inventorylocationsItemDescription = $INVENTORY_LOCATIONS->ItemDescription;
$inventorylocationsCurrenctStock = $INVENTORY_LOCATIONS->Stock;
$INVENTORY_LOCATIONS_SQL = "INSERT IGNORE INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES ('$inventorylocationID','$inventorylocationsItemCode','$inventoryStorageLocationsCode','$inventorylocationsItemDescription','$inventorylocationsCurrenctStock')";
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_LOCATIONS_SQL);
$INVENTORY_STMT->execute();
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
Rewriten code:
try{
$INVENTORY_LOCATIONS_TRUNCATE = $conn->query("TRUNCATE `data_exact_inventory_locations`");
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
$INVENTORY_SQL = "INSERT INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES (:ID, :Code, :StorageLocationCode, :ItemDescription, :Stock)";
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_SQL);
$INVENTORY_STMT->execute(array($INVENTORY_LOCATIONS));
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
I don't know what's wrong in the rewritten code, but i keep getting the error
Object of class PicqerFinancialsExactItemWarehouseStorageLocation could not be converted to string on line 99
php pdo
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
So I have a bit of working code, but I'm trying to rewrite that. I was told PDO was a nice way to get parameters out of an array.
try{
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$inventorylocationID = $INVENTORY_LOCATIONS->ID;
$inventorylocationsItemCode = $INVENTORY_LOCATIONS->ItemCode;
$inventoryStorageLocationsCode = $INVENTORY_LOCATIONS->StorageLocationCode;
$inventorylocationsItemDescription = $INVENTORY_LOCATIONS->ItemDescription;
$inventorylocationsCurrenctStock = $INVENTORY_LOCATIONS->Stock;
$INVENTORY_LOCATIONS_SQL = "INSERT IGNORE INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES ('$inventorylocationID','$inventorylocationsItemCode','$inventoryStorageLocationsCode','$inventorylocationsItemDescription','$inventorylocationsCurrenctStock')";
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_LOCATIONS_SQL);
$INVENTORY_STMT->execute();
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
Rewriten code:
try{
$INVENTORY_LOCATIONS_TRUNCATE = $conn->query("TRUNCATE `data_exact_inventory_locations`");
$INVENTORY_LOCATIONS = new PicqerFinancialsExactItemWarehouseStorageLocation($connection);
$INVENTORY_LOCATIONS_GET = $INVENTORY_LOCATIONS->filter('', '','ID, ItemCode, StorageLocationCode, ItemDescription, Stock');
$INVENTORY_SQL = "INSERT INTO data_exact_inventory_locations (ID, Code, Opslaglocatie, Omschrijving, Op_voorraad)
VALUES (:ID, :Code, :StorageLocationCode, :ItemDescription, :Stock)";
foreach($INVENTORY_LOCATIONS_GET as $INVENTORY_LOCATIONS){
$INVENTORY_STMT = $pdoconn->prepare($INVENTORY_SQL);
$INVENTORY_STMT->execute(array($INVENTORY_LOCATIONS));
}
} catch (Exception $e) {
echo 'Exception ->';
var_dump($e->getMessage());
}
I don't know what's wrong in the rewritten code, but i keep getting the error
Object of class PicqerFinancialsExactItemWarehouseStorageLocation could not be converted to string on line 99
php pdo
php pdo
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
asked Nov 21 '18 at 10:56
FlubberBeerFlubberBeer
137
137
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410590%2fhow-do-i-use-pdo-to-accept-array-with-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410590%2fhow-do-i-use-pdo-to-accept-array-with-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
