Mixing
php pdo insert in foreign key table using Max function
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm stuck in my example and I need your help.
I'm new in php and sql.
I have two tables:
Table dataip:
- data (current date)
- ip (ip number)
- dataip_id (auto increment)
Table controler:
- machine (text)
- controller (text)
- controller_id (equal with dataip_id)
I have defined a html form to input the data into these two tables.
I'm using php to sent the data between for mand server (using MAMP and MySql).
I'm trying to add data in controler table. For controller_id I would like to use the biggest value from dataip_id. Unfortunately I can not add add the date for controller_id.
I also removed the relation between tables in order to simplify my test.
if(isset($_REQUEST['machine']) or isset($_REQUEST['controller'])){
$_date = date("Y-m-d");
$IpAddress= $_SERVER['REMOTE_ADDR'];
$sql = "INSERT INTO dataip (date, ip) VALUES (:date, :ip)";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':date'=>$_date,
':ip'=>$IpAddress,
));
$dataip_id = $pdo->query("SELECT MAX(dataip_id) FROM dataip");
#$dataip_id = $pdo->query("SELECT dataip_id FROM dataip WHERE dataip_id=17");
#echo $dataip_id;
$sql = "INSERT INTO controler (machine, controller, controller_id) VALUES (:machine, :controller, :controller_id) ";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':machine'=>$_POST['machine'],
':controller'=> $_POST['controller'],
':controller_id'=>$dataip_id,
));
return ;
}
At the end I would liek to add a relation 1:1 between thse two tables.
I'm not sure what I'm doing wrong.
Please help.
Thank you
php mysql
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
add a comment |
I'm stuck in my example and I need your help.
I'm new in php and sql.
I have two tables:
Table dataip:
- data (current date)
- ip (ip number)
- dataip_id (auto increment)
Table controler:
- machine (text)
- controller (text)
- controller_id (equal with dataip_id)
I have defined a html form to input the data into these two tables.
I'm using php to sent the data between for mand server (using MAMP and MySql).
I'm trying to add data in controler table. For controller_id I would like to use the biggest value from dataip_id. Unfortunately I can not add add the date for controller_id.
I also removed the relation between tables in order to simplify my test.
if(isset($_REQUEST['machine']) or isset($_REQUEST['controller'])){
$_date = date("Y-m-d");
$IpAddress= $_SERVER['REMOTE_ADDR'];
$sql = "INSERT INTO dataip (date, ip) VALUES (:date, :ip)";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':date'=>$_date,
':ip'=>$IpAddress,
));
$dataip_id = $pdo->query("SELECT MAX(dataip_id) FROM dataip");
#$dataip_id = $pdo->query("SELECT dataip_id FROM dataip WHERE dataip_id=17");
#echo $dataip_id;
$sql = "INSERT INTO controler (machine, controller, controller_id) VALUES (:machine, :controller, :controller_id) ";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':machine'=>$_POST['machine'],
':controller'=> $_POST['controller'],
':controller_id'=>$dataip_id,
));
return ;
}
At the end I would liek to add a relation 1:1 between thse two tables.
I'm not sure what I'm doing wrong.
Please help.
Thank you
php mysql
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
add a comment |
I'm stuck in my example and I need your help.
I'm new in php and sql.
I have two tables:
Table dataip:
- data (current date)
- ip (ip number)
- dataip_id (auto increment)
Table controler:
- machine (text)
- controller (text)
- controller_id (equal with dataip_id)
I have defined a html form to input the data into these two tables.
I'm using php to sent the data between for mand server (using MAMP and MySql).
I'm trying to add data in controler table. For controller_id I would like to use the biggest value from dataip_id. Unfortunately I can not add add the date for controller_id.
I also removed the relation between tables in order to simplify my test.
if(isset($_REQUEST['machine']) or isset($_REQUEST['controller'])){
$_date = date("Y-m-d");
$IpAddress= $_SERVER['REMOTE_ADDR'];
$sql = "INSERT INTO dataip (date, ip) VALUES (:date, :ip)";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':date'=>$_date,
':ip'=>$IpAddress,
));
$dataip_id = $pdo->query("SELECT MAX(dataip_id) FROM dataip");
#$dataip_id = $pdo->query("SELECT dataip_id FROM dataip WHERE dataip_id=17");
#echo $dataip_id;
$sql = "INSERT INTO controler (machine, controller, controller_id) VALUES (:machine, :controller, :controller_id) ";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':machine'=>$_POST['machine'],
':controller'=> $_POST['controller'],
':controller_id'=>$dataip_id,
));
return ;
}
At the end I would liek to add a relation 1:1 between thse two tables.
I'm not sure what I'm doing wrong.
Please help.
Thank you
php mysql
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
I'm stuck in my example and I need your help.
I'm new in php and sql.
I have two tables:
Table dataip:
- data (current date)
- ip (ip number)
- dataip_id (auto increment)
Table controler:
- machine (text)
- controller (text)
- controller_id (equal with dataip_id)
I have defined a html form to input the data into these two tables.
I'm using php to sent the data between for mand server (using MAMP and MySql).
I'm trying to add data in controler table. For controller_id I would like to use the biggest value from dataip_id. Unfortunately I can not add add the date for controller_id.
I also removed the relation between tables in order to simplify my test.
if(isset($_REQUEST['machine']) or isset($_REQUEST['controller'])){
$_date = date("Y-m-d");
$IpAddress= $_SERVER['REMOTE_ADDR'];
$sql = "INSERT INTO dataip (date, ip) VALUES (:date, :ip)";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':date'=>$_date,
':ip'=>$IpAddress,
));
$dataip_id = $pdo->query("SELECT MAX(dataip_id) FROM dataip");
#$dataip_id = $pdo->query("SELECT dataip_id FROM dataip WHERE dataip_id=17");
#echo $dataip_id;
$sql = "INSERT INTO controler (machine, controller, controller_id) VALUES (:machine, :controller, :controller_id) ";
$stmt = $pdo->prepare($sql);
$stmt-> execute(array(
':machine'=>$_POST['machine'],
':controller'=> $_POST['controller'],
':controller_id'=>$dataip_id,
));
return ;
}
At the end I would liek to add a relation 1:1 between thse two tables.
I'm not sure what I'm doing wrong.
Please help.
Thank you
php mysql
php mysql
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
asked Jan 3 at 17:00
Alexe Adrian MariusAlexe Adrian Marius
11
11
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
});
}
});
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%2f54026649%2fphp-pdo-insert-in-foreign-key-table-using-max-function%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
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.
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%2f54026649%2fphp-pdo-insert-in-foreign-key-table-using-max-function%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
