javascript and php not quite working

Question

You can look at the application here: application

I know the code doesn't work in jsfiddle but I have included my code in the jsfiddle so that you can see the whole code and the way it is laid out. jsfiddle

Now if textbox is empty, it displays "false" in alert and displays a message which is fine.

The problem though is this:

If I type the correct or incorrect room number value in the textbox, it always states it is "false" and does not come with a javascript message.

What should happen is if textbox value matches database, then it should alert "true" and display a javascript message "room is Valid", if textbox value doesn't match database then it should alert "False" and display a javascript message "room is Invalid" How can I achieve this?

You can test the application, enter in these figures in the textbox if you wish for testing:

Valid room number CW5/10 , Invalid room number CN2/10.

Below is where error occurs:

 var js_var = [];
<?php while($data = mysql_fetch_assoc($roomquery)){ ?>
js_var.push(<?php $data['roomChosen']; ?>);
<?php }?>

Jsfiddle application url updated above

This question is difficult to understand, and thus difficult to answer. The clearer your question, the more likely it is that you'll receive good answers. — davidchambers
– davidchambers, Commented Jan 25, 2012 at 7:26
js_var.push(<?php echo $data['roomChosen']; ?>); I think you're lacking the echo. — jerjer
– jerjer, Commented Jan 25, 2012 at 8:04
Still displays error, I am also having error on validation not defined everytime I click on "Prepare Questions" button. Please help, I have really been struggling on this for ages, I am really desperate for help — user1163005
– user1163005, Commented Jan 25, 2012 at 8:13

jerjer · Accepted Answer · 2012-01-25 08:07:07Z

2

I think you are lacking echo:

<script>
  var js_var = [];
  <?php while($data = mysql_fetch_assoc($roomquery)){ ?>
  js_var.push(<?php echo $data['roomnumber']; ?>);
  <?php }?>
</script>

answered Jan 25, 2012 at 8:07

jerjer

8,77634 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dau · Accepted Answer · 2012-01-25 09:42:44Z

0

use it as

<script>
var js_var = [];
<?php while($data = mysql_fetch_assoc($roomquery)){ ?>
js_var.push(<?php echo $data['roomnumber']; ?>);
<?php }?>

function checkroomnumber(){
 var roomnumber = document.getElementById("roomnumber").value;
 for (i = 0 ; i<js_var.length; i++){
   if (js_var[i]==roomnumber){
     alert("room is correct");
     return true;
   }
 }
 alert("room is incorrect");
 return false;
}
</script>

<input type="textbox" name="roomnumber" id="roomnumber" />
<input type="button" name="checkroom" value="checkroom" onclick= "checkroomnumber();" />

edited Jan 25, 2012 at 9:42

answered Jan 25, 2012 at 7:24

Dau

8,9204 gold badges25 silver badges49 bronze badges

1 Comment

user1163005 Over a year ago

I am getting an error on a particular code stating invalid regular exression flag w, roomquery is undefined, I have posted the code I am getting an error in on bottom of my question, I have updated jsfiddle so you can see the current code

Collectives™ on Stack Overflow

javascript and php not quite working

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related