<?php
$serverName = "192.168.1.25,1433\WPH-CRE100SVR\SQLEXPRESS";
$connectionOptions = array(
"Database" => "esp32",
"UID" => "CRE100",
"PWD" => "cre100",
);
$conn = sqlsrv_connect($serverName, $connectionOptions);
if ($conn === false) {
die(print_r(sqlsrv_errors(), true));
}
echo "Connection Success!<br>";
if (isset($_GET['Value1']) || isset($_GET['Value2'])) {
$value1 = isset($_GET['Value1']) ? $_GET['Value1'] : null;
$value2 = isset($_GET['Value2']) ? $_GET['Value2'] : null;
$sql = "INSERT INTO dbo.ESP (Value1, Value2) VALUES (?, ?)";
$params = array($value1, $value2);
$result = sqlsrv_query($conn, $sql, $params);
if ($result === false) {
echo "Error inserting data: " . print_r(sqlsrv_errors(), true);
} else {
echo "Data inserted into Value1: " . $value1 . " and Value2: " . $value2;
}
} else {
echo "Either Value1 or Value2 data must be provided in the request.";
}
sqlsrv_close($conn);
?>
Patulong naman po. Kapag nag iinsert akong data
id Value1 Value2
62 kcjyo NULL
63 mxzph NULL
64 egzfl NULL
65 NULL nycmz
66 NULL xnknw
67 NULL ctnfk
nagiging NULL yung other row na dapat mag karow sila.
$serverName = "192.168.1.25,1433\WPH-CRE100SVR\SQLEXPRESS";
$connectionOptions = array(
"Database" => "esp32",
"UID" => "CRE100",
"PWD" => "cre100",
);
$conn = sqlsrv_connect($serverName, $connectionOptions);
if ($conn === false) {
die(print_r(sqlsrv_errors(), true));
}
echo "Connection Success!<br>";
if (isset($_GET['Value1']) || isset($_GET['Value2'])) {
$value1 = isset($_GET['Value1']) ? $_GET['Value1'] : null;
$value2 = isset($_GET['Value2']) ? $_GET['Value2'] : null;
$sql = "INSERT INTO dbo.ESP (Value1, Value2) VALUES (?, ?)";
$params = array($value1, $value2);
$result = sqlsrv_query($conn, $sql, $params);
if ($result === false) {
echo "Error inserting data: " . print_r(sqlsrv_errors(), true);
} else {
echo "Data inserted into Value1: " . $value1 . " and Value2: " . $value2;
}
} else {
echo "Either Value1 or Value2 data must be provided in the request.";
}
sqlsrv_close($conn);
?>
Patulong naman po. Kapag nag iinsert akong data
id Value1 Value2
62 kcjyo NULL
63 mxzph NULL
64 egzfl NULL
65 NULL nycmz
66 NULL xnknw
67 NULL ctnfk
nagiging NULL yung other row na dapat mag karow sila.