php - Limit select options -
the other day when out friends of sudden hit me use inspect element , change name of option in select tag whatever want, stored in database (still unsure on why thinking of this, glad did!)
this select tag:
<form name="submit" method="post" action="select.php" validate> <select class="form-control" name="genre" id="genre" required> <option value="" selected="selected">select genre</option> <option value="autos , vehicles">autos , vehicles</option> <option value="comedy">comedy</option> <option value="education">education</option> <option value="entertainment">entertainment</option> <option value="film & animation">film & animation</option> <option value="gaming">gaming</option> <option value="howto & style">howto & style</option> <option value="music">music</option> <option value="news & politics">news & politics</option> <option value="nonprofits & activism">nonprofits & activism</option> <option value="people & blogs">people & blogs</option> <option value="pets & animals">pets & animals</option> <option value="science & technology">science & technology</option> <option value="sports">sports</option> <option value="travel & events">travel & events</option> </select> </form>
i have stripped php code relevant features there:
require ("conn/connection.php"); $conn = new pdo("mysql:host=localhost;dbname=$database", $username, $password); if(isset($_post['submit'])) { $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception); $stmt = $conn->prepare("insert videos (genre) values (:genre)"); $stmt->bindparam(':genre', $genre); $genre = $_post['genre']; $stmt->execute(); echo "done"; } else{ echo "nope"; }
i want options allowed stored in database , give error if "selected" invalid option. don't have of previous attempts saved woke , deleted them before slept last night, sorry. still learning php, pdo , appreciate have been scratching head hours @ this.
you keep options in own table, ids. use ids in select, , use databases foreign key management check valid entries
alternatively create array of allowed options, , check user submitted data against it:
$allowed = [ "autos , vehicles", "comedy", "education", "entertainment", "film & animation", "gaming", "howto & style", ... ]; if(in_array($genre, $allowed)){ //good go }else{ //error }
Comments
Post a Comment