I have a simple issue I am using PDO with MSSQL I had CURDATE() before but that didn't work because MSSQL does not support that. Only MySQL does and I added GETDATE() but that is not working also. How would I be able to get the current date. I want the information to show first name order by id and todays date only.
$stmt = $db->prepare("SELECT * FROM students WHERE name='Firstname' And Getdate() ORDER BY id DESC");
$stmt->execute()
updated sorry this is what I meant
$stmt = $db->prepare("SELECT * FROM students WHERE name='BOB' And Getdate() ORDER BY id DESC");
$stmt->execute()
The whole query page.
<head>
<title></title>
</head>
<body>
<?php
//connects to the database
require_once("../../db_connect.php");
//prepared statement with PDO to query the database
$stmt = $db->prepare("SELECT * FROM requests WHERE name='Bob' AND Date = CAST(GETDATE() AS DATE) ORDER BY id DESC");
$stmt->execute();
?>
<?php //start of the while loop ?>
<?php while( $row = $stmt->fetch(PDO::FETCH_ASSOC) ) { ?>
<table border="1">
<br>
<tr>
<th style="width:25px; height: 25px;">ID</th>
<th style="width:90px; height: 25px;">Name</th>
<th style="width:40px; height: 25px;">Date</th>
</tr>
<tr style="width:25px">
<?php $id = $row['id'];?>
<?php echo "<td> <a href='../../update.php?id=$id'>$id</a></td>"?>
<td style="width:90px; height: 12px;"><?php echo $row['name']; ?></td>
<td style="width:40px; height: 12px;"><?php echo $row['date']; ?></td>
</tr>
</table>
<?php } //end of the while loop?>
</body>
</html>
here is the page were user updates the information
<?php
include('db_connect.php');
$id=$_GET['id'];
$result = $db->prepare("SELECT * FROM students WHERE id= :id");
$result->bindParam(':id', $id);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
<html>
<head>
<title></title>
</head>
<body class='body'>
<form action = "update_process.php" method ="post" class="Form">
<p><input type ="hidden" name = "id" value="<?php print($id); ?>"</p>
<table border='1' align="center">
<tr>
<td>Name:</td>
<td><input type="text" value ="<?php print($row['name']) ?>"name="name"></td>
</tr>
<tr>
<td>Date</td>
<td style="width: 303px">
<input type="text" value ="<?php echo date("Y-m-d",time())?>"name="date" style="width: 148px"></td>
</tr>
</table>
<input type="submit" value= "Update Information">
<br>
</div>
</form>
</body>
</html>
<?php
}
?>
