Redirect to URL if input exists in database

Question

I'm trying to redirect a user to an existing URL (stored in a MySQL database) if the value they input already exists in the database. I've got most of it working, but I've run into some issues.

I'm using AJAX to check the database. It sends the input value to another PHP file & checks the database to see if it already exists.

if($row) {
    echo ".$row["itemNum"].";
} else {

}

It's within the AJAX code that I'm having issues, in particular this:

success: function (response) {
    if (response == <?php ".$row["itemNum"]." ?>) {
        window.location.href = "http://www.example.com/" <?php echo "+"; if (".$row["itemNum"].") { echo ".$row["itemNum"]." } else {""}
    } else {
        // do other stuff
    }
}

$row["itemNum"] doesn't always exist, so it's in a conditional statement to prevent a syntax error.

The above doesn't work regardless of how I do it.

I have a feeling the main issue is with the if (response == <?php ".$row["itemNum"]." ?>) line?

try to remove your echo "+"; line like : window.location.href = "http://www.example.com/ <?php if ($row["itemNum"]) { echo $row["itemNum"]; }; — Guillaume Sainthillier
– Guillaume Sainthillier, Commented Mar 20, 2017 at 11:30
You might also want to change if (response == <?php ".$row["itemNum"]." ?>) to if (response == '<?php ".$row["itemNum"]." ?>'), i.e. add apostrophes around the echoed value. — mrun
– mrun, Commented Mar 20, 2017 at 11:33
You can't mixing php (server side) and js (client side) like that — Christof
– Christof, Commented Mar 20, 2017 at 11:33

Death-is-the-real-truth · Accepted Answer · 2017-03-20 11:37:54Z

3

Based on this code:-

if($row) {
    echo $row["itemNum"]; // check the change here
} else {

}

You have to do like this:-

success: function (response) {
    if (response !== '') { // if response have some value
        window.location.href = "http://www.example.com/"+response;
    } else {
        // do other stuff
    }
}

edited Mar 20, 2017 at 11:37

answered Mar 20, 2017 at 11:31

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

Comments

reza · Accepted Answer · 2017-03-20 11:32:51Z

0

As you suspected you have problem with following line.

if (response == <?php ".$row["itemNum"]." ?>) {

The Problem is your use of (") and (.) characters

Following syntax will give you what you want.

if (response == <?=$row["itemNum"]?>) {

answered Mar 20, 2017 at 11:32

reza

1,5072 gold badges12 silver badges17 bronze badges

Collectives™ on Stack Overflow

Redirect to URL if input exists in database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related