Insert Your Advertisement Here
PHP Script Code To Validate Form if Room Number is Not Available in Database
Additional Details
Below I have a php code where it will check to see if the room number entered in a textbox is in the database or not.
< ?php
$room_there = true;
while( $room_there ){
$roomresult = mysql_query( "SELECT Room FROM Room WHERE Room = " . (int) $_POST['roomChosen']);
if( mysql_num_rows( $roomresult ) == 0 ) $room_there = false;
}.
? >
Room:
Now what I want to know is how do I create a vlaidation for this. My validation works in javascript and if it is met then it should display a message such as "Room number is invalid" else display "" which is nothing. How can I validate if room number not in database is met?
Below is an example of my validation if the room number textbox is empty to show how I display my validation messages:
function validation() {
var isDataValid = true;
var roomTextO = document.getElementById("room");
//this retrieves an element from the textbox where user enters in a room number
var errRoomMsgO = document.getElementById("roomAlert");
// this is where the alert message appears for validation
if (roomTextO.value == ""){
errRoomMsgO.innerHTML = "Please Enter in a Room Number";
isDataValid = false;
}else if (!trimmedRoomText.length){
errRoomMsgO.innerHTML = "Please Enter in a Room Number";
isDataValid = false;
}else{
errRoomMsgO.innerHTML = "";
}
}
Asked in PHP - 30 days ago
Tags: PHP Script Code To Validate Form if Room Number is Not Available in Database
Insert Your Advertisement Here
