Selecting dates and showing results in PHP

Question

I have a table called "reservations" containing columns

id
serviceID
dateCreated
name
email
phone
comments

I want to that user can select date from "dateCreated" (dropdown) and then show the results. Right now I have this

$tbl_name = "reservations"; "$select = SELECT * FROM `".$tbl_name."` LIMIT 0 , 30";

What should I do?

Devon Bessemer · Accepted Answer · 2013-12-25 00:14:17Z

You will want to use a WHERE dateCreated = $date where $date equals the user provided date. However, you will want to look at prepared queries to prevent SQL injections from the user input.

Collectives™ on Stack Overflow

Selecting dates and showing results in PHP

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related