我试图创建一个页面,用户可以搜索MySQL general_log之间的两个日期和时间的所有MySQL查询,但我不知道如何去格式化用户输入的数据,所以它可以由表读取。
这是我(非常)粗略的尝试,我有点迷路了;MYSQL查询;
$result = mysqli_query($con,"SELECT * FROM general_log WHERE event_time between UNIX_TIMESTAMP('$fromDate') AND UNIX_TIMESTAMP('$toDate'");
形式;
<h1>Query Error Log</h1>
<h2>Insert Date/Time as format YYYY-MM-DD HH:MM:SS</h2>
<h2>From Date:Time</h2><input type="number" id="fromDate" name="fromDate" value="" /> <p></p>
<h2>To Date:Time</h2><input type="number" id="toDate" name="toDate" value="" /> <p></p>
<p></p><input type="submit">
感谢您的帮助
试试这个
$result = mysqli_query($con,"SELECT * FROM general_log WHERE (event_time BETWEEN UNIX_TIMESTAMP('$fromDate') AND UNIX_TIMESTAMP('$toDate'))";