|
Server IP : 103.191.208.227 / Your IP : 18.191.174.4 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../ssl/../www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// Include the database connection script (db.php)
include('db.php');
// Initialize the $data array
$data = array();
$currentDate = date('Y-m-d');
$query = "SELECT * FROM profile WHERE targetdate >= ? ORDER BY targetdate ASC";
$statement = $conn->prepare($query);
if ($statement) {
// Bind the current date as a parameter
$statement->bind_param("s", $currentDate);
if ($statement->execute()) {
$result = $statement->get_result();
while ($row = $result->fetch_assoc()) {
$data[] = $row;
}
// Output the JSON data
echo json_encode($data);
} else {
// Handle query execution error
echo json_encode(array('error' => 'Query execution failed.'));
}
// Close the statement
$statement->close();
} else {
// Handle statement preparation error
echo json_encode(array('error' => 'Statement preparation failed.'));
}
// Close the database connection
$conn->close();
?>
<?php
//select.php
// include('db.php');
// $query = "SELECT * FROM demo1 ORDER BY id ASC";
// $statement = $connect->prepare($query);
// if($statement->execute())
// {
// while($row = $statement->fetch(PDO::FETCH_ASSOC))
// {
// $data[] = $row;
// }
// echo json_encode($data);
// }
?>