HTML:
<form method="post" action="/pdf/prod-web-insert-update.php" target="_blank">
<input id="Commission" name="Commission" type="text" /> <br/>
<input name="Letter" id="Letter" type="text" /><br />
<input name="Status" id="Status" type="text" /><br />
<input name="DeliveryDate" id="DeliveryDate" type="text" /></div>
<input id="select" name="select" value="SELECT" type="button" /> <br/>
<input id="update" name="update" value="UPDATE" type="button" /> <br/>
<input id="insert" name="insert" value="INSERT" type="button" /> <br/>
</form>
JS:
$("#insert").click(function() {
var Commission = $("#Commission").val();
var Letter = $("#Letter").val();
var Status = $("#Status").val();
var DeliveryDate = $("#DeliveryDate").val();
var dataString = {Commission: Commission, Letter: Letter, Status: Status, DeliveryDate: DeliveryDate};
var jsonString = JSON.stringify(dataString);
$.ajax({
type: "POST",
url: "/pdf/prod-web-insert-update.php",
data: {insertArray : jsonString},
cache: false,
success: function() {}
});
});//end of .click
$("#select").click(function() {
var Commission = $("#Commission").val();
var Select = 'id1=' + id;
$.ajax({
type: "POST",
url: "/pdf/prod-web-insert-update.php",
dataType: "json",
data: Select,
cache: false,
success: function() {}
});
});//end of .click
PHP:
//získání hodnoty pro SELECT
$select = $_POST["id1"];
//získání pole pro INSERT
$insert = json_decode(stripslashes($_POST['insertArray']));
if(isset($_POST['id1'])){
//do SQL
}
if(isset($_POST['insertArray])){
//do SQL
}
navedl by mě někdo jak správně vyvolat v PHP/PDO jednotlivé SQL (SELECT,INSERT, UPDATE) ?
díky